Skip to main content

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. ðŸ˜«

Labels:

Comments

Post a Comment

Popular posts from this blog

Reflections for year 2024

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 ...
Post a Comment
Read more

The best credit card for my new house renovation

As updated in my previous post, I have finally bought my own place. For the past few months I have been busy coordinating with various contractors and vendors for my house renovation. As I am still on A flexi work schedule, I decided to be my own ID. With only a simple renovation plan in mind, I set my reno budget at $20,000 (aircon & fixtures inclusive). The renovation process and acting as my own ID were not as easy as I thought. It took me about a month to gather and compare quotations from different contractors and another few weeks to finalize all the things that I need my chosen contractor to do. I eventually settled for a main contractor who specializes in carpentry work but also provides painting, tiling and electrical services. I have grossly underestimated the amount of defects that need fixing for this resale flat. Fortunately, the floor tiles and some of the existing built-ins are still in good condition so I kept them, otherwise I would have burst my budget. The first ...
Post a Comment
Read more

Shit happens and I lost my low-hanging fruits

My POSB SAYE account just hit its 25th month —the much-anticipated “month of maturity.” I was all ready to enjoy the 3.5% bonus interest I’d patiently saved for… only to receive a measly $17+ cash gift instead of a few hundred dollars. I was about to send a message to query the bank what caused this interest drop versus what I have gotten on the 13th month. Confused, I double checked my account history and— gasp! —found a single $50 transfer I’d made to a joint account in one of the past months. I hadn’t even realized that I’d chosen the SAYE account as the fund transfer source. For those unfamiliar with the T&Cs of POSB SAYE: “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.” Yes, one tiny transfer = months of bonus interest gone . Even depositing it back the...
Post a Comment
Read more