Skip to main content
PL-300T00: Design and manage analytics solutions using Power BI
0%
Previous
Course data
Introduction
Audio Book PL-300T00
Lesson-1 Get started with Microsoft data analytics
Lesson-1 Get started with Microsoft data analytics
Audio Lesson-1 Get started with Microsoft data analytics
Podcast Lesson-1 Get started with Microsoft data analytics
1.1.1 Introduction
1.1.2 Overview of data analysis
1.1.3 Roles in data
1.1.4 Tasks of a data analyst
1.1.5 Summary
Activity:Multiple choice with image
Activity: Knowledge Check
1.2.1 Introduction
1.2.2 Use Power BI
1.2.3 Building blocks of Power BI
1.2.4 Tour and use the Power BI service
1.2.5 Summary
Activity:Sequence
Activity: Knowledge Check
1.3.1 Introduction
1.3.2 Explore end-to-end analytics with Microsoft Fabric
1.3.3 Explore data teams and Microsoft Fabric
1.3.4 Enable and use Microsoft Fabric
1.3.5 Summary
Activity: Accordion
Activity: Knowledge Check
1.4.1 Introduction
1.4.2 Use Copilot in Power BI to prepare and model data
1.4.3 Create reports with Copilot in Power BI
1.4.4 Get your data ready for AI usage in Power BI
1.4.5 Summary
Activity:Short Answer
Activity: Knowledge Check
Lesson-2 Prepare data for analysis with Power BI
Lesson-2 Prepare data for analysis with Power BI
Audio Lesson-2 Prepare data for analysis with Power BI
Podcast Lesson-2 Prepare data for analysis with Power BI
2.1.1 Introduction
2.1.2 Get data from files
2.1.3 Get data from relational data sources
2.1.4 Create dynamic reports with parameters
2.1.5 Get data from a NoSQL database
2.1.6 Get data from online services
2.1.7 Select a storage mode
2.1.8 Get data from Azure Analysis Services
2.1.9 Fix performance issues
2.1.10 Resolve data import errors
2.1.11 Summary
Activity:True/False
Activity: Knowledge Check
2.2.1 Introduction
2.2.2 Shape the initial data
2.2.3 Simplify the data structure
2.2.4 Evaluate and change column data types
2.2.5 Combine multiple tables into a single table
2.2.6 Profile data in Power BI
2.2.7 Use Advanced Editor to modify M code
2.2.8 Summary
Activity:Popup
Activity: Knowledge Check
2.3.1 Introduction
2.3.2 Describe Power BI model fundamentals
2.3.3 Determine when to develop an import model
2.3.4 Determine when to develop a DirectQuery model
2.3.5 Determine when to develop a composite model
2.3.6 Choose a model framework
2.3.7 Summary
Activity:Multiple Response
Activity: Knowledge Check
Lesson-3 Model data with Power BI
Lesson-3 Model data with Power BI
Audio Lesson-3 Model data with Power BI
Podcast Lesson-3 Model data with Power BI
3.1.1 Introduction
3.1.2 Configure relationships
3.1.3 Configure tables
3.1.4 Configure columns
3.1.5 Configure hierarchies
3.1.6 Configure measures
3.1.7 Configure parameters
3.1.8 Summary
Activity:Tab: Type 2
Activity: Knowledge Check
3.2.1 Introduction
3.2.2 Understand DAX calculation types
3.2.3 Write DAX formulas
3.2.4 DAX data types
3.2.5 Work with DAX functions
3.2.6 Use DAX operators
3.2.7 Use DAX variables
3.2.8 Summary
Activity:Popup
Activity: Knowledge Check
3.3.1 Introduction
3.3.2 Create calculated tables
3.3.3 Create calculated columns
3.3.4 Understand implicit measures
3.3.5 Create explicit measures
3.3.6 Use iterator functions
3.3.7 Summary
Activity:Tab: Type 1
Activity: Knowledge Check
3.4.1 Introduction
3.4.2 Understand filter context
3.4.3 Modify filter context
3.4.4 Use filter modifier functions
3.4.5 Examine filter context
3.4.6 Perform context transition
3.4.7 Summary
Activity:Tab: Type 1
Activity: Knowledge Check
3.5.1 Introduction
3.5.2 Use DAX time intelligence functions
3.5.3 Additional time intelligence calculations
3.5.4 Summary
Activity:True/False
Activity: Knowledge Check
3.6.1 Introduction to performance optimization
3.6.2 Understand visual calculations
3.6.3 Create visual calculations
3.6.4 Use parameters in visual calculations
3.6.5 Summary
Activity:Multiple Response
Activity: Knowledge Check
3.7.1 Introduction to performance optimization
3.7.2 Describe semantic model optimization techniques
3.7.3 Review performance of measures, relationships, and visuals
3.7.4 Use variables to improve performance and troubleshooting
3.7.5 Reduce cardinality
3.7.6 Optimize DirectQuery models with table level storage
3.7.7 Create and manage aggregations
3.7.8 Summary
Activity:Tab: Type 2
Activity: Knowledge Check
Lesson-4 Design effective reports in Power BI
Lesson-4 Design effective reports in Power BI
Audio Lesson-4 Design effective reports in Power BI
Podcast Lesson-4 Design effective reports in Power BI
4.1.1 Introduction
4.1.2 Identify the audience
4.1.3 Determine report types
4.1.4 Define user interface requirements
4.1.5 Define user experience requirements
4.1.6 Explore designs in a Power BI report
4.1.7 Summary
Activity:Pop up
Activity: Knowledge Check
4.2.1 Introduction
4.2.2 Design the analytical report layout
4.2.3 Design visually appealing reports
4.2.4 Use report objects
4.2.5 Select report visuals
4.2.6 Apply filters and slicers to reports
4.2.7 Understand filtering techniques and considerations
4.2.8 Summary
Activity:Drag-and-Drop
Activity: Knowledge Check
4.3.1 Introduction
4.3.2 Design reports to show details
4.3.3 Design reports to highlight values
4.3.4 Design reports that behave like apps
4.3.5 Work with bookmarks
4.3.6 Design reports for navigation
4.3.7 Work with visual headers
4.3.8 Design reports with built-in assistance
4.3.9 Tune report performance
4.3.10 Optimize reports for mobile use
4.3.11 Summary
Activity:Accordion
Activity: Knowledge Check
4.4.1 Introduction to analytics
4.4.2 Explore statistical summary
4.4.3 Identify outliers with Power BI visuals
4.4.4 Group and bin data for analysis
4.4.5 Apply clustering techniques
4.4.6 Conduct time series analysis
4.4.7 Use the Analyze feature
4.4.8 Create what-if parameters
4.4.9 Use specialized visuals
4.4.10 Summary
Activity:Tab: Type 1
Activity: Knowledge Check
Lesson-5 Manage and secure Power BI
Lesson-5 Manage and secure Power BI
Audio Lesson-5 Manage and secure Power BI
Podcast Lesson-5 Manage and secure Power BI
5.1.1 Introduction
5.1.2 Understand Power BI service
5.1.3 Understand workspaces
5.1.4 Publish to Power BI service
5.1.5 Summary
Activity:Carousel/Slideshow
Activity: Knowledge Check
5.2.1 Introduction
5.2.2 Use a Power BI gateway to connect to on-premises data sources
5.2.3 Configure a semantic model scheduled refresh
5.2.4 Configure incremental refresh settings
5.2.5 Manage and promote semantic models
5.2.6 Boost performance with query caching (Fabric or Premium capacity)
5.2.7 Use lineage and impact analysis
5.2.8 Summary
Activity:Accordion
Activity: Knowledge Check
5.3.1 Introduction
5.3.2 Understand sharing models
5.3.3 Create a Power BI app
5.3.4 Apply data governance principles
5.3.5 Track report or dashboard usage
5.3.6 Summary
Activity:Multiple Response
Activity: Knowledge Check
5.4.1 Introduction to dashboards
5.4.2 Configure data alerts
5.4.3 Explore data by asking questions
5.4.4 Review Quick insights
5.4.5 Add a dashboard theme
5.4.6 Pin a live report page to a dashboard
5.4.7 Set mobile view
5.4.8 Summary
Activity:Accordion
Activity: Knowledge Check
5.5.1 Introduction
5.5.2 Configure row-level security with the static method
5.5.3 Configure row-level security with the dynamic method
5.5.4 Use single sign-on (SSO) for DirectQuery sources
5.5.5 Restrict access to Power BI model objects
5.5.6 Summary
Activity:Drag-and-Drop
Activity: Knowledge Check
Resources
PL300T00 Blueprint
PL300T00 Detailed Curriculum
Next
Side panel
Categories
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Search
Search
Search
Search
Close
Toggle search input
Log in
Categories
Collapse
Expand
All categories
AICERTs- Extended E-Learnin...
AICERTs- Extended E-Learnin...
NetCom+
NetCom+ v1
AI CERTs Free Courses
NetCom+ Bengali
Netcom+ Free Courses
AI Tools
Soft Skills
Internal Training
Microsoft Spanish
Home
Course info
PL-300T00: Design and manage analytics solutions using Power BI
Grade
Certificate
Certificate Download
Certificate Sharing
