Course Outline:
Day 1
- Introduction to the course and overview
- Module 1: Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Getting Started with Power BI
- Module 2: Getting Data in Power BI
- Data Analytics and Microsoft
- Optimize Performance
- Resolve Data Errors
Break (15 mins.)
- Lab: Preparing Data in Power BI Desktop
- Module 3: Clean, Transform, and Load Data in Power BI
- Shaping the Data
- Profiling the Data
- Enhance the data structure
- Lab: Loading Data in Power BI Desktop
Break (15 mins.)
- Module 4: Design a Data Model in Power BI
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
- Lab: Data Modeling in Power BI Desktop
Day 2
- Module 5: Create Model Calculations using DAX in Power BI
- Introduction to DAX
- Lab: Introduction to DAX in Power BI Desktop
Break (15 mins.)
- Module 5: Create Model Calculations using DAX in Power BI
- Advanced DAX
- Real-time dashboards
- Lab: Advanced DAX in Power BI Desktop
Break (15 mins.)
- Module 6: Optimize Model Performance in Power BI
- Optimize the data model for performance
- Optimize Direct Query Models
- Module 7: Create Reports in Power BI
- Design a Report
- Enhance the Report
Day 3
- Lab: Designing a report in Power BI Desktop
- Lab: Enhancing reports with interaction and formatting in Power BI Desktop
Break (15 mins.)
- Module 8: Create Dashboards in Power BI
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
- Lab: Creating a Dashboard in Power BI Service
Break (15 mins.)
- Module 9: Identify Patterns and Trends in Power BI
- Advanced Analytics
- Data Insights through AI visuals
- Lab: Data Analysis in Power BI Desktop
- Module 10: Create and Manage Workspaces in Power BI Service
- Creating Workspaces
- Course wrap-up and Q&A session
- Module 11: Financial Modeling in Power BI
- Advanced Analytics and Dashboard Preparation
Duration : 3 Days (18 hrs.) Project Based
Mode of training : Online (Live Training Session)
Course Features
- Lectures 7
- Quizzes 0
- Duration 18 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
Curriculum
- 2 Sections
- 7 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Key Topics Covered:4
- Course Benefits:3






