Course description
Introduction to Power BI Desktop
This Introduction to Power BI Desktop training course is offered as an open/scheduled 2-day training course by SquareOne Training or a closed course at your offices.
There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course. Firstly, you'll learn how to get data from all manner of different sources, usingQuery Editorto manipulate the results; secondly, you'll learn how to create, format and usevisualisations(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.
Training Course Content
Basic reports
- Getting data
- Basic visualisations
- Shapes, text boxes and images
Data sources
- SQL Server / databases
- Excel / text files
- Websites and web services
Query editor
- Filtering rows
- Manipulating columns
- Working with data types
Advanced query editor
- Grouping and pivoting
- Creating new columns
- Basic M formula language
Multiple tables
- Relationships
- Filter directions
Parameters
- Creating parameters
- Filtering by parameter
Filtering data
- Slicers
- Visualisation level filters
Drill-down
- Interactions
- "See records" feature
- Hierarchies
Formatting visualisations
- The formatting panes
- Conditional formatting
Charts
- Working with charts
- Specific chart type issues
- Grouping and binning
Other types of visualisations
- Working with matrices
- Working with cards
Dashboard visualisations
- Gauges
- Single-number visualisations
- KPIs
Maps
- Categorising data
- Issues with maps
Calculated columns
- Adding columns
- IF and SWITCH
- The RELATED function
Measures/DAX
- How measures work/tuples
- Adding measures
- Basic DAX
Calendars
- Creating calendars
- Using multiple calendars
- Working days
Date Functions
- Period to date
- Previous periods
- Other date functions
- Semi-additive measures
Advanced measures
- AggregateX functions
- The CALCULATE function
- The FILTER function
- DAX variables
Roles and security
- Creating roles
- DAX restrictions
Publishing reports
- Power BI accounts
- Power BI files (PBIX)
Power BI Service Overview
- Differences from PBI Desktop
- Workspaces
- Favorites
Using Power BI Service
- Reports and dashboards
- Using tiles
- Pinning to dashboards
Overview of Excel tools
- Power BI Publisher for Excel
- Analyze for Excel
Overview of other tools - If time
- Power BI Mobile overview
- Power BI Pro overview
Why choose SquareOne Training
25 years' experience of delivering quality IT Training Services
All trainers Certified Microsoft Office Trainer (MOS) or higher
Public and in-house training throughout the UK
About provider
SquareOne Training
SquareOne Training is an internationally renowned IT Training company who create inspiring, motivational and cost effective training services which bring about tangible improvements in productivity. They specialise in providing classroom courses, Microsoft upgrade training, IT consultancy and large-scale rollout support...
Request info
Contact info
SquareOne Training
Reviews
Average rating 4.7
Based on 21 reviews
Find out more about this Microsoft Power BI - Introduction course - simply fill out your details:
Are you curious about the L&D strategies of some of the U.K.'s top companies?
Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!
 |
Read the course |
|
 |
Fill in your details and Request information |
|
 |
Receive all the info you need |
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Read more
At SquareOne Training we take pride in designing Spreadsheets for our customers, so we were delighted to be asked to design a solution to track staff courses and KPI alerts. This spreadsheet was implemented in 2018, but completely changed the way the company worked and made the data not only accurate but trackable.
Read more