*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.
Overview
This course is intended as a continuation of our introductory-level courses in Power BI (DA-100: 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 desirable new features.
Prerequisites
Before attending this course, students should have the general knowledge equivalent to what is covered in:
Excel BI Tools: Power BI for Excel Users.
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
Do You Still Prefer a Live, Instructor-led Class?
Already know On-Demand, self-study training is not right for you? We also offer this same course content in a live, instructor-led format. For details, click on the link below:
Power BI Intermediate (Instructor-led Class)
Course Outline
Intermediate Power Query
Import Data from PDFs
Connect to webpages from Power BI Desktop
Get webpage data by providing examples
Combined files (binaries) in Power BI Desktop
Use Fuzzy Matching to Combine Disparate Data Sets
Using Data Profiling
Add a Column from Examples
Add a Custom Column with M
Intermediate Data Modeling
Create and use What-If Parameters to Visualize Variables
Using Grouping and Binning in Power BI Desktop
Set and user Date Tables in Power BI Desktop
Use Quick Measures for Common Calculations
Script Visuals
Create R Visuals in Power BI Desktop
R Integration: Installing an R Environment
Create Python Visuals in Power BI Desktop
Python Integration: Installing Python
Advanced Report Design
Using Report Themes in Power BI Desktop
Use Conditional Formatting in Tables
Using Drillthrough in Power BI Desktop
Adding Data-Driven Images to Power BI Reports
Using Parameters
Create and Use Report Templates in Power BI Desktop
Advanced Dashboard Design
Use Dashboard Themes in the Power BI Service
Import and Display KPIs in Power BI
KPI Visuals
The Multi KPI Visual
The UNICHAR Function
Analytics
A tiny introduction to machine learning and predictive analysis in Power BI
Forecasting with ARIMA
Visualizing and Operationalizing R Data in Power BI Desktop
