Interactive Dashboards in Excel
Using the pioneer data analytics software
This is a departure from the more development-centric posts I usually write. However, I had a recent privilege to team up with a family to up-skill their digital literacy & one of the topics we decided on is Excel.
I worked as a full-time data analyst for several years. This title has somewhat been diluted in recent years as many varying roles are required to process, obtain insights and present data. Even as a DevSecOps engineer today, I still have to do that to ensure all the systems I manage are working effectively & efficiently.
Excel is in my opinion, the pioneer, and most widely used data engineering & analytics software in the “non-tech” world. The data analytics & visualisation skills learnt here can easily translated to any domain, and any software as long as we develop strong fundamentals.
This tutorial was created using Mac Excel v16.77.1. There might be some small difference in functionalities & appearances from earlier or later versions.
Outcome
The outcome of this exercise is to produce an interactive dashboard identical to the one below. Cool, right?