Curriculum
7 Sections
34 Lessons
10 Weeks
Expand all sections
Collapse all sections
Introduction to Data Analytics & Power BI
Learn the fundamentals of data analysis and how Power BI fits into the modern data ecosystem.
5
1.1
Discover data analysis and analyst roles
1.2
Tasks of a data analyst
1.3
Power BI services and applications
1.4
Creating visuals and reports
1.5
Business efficiency with Power BI
Data Preparation & Transformation
Master data import, cleaning, and transformation techniques in Power BI.
5
2.1
Connecting to data sources
2.2
Storage modes and performance
2.3
Data import error resolution
2.4
Cleaning and transforming data
2.5
Naming conventions and shaping data
Data Modeling with DAX
Design semantic models and use DAX for calculated measures and performance optimization.
5
3.1
Star schema design and relationships
3.2
DAX syntax and calculated columns
3.3
Filter context and time intelligence
3.4
Visual calculations and parameters
3.5
Performance optimization with variables
Designing Interactive Reports
Create engaging and interactive reports with advanced visuals and navigation features.
5
4.1
Report structure and visual types
4.2
Formatting and configuring visuals
4.3
Navigation, bookmarks, and drill-through
4.4
Paginated reports and user experience
4.5
Advanced analytics: clustering, trends
Managing & Publishing Reports
Learn how to manage workspaces, publish reports, and implement security.
6
5.1
Workspace creation and permissions
5.2
Sharing and distributing reports
5.3
Semantic model management
5.4
Scheduled and incremental refresh
5.5
Dashboard creation and mobile view
5.6
Row-level security (static and dynamic)
Power BI Copilot & Microsoft Fabric Overview
Explore AI-powered features in Power BI and the Microsoft Fabric ecosystem.
4
6.1
Copilot for report creation and summaries
6.2
Semantic model requirements
6.3
End-to-end analytics with Microsoft Fabric
6.4
Data team roles and Fabric enablement
Capstone Project
Participants will complete a hands-on project demonstrating their Power BI skills.
4
7.1
Data preparation and modeling
7.2
Report design and publishing
7.3
Use of DAX and advanced analytics
7.4
Dashboard creation and security setup
Power BI Data Analyst
Curriculum
This content is protected, please
login
and enroll in the course to view this content!
Home
Courses
Search
Search
Account
Login with your site account
[microsoft_login_button]
Not a member yet?
Register now
Register a new account
Want to become an instructor?
Are you a member?
Login now
Modal title
Main Content