Course description
Microsoft Power BI: Introduction
Learn how to harness the potential of Microsoft Power BI with this fantastic two day introduction course aimed at those who have a keen eye for data. Upon completion of this training, you will be able to use Power BI to create fully interactive and immersive dashboards and reports on all aspects of your business, helping you to gain insights and make the decisions that matter most.
Delegates will also receive a full certificate of attendance and extensive manual, benefitting them long into the future. To find out more about our training options, please speak to our team today.
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 believe that no two people are the same, therefore all our courses are unique just like you. SquareOne will work with you and your company to tailor a course that is suitable for your business needs, development and future...
Request info
Contact info
SquareOne Training
Reviews
Average rating 4.7
Based on 31 reviews.
Find out more about this Microsoft Power BI: Introduction course - simply fill out your details:
 |
Read the course |
|
 |
Fill in your details and Request information |
|
 |
Receive all the info you need |
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
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
Read more