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...
Category
visulization
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...
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...
Data Slicer and Timeline are Useful Reporting Tools in PivotTable
Most of us know how to use a Filter in PivotTable, but do you know that there is an even better tool in slicing data in PivotTable? Yes, there is, and the name is, well, Data...
How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac
When two columns of data are of different scale, you will need to use a combo chart to plot each column on a separate axis. In the video below, one column is numbers of...
How to Draw a 3-D Chart
If you have 3-dimensional data, drawing a 3D chart can be very helpful in visualizing how the two variable jointly affect the outcome. In Microsoft Excel, such 3D charts are...
Chance of Nothing Happening? The Power of Joint Probabilities
Yesterday, as I was reading a book about Blackstone, the famed asset management company, something caught my attention. It was about how one of its executives describing...
This Site Has Abundant Climate Data
I have always been fascinated by climate data. Just today while researching for data on this topic, I came upon the Berkley Earth website and found that it has warehoused...
What (and when) are the most popular US cities to visit?
For some business reasons, I need to check what the most popular tourists destinations in the US are. It is not hard to find such data. The US National Travel and Tourism...
All Great Boston Area Towns Benefitting from the Housing Boom? Not Quite So
I recently came across an interesting summary table on median condo prices in the Great Boston area (re-created in Excel below; original data from the Boston Magazine, whose...