Dynamic Dashboard for Data Analyst with PowerPivot & PowerQuery
What will you learn in this program?
- Loading tables into Power Pivot
- Linking tables with relationships
- DAX function
- Building reports with Data Model
- Insert Pivot Reports
- Visualizing reports with dynamic charts
- Refreshing report
-Cleans Data
Extracting and Connecting data source
Editing and merging data from different sources
Transform Data
Edit Queries
Loading and refreshing cleansed data
