Introduction to Power BI (classroom)
Training
In Manchester and London
Description
-
Type
Training
-
Level
Beginner
-
Location
-
Duration
2 Days
-
Start date
Different dates available
There are three parts to creating a Power BI report, all of which are covered by this two-day course.
Important information
Documents
- Introduction to Power BI Desktop.pdf
Facilities
Location
Start date
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
- Basic reports
- Data sources
- Formatting visualisations
- Charts
- Other types of visualisation
- Dashboard visualisations
- Query editor
- Multiple tables
- Filtering Data
- Drill-down
- Drill-through filtering
- Action buttons
- Bookmarks
- Overview of maps
- Calculated columns
- Calendars
- Publishing reports
- Power BI Service Overview
- Using Power BI Service
Teachers and trainers (5)
Andrew Gould
Senior Trainer
Andy Brown
Microsoft Trainer & Programmer
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 (classroom)