This course is designed to prepare students for the Microsoft Power BI Data Analyst (PL-300) certification exam. It covers all the topics necessary to become a proficient Power BI data analyst, including data modeling, visualization, report creation, and dashboard design.

The course begins with an introduction to Power BI and its various components. Students will learn about data sources, data modeling, and creating visuals in Power BI. The course also covers creating reports, including adding visuals and formatting options.

In addition to report creation, the course will cover advanced visualization techniques, including drill-throughs, bookmarks, and custom visuals. Students will also learn how to design dashboards and create KPIs using Power BI.

Throughout the course, students will have access to hands-on labs and practical exercises to reinforce their learning. The labs will be based on real-world scenarios, allowing students to apply their knowledge to actual data analysis situations.

By the end of the course, students will be prepared to take the Microsoft Power BI Data Analyst (PL-300) certification exam. The exam validates the skills needed to design and develop data models, reports, and dashboards in Power BI.

Course Duration: 3 Days

What You’ll Learn

By the end of this course, learners will be able to:

• Apply predictive data modelling techniques to identify patterns across multiple datasets using Power BI.
• Create prototype algorithms to make decisions on patterns.
• Manage the creation of interactive data visualisations using industry-standard tools in line with organisational procedures.
• Apply data aggregation and machine learning techniques to gain new insights into data.
• Assess relevant insights from mined data and determine their impact on the organisation for ongoing improvements.
  
  
  

Course Topics

Topic 1: Discover data analysis

• Overview of data analysis
• Roles in data
• Tasks of a data analyst

Topic 2: Get started building with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

Topic 3: Get data in Power BI

• Get data from files
• Get data from relational data sources
• Get data from a NoSQL database
• Get data from online services
• Select a storage mode
• Get data from Azure Analysis Services
• Fix performance issues
• Resolve data import errors

Topic 4: Clean, transform, and load data in Power BI

• Shape the initial data
• Simplify the data structure
• Evaluate and change column data types
• Combine multiple tables into a single table
• Profile data in Power BI
• Use Advanced Editor to modify M code

Topic 5: Design a data model in Power BI

• Get data from files
• Get data from relational data sources
• Get data from a NoSQL database
• Get data from online services
• Select a storage mode
• Get data from Azure Analysis Services
• Fix performance issues
• Resolve data import errors

Topic 6: Introduction to creating measures using DAX in Power BI

• Introduction to DA
• Understand context
• Use the Calculate function
• Use relationships effectively
• Create semi-additive measures
• Work with time intelligence

Topic 7: Optimize a model for performance in Power BI

• Introduction to performance optimization
• Review performance of measures, relationships, and visuals
• Use variables to improve performance and troubleshooting
• Reduce cardinality
• Optimize DirectQuery models with table level storage
• Create and manage aggregations

Topic 8: Work with Power BI visuals

• Introduction to work with Power BI visuals
• Add visualization items to reports
• Choose an effective visualization
• Format and configure visualizations
• Import a custom visual
• Add an R or Python visual
• Work with key performance indicators

Topic 9: Create a data-driven story with Power BI reports

• Introduction to create a data-driven story with Power BI reports
• Design a report layout
• Add buttons, bookmarks, and selections
• Design report navigation
• Use basic interactions
• Use advanced interactions and drill through
• Configure conditional formatting
• Apply slicing, filtering, and sorting
• Publish and export reports
• Comment on reports
• Tune report performance
• Optimize reports for mobile use
  
  

Topic 10: Create dashboards in Power BI

• Introduction to dashboards
• Configure data alerts
• Explore data by asking questions
• Add a dashboard theme
• Pin a live report page to a dashboard
• Configure a real-time dashboard
• Configure data classification
• Set mobile view

Topc 11: Perform analytics in Power BI

• Introduction to analytics
• Explore statistical summary
• Identify outliers with Power BI visuals
• Group and bin data for analysis
• Apply clustering techniques
• Conduct time series analysis
• Use the Analyze feature
• Use advanced analytics custom visuals
• Review Quick insights
• Apply AI Insights

Topic 12: Work with AI visuals in Power BI

• Introduction to working with AI visuals
• Use the Q&A visual
• Find important factors with the Key influencers visual
• Use the Decomposition Tree visual to break down a measure

Topic 13: Create and manage workspaces in Power BI

• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

Topic 14: Manage datasets in Power BI

• Create dynamic reports with parameters
• Create what-if parameters
• Use a Power BI gateway to connect to on-premises data sources
• Configure a dataset scheduled refresh
• Configure incremental refresh settings
• Manage and promote datasets
• Troubleshoot service connectivity

Topic 15: Implement row-level security

• Configure row-level security with the static method
• Configure row-level security with the dynamic method

Final Assessment

• Written Assessment – Short Answer Questions (WA-SAQ)
• Practical Performance (PP)