Why Hasn’t Anybody Done This Graph about COVID-19?
The COVID-19 pandemic has been going on for over 9 months now (I am writing this in mid-December of 2020). One question that I have always been thinking about: Has the risk of...
Wow What a Great Data Site
Recently I came across a beautiful data analytics website while I was reading on why renewable energy is showing greater and greater momentum in replacing traditional fossil...
Excel Shortcut Keys (2020 Edition)
Every year I update my favorite shortcut keys. Here is the 2020 version. You can also download PDF here.
How to Provide Electricity Access to Rural Africa: An Example
How to provide electricity access to the remote regions in developing countries is a vast topic, both in terms of its scope and its related research. Take Africa as an...
Why is Chick-Fil-A Picking up Market Share (and Why is McDonalds Testing Robot Fryers and Voice-Activated Drive-Through)?
WSJ recently ran an interesting article (and video) on how and why McDonalads is testing using robots to cook and voice-recognition software to take orders at drive-through....
Filter Data Right in your Pivot Table Fields!
One of the ‘hidden treasure’ in Pivot Table a lot of people do not know about is that you can filter data right in your Pivot Table Fields. This is extremely...
Sensitivity Study (or Scenarios) with Data Table
In managerial decision making, many time we need more than just an optimal decision. Often we would like to know how my results change if I change my decision in a certain...
PivotTable: Calculated Fields
Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total...
Dashboard with PivotTable
Dashboard is an effective communication tool to summary and highlight your data and your analysis. Here is an example of an Excel Dashboard that I made with PivotTable (and...