Microsoft Power BI

Intermediate

Download PDF
Back to Courses

Course Details

Course Name

Microsoft Power BI Intermediate

Duration

3 Days

Course Code

AFBMPBI

Assumed Knowledge

Basic understanding of Power BI or similar

Course Aims

Now that you’re familiar with the basics of Power BI and report building, it’s time to take the next steps in your learning journey! You’re now ready to understand the ‘why’ and what’s next, so in this course, you’ll work with us on a carefully guided journey from raw data to engaging report while we build upon what you already know. We follow one of the most common industry approaches to working with data and understanding the choices behind each step. You’ll learn how to build better reports and datasets with powerful data connections, exciting new visualisations, tips on report design and more!

What You Will Learn

The objective of the course is to offer you a guided journey to approaching a more complex Power BI reporting project from raw data to report production and sharing, through the use of more advanced techniques and tools – all supported by real life use cases. You’ll tackle the real life challenges that you face as you look to clean, transform or integrate multiple different data sources. Learn to enrich your data with more complex transformations, provide an engaging report that tells the message you need, and how to share with the right. By the end of the course, you’ll have developed the confidence to correctly plan and execute more complex data projects.

Skills

  • You’ll learn the Extract, Transform, and Load (ETL) methodology of working with data
  • How to handle and transform more complex datasets and connections, when it’s right to use cloud or on premises solutions, and using more complex DAX to solve data problems
  • Report building approaches and best practices in design
  • Understanding which visualisations to use and enhancing your work with AI
  • Advanced formatting with bookmarks, side panels and navigation experiences
  • Using and testing roles to keep your data in the right hands

Who This Is For

This course is aimed towards individuals that have a basic understanding of the Power BI report building process and are looking to develop their skills further to support their role or career progression.

Course Content

What’s a Data Wrangler?

  • Topic A

    So what’s a Data Wrangler?

  • Topic B

    Excel or Power BI? The right tool for the right job

  • Topic C

    What is ETL?

  • Topic D

    How ETL is implemented in Power BI

  • Topic E

    A Dashboard or Report? Plan your project

The Power Of Datasets

  • Topic A

    Is it Dataset or Semantic Model, or Semantic Layer?

  • Topic B

    Data Source considerations

  • Topic C

    On Premises vs Cloud sources

  • Topic D

    Understanding Gateways

Going further with Data Connections

  • Topic A

    Common industry Data sources

  • Topic B

    Importing from SQL or APIs/web endpoints

  • Topic C

    Power BI Semantic models as a source

Going Further With Data Transformation

  • Topic A

    Data transformation best practices

  • Topic B

    Power Query next steps

  • Topic C

    Data Profiling and Quality

  • Topic D

    Using advanced transformations

  • Topic E

    Adding indexes, and why they matter

  • Topic F

    Date and Time

  • Topic G

    Split columns

  • Topic H

    Standard operator columns

  • Topic I

    Merging, Appending, or Referencing Queries

Data Modelling basics

  • Topic A

    Introduction to Data Modelling concepts

  • Topic B

    Setting relationships manually or automatically

  • Topic C

    Hierarchies overview

  • Topic D

    DAX overview

  • Topic E

    Useful DAX functions

  • Topic F

    Time intelligence in DAX

Taking your reports further

  • Topic A

    Audience consideration

  • Topic B

    Report Building and design best practices

  • Topic C

    Which visualisation to use and when?

  • Topic D

    Using the Visualisations marketplace

  • Topic E

    Adding and formatting advanced visualisations

Visualisation deep dive

  • Topic A

    Groupings, analysis, predictions, and sparklines

  • Topic B

    Advanced interactivity and Drill Through

Enhancing the report with Co-Pilot

  • Topic A

    Co-Pilot overview

  • Topic B

    Narrative Visuals and Q&A/Synonyms

Design Deep Dive

  • Topic A

    Exploring visual formatting

  • Topic B

    Designing in 3D

  • Topic C

    Advanced actions and bookmarks

  • Topic D

    Mobile formatting tips and tricks

Considering your audience

  • Topic A

    The importance of roles

  • Topic B

    Using and testing roles

Going Further with the Power BI service

  • Topic A

    Service Deep Dive and refreshing datasets

  • Topic B

    Overview of web, portal and embedded publishing

  • Topic C

    Using Dataflows

  • Topic D

    Advanced editing using the service

  • Topic E

    Advanced sharing options and considerations

  • Topic F

    Paginated Reports and use cases

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 for Business, 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

2 Days

Microsoft Power BI Intermediate

3 Days

Microsoft Power BI Advanced

3 Days

Microsoft Power BI Masterclass

5 Days

Why Companies Love Working with Appetite for Business

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