So-called ‘Dashboards‘ are heard in our analytics driven world but what exactly is dashboard and why we should do it?
Regardless of the business functions, chances are that you are keep repeating the manual process of data to report generation.
The process you use to create your reports might look like this.
1) You extract the data from databases such as SQL or SAP or whatever the company system is.
2) You transform and summarize data in Microsoft Excel with the commonly used function such as Pivot Table or Vlookup. You might need to join the data from different sources into one source as well.
3) You use the data from your Microsoft Excel to generate graphs and reports in Powerpoint.
4) You present the report to the management.
However you might face these key challenges
- I need to redo all the steps in all rounds of report
- Lots of efforts spent doing repeating works
- I need to redo some steps to drill down data
- I need to cleanse all the data for everyone who consume my report
With the new Dashboard concept, you can use BI tools such as Power BI or Tableau to create report only once
- The report can be automatically updated when the data is updated
- Data from different data sources could be joined
- The dashboard is interactive for drilling down into details
These are some sample of the dashboards that could be seen below.
Creating the dashboard utilizes the data and could unlock the potential value of data at different levels and departments that is easy to understand for everyone.
Interested in transforming your reports into dashboards?
- Join us at the next training on 7 Mar https://www.eventpop.me/e/7999-powerbi
- or Contact us at Davoy.tech via the form below