Course Outline
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.
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
£995
Scheduled Classes
Remote Access:
22 – 23 Aug 2023
31 Oct – 01 Nov 2023
12 – 13 Dec 2023
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