All you wanted to know about Self-Service Dashboards in Excel

Course details

This course takes a profound look at the new capabilities of MS Excel to develop instant Dashboards. These smart techniques will allow you to design self-service dashboards in minutes. The topics covered in this course primarily focuses on Analysis proficiencies.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

• Generate Pivot tables and charts to explore data sets
• Implement slicers to develop instant dashboards
• Appreciate the use of Sparklines to in-cell histograms
• Reduce data speculation by using Excel's data Analysis capabilities

This course is designed for Excel users, project managers, and decision makers who want to fill the gap between an Excel spreadsheet and a complete business intelligence solution. Leveraging Power Bi from Microsoft, candidates will learn how to pull data into an Excel spreadsheet from a multitude of sources, how to format and prepare that data prior to loading into an analytical model, and how to create visualizations and dashboards upon that data.