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
Syllabus
Taught by
Tags
