Got a question? Call 1800 853 276   |   

Power BI Fundamentals

  • Length 2 days
  • Price $1320 inc GST
Course overview
View dates &
book now
  • Register interest

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 world-wide.

Power BI is a suite of Microsoft tools that are used for business analytics, visualisation and reporting. Power BI delivers supported decision making through actionable insights. It provides interactive reporting and business intelligence capabilities, allowing users to easily connect to, model and visualise organisational and public data.

This workshop is designed to provide participants with a fundamental understanding of Power BI. 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.

Are you looking for a more in-depth technical course on Power BI? See our Microsoft DA-100T00 course.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


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 at DDLS

DDLS 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 First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

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

We can also deliver and customise this training course for your organisation. For more information, please contact us on 1800 853 276.


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

None


Terms & Conditions

The supply of this course by DDLS 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

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.