Associated Courses

Excel Core Skills

Excel Intermediate

pdfCourse Outline

Duration

2 Days

Price

£795 per person

Pre-Requisites

Delegates should have a good working knowledge of Excel including chart creation and formatting and producing aggregate formulae as can be gained from our Excel Core Skills and Excel Intermediate courses.

Course tailoring service

Our tailoring service is a luxury you can afford, allowing you to combine elements of related courses producing a bespoke
solution, designed specifically to fulfil your training needs. Is there any better way to meet all of your training objectives and maximise your training ROI?

Kit supply

Running a course at your facilities might sound like a good idea until you start thinking about the practicalities of equipment usage and the
impact this could have on day to day business, so why not let us bring the necessary
equipment with us?

Power BI Core Skills

Learn how to

Content

Getting Started with Power BI Desktop
Power BI Overview
Introduction to PowerBI Features
Understanding Imports
Understanding Visualizations
Understanding Filters and Queries
Understanding Reports

Connecting to Data Sources with Power BI Desktop
Understanding Data Sources
Data Types and Properties
Import and Enter Data
Get Data
Using the Query Editor to Connect to Data
Combining Data Sources as a Mash Up
Use Append Queries
Merge Data Tables
Working with Relationships in Data

Data Visualizations
Overview of Data Visualizations
Tables and Matrix Views
Conditional Formats
Charts
Types
Options
Interactive Slicers
Date Slicers - Dropdowns and Searches
Number Slicers with Value Ranges
Date Slicers with Relative Filters
Drill Visualizations to See Underlying Data
Record Grouping and Binning in Visualizations
Analytics
Forecast
Create Measures
Create a KPI Visualization
Drill Visualizations to See Underlying Data
See Records
Date Hierarchies
Quick Measures
Q and A
Clustering
Data Categories, Geo-Data and Maps

Querying and Shaping the Data
Using the Query Editor
Applying Filters
Using Delimiters
Transforms
Pivot and Group By
Creating Custom Calculated Columns
Add Columns by Example
Adding Conditional Columns
Introduction to DAX Expressions
Histograms

Reports and Output Options
Report Elements and Options
Working with Pages
Adding Graphics
Visual and Filter Settings
Bookmarks
Q and A Buttons and Return Report Pages
Report Themes
Export Power BI Data to CSV
Creating a Power BI Template