MS Excel Workshops: MS Excel for Business Analytics

MS Excel for Business Analytics is a project-based workshop focused on building automated business analytics reports with MS Excel. Students will develop a complete project for professional portfolio using a real-world scenario and dataset. Students will improve technical skillset in MS Power Query, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables as well as conceptional understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics.

Benefits

• Complete project for professional portfolio

• Technical skillset in MS Power Query, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables

• Conceptual understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics

• Interactive group training

• Free access to AdventureWorks Sales Project

Topics

1. Data Transformations using MS Power Query

2. Data Modeling using MS Power Pivot

3. Calculated Measures using DAX

4. Data Visualizations using Pivot Charts

5. Data Analytics using Pivot Tables

Deliverables

• Live 60-min screensharing via Google Meet with maximum 3 student

Requirements

• MS Excel Desktop

• Intermediate and above MS Excel skillset

• Private information secured during screensharing