Power BI Essentials

Power BI is Microsoft’s Business Intelligence solution for data analysis and visualising and sharing data. It enables you to quickly develop interactive reports and dashboards and share impactful visualisations with customers or your team. This one- day course will introduce you to the software, how to best use it, and the range of possible applications it might have in your organisation.

Beginning with how to import data into Power BI from various file formats and databases, you will then move on to exploring different visualisation techniques and filtering techniques. Next, you will focus on understanding and differentiating between different chart types and the data they can be used to represent. Finally, we will show you how to filter and highlight specific bits of information to enhance the presentation of your key messages.

What you will learn
* What is Power BI?
Introduction
Outline & Objectives
* Power BI Desktop
* Importing Files (Get Data)
* Data Relationships
Setting up Data relationships
Viewing Relationships
Editing Relationships
* Creating Interactive Visualisations and Dashboards
Pie, Line and Combination Charts
Working with Matrices
Working with Cards
Geo Data
Data Categorisation and Maps
Tables and Conditional Formatting
Maps and Geographic Data
KPI Cards
* Formatting Visualisations
Filtering data
Slicers
Visualisation Level Filters
Hierarchies and Re-Usable Hierarchies
Drill Down by Date
Editing Interactions Between Charts
* Calculating Data using DAX (desktop only)
Creating a calculated column
Completing DAX Formulae
* Sharing Reports and Dashboards

Do you want to create impactful data analysis and visualisations to help your business to move forward in its goals with confidence? Then this course is for you.