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

Dynamic Dashboard wix.JPG