Business Charting & Dashboards in Excel & Power BI (post-lunch session)

You will learn to understand the process for making executive dashboards to tell a complete story in one picture. 

  • What is a dashboard and process for creating one 
  • Exploring dashboard case study of a retail mart 
  • Making a mock-up drawing of the dashboard 
  • Setting up data model in Excel – tables & relationships 
  • Creating pivot table driven calculation engine for the dashboard 
  • Preparing charts & information tiles for the dashboard 
  • Laying everything out and formatting
  • Demo a Power BI version of dashboard

In conclusion, closing thoughts on business reporting thru Excel.