ITIL® (Version 5) available now! Learn more

By the end of this course, learners will be able to import and transform data from multiple sources, design effective data models, create interactive visualizations and dashboards, apply calculations and measures using DAX, and share insights with stakeholders while adhering to best practices in data visualization and reporting.

1. Overview of Microsoft Power BI

  • Understand the Applications    
  • Power BI Desktop and Power Query
  • The Power BI Service

2. Build a Basic Report

  • Import Data
  • Add Visualisations

3. Get & Transform Data - Power Query

  • Import Data ® from various sources
  • Transform Data (Tidy, Convert, Clean)
  • Edit Queries

4. Build the Data Model

  • Relationships Between Tables
  • Introduction to DAX Formulas:
  • Calculated Columns, Tables & Measures

5. Build a visual Report

  • Report Pages
  • Handle Visualisations (Tiles)
  • Format Visuals - Fields, Format, Analytics

6. Power BI Service    

  • Publish Desktop Report to PBI Service
  • View/Edit Report in PBI Service
  • Create Dashboard

Business analysts, data analysts, report developers, and professionals interested in data visualization and business intelligence

Instructor-led sessions, lab exercises, course slides, sample datasets, practice dashboards

Basic knowledge of Excel, familiarity with data concepts, and understanding of business processes

Microsoft Docs: Power BI Documentation

This course prepares learners for the PL-300: Data Analyst Associate certification exam. The exam evaluates your ability to prepare, model, visualize, and analyze data in Power BI, as well as deploy and maintain deliverables. The exam includes multiple-choice, scenario-based, and practical exercises. Successfully passing the exam demonstrates proficiency in using Power BI to create actionable insights and supports a career as a data analyst.

Proctored Exam
Microsoft Certified: Data Analyst Skills

After this course, learners can take advanced Power BI or data analytics courses, including Power BI Advanced Modeling, DAX Mastery, or Azure Data Analytics pathways.

Prerequisites

A strong knowledge of Microsoft Excel is recommended and this course will use Power BI Pro Desktop in its delivery.

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager

Reviews

INFORMATION

Power BI Essentials Course Dates

There are currently no course dates that match your selected filter options. Please try another filter or contact one of our dedicated account managers on +44 208 1428 961 to discuss your requirements. Thanks.