Microsoft Power BI – Level 1

Duration: 2 Days

Course Overview

With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows you to then produce detailed reports through a comprehensive range of visualizations.
The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.
This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.

On-line from
your chosen location

At our dedicated
training facility

On-site at
your premises

Target Audience

Business professionals who need to collect, cleanse, analyze, and visualize business data.

Data analysts looking to enhance their skills in data transformation and report creation.

Managers and team leaders who want to leverage data insights for better decision-making.

Anyone with a basic understanding of Excel or relational database technologies who wants to learn how to use Power BI for data analysis and reporting.

This course provides a comprehensive introduction to Power BI, covering everything from connecting to data sources to creating detailed visualizations and sharing reports online

COURSE OBJECTIVES

Course Content

Getting Started

• The Power BI process
• Launch Power BI Desktop
• Power BI Desktop views

Getting Data

• Connect to data sources
• Connect to an Excel file
• Connect to a CSV file
• Connect to a Web source

Transform Data in the Query Editor

• Clean data in the query editor
• Data types and replace values
• Fill data up and down
• Split column by delimiter
• Add conditional and custom columns
• Pivot data in the query editor
• Pivot and append data
• Insert a custom column
• Append data to a query
• Add an index column

Build a Data Model

• Relate tables in a data model
• Manage table relationships

Merge Queries

• Table join kinds
• Table merge process

Create Report Visualisations

• Create and format visuals
• Create map visuals
• Format map visuals
• Create chart visuals
• Format chart visuals
• Table, matrix and card visuals
• Control number formats
• Format chart visuals continued
• Use slicers to filter data
• Visuals from the marketplace
• Map latitude and longitude
• Export report data to Excel

Introduction to Calculated Column

• Two kinds of power BI formulas
• Add your first calculated column
• The SWITCH function

Introduction to DAX Measures

• COUNTROWS and DISINCTCOUNT
• DAX rules
• Introduction to the CALCULATE function

Introduction to Date Tables and Time Intelligence

• Standard vs. custom calendar
• Calendar: a special lookup table
• Time intelligence functions
• The TOTALYTD function

Hierarchy and Conditional Formatting

• Create a hierarchy to “drill” data
• Add conditional formatting

Publish and Share Your Report Online

• Publish to the online Power BI Service

COURSE PREREQUISITES

There are no specific technical pre-requisites for this course, but a familiarity with Excel and/or Relational Database Technologies may be beneficial. The main pre-requisite is to have a basic understanding of your business’s needs to collect, cleanse, analyze and deliver insights and visualizations of your business data.

You will receive a full set of course notes
and all supporting materials for your course.

Hard Copy Delivered to your premises or Downloaded to a chosen device.