About Course
5-days training focused on modeling, visualizing, and analyzing data using Power BI. Learn data processing, security implementation, report deployment, and more. Course objectives include data ingestion, transformation, modeling, and advanced analytics. No prerequisites required.
- Course outline covers topics such as Microsoft data analytics, data loading and optimization, data modeling, DAX calculations, performance optimization, report and dashboard creation, advanced analytics, workspace creation and management, and row-level security in Power BI.
Course Objectives:
Upon completion of this program, candidates should 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
Who Should Attend?
None
Pre-requisite
None
Course Curriculum
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
Module 3: Loading Data in Power BI Desktop
• Loading Data
Module 4: Design a Data Model in Power BI
• Introduction to data modeling
• Working with tables
• Dimensions and Hierarchies
Module 5: Create Model Calculations using DAX in Power BI
• Introduction to DAX
• Real-time dashboards
• Advanced DAX
Module 6: Optimize Model Performance in Power BI
- Optimize the data model for performance
- Optimize DirectQuery Models
Module 7: Create Reports in Power BI
- Design a report
- Enhance the report
Module 8: Create Dashboards in Power BI
- Create a Dashboard
- Real-time Dashboards
- Enhance a Dashboard
Module 9: Identify Patterns and Trends in Power BI
- Advanced Analytics
- Data Insights through AI visuals
Module 10: Create and Manage Workspaces in Power BI
- Creating Workspaces
- Sharing and Managing Assets
Module 11: Manage Files and Datasets in Power BI
- Parameters
- Datasets
Module 12: Row-level Security in Power BI
• Security in Power BI
