Q: How frequently does the Excel Dashboard need to be updated? Based on who uses your dashboard, you need to structure the data and the final output. Here are the questions you should ask: Who owns the data? In what format will you get the data? How frequently does the data update?Ī manager would probably only be interested in the insights your dashboard provides, however, some data analysts in his team may need a more detailed view. This completely changed the scope and most of our time was sucked up in manually culling the data. In one of my projects, the data was provided as PDF files in the Spanish language. Asking the right questions would help you understand what data you need and how to design the dashboard.Īlways know where the data comes from and in what format. Is it to track KPIs just one time, or on a regular basis? Does it need to track the KPIs for the whole company or division-wise?. Be clear on what purpose the dashboard needs to serve. The first thing to do as soon as you get the data (or even before getting the data), is to get clarity on what your stakeholder wants. Things to Do Before You Even Start Creating an Excel DashboardĪ lot of people start working on the dashboard as soon as they get their hands on the data.Īnd in most cases, they bring upon them the misery of reworking on the dashboard as the client/stakeholder objectives are not met.īelow are some of the questions you must have answered before you start building an Excel Dashboard: Similarly, if you’re creating a dashboard for Human Resources department to track the employee training, then the objective would be to show how many employees have been trained and how many needs to be trained to reach the target. Also read: Excel Skills (Basic, Intermediate, and Advanced) How to Create an Excel Dashboard?Ĭreating an Excel Dashboard is a multi-step process and there are some key things you need to keep in mind when creating it.Įven before you launch Excel, you need to be clear about the objectives of the dashboard.įor example, if you’re creating a KPI dashboard to track financial KPIs of a company, your objective would be to show the comparison of the current period with the past period(s). Now that we have an understanding of what a dashboard is, let’s dive in and learn how to create a dashboard in Excel. These dashboards could be static or interactive (where the user can make selections and change views and the data would dynamically update).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |