DYNAMIC DASHBOARD FOR DATA ANALYST WITH POWERPIVOT & POWERQUERY

Happening on 20 Sep 2021
Selling Price: RM350/pax
Duration: 1 day

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