Power BI Phoenix - Latest 310823

Looking to make a difference in the quality of your Reports?

Learning Power BI empowers you to transform raw data into visually appealing and actionable insights effortlessly.

Unlocking this in-demand skill will accelerate your career prospects, enabling you to make data-driven decisions, impress employers, and drive business success.

Start Date

Flexible to your requirements

Price

£1,850 + VAT - up to 8 attendees

Eligibility Requirements

Learners should have an Intermediate or advanced level of knowledge of Microsoft Excel including knowledge of Pivot Tables.

Why choose us ?

Closed Company - not public - courses

Our training is kept within your company so it can be tailored precisely to your requirements.

Accredited Microsoft Partner

All of our course facilitators are professional Microsoft Certified Trainers, passionate about IT training and helping people improve their software knowledge.

Post Learning Support

Our support doesn't end after the training - we're here to support you and ensure your learning is put to good use.

Classroom-based or Online

Our courses are classroom-based or we can provide distance learning training solutions; we always provide one-to-one support whichever method you choose.

Enquire Now

What will you learn?

The Modules we cover give you a great foundation for your Power BI skills, with practical exercises and knowledge you can take back to the workplace and apply immediately.

Here's the module details

WHAT IS POWER BI?

Power Query
The Data Model/Power Pivot
Rich interactive visualisations
Power BI Desktop and Power BI Service

THE POWER BI DESKTOP INTERFACE

Different Views
Visualisation and Fields pane
Power BI Desktop Options

GETTING DATA INTO POWER BI

From Text Files
From CSV files
From Web
From Folder
From Excel ranges and sheets

UNDERSTANDING POWER QUERY

Understanding the Power Query interface
Renaming and deleting steps
Cleaning messy data example
Refreshing a query
Power Query Options

COMMON POWER QUERY FEATURES

Unpivot Columns
Setting Data Types
Append Queries
Merge Queries

CREATING THE DATA MODEL

Create table relationships
Edit and delete relationships
Understand filter context
Tables & Columns – Understanding basic data structure.
Data View – Seeing your underlying data values
Exploring Data – Easy data profiling
Managing Schema & Data Changes –
Dealing with issues of change control
Connections & Tables – Data lineage.

CREATING THE DATA MODEL Pt.2

Data Refresh – Optimising new data acquisition.
Relating Tables – Telling Power BI how your data relates internally.
Rules & Limitations – Filter flow options and consequences.
Auto-Detecting – Pros and cons of saving design time
Relationship View – Working on your data model structure

GETTING STARTED WITH DAX

How is DAX different to Excel Formulas
Calculated Columns vs Measures
Creating a Calculated Column
Creating Measures
Using Common DAX Functions

LOOKUP AND FILTER DAX FUNCTIONS

Why these functions are useful?
RELATED Function
CALCULATE Function
FILTER Function

INTERACTIVE VISUALISATIONS

Adding tiles to a Report
Creating Charts
Using Geographic Data
Creating Matrixes
Using Slicers
Other Filter tools (Report, Pages,
Visualisations)
Editing Interactions
Highlight vs Filter
Formatting Visualisations
Drill Down

POWER BI SERVICE

Publishing your Report
Mobile Layout
Reports and Dashboards
Bookmarks
Understanding Gateways
Refreshing your Reports

Take your skills
to new heights

Enquire now

Look what our clients say

“We would recommend Phoenix to others as an IT learning solution. They are knowledgeable, professional and extremely pleasant to work with. Phoenix is doing a great job at meeting our learning objectives”