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.