Duration
2 days
Course Description
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.
Objectives
After completing this course, you will be able to
- Ingest, clean, and transform data
- Model data for performance and scalability
- Design and create reports for data analysis
- Apply and perform advanced report analytics
- Manage and share report assets
- Create paginated reports in Power BI
Module 1: Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Getting Started with Power BI
Module 2: Prepare Data in Power BI
- Get data from various data sources
- Resolve data errors
Module 3: Clean, Transform, and Load Data in Power BI
- Data shaping
- Enhance the data structure
- Data Profiling
Module 4: Design a Data Model in Power BI
- Introduction to data modeling
- Working with tables
- Dimensions and Hierarchies
Module 5: Create Measures using DAX in Power BI
- Introduction to DAX
- DAX context
Module 6: Create Reports
- Design a report
- Enhance the report
Module 7: Create Dashboards
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
Module 8: Create and Manage Workspaces
- Creating Workspaces
Programme scope, delivery arrangements and suitability are confirmed during enquiry.