One of my favorite Excel project is to create dashboards for my client. A dashboard is a one page overview of various KPIs (Key Performance Indicator). The goal of the dashboard is to have 1 minute overview of how the KPIs are doing. It allows the audience to easily pin point the issues within an organization. For that reason, a Dashboard have to be very visual. Symbols are used in lieu of numbers, charts are used instead of tables, colors are used to indicate good or bad. It is not easy to design and construct a good dashboard. It requires somebody who is not only analytical, but also artistic.
Some of the common use of dashboard are:
- Internet marketing. There are many indicators to keep track for Internet marketing, some of the KPIs are: Impressions, Clicks, Click Thru Rate, Submitted, Visits, New Visits, and many others. Further, these KPIs are drilled down by region, by media type, and various other ways. A good dashboard will show the trend, current month data, and how it compared to the prior month.
- Sales data. In this type of dashboard, Sales by channel, Top 10 data, comps data, and some historical trend are usually very useful. It will easily identify how the sales is doing, compared to plan, positive or negative trend, and ability to quickly identify which channel require some work.
- Strategy. This is the type of dashboard used in conjunction with CRM (Customer Relationship Management) system. The dashboard will summarize the customers, the projects, the regions, and Customer Satisfactions. A good dashboard will help management to see which business unit require attention, which demographic will generate most sales, and what type of products are most profitable.
- Company Overall. A dashboard for CEO or CFO, where it shows the level of Inventory, Accounts Receivables, Sales data as well as Accounts Payables information. This type dashboard will layout the vision to the company leader for the areas to focus on.
These are just some type of dashboard I’ve worked on in the past. Please visit: https://www.fiverr.com/joshmastaaa to see some of the services I offer.