Microsoft Power BI

Advanced

Download PDF
Back to Courses

Course Details

Course Name

Microsoft Power BI Advanced

Duration

3 Days

Course Code

AFBMPBA

Assumed Knowledge

Intermediate Knowledge of Power BI

Course Aims

This course will give you the tools and skills you need to become a Power BI expert. You’ll discover advanced features for each step of your project, from powerful new data connections, advanced data modelling to incredible new ways to share your data story. We’ll be working on an advanced reporting project from start to finish and along the way you’ll see ways to fix and troubleshoot the most common problems, how to present your data in a compelling way, and taking your first steps down the road of development.

What You Will Learn

The objective of the course is to give attendees an advanced understanding of the full data journey in Power BI, supported by in-depth knowledge of methodologies and processes, as well as day to day examples and business use cases to help you take your learning back to your business.

Skills

  • Understanding complex Power BI architecture, such as DataMarts, Lakes, and Warehouses
  • When and why, we should use paginated reports, as well as the Power BI Report builder desktop app, as well as creating and using Power BI apps in your organisation
  • Advanced data connections such as DirectQuery, Live connections and using composite models or aggregations, followed by in-depth Power Query, optimisation and Mcode basics
  • Advanced Power Query use cases, data optimisation and exploring the Mcode language
  • Using workkflows and gateways to fix common issues.
  • Advanced DAX use cases like time intelligence, filters, contexts and measures
  • Advanced Data Modelling, complex relationships; many to many, multiple fact tables
  • An overview of custom visuals in Power BI using R or Python
  • Advanced license options, complex troubleshooting scenarios, and an exploring Power BI service features for expert users

Who This Is For

This course is aimed towards individuals that have a solid understanding of the Power BI report building process and service and want to gain an understanding of the advanced tools available to them.

Course Content

Advanced Power BI Infrastructure

  • Topic A

    Infrastructure overview

  • Topic B

    What are DataMarts, Lakes, Lakehouses and Warehouses? When should we use them?

  • Topic C

    Power BI Report Builder desktop app overview

  • Topic D

    Power BI in Non-Microsoft environments

Power BI Apps

  • Topic A

    What’s a Power BI App? Why use it?

  • Topic B

    Finding and using apps on the store

  • Topic C

    Sharing your app

Advanced Data Connections

  • Topic A

    When to use Live Data?

  • Topic B

    Live vs Realtime data

  • Topic C

    DirectQuery, Live Connections and composite models

Deep Dive Power query

  • Topic A

    Handling changes in data sources

  • Topic B

    Making changes to a gateway

  • Topic C

    Mcode Basics and Custom Functions

Advanced DAX

  • Topic A

    Advanced DAX functions and use cases

  • Topic B

    Advanced Measures

  • Topic C

    The importance of Context

  • Topic D

    DAX time intelligence use cases

  • Topic E

    Third Party tools

Mastering Models

  • Topic A

    Complex data relationships

  • Topic B

    Many To Many

  • Topic C

    Multiple fact tables

  • Topic D

    Optimising performance

Custom Visuals

  • Topic A

    What are custom visuals?

  • Topic B

    Business use cases for custom visuals

  • Topic C

    R or Python and how they’re implemented

  • Topic D

    Overview of the installation process

  • Topic E

    Creating a simple custom visual

Visualisation deep dive

  • Topic A

    Groupings, analysis, predictions, and sparklines

  • Topic B

    Advanced interactivity

Advanced Power BI Service

  • Topic A

    Co-Pilot deep dive and report building

  • Topic B

    Monitoring Hub

Other ways to reach your audience

  • Topic A

    Power BI Premium and Premium per user explained

  • Topic B

    Sharing options in Premium

  • Topic C

    What is Power BI Embedded? Why use it?

Becoming a Data Storyteller

  • Topic A

    What is data storytelling?

  • Topic B

    Data Storytelling techniques

  • Topic C

    Advanced Sharing and Presenting

  • Topic D

    PowerPoint presenting with integrated reports

  • Topic E

    Sharing, collaborating, and presenting in Teams

The development Journey

  • Topic A

    Development methodology overview

  • Topic B

    DEV, TEST, and PROD

  • Topic C

    Creating development pipelines in fabric

  • Topic D

    Managing a deployment

Advanced Troubleshooting

  • Topic A

    Advanced troubleshooting and support pathways

Course Progression

Power BI is a powerful tool for data analysis and visualisation that can help you gain insights and make informed decisions. At Appetite, we understand the significance of learning the full depth of using Power BI in a modern organisation. That’s why we offer a range of courses from introduction to advanced, covering topics such as data modelling, DAX, visualisations, dashboards, reports, and more. We can guide you from having no prior knowledge to building very detailed reports using some advanced skills.

Whether you want to learn the basics of Power BI, or take your skills to the next level, we have a course for you. Our courses are interactive, engaging, and can also be tailored to your needs. You’ll learn from our experienced trainers who will share their best practices and tips for success. By the end of the course, you’ll be able to apply your learning to your own data and scenarios, and create stunning and impactful reports that will impress your colleagues and stakeholders.

Join us in discovering the power of Power BI and enhancing your data literacy by taking one of the following courses.

Introduction to Power BI

1 Day

Introduction to Power BI Service

1 Day

Microsoft Power BI Essentials

1 Day

Microsoft Power BI Intermediate

3 Days

Microsoft Power BI Advanced

3 Days

Microsoft Power BI Masterclass

5 Days

Why Companies Love Working with Appetite

Join 100 + companies using our services to meet their growth needs.