Enterprise Business Intelligence with Microsoft Power BI

• Prepare data from multiple sources using Power Query.
• Build robust Power BI data models.
• Create DAX measures for business calculations.
• Develop interactive reports and dashboards.
• Optimize Power BI report performance.
• Apply row-level security to Power BI content.
• Manage Power BI workspaces and apps.
• Publish and share Power BI reports.
• Work with Power BI Service for enterprise reporting.
• Apply Power BI skills to real-world business intelligence scenarios.

Module 1: Introduction to Power BI

Module 2: Connecting to Data

Module 3: Data Preparation with Power Query

Module 4: Data Modeling

Module 5: DAX and Data Analysis

Module 6: Data Visualization

Module 7: Interactive Reports and Business Storytelling

Module 8: Advanced Analytics

Module 9: Power BI Service

Module 10: Enterprise Power BI Security

Module 11: Power BI Refresh and Gateways

Module 12: Enterprise Deployment and Governance

Module 13: Performance Optimization

Module 14: Enterprise Business Intelligence Project

5 Days

Microsoft Certified: Power BI Data Analyst Associate

Exam: PL-300: Microsoft Power BI Data Analyst

Format: Multiple-choice

• Connect Power BI to multiple data sources.
• Connect Power BI to Azure SQL Database.
• Import and transform enterprise datasets.
• Clean and profile data using Power Query.
• Merge and append queries.
• Create fact and dimension tables.
• Build a Power BI semantic model.
• Create relationships between tables.
• Create DAX measures.
• Create time-intelligence calculations.
• Build interactive Power BI reports.
• Create dashboards and KPI visualizations.
• Configure slicers and filters.
• Implement drillthrough and report navigation.
• Publish reports to Power BI Service.
• Create and configure Power BI workspaces.
• Create Power BI apps.
• Configure semantic-model refresh.
• Configure gateway requirements.
• Implement row-level security.
• Configure workspace roles and permissions.
• Apply sensitivity labels.
• Optimize report performance.
• Use Performance Analyzer.
• Complete an end-to-end enterprise BI project.

• Data Analysts
• Business Intelligence Analysts
• BI Developers
• Reporting Analysts
• Power BI Professionals
• Professionals working with enterprise reporting
• Professionals preparing for the PL-300 certification

• Basic understanding of data concepts such as tables, fields and data types.
• Basic Microsoft Excel proficiency.
• General computer skills.
• Logical thinking and problem-solving skills.