End User Applications Category Banner Image

Power BI Fundamentals

  • Length 2 days
  • Price  NZD 1600 exc GST
Course overview
View dates &
book now

Why study this course

Power BI is an industry leader and one of the largest and fastest-growing business intelligence cloud solutions, used by over 35,000 companies worldwide.

Power BI is a suite of Microsoft tools used for business analytics, visualisation, and reporting, forming part of the broader Power Platform ecosystem. Power BI delivers supported decision-making through actionable insights, empowering users to conduct thorough data analytics and data analysis. It provides interactive reporting and business intelligence capabilities, allowing users to easily connect to, model, and visualise organisational and public data. This capability enables users to create compelling data visualisations that facilitate informed decision-making based on organisational and public data, thereby enabling the creation of robust data models for informed decision-making.

Key components of the Power BI suite include Power BI Desktop, Power BI Service, Power BI Mobile Apps, and Power BI Gateway, among others.

Power BI training is designed to give participants a fundamental understanding of the tools. Participants will learn how to use the Power BI tools by following a simple workflow that can be used to design, develop, deploy, and share Power BI reports and dashboards. Microsoft Power BI courses, such as this course from Lumify Work, help you learn how to use these tools effectively and efficiently.

The Microsoft Power BI fundamentals course is an entry-level workshop for professionals in New Zealand. If you are looking for a more in-depth technical course on advanced Power BI, see our Microsoft PL-300T00 Power BI Data Analyst course.

Important note: Power BI is a Microsoft App that is not currently supported on non-Windows systems (such as Apple Mac).

Request Course Information


What you’ll learn

After completing this workshop, participants will be able to:

  • Connect to various data sources and extract data

  • Shape data to ensure that all data is necessary, clean, and transformed appropriately

  • Model data to add any necessary derived calculations, columns, and tables

  • Utilise out-of-the-box and custom visualisations to display data appropriately

  • Publish reports and datasets to the Power BI service

  • Create dashboards, and use workspaces and apps to share Power BI objects


Microsoft Partner Cloud Logo

Microsoft Apps at Lumify Work

Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.


Who is the course for?

Microsoft Power BI Fundamentals training is an entry-level two-day workshop designed for anyone who needs to be able to analyse and visualise data using Power BI.

Students can attend the Power BI course on campus in Auckland, Wellington, Christchurch, or online.


Course subjects

Module 1: Introduction to Power BI

  • What is Power BI?

  • A brief history of Power BI

  • Power BI components

    • Power BI Report Server

  • Power BI architecture

  • Power BI Workflow

  • Getting started with Power BI

    • Power BI Desktop

    • Power BI Service

    • Power BI Help

Module 2: Getting Data

  • Power BI Workflow

  • Get data process flow

  • Data Sources

  • Data Base Data Sources

  • Data Base Queries

  • File Sources

  • Web Pages

Module 3: Shaping Data

  • Shaping vs Transforming Data

  • Shaping Data Overview

  • Where should I do the Shaping?

    • Shaping Data in SQL

    • Shaping Data in DAX

    • Shaping Data in Power Query

  • The Power Query Editor

  • First Pass at Shaping

  • Applied Steps

  • The Advanced Editor

    • Advanced Shaping

Module 4: Modelling Data

  • Relationships

    • Cardinality

    • Cross Filter Direction

    • Role Playing Dimensions

  • Optimising the Model

    • Configuring Data for Q&A

  • Hierarchies

  • Introduction to DAX

    • Calculated Columns

    • Calculated Measures

Module 5: Visualising Data

  • Visualisations

    • Charts

    • Filters

    • Slicers

    • Maps

    • Tables

    • Tree Maps

  • Formatting Visuals

    • Page Layout and Formatting

    • Mobile Layout

    • Custom Visuals

    • Report Themes

Module 6: Publishing to Power BI

  • Publishing to the service

  • Dashboards

    • Dashboards vs Reports

  • Q&A

  • Power BI Insights

  • Apps

    • Creating Workspaces and Apps

    • What can you do with an App?


Prerequisites

In order to attend this course you must have Power BI Desktop installed on your local desktop or laptop prior to attendance. Download Power BI Desktop from Microsoft here. Power BI accessed through a browser or Microsoft Teams does not have the features and functionality needed to complete this course. Remote connection to your work desktop or laptop is also not suitable.

In addition you will need to be able to extract compressed (ZIP) files to your desktop or laptop.

We recommend dual monitors, especially if your primary monitor is a laptop screen.


Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.


Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.



Offers

  • Managing Successful Programmes Foundation and Practitioner Combo - Self-paced
    Save when you purchase the Managing Successful Programmes Self-paced Combo bundle for only $2290 ex GST. Booked separately, these courses would cost you almost $2700 ex GST.
  • PRINCE2 Agile® Foundation and Practitioner Combo - Self-paced
    Save when you purchase the PRINCE2 Agile® Self-paced Combo bundle for only $2290 ex GST. Booked separately, these courses would cost you almost $2700 ex GST.
  • PRINCE2® 6th Edition Foundation and Practitioner Combo - Self-paced
    Save when you purchase the PRINCE2® Self-paced Combo bundle for only $2290 ex GST. Booked separately, these courses would cost you almost $2700 ex GST.
  • PRINCE2® 7th Edition Foundation and Practitioner Combo - Self-paced
    Save when you purchase the PRINCE2® Self-paced Combo bundle for only $2290 ex GST. Booked separately, these courses would cost you almost $2700 ex GST.
  • Continue your learning experience online with Lumify Plus
    Lumify Plus is coming soon to New Zealand!
  • Change Management Foundation and Practitioner Combo - Self-paced
    Save when you purchase the Change Management Self-paced Combo bundle for only $1900 ex GST. Booked separately, these courses would cost you almost $2400 ex GST.
  • Agile Project Management Foundation and Practitioner Combo - Self-paced
    Save when you purchase the Agile Project Management Self-paced Combo bundle for only $1900 ex GST. Booked separately, these courses would cost you almost $2400 ex GST.
  • Agile Business Analysis Foundation and Practitioner Combo - Self-paced
    Save when you purchase the Agile Business Analysis Self-paced Combo bundle for only $1900 ex GST. Booked separately, these courses would cost you almost $2400 ex GST.