Microsoft Power BI

Essentials

Download PDF
Back to Courses

Course Details

Course Name

Microsoft Power BI Essentials

Duration

2 Days

Course Code

AFBMPBI

Assumed Knowledge

Basic understanding of Power BI or similar

Course Aims

The aim of this course is to introduce you to the fundamentals of Power BI and enable you to create your own data-driven solutions. You’ll learn how to connect to various data sources, transform and model data, create stunning visualizations, and publish and share your insights with others. You’ll also learn how to use the Power BI service and desktop app, as well as the Power BI mobile app, to access your data anytime, anywhere. This course will help you develop the skills and confidence to leverage the power of Power BI for your personal or professional needs.

What You Will Learn

In this course, you will learn how to import data from various sources into Power BI, and transform and model it using the Power Query Editor and the Data View. You will also learn how to create and customise visualisations using different types of charts, maps, slicers, and other elements, and how to use DAX to create measures and calculated columns. You will also learn how to optimise and share your Power BI solutions using the Power BI service and mobile app.

Skills

  • You will understand how to use the basic tools and features of Microsoft Power BI
  • The course will showcase all the core skills required to create, manage and use key Power BI tools including datasets, reports, dashboards, workspaces and more
  • You will also be shown best practices and use cases to take advantage of Power BI

Who This Is For

This course is aimed towards individuals that are new to Power BI and need to know the basics of Power BI in order to build reports and share information internally within their own organisation.

Course Content

Introduction to Power BI

  • Topic A

    What is Microsoft Power Platform, Fabric and Power BI

  • Topic B

    Power BI licensing, set-up and connections

  • Topic C

    Power BI architecture

  • Topic D

    Power BI Desktop Overview

  • Topic E

    Power BI Online Service Overview

  • Topic F

    Sharing Power BI data

Connecting to Data Sources and Preparing Data

  • Topic A

    Overview of Power Query

  • Topic B

    Data sources and limitations

  • Topic C

    Connection Types

  • Topic D

    Connecting to Data

  • Topic E

    Preparing data in Power Query

  • Topic F

    Pros and cons to different data sources

Data Modelling and Transformation

  • Topic A

    Adding data directly into Power BI

  • Topic B

    Merging, Appending data

  • Topic C

    Power Pivot

  • Topic D

    Duplicate / reference tables

  • Topic E

    Advanced Editor

Setting Up Relationships and Building Visualisations

  • Topic A

    Overview of the different views

  • Topic B

    Creating folders, bins, measures table and hierarchies

  • Topic C

    Build Relationships

  • Topic D

    Adding Visualisations

  • Topic E

    Edit Interactions

  • Topic F

    Setting up your report theme

  • Topic G

    Filtering levels and options

  • Topic H

    Drill through

  • Topic I

    Drill Up / Down

Introduction to DAX

  • Topic A

    The difference between a measure and a calculated column

  • Topic B

    Quick Measures

  • Topic C

    Basic DAX calculations

  • Topic D

    Creating KPI's

  • Topic E

    Quick Measures

  • Topic F

    Visual calculations

Taking Your Report Visualisations to the Next Level

  • Topic A

    Bookmarks

  • Topic B

    Selection Pane

  • Topic C

    Field parameters

  • Topic D

    Visual marketplace

  • Topic E

    Adding animation to your reports

Report Optimisation and Publishing to Power BI Service

  • Topic A

    Publishing reports and sharing Information

  • Topic B

    Refreshing data

  • Topic C

    Performance analyser

  • Topic D

    Row level security

  • Topic E

    Creating a Dashboard

  • Topic F

    Managing alerts

  • Topic G

    Q&A feature

Power BI Service Basics

  • Topic A

    Power BI Service overview

  • Topic B

    Editing report via the Power BI Service

  • Topic C

    Embedding a report SP or Web

  • Topic D

    Mobile layout view

  • Topic E

    Metrics (Scorecards)

  • Topic F

    Power BI Apps

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

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

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