Microsoft Power BI Certification Training
1.250,00 EUR
- 24 hours
In today’s data-driven world, the ability to rapidly convert complex data into actionable business intelligence is essential. The PL-300 Microsoft Power BI Certification Training equips you with the end-to-end expertise required to extract, clean, model, and visualize data using Microsoft Power BI.
What Is Included?
Language
Course material in English
Level
Beginner - intermediate level
24 Hours of Instructor-Led Online Training
60+ hours recommended study time
2+ Hours of eLearning content
Practice tests for the PL 300 exam
1 year access to the learning platform
New class cohort every month with flexible registration
Curriculum Aligned to PL-300 Certification
Industry-based projects
No exam included
Program completion certification included
What Skills Will You Gain?
At the end of this program, you will be able to:
Prepare and Clean Data
Seamlessly import, transform, and refine data from multiple heterogeneous sources using Power Query.
Build Robust Data Models
Design efficient relational data models, establish scalable schemas, and optimize model performance for fast querying
Master DAX Expressions
Utilize basic-to-advanced Data Analysis Expressions (DAX) to create custom measures, calculated columns, and time-intelligence metrics.
Design Interactive Dashboards
Create compelling visual reports and mobile-responsive dashboards tailored for diverse business stakeholders.
Implement Advanced Analytics
Apply built-in AI visual features, trend analysis, and custom aggregations to uncover deep business insights.
Manage & Secure Reports
Publish reports to the Power BI Service, configure Row-Level Security (RLS), and set up scheduled data refreshes for enterprise collaboration.
Ace the PL-300 Exam
Master exam domains with practice tests and hands-on projects designed to match Microsoft's official certification requirements
What Will You Learn?
Course Introduction
Lesson 1
- Overview of the course and covered skills
- Introduction to Business Intelligence (BI) and data analytics
- Basics of Power BI and its product offerings
- Installing Power BI Desktop
Getting Data From Different Sources
Lesson 2
- Connecting to data sources and managing source settings
- Using shared datasets and Microsoft Dataverse
- Understanding and choosing storage modes
- Selecting query types, using parameters, and working with PBIDS files
Profiling Data
Lesson 3
- Examining data structures
- Reviewing column properties
- Analyzing data statistics
Cleaning, Transforming, and Loading Data
Lesson 4
- Introduction to data transformation techniques
- Fixing data quality issues, null values, and inconsistencies
- Applying user-friendly value replacements and naming conventions
- Changing column data types and reshaping tables
- Combining queries and modifying Power Query M code in the Advanced Editor
Designing a Data Model
Lesson 5
- Defining tables and configuring table/column properties
- Flattening parent-child hierarchies and defining role-playing dimensions
- Creating common date tables
- Setting relationship cardinality and cross-filter directionsDesigning Interactive Dashboards
- Implementing User Feedback into Visualization Design
Optimizing Model Performance
Lesson 6
- Removing unnecessary rows and columns
- Identifying and fixing slow measures, relationships, and visuals
- Improving cardinality and creating aggregations
- Optimizing DirectQuery models and using Query Diagnostics
Creating Reports
Lesson 7
- Selecting, adding, formatting, and configuring report visuals
- Applying slicing and filtering techniques
- Adding R and Python custom visuals
Creating Dashboards
Lesson 8
- Designing dashboards and optimizing mobile layouts
- Managing dashboard tiles, themes, and pinning live report pages
- Setting up data alerts and natural language Q&A features
Enhancing Reports for Better Insights
Lesson 9
- Performing Top N analysis and exploring statistical summaries
- Utilizing Q&A visuals and Quick Insights
- Animating visuals with the Play Axis and enabling personalized visuals
Performing Advanced Analytics
Lesson 10
- Detecting data anomalies and outliers
- Conducting time series analysis, grouping, and binning
- Using Key Influencers, Decomposition Trees, and AI Insights to explain data variances
Managing Semantic Models
Lesson 11
- Setting up scheduled refreshes and incremental refreshes
- Managing Row-Level Security (RLS) group memberships
- Promoting and certifying Power BI datasets
Who Should Enroll in this Program?
Prerequisites
A basic level of computer skills, a general understanding of data concepts, and proficiency in English are recommended.
Data Analysts
Data Scientists
Database Administrators
Consultants
Business Analysts
Data Engineers
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.