Data analysis and dashboard reporting have become an emerging requirement for many businesses today. Employees are frequently asked to prepare management reports, scorecards, and dashboard charts in order to help the management in their decision-making process.

This course will help you understand advanced levels of analysis and reporting and allow you to create custom reports. The course will cover various tools and techniques used to perform data reporting, analysis and visualisation. It will also discuss high-level modelling techniques, data amalgamation, report visualisation, and possible cases of automation.
here is valuable information hidden in the sea of data. A picture is worth a thousand words - use Excel dashboard to present information visually and beautifully within a single page that allows users to understand what is going on and make business decisions. Excel dashboard reports allow managers to have high-level overview of the business and help them make decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insights and alert managers in a timely manner.

A good Excel dashboard is:

visually appealing for decision makers to understand key information clearly
highly dynamic, allowing managers to easily dig into your data
easy to update

Prerequisites
Participants should be comfortable with basic Excel tools and functions. At a minimum, participants should know how to navigate confidently in Excel, create and use simple formulas and link between workbooks.