Overview
This course is intended as a continuation of our introductory-level courses in Power BI (20778: Analyzing Data with Power BI and/or Excel BI Tools: Power BI for Excel Users ). It covers common intermediate-level tasks and some of Power BI’s most desireable new features. Unify data from many sources to create interactive, immersive dashboards and reports that provide actionable insights and drive business results.Include powerful workflow automation directly in your apps with a no-code approach that connects to hundreds of popular apps and services.
Prerequisites
Before attending this course, students should have: – General knowledge equivalent to what is covered in 20778: Analyzing Data with Power BI .
-
Module 1: Intermediate Power Query
- Lesson 1: Getting data from a table in a PDF document
- Lesson 2: Getting tabular data from a web page
- Lesson 3: Getting hierarchical data from a web page
- Lesson 4: Importing and merging from a folder full of flat files
- Lesson 5: Filtering the files that get imported
- Lesson 6: Use fuzzy matching to combine disparate data sets
- Lesson 7: Use data profiling to understand unfamiliar data
- Lesson 8: Adding columns from examples
- Lesson 9: Conditional columns
- Lesson 10: Basic math
- Lesson 11: Going beyond basic math: writing your own calculations
-
Module 2: Intermediate Data Modeling
- Lesson 1: Adding What-If Parameters
- Lesson 2: Create a What-If Parameter to enable interactive scenarios Using Grouping and Binning
- Lesson 3: Organizing non-numeric dimension data into groups
- Lesson 4: Summarizing numeric ranges into bins Generating DAX with Quick Measures
- Lesson 5: Aggregating by categories
- Lesson 6: Generating text
- Lesson 7: YTD, QTD, MTD and Running Total Calculations
- Lesson 8 : Year-Over-Year calculations
-
Module 3: Script Visuals
-
Module 4: Advanced Report Design
- Lesson 1: Using one of the built-in themes for your reports
- Lesson 2: Creating your own theme
- Lesson 3:Data bars
- Lesson 4: Color scales
- Lesson 5: Get more detail by adding a drillthrough filter
- Lesson 6: Adding simple images to your reports
- Lesson 7: Adding data-driven images to your reports
- Lesson 8: Generate custom tooltips
-
Module 5: Advanced Dashboard Design
- Lesson 1: Presenting the most important things first
- Lesson 2: Adding context with special tiles
- Lesson 3: Defining metrics with thresholds
- Lesson 4: Adding trend analysis to your KPIs
- Lesson 5: Show progress toward a goal
- Lesson 6: Show your KPI with multiple streams of supporting data
- Lesson 7: Importing from the Excel data model
- Lesson 8: Using conditional formatting
- Lesson 9: Using the DAX UNICHAR function
- Lesson 10: Using image embedding
-
Module 6: Analytics
0.00 average based on 0 ratings