Hi, 
PL-300: Design and manage analytics solutions using Power BI
Minimum cohort size: 10 learners
Book a free consultation to enroll & feel free to bring a friend along!
Course
PL-300: Design and manage analytics solutions using Power BI
Explore the methods and best practices for modeling, visualizing, and analyzing data with Power BI. Discover how to access and process data from relational and non-relational sources and learn to manage and deploy reports and dashboards for sharing and content distribution.
Benefit from instructor-led preparation for thePL-300 certification exam with tips, tricks, guidance, and mentored support.
Online Live Classes
Intermediate Level
Mentor Support
Course Outline
Introduction
Grading Scheme
Pre-Requisite
Lab Instructions
About this module
Overview of data analysis
Roles in data
Tasks of a data analyst
Knowledge Check
About this module
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
Knowledge Check
About this module
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Knowledge Check
About this module
Use Copilot in Power BI to prepare and model data
Create reports with Copilot in Power BI
Get your data ready for AI usage in Power BI
Knowledge Check
About this module
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Lab Exercise - Get data in Power BI
Knowledge Check
About this module
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Lab Exercise - Load data in Power BI Desktop
Knowledge Check
About this module
Describe Power BI model fundamentals
Determine when to develop an import model
Determine when to develop a DirectQuery model
Determine when to develop a composite model
Choose a model framework
Knowledge Check
About this module
Configure relationships
Configure tables
Configure columns
Configure hierarchies
Configure measures
Configure parameters
Lab Exercise - Configure a semantic model in Power BI Desktop
Knowledge Check
About this module
Understand DAX calculation types
Write DAX formulas
DAX data types
Work with DAX functions
Use DAX operators
Use DAX variables
Knowledge Check
About this module
Create calculated tables
Create calculated columns
Understand implicit measures
Create explicit measures
Use iterator functions
Lab Exercise - Create DAX calculations
Knowledge Check
About this module
Understand filter context
Modify filter context
Use filter modifier functions
Examine filter context
Perform context transition
Lab Exercise - Modify DAX filter context
Knowledge Check
About this module
Use DAX time intelligence functions
Additional time intelligence calculations
Lab Exercise - Use time intelligence functions
Knowledge Check
About this module
Understand visual calculations
Create visual calculations
Use parameters in visual calculations
Lab Exercise - Create visual calculations in Power BI Desktop
Knowledge Check
About this module
Describe semantic model optimization techniques
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Knowledge Check
About this module
Identify the audience
Determine report types
Define user interface requirements
Define user experience requirements
Explore designs in a Power BI report
Knowledge Check
About this module
Design the analytical report layout
Design visually appealing reports
Report objects
Select report visuals
Apply filters and slicers to reports
Understand filtering techniques and considerations
Case study - Configure report filters based on feedback
Lab Exercise - Design Power BI reports
Knowledge Check
About this module
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
Lab Exercise - Enhance Power BI reports
Knowledge Check
About this module
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
Lab Exercise - Perform analytics in Power BI
Knowledge Check
About this module
Understand Power BI service
Understand workspaces
Publish to Power BI service
Knowledge Check
About this module
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Boost performance with query caching (Fabric or Premium capacity)
Use lineage and impact analysis
Knowledge Check
About this module
Understand sharing models
Create a Power BI app
Apply data governance principles
Track report or dashboard usage
Knowledge Check
About this module
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
Lab Exercise - Create dashboards in Power BI
Knowledge Check
About this module
Configure row-level security with the static method
Configure row-level security with the dynamic method
Use single sign-on (SSO) for DirectQuery sources
Restrict access to Power BI model objects
Lab Exercise - Enforce row-level security in Power BI
Knowledge Check
Practice Set 1
Practice Set 2
Project
null
Why Learn with SkillUp Online?
We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.
Reskilling into tech? We’ll support you.
Upskilling for promotion? We’ll help you.
Cross-skilling for your career? We’ll guide you.
Personalized Mentoring & Support
1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.
Practical Experience
Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.
Best-in-Class Course Content
Designed by the industry for the industry so you can build job-ready skills.
Job-Ready Skills Focus
Competency building and global certifications employers are actively looking for.
Type of certificate
Certificate of Completion
About this course
24 Modules
14 Skills
Includes
Discussion space
10 Labs
24 Knowledge checks
02 Practice exam
01 Project
Create
Data model
Power BI dashboard
Paginated reports
Exercises to explore
Power BI
Data Analysis Expressions (DAX)
Newsletters & Updates
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.