Power BI Data Analyst

This Course Includes:

Learn Power BI and become a Microsoft-certified Power BI Data Analyst with Seven Learning’s course Power BI Data Analyst. The course has well descriptive interactive lessons containing knowledge checks, quizzes, flashcards, and glossary terms to get a detailed understanding of preparing, modelling, visualising and analysing the data in Power BI. The live labs present in the course will give you a hands-on experience of data analysis in Power BI.

What do you get:

Microsoft Power BI Data Analyst focuses on using Microsoft Power BI for data analysis. The PL-300 exam covers various topics such as getting data from different data sources, and profiling, cleaning, transforming, and loading the data, data modeling: designing, developing, and optimizing a data model, visualising and analysing data, such as creating reports and dashboards, as well as performing advanced analysis.

Lessons 1: Introduction

  • Organisation of this course
  • Microsoft certifications

Lessons 2: Prepare the data

  • Skill 1.1: Get data from different data sources
  • Skill 1.2: Profile the data
  • Skill 1.3: Clean, transform and load the data

Lessons 3: Model the data

  • Skill 2.1: Design a data model
  • Skill 2.2: Develop a data model
  • Skill 2.3: Create measures by using DAX
  • Skill 2.4: Optimise model performance

Lessons 4: Visualise the data

  • Skill 3.1: Create reports
  • Skill 3.2: Create dashboards
  • Skill 3.3: Enrich reports for usability

Lessons 5: Analyse the data

  • Skill 4.1: Enhance reports to expose insights
  • Skill 4.2: Perform advanced analysis

Lessons 6: Deploy and maintain deliverables

  • Skill 5.1: Manage datasets
  • Skill 5.2: Create and manage workspaces

Hands-on LAB Activities

Prepare the data

  • Creating a Data Connection
  • Profiling Data in Power BI
  • Using the Transpose Feature
  • Shaping Data for Analysis
  • Cleaning, Transformings and Loading Connected Data

Model the data

  • Configuring and Managing Data Relationships
  • Creating a Calculated Table
  • Creating and Managing Data Hierarchies
  • Creating Calculations with DAX
  • Creating Conditional Columns
  • Creating Calculated Measures

Visualise the data

  • Reviewing Custom Visuals and Apps
  • Filtering and Slicing Reports
  • Customising Visuals in Power BI
  • Charting Data in Power BI
  • Creating Visualisations
  • Configuring the Mobile Layout
  • Incorporating Tooltips to Enhance Data Analysis
  • Saving and Exporting Files in Power BI

Analyse the data

  • Enhancing Reports
  • Enhancing Visuals with Statistical Analysis
  • Performing Advanced Analysis

Deploy and maintain deliverables

  • Configuring Row-level Security
  • Publishing Reports and Refreshing Data
  • Enhancing Dashboards

Exam FAQs

FAQ's are not Available for this course.



Power BI Data


6+ Lessons

Delivery Method:




Scroll to Top