Without doubt the way forward for analysing data. From small amounts to vast arrays of data and from multiple sources Microsoft Power BI provides interactive visualizations and business intelligence capabilities allowing you to gain invaluable insights into your data
Microsoft Power BI Interfaces are provided to make it simple for end users to create their own reports and dashboards and subsequently share them with a combination of tables, charts, maps, diagrams, and filters and all fully interactive
You will no longer require IT or outside consultants to gather, transform and analyse your data, this can all now be down within Microsoft Power BI
If you are using Excel to analyse data, from small data sets to thousands, hundreds of thousands or millions of rows of data you should consider switching to Microsoft Power BI.
.Courses we offer
An Introduction to Power BI – 1 Day course
The focus of this course is to understand the basics of creating reports and includes importing and cleaning files, writing DAX (Data Analysis Expressions) formulas to enhance reports visualisations, and creating an interactive dashboard. It also looks at different ways of sharing reports in the Power BI service.
An Introduction to Power BI – 2 day course
This course starts at an introductory level, then takes a deeper dive into the concept of creating reports. It explains the concepts of data modelling, cleaning and transforming data, and writing both M (Mashup) formulas and DAX formulas. It includes various visualisations to better understand their use.
Power BI – Intermediate course – 2 Days
This course is designed for users already familiar with the basics and are ready to advance to the next level. It starts with transforming data in the Power Query, matching up mismatched data. Then takes a deep dive into writing DAX formulas to generate insights with data and finishes by creating dynamic interactive visualisations.
Power BI – Advanced course – 1 Day
This course is for users who work with Power BI on a regular basis and aims to enhance your knowledge of advanced visualisations that incorporate the use of AI (Artificial Intelligence). Content includes the analytics pane, data anomaly detection, key influencers. It also covers the query, number and field parameters, and detecting trends in data, and forecasting.
Course content
An Introduction to Power BI – 1 Day course
Getting Started
Importing Files
The Power Query Editor
Dashboard Visuals
The Power BI Service
The Data Model
DAX New Columns
DAX Measures
The CALCULATE measure
Time Intelligence
Visual Hierarchies
An Introduction to Power BI – 2 Day course
Getting Started
Importing Files
Clean Data in Power Query
Transforming Data
The Data Model
Merge Query
Dashboard Visualisations
Publish and share Reports
Power Query Expanded
M Functions
Pivoting Tables
Data Modelling Expanded
DAX New Columns
DAX Measures
The CALCULATE Measure
The SUMX measure
Time Intelligence
Drilling into Data
Creating Groups
Creating a Guage Chart
Power BI – Intermediate course – 2 Days
Power Query Editor
Fuzzy Matching
Logical Functions
Editing DAX
CALCULATE Measure
The ALL Measure
Iterator Measures
Date Functions
Time Intelligence Measures
More Visualisations
Creating Dynamic Content
Row Level Security
Power BI – Advanced course – 1 Day
Dataset Design
Parameters in Power Query
Field Parameters
Groups, Bins & Clusters
Forecast Charts
The Analytics Pane
Customising Q&A
AI Capabilities
AI Features in Charts
Power BI Service
Contact us about Power BI
It’s always easier to contact us via email rather than phone. We’re out training most days of the week