Thought processes & problem solving

-
I finally discovered how to utilise pivot tables for data analysis. It looks cheem to me when I first looked it up (I only know pie charts and line graphs for the sake of presentations), until I discovered the 'woah' moment with trial-and-error and things suddenly fall into place like magic. 
Not without some data chewing that was quite frustrating initially as I have 800+ lines of data with assorted information such as timing, category etc.

--
When it comes to problem solving, many times we tend to fall into the trap of focusing on 'What I can do?' instead of "What is the ideal solution to this?". If there is more than one possible solutions, choose the best one. The best pick should be the ideal solution to the problem, although that may not necessarily be the most achievable. 

With that in mind, we proceed to brainstorm on 'HOW to achieve it'. During which we can list down all the possible methods and pathways.



When problem solving starts with "What can I do?" before everything else, we set a limit on the possibilities based on our current ability. It is like looking through a peep hole instead of opening a door to the solution. When an action is taken it may lead to taking a roundabout path, winding around with no end point in sight or circling on the same spot. At times, it will make us want to 'escape the problem' because 'I just can't do anything about it'.


So instead of 1, 2, 3 in the above flowchart, it became 1, 3, stuck.

We need to keep our focus on the solution / outcome and be as specific as possible.

The complete cycle of problem solving in a clear picture:
Source: http://www.humorthatworks.com/learning/5-steps-of-problem-solving/


--
Back to my problem. I have to first see what are the data I have on hand and which part of it to analysis so that I can draw a conclusion for my boss on this question xxx. 
In order to analyse it, how should I organise the data. Then I ask what is the most efficient method to display the results and give the answer.

The formula - no need formula. Just pivot table.

Actually that is not the end to the problem, it's only the end to my data analysis problem. 

Back to the problem solving cycle. 😫

Comments

Post a Comment

Popular posts from this blog

Reflections for year 2024

-
Image
2024 has been a relatively peaceful year. So peaceful that I have read countless novels and other books, met my sports buddies almost every weekend and picked up horticulture. Physical and mental health As we say, health is wealth. I have stuck fairly consistently with my exercise regime and tried to include more fruits and vegetables in my meals (although I eat out more and cook less these days). My weight, BP and cholesterol levels are doing ok. For those 40 years and above, remember to get your  subsidized health screenings from the government . Working less and meeting up with friends more contributed to an improved mental health. I see that the government has stepped up on initiatives in the community but work place initiatives from employers still seemed lackluster, especially for those who can't WFH and need to commit 44 hours or more a week at frontline work. I have also started a Gratitude journey to celebrate all my little life milestones. Financials Investment wise ...
Read more

The gold rush again

-
Image
I recently saw this video on CNA Money Mind channel https://www.channelnewsasia.com/watch/money-mind-2024-2025/going-gold-4299741 and thought I would summarize some learning points for those interested in gold investment. Photo by Zlaťáky.cz on Unsplash Gold is viewed as a safe haven asset in time of uncertainty, crisis or geopolitical risks. Demand for gold is influenced by Central bank purchases. The purchase premium of gold decreases in % with relationship to the gold bar's weight. Eg, a heavier gold bar has lower purchase premium over a lighter one. There's no GST for investment grade gold bars. Gold-backed ETF is backed by physical gold. Lower yield environment will benefit gold prices as the opportunity cost of holding gold lowers. Source: https://www.statista.com/statistics/673513/monthly-prices-for-gold-worldwide/ As seen from the chart, the last mega price spike was in year 2019 to 2020. This year we saw another mega spike. In order to circumvent any US withholding t...
Read more

Shit happens and I lost my low-hanging fruits

-
My SAYE account has just hit its 25th month anniversary which is also the "month of maturity". Anticipating to get the 3.5% bonus interest for all these months of saving, I was shocked to see only $17+ cash gift credited as opposed to a few hundred dollars. I was about to send a message to query the bank what caused this interest plummet versus what I got in the 13th month when I came across a debit transaction in my account history (GASP!). To my oblivion and horror, I have accidentally selected my SAYE account to transfer $50 to a joint account to foot some bill in one of the months last year. Here's the terms and conditions for those who are not familiar with the SAYE account of POSB. "To receive the additional 3.5% p.a. Cash Gift Interest, ensure that you do not make any withdrawal from your POSB SAYE account." "If a withdrawal is made in the month, this will result in the previously accumulated additional 3.5% p.a. interest to be forfeited." Damn....
Read more

Reflections for year 2023

-
Image
2023 is a year which I have relented to the inevitable dealing with adversities. Sending my mother in and out of hospital had become a norm. Being a healthcare professional, I thought I could handle it single-handedly well enough, not until the point when my mother ceased to be fit enough to attend dementia day care that I came to the conclusion that I needed a helper. However, things took a steep downhill turn before I could hired one (counted myself lucky that I did not commit to a hire). My mother passed away in June, it was a relief for me and probably a relief for her as well. However, life is not meant to be smooth-riding. My mother did not leave behind a will, thus I have to apply for the Letters of Administration with the Court and as my sibling has mental disability, this led to some complexities which have yet to be resolved. Instead of hiring a lawyer, I decided to apply the LOA and MCA orders by myself through the Service Bureau. I am paying my time and convenience for it ...
Read more

Be anti-fragile

-
Image
Life's not easy, life goes on. Rather than gripe (we know the saying "人生不如意事十之八九"), it is important for us to focus on risk management in our daily lives and how to become anti-fragile. Buying insurance, setting stop-losses, cut losses and bad connections out of our lives, look before stepping and don't seek cheap thrills. That's risk management at its very least. Taleb's concept of anti-fragile is one level above risk management and robustness.  It is about how chaos can make one better and stronger. Don't fear volatility, uncertainty and disruptions. Instead view them as opportunities.  Quoting the video, we should learn to  "transforms fear into prudence, pain into information, mistakes into initiation and desires into undertaking" . Toughen your mindset If you have tough desire, then be prepared for a tough process working towards it. Another point highlighted in the video for our mind training is - we can imagine worse case scenario, imagine...
Read more

Disclaimer:

The contents of this blog are author's personal opinions and do not constitute advice to hold, buy or sell any securities, commodities or assets mentioned. I do not guarantee the accuracy and reliability of any information provided, and shall not be liable for any losses incurred from reading my posts or using the materials herein. This blog may contain affiliate links to external sites.