Power BI for Excel 2016 - Report Builders, Power BI Tools, Data Model Designers, and DAX Functions
E-Learning
Description
First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates.
First day topics covered include an overview of PowerPivot, creating effective and professional reports, creating hierarchies, effectively applying different chart styles, and creating report templates.
This course takes an in dep otherview of PowerPivot, creating effective and professional reorts, Power Views with Excel, Power Map, and Power Query how to use basic DAX language, Date functions, Banding, Ranking, advanced Slicer techniques, plus using DAX as a query language for customized analysis.
This course is Intended for students with Excel knowledge including PivotTable & Pivot Chart skills; plus a basic understanding of database concepts.
| Lesson Id | Title | Description |
|---|---|---|
| 1 | Introducing Power BI for Excel |
What Is Power BI for Excel? Power BI Key Features The Self-Service BI Model Power BI in Excel PowerPivot Add-In Using Power BI |
| 2 | Defining a Report |
What is a PowerPivot Report? Defining a Report Data-Driven Storytelling |
| 3 | Understanding PowerPivot Data |
Understanding Data Terminology Tables Relationships Diagnosing Data Models Data Model Schemas |
| 4 | Create Reports using PowerPivot Data |
Making Changes to PowerPivot Data Creating PowerPivot PivotTables Creating PowerPivot PivotCharts Creating Slicers Graphing Data |
| 5 | Understanding PowerPivot Functions |
Calculated Columns What is DAX? Understanding DAX Functions Common DAX Functions Dates and Date Functions |
| 6 | Introducing Power BI Tools |
Microsoft’s Self-Service Power Bi Model What Is Power BI for Excel |
| 7 | Power View for Excel |
What Is Power View? Creating Power View Reports Power View Interface Components Understanding Table Visualizations Chart Visualizations Power View Tiles, Slicers, & Multiples |
| 8 | Power Map/3D Maps for Excel |
What Is 3D Map/Power Map? Preparing a 3D Maps/Power Map Tour 3D Maps/Power Map Designer 3D Maps/Power Map Formatting Tools Finalizing a 3D Maps/Power Map Tour |
| 9 | BI Data Query Basics |
What Is a BI Data Query? Planning a BI Data Query |
| 10 | Query Editor Transformations |
Basic Transformations Merging & Appending Queries Calculated Columns Grouping and Summarizing Data Unpivoting Data Dealing with Malformed Data Finalizing Queries |
| 11 | Understanding BI Data |
Business Intelligence Data Sources Data Source Types Table Roles |
| 12 | Creating Data Models |
Creating a Data Model - Excel Creating a Data Model - Database Creating a Data Model - Hybrid |
| 13 | Creating DAX Functions |
Review of Syntax and Calculated Columns Best Practices DAX Measures Creating Measures (Calculated Fields) |
| 14 | Dates and Hierarchies |
Building Data Tables Building Data Hierarchies |
| 15 | Shaping Reports |
Building Communication Worksheets Controlling Item Ordering PowerPivot Metadata |
| 16 | Basic DAX Functionality |
Review Of Calculated Column PivotTable Function Review Of Measure Rules Of DAX Measure Evaluation Context Formatting DAX Code |
| 17 | Controlling Content & Values |
Controlling Values Switch Function Error Handling |
| 18 | Context Control Functions |
Filter Function All Function Iterative Functions Earlier Function Calculate Function Additional Uses Of The All Function |
| 19 | Contexts In Relationships |
Working With Many Tables Row Context & Relationships Filter Context & Relationships Values Function |
| 20 | Advanced Concepts |
Circular Dependencies Controlling Totals Advanced Hierarchy Concepts |
| 21 | Time Intelligence Calculations |
Working With Date Tables Calculating Operating Periods Working With Missing Periods DAX Date Functions Advanced Date Functions Prior Year Functions Moving Averages |
| 22 | DAX Dashboard Techniques |
Parameter Tables Banding Ranking Advanced Slicer Techniques |
Self-Paced
Free
This course includes: :
Full lifetime access