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
Create data models and build powerful analyses. Automate your report update process using the Power Query Editor. Combine multiple data sources in an interactive report with Power Pivot.
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 a maximum of 6 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…
