power bi training, power bi certification, pl 300 exam, pl300 exam, pl 300 certification, pl300 certification, course on power bi, power business intelligence
SKU: MS-PL300T00 Category:

Design & Manage Analytics Solutions Using Power BI

Turn data into clear decisions with Power BI. Learn practical methods and best practices for modelling, visualising and analysing data – aligned to real business and technical needs. Connect to relational and non-relational sources, shape and process your data properly and build reports and dashboards that are ready to share, scale and deliver value.

R8,500.00 Excl. VAT

Product Details

Power BI training course that provides a comprehensive guide to modeling, visualising and analysing data using Microsoft Power BI. Participants will learn best practices aligned with business and technical requirements, access and process data from both relational and non-relational sources and develop insights through interactive reports and dashboards. This course on Power BI also prepares learners for Power BI certification, including the PL-300 exam (PL300 exam), helping you gain the skills and knowledge needed for PL-300 certification (pl300 certification) and a career in Power Business Intelligence.

 

Discover more

Download Outline ➤ MS-PL300T00 Design & manage analytics solutions using Power BI

Watch an informative video ➤ What is Power BI

ASSOCIATED CERTIFICATIONS & EXAM

This course will prepare delegates to write the PL-300 Power BI Data Analyst Associate exam.

 

Module 1: Get started with Microsoft data analytics

Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards that support trusted, data-driven decisions across the business.

Power BI Module 1.1

Discover data analysis
  • Explore the journey of a data analyst
  • Learn how a data analyst tells a story with data
  • Understand the different roles in data and the tasks of a data analyst

Power BI Module 1.2

Get started building with Power BI
  • Learn about Power BI
  • Understand the building blocks and flow of Power BI
  • Create compelling, interactive reports

Power BI Module 1.3

Introduction to end-to-end analytics using Microsoft Fabric
  • Discover how Microsoft Fabric meets enterprise analytics needs in one platform
  • Learn how Microsoft Fabric works
  • Identify how to use Microsoft Fabric for analytics

Power BI Module 1.4

Get started with Copilot in Power BI
  • Increase productivity when developing semantic models and reports
  • Interact with your data using natural language to gain insights
  • Leverage Copilot to enhance your Power BI experience

Module 2: Prepare data for analysis with Power BI

You’ll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You’ll also learn to profile, clean, and load data into Power BI before you model your data.

Power BI Module 2.1

Get data in Power BI
  • Retrieve data from a variety of sources including Excel, relational databases, and NoSQL data stores
  • Learn techniques to improve data retrieval performance

Power BI Module 2.2

Clean, transform and load data in Power BI
  • Use Power Query to clean and prepare data for analysis
  • Simplify complex models, change data types, rename objects, and pivot data
  • Profile columns to identify valuable data for deeper analytics

Power BI Module 2.3

Choose a Power BI model framework
  • Understand different Power BI model frameworks
  • Learn the benefits and limitations of each framework
  • Explore features to optimise Power BI data models

Module 3: Model Data with Power BI

Data modeling configures and shapes your prepared data to design a semantic model with the necessary relationships and calculations using Data Analysis Expressions (DAX). This process ensures accurate analysis and sets you up to create clear, impactful Power BI reports.

Power BI Module 3.1

Configure a semantic model
  • Semantic models organise complex data into an intuitive structure
  • Enhance data visualisation
  • Enable efficient, insightful reporting for better decision-making

Power BI Module 3.2

Write DAX formulas for semantic models
  • Use DAX, a formula language for Power BI
  • Create calculations and add logic
  • Enhance data analysis within reports and semantic models

Power BI Module 3.3

Create DAX calculations in semantic models
  • Add DAX calculations to semantic models
  • Define custom logic within your data model
  • Enable deeper analysis and data-driven business decisions

Power BI Module 3.4

Modify DAX filter context in semantic models
  • Control how calculations evaluate data in semantic models
  • Gain deeper insights by tailoring analysis in reports
  • Choose exactly what data is included in calculations

Power BI Module 3.5

Use DAX time intelligence functions in semantic models
  • Analyse and compare data across different time periods
  • Support reporting on trends, growth, and performance over time
  • Enable insightful time-based reporting

Power BI Module 3.6

Create visual calculations in Power BI Desktop
  • Enrich data analysis with calculations
  • Simplify complex formulas for better performance
  • Reduce maintenance effort in reports

Power BI Module 3.7

Optimise a model for performance in Power BI
  • Make changes to improve semantic model efficiency
  • Apply performance tuning techniques
  • Ensure reports and dashboards run more efficiently

Module 4: Design effective reports in Power BI

Use data visualisation and storytelling techniques to create insightful, dynamic Power BI reports that engage users, highlight key findings, and help inform decisions based on data.

Power BI Module 4.1

Scope report design requirements
  • Identify your audience
  • Choose suitable report types
  • Define interface and experience requirements for effective report planning

Power BI Module 4.2

Design Power BI Reports
  • Create visually appealing and easy-to-understand reports
  • Maintain consistent report structure
  • Use interactive objects and filtering effectively

Power BI Module 4.3

Enhance Power BI report designs for the user experience
  • Design reports with intuitive navigation
  • Enable users to explore data easily
  • Ensure reports are meaningful and user-friendly

Power BI Module 4.4

Perform analytics in Power BI
  • Gain deeper insights into your data with advanced analytics
  • Identify trends and patterns
  • Use Power BI tools and features for effective data analysis

Module 5: Manage and secure Power BI

Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organisation.

Power BI Module 5.1

Manage workspaces in Power BI Service
  • Explore the Power BI service
  • Create and manage workspaces
  • Distribute reports to users effectively

Power BI Module 5.2

Manage semantic models in Power BI
  • Understand the importance of semantic models
  • Ensure data connectivity and accuracy
  • Improve report performance through efficient management

Power BI Module 5.3

Choose a content distribution method
  • Select the best method to distribute Power BI content
  • Understand the differences between sharing, publishing, and apps
  • Ensure content reaches the intended audience efficiently

Power BI Module 5.4

Create dashboards in Power BI
  • Understand the difference between dashboards and reports
  • Create dashboards composed of pinned visuals from multiple reports
  • Deliver personalised dashboards for report consumers

Power BI Module 5.5

Secure data access in Power BI
  • Implement row-level security (RLS) using static or dynamic methods
  • Use object-level security (OLS) to restrict access to model objects
  • Test RLS in Power BI Desktop and Power BI Service

 

Disclaimer

Training4Every1 Course details and content may change without notice to stay aligned with current software updates and best practices.

By booking this training, you agree to our Training Terms and Conditions.

Click here to view Training T & C’s.

Got questions or feeling a bit lost in Excel, Word or Teams?

Don’t worry – we’ve got you! Reach out and we’ll help you find the perfect Microsoft training for you and your team.

Follow us and stay up to date with the latest training journeys, business solutions and powerful automation tools.

Microsoft Outlook Training    Microsoft Outlook Training

Related products

Data4Every1