Introduction to Power BI (online)
Short course
Online
Description
-
Type
Short course
-
Level
Beginner
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
-
Virtual classes
Yes
There are three parts to creating a Power BI report, all of which are covered by this two-day course.
Facilities
Location
Start date
Start date
About this course
Firstly, you'll learn how to get data from all manner of different sources, using Query Editor to manipulate the results; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns and measures using basic DAX language. You'll also learn how to use Power BI Web, and get an overview of Power BI Mobile.
Reviews
Subjects
- SQL
- Creating databases - overview
- Working with tables
- Power BI Desktop overview
- Power BI Service Overview
Teachers and trainers (4)
Andrew Gould
Senior Trainer
Rick Gould
Trainer
Sam Lowrie
Trainer
Shaun Wantling
Trainer
Course programme
- Getting data
- Basic visualisations
- Shapes, text boxes and images
- SQL Server / databases
- Excel / text files
- Websites and web serivces
- The formatting panes
- Conditional formatting
- Working with charts
- Specific chart type issues
- Grouping and binning
- Working with matrices
- Working with cards
- Gauges
- Single-number visualisations
- KPIs
- Filtering rows
- Manipulating columns
- Working with data types
- Creating new columns
- Introducing the M language
- Relationships
- Filter directions
- Slicers
- Visualisation level filters
- Interactions
- "See records" feature
- Adding drillthrough filters
- Back buttons
- Assigning actions to shapes
- Inserting buttons
- Hover and select effects
- Creating bookmarks
- Filtering using bookmarks
- Spotlighting and hiding visuals
- The types of map
- Geo-location
- Introduction to ArcGIS
- Adding columns
- IF and SWITCH
- The RELATED function
- Creating calendars
- Using multiple calendars
- Working days
- Power BI accounts
- Power BI files (PBIX)
- Differences from PBI Desktop
- Workspaces
- Favorites
- Reports and dashboards
- Using tiles
- Pinning to dashboards
Additional information
Introduction to Power BI (online)