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
Obtaining Data
- Different data sources: Files, Databases and the Web
- Changing the Data Source
Transforming Data
- Removing Columns/Rows
- Data Type Changes
- Filters
- Grouping
- Split
- Duplicate
- Combine: Append and Merge Queries
- Pivot/Unpivot
- Columns: Add Column, Custom Function, Conditional Column, Index Column
Relationships
- Model View and Relationship management
- Join Kinds
- Working with Related Tables
- Hierarchies
Introduction to DAX Formula & Measures
- Formula
- Measures
- Quick Measure
Date Tables and Time Intelligence
- Creating Date Tables
- Time Intelligence Formulas and Measures
Visualisations
- Table
- Matrix
- Charts
- Maps
- KPI (Key Performance Indicator)
- Conditional Formatting
- Spatial Intelligence
Visualisation Manipulation
- Filter: Basic and Advanced
- Top 10
- Slicer
- Drill Through
Publishing/Sharing Reports
- Publishing to the Power BI Service on the web
- Exporting to PDF
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
Reviews
Average rating 4.8
All of the content was very good as a beginner
Good course - Using PowerBI in general was great
Request info
SquareOne Training
With 30 years of experience in IT training, personal skills, and consultancy, SquareOne specialise in crafting and delivering exceptional industry leading training courses. Our extensive range of courses are tailored to cater to a diverse range of learning preferences and...
Case Studies
Excel Templates For Mexichem
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.
SquareOne Deliver IT Rollout Projects to a World Leading Gas and Oil Company
Read about SquareOne's global projects in New Hardware and Software Refresh and Microsoft Lync/Skype Rollout.
I enjoyed learning about power query, date table, and model view