Design and Manage Analytics Solutions using Power BI
Course Code: MSPL300
Duration: 3 days
Price: £2295
Upcoming Events
- Virtual Classroom
- Mon 18 May 2026
- 3 days
- £2,295.00 (€2,690.00)
- Virtual Classroom
- Mon 20 July 2026
- 3 days
- £2,295.00 (€2,690.00)
- Virtual Classroom
- Mon 7 September 2026
- 3 days
- £2,295.00 (€2,690.00)
- Virtual Classroom
- Mon 23 November 2026
- 3 days
- £2,295.00 (€2,690.00)
Course Overview:
This PL300 course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.
The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Target Audience:
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Course Objectives:
By actively participating in this course, you will learn about the following:
- 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.
Course Content:
Module 1 : Get Started with Microsoft Data analytics- Discover Data Analysis
- Get started building with Power BI
- Introduction to end-to-end analytics using Microsoft Fabric
Module 2 : Prepare Data for Analysis with Power BI-Get data in Power BI
- Clean, transform, and load data in Power BI
- Choose a Power BI model framework
Module 3 : Model Data with Power BI
- Configure a semantic model
- Write DAX formulas for semantic models
- Create DAX calculations in semantic models
- Use DAX time intelligence functions in semantic models
- Create visual calculations in Power BI Desktop
-
Optimize a model for performance in Power BI
Module 4 : Design Effective Reports in Power BI
- Scope report design requirements
- Design Power BI reports
- Enhance Power BI report designs for the user experience
- Perform analytics in Power BI
Module 5 : Manage and Secure Power BI
- Manage workspaces in Power BI service
- Manage semantic models in Power BI
- Choose a content distribution method
- Create dashboards in Power BI
-
Secure data access in Power BI
Prerequisites:
The PL-300: Microsoft Power BI Data Analyst course and exam are designed for individuals aiming to demonstrate their expertise in analyzing data with Power BI. While there are no strict prerequisites mandated by Microsoft, the following foundational skills and knowledge are highly recommended to ensure success:
- Basic Data Analysis Knowledge:
- Understanding of data concepts, such as data tables, relationships, and common visualization types.
- Familiarity with basic statistical concepts like averages, sums, and trends.
Proficiency in Microsoft Excel:
- Some experience with Excel functions like pivot tables, charts, and formulas is advantageous.
- Understanding of Data Sources: and basic knowledge of data structures and how to work with different data sources, such as SQL databases, Excel files, or cloud services.
Technical Skills:
- Ability to navigate and use software applications comfortably.
- Familiarity with Power BI Desktop and Power BI Service is beneficial but not mandatory.
General IT Knowledge:
- Awareness of fundamental IT concepts such as file systems, basic networking, and application installation.
Certification / Exam:
This course will help to prepare for exam PL-300 - Microsoft Certified: Power BI Data Analyst Associate.
Further Information:
For more information or to book this course, please contact our Course Enquiries Team on 0117 370 1970 or send us an email us at enquiries@skilltec.co.uk
