Simplify Complex Reports with Data Modeling
(1 day)
Hands-On Workshop
- Participants must bring their own laptop.
Learning Outcomes
- Transform data with Power Query Editor
- Model Data in Power Pivot Environment
- Create Measures and Calculated Columns with DAX functions
- Build interactive reports with charts, tables and slicers
Training Location
123 Slater Street, Ottawa ON K1P 5G4
Available for private groups : inquire.
Target Audience
Analysts, Accountants, Report Builders, Data Analysis Professionals
Bring Your Own Device
Each participant must bring his/her laptop with Microsoft Excel application (version 2013 or greater).
Or add Laptop Rental to your cart.
Microsoft Certified Instructor
Our Ottawa-based instructor is certified by Microsoft, as a skilled professional in Business Intelligence Reporting.
Quality Service
Workshops are limited to 10 attendees to address each participants questions and requests.
Training is delivered in a modern environment: offering a comfortable and bright workplace, centrally located.
Training Schedule
Training takes place from 9 a.m. to 4 p.m.
Learning Outcomes
- Transform data with Power Query Editor
- Model Data in Power Pivot environment
- Create Measures and Calculated Columns with DAX functions
- Build interactive reports with charts, tables and slicers
Topics
1. Master the basic workflow
- Import data from different sources
- Transform data in Power Query
- Load data to Data Model
- Define data default format setting in Power Pivot environment
- Create relationships between data tables in Power Pivot
- Create a PivotTable
- Create a PivotChart
- Create a slicer
2. Review the report’s update process
- Periodic Update process: click Refresh All
- Cyclical Update process: edit Data Source Settings…
3. Add complexity to the basic workflow
- View the impact of wrong relationships on a Pivot Table
- Understand the concept of context in a Pivot Table or PivotChart
- Create inactive relationships between data tables in Power Pivot
- Create Measures
- Use DAX functions : COUNT, SUM, DIVIDE AVERAGEX, CALCULATE and USERELATIONSHIP
- Edit a Measure
- Create a Pivot Table to visualize a measure
- Create Calculated Columns in Power Pivot environment
- Use a calculated column in a Pivot Table as a Row field
- Format a report
- Name charts and tables
You may also like…
