Power BI is one of our most popular class series and these classes can fill weeks ahead.
Description
Power BI is one of our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.
Power BI is one of our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.
Power BI Intermediate Course Overview
This hands-on, online instructor-led course is intended as a continuation of our introductory-level courses, PL-300: Microsoft Power BI Data Analyst and/or Excel BI Tools: Power BI for Excel Users in `
Power BI. This course covers common intermediate-level tasks and some of Power BI’s most desirable new features.
Power BI Intermediate Course Prerequisites
Excel BI Tools: Power BI for Excel Users orPL-300: Microsoft Power BI Data Analyst
-OR- equivalent knowledge before attending this course.
At Course Completion
After completing this course, students will be able to:
• Import data from PDFs, regions of web pages, and collections of files
• Characterize data with data profiling
• Merge mismatched data sets with fuzzy matching
• Generate custom columns in Power Query
• Perform advanced data modeling
• Use Power BI time intelligence
• Work with custom scripts in R and Python
• Create KPIs and scorecards
• Use advanced report design techniques
• Use advanced dashboard design techniques
• Perform basic statistical analysis in Power BI
Note: This class is also available in our On-Demand, eLearning Format.
Can't miss 2 days out of the office to take the live, instructor-led course? Learn at your own pace and in your own time with our self-study On-Demand course. For details, click this link:
Microsoft On-Demand: Power BI Intermediate
Number of learners451,019
Courses Taken62,523
Average course rating4.25
COURSE OUTLINE
Intermediate Power Query
Importing from PDFs
Finding data in web pages
Getting tabular data
Getting data by providing an example
Importing the contents of a folder
Using fuzzy matching to combine disparate data sets
Creating custom columns in Power Query
Common math & string operations
M script
Columns by example
Intermediate Data Modeling
Adding What-If Parameters
Grouping and Binning
Using Time Intelligence
Generating DAX with Quick Measures
Script Visuals
Creating an R script visual
Installing an R environment
Creating a Python visual
Installing a Python environment
Advanced Report Design
Using report themes
Creating your own theme
Conditional formatting in tables and matrices
Using drillthrough in your reports
Adding data-driven images
Advanced Dashboard Design
Using dashboard themes
Using the KPI visual
Using the Multi KPI visual
Adding KPIs and trend analysis with DAX
Strategies for adding KPIs to tables & matrices
Importing from Excel data model
Conditional formatting
The DAX UNICHAR function
Image embedding
Analytics
Characterizing your data
Revisiting the data profiler
Getting help from custom visuals
Moving averages
ARIMA
Linear regression in R
Time series forecasting in Python