Power BI Intermediate (Live Online)

Overview

Join our hands-on, online instructor-led intermediate Power BI course. This course is the perfect continuation from introductory-level courses like PL-300 and Excel BI Tools for Power BI enthusiasts.

Enhance your skills by mastering common intermediate tasks and exploring Power BI's new features.

Prerequisites:

Participants should have foundational knowledge equivalent to PL-300:

Microsoft Power BI Data Analyst or Excel BI Tools:

Power BI for Excel Users.

Course Completion:

Upon finishing this course, participants will be able to:

• Import data from PDFs, web page regions, and file collections
• Characterize data using profiling techniques
• Merge mismatched datasets with fuzzy matching
• Create custom columns using Power Query
• Implement advanced data modeling and use time intelligence
• Integrate custom scripts in R and Python
• Develop KPIs and scorecards
• Utilize advanced report and dashboard design techniques
• Conduct basic statistical analysis within Power BI

Course Outline:

Module 1:

Intermediate Power Query

• Importing data from PDFs and web pages
• Obtaining tabular data and data by example
• Using fuzzy matching for disparate datasets
• Creating custom columns and using M script

Module 2:

Intermediate Data Modeling

• Adding What-If Parameters, Grouping, and Binning
• Implementing Time Intelligence and Quick Measures

Module 3:

Script Visuals

• Creating R and Python visual scripts
• Setting up R and Python environments

Module 4:

Advanced Report Design

• Using and creating report themes
• Applying conditional formatting
• Utilizing drillthrough features and data-driven images

Module 5:

Advanced Dashboard Design

• Applying dashboard themes and visual KPIs
• Adding trend analysis with DAX
• Embedding images and using DAX UNICHAR function

Module 6:

Analytics

• Characterizing and profiling your data
• Utilizing custom visuals for help
• Performing moving averages, ARIMA, and linear regression
• Conducting time series forecasting with Python

University:

Provider:

CourseHorse

Categories:

Python Courses, R Programming Courses, Data Analysis Courses, Business Intelligence Courses, DAX (Data Analysis Expressions) Courses, KPIs (Key Performance Indicators) Courses, Data Modeling Courses, Power Query Courses

Subjects