Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Power BI Desktop

Power BI Desktop

Duration

This is a 2 day, instructor-led course. 

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.

Course Contents

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

Price per delegate

£895

Scheduled Classes

Indicia Training, Glasgow:

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com

Contact Us