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

Anyone wishing to further their skills with Power BI

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

Introduction to Date Tables and Time Intelligence

• 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 need to collect, cleanse, analyse and deliver insights and visualisations 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.

Download a
Course Outline PDF

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.

To book this course please call 
+44 (0) 1444 410296 or email: Info@kplknowledge.co.uk

Short Description