Power BI Desktop

Overview

This course will help you to create powerful, visual Power BI dashboards and reports that can really help you to understand the data you have.  You will learn how to connect to a range of different data sources and then manipulate this to produce the required format and layout so it is ready to be used in the visualisations.  These can be any mix of table, charts, maps, KPI’s, gauges and more.  Finally you will see how to publish the end result to share your insights with others.

Introduction to Power BI Desktop

• What is Power BI Desktop
• Power BI Desktop Environment

Importing and Connecting to data sources

• Difference between Importing and Connecting
• Databases
• Excel
• Text file
• Web Page
• SQL Database
• Entering Data
• Relationships

Querying and Shaping Data

• Filtering
• Sorting
• Understanding applied steps
• Manipulating columns
• Data Types
• Parameters
• Custom columns
• Columns by Example
• Introduction to DAX Functions
• Starting to use DAX in more advanced ways

Visualisations

• Charts
• Tables
• Maps
• Matrices
• KPIs
• Gauges
• Basic Slicers
• Setting slicers to control individual visualisations or multiple sheets
• Detailed Formatting options
• Drill down
• Hierarchies
• Role based views
• Groups and Bins
• Drill through
• Bookmarks

Report Elements and Output options

• Formatting the report
• Adding graphics, shapes and text boxes
• Report Filters
• Export as csv