Overview:
Learn how to import raw data from different Excel locations into Power Query. Then use Power Query to clean and transform the data. From there, use the output data as the source for an interactive Excel dashboard. Build the dashboard with several PivotTables, PivotCharts and other interactive components. See the dynamic nature of the dashboard with changes in the original data.
Areas Covered in the Session:
- How to import raw data into Power Query from different Excel locations
- Prepare, Clean and Transform the data in the Power Query Editor
- Output the data into Excel and start building the dashboard
- Add several PivotTables and PivotCharts to the dashboard
- Add other dashboard components like Slicers and Timelines
- Make changes to the original data to see dynamic changes in the Dashboard
Who Will Benefit:
- Managers
- Business professionals
- Administrative Personnel
- Legal Professionals