Excel Dashboards

• Stories
• Analysis
• Excel is sexy!

Photo by PhotoMIX Ltd.from  Pexels

Excel Dashboards

When creating a dashboard in Excel, the idea behind it is that you want to tell a story.  Whomever, who opens up the spreadsheet can then see your story. And of course, stories are there to be told beautifully.

Now there are different ways to go about telling your story. Look at the data, find correlations, trends and the likes and go about telling the story of how the client did in the past. There is much that can be done with past data. You can award your most loyal client (simple example). You can clean up your system of junk (Garbage in garbage out). You can determine your efficiency. And so the list goes on.

But what about predictive analysis? “Making predictions about the future” sounds a bit like looking in a glass ball does it not? Well, there are many techniques that can contribute to making [business] predictions: data mining, statistics, AI to name a few. The patterns seen in the past data can be used to identify risks and opportunities in order for the business owner to know which path he could choose. All to make his story more beautiful!

Try at least not to make the three mistakes as illustrated above!

Have you given telling stories a try? No? Need help? You DO KNOW where to find me do you not?  As usual tell us what you think!