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......