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.9
Favourite Topic: All really useful so it would be difficult to answer this.. Comments: Very good trainer, went at correct pace for the group
Favourite Topic: All of it.. Comments: Brill.
Request info
Welcome to SquareOne Training – Where Your Learning Journey Takes Centre Stage! For over 30 transformative years, SquareOne Training has been the beacon of excellence in IT and personal skills training. We started our journey when computers were just making...
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.
Favourite Topic: All modules were really beneficial. . Comments: Noel was a great trainer. Felt at ease learning, good pace, content and very knowledgeable.