Power BI Fundamentals

Length

2 days

Price

$1320.00 inc GST

Overview

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.

Key Topics

Detailed Info

Introduction to Power BI
Getting Data
Shaping Data
Modelling Data
Visualising Data
Publishing to Power BI

Skills Gained

Key Topics

Target Audience

Prerequisites

Skills Gained

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

Key Topics

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?

Target Audience

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.

Prerequisites

None

Print course details

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.

Book Your Course

You don't appear to have Javascript enabled, our contact forms & booking process unfortunately requires it.

If you'd like more information, or to book a course please email us

Perth

Virtual-Classroom

Perth

Virtual-Classroom

Sydney

Virtual-Classroom

Perth

Virtual-Classroom

Perth

Virtual-Classroom

Perth

14 Dec - 15 Dec

27 Jan - 28 Jan

02 Feb - 03 Feb

04 Mar - 05 Mar

18 Mar - 19 Mar

08 Apr - 09 Apr

04 May - 05 May

08 Jun - 09 Jun

Book Course Book Course Book Course Book Course Book Course Book Course Book Course Book Course Book Course Book Course Book Course

Email Course Outline

Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.

Length

Price

Overview

Key Topics

Skills Gained

Key Topics

Target Audience

Prerequisites

Book Your Course

Testimonials

YOUR IT TRAINING PARTNER

FOLLOW US