Data Skills will teach you everything you need to work effectively with Power BI. Get started with the basics and then progress up through DAX, the Data Model, filters, visualisations and more.
Introduction to Power BI
This course is intended for anyone who needs to use Power BI but has no or limited experience with this fantastic product. The course will give learners a solid grounding in Power BI, giving an overview of the product and how the various elements work together.
Introduction to Power BI
Importing data into Power BI
Creating tables
Creating matrixes
Creating cards
Graphs – Line, Area, Bar & Column charts
Graphs – other graphs
Calculated columns
Using Power Query
Building a data model
Publishing data to the Power BI service
Scheduling refreshes
Sharing reports
Introduction to Power BI
This course is intended for anyone who needs to use Power BI but has no or limited experience with this fantastic product. The course will give learners a solid grounding in Power BI, giving an overview of the product and how the various elements work together.
Introduction to Power BI
Importing data into Power BI
Creating tables
Creating matrixes
Creating cards
Graphs – Line, Area, Bar & Column charts
Graphs – other graphs
Calculated columns
Using Power Query
Building a data model
Publishing data to the Power BI service
Scheduling refreshes
Sharing reports
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £390 (day charge) and £50 (per delegate).
This is a 2-day course, intended to give learners a more in-depth understanding of the Power BI ecosystem than our 1-day course. In this course, learners will spend more time understanding how to import various formats of data into Power BI, how to format visualisations, use DAX to create various types of calculated columns and measures, use Power Query to transform data and publish the report to the Power BI service. Learners will also get an introduction to Microsoft Fabric use the online Power Query tool, and how to create an app to leverage the collaborative features in the Power BI ecosystem.
Introduction to Power BI
Importing data into Power BI
CSV & TXT files
Excel files
Creating tables
Creating matrixes
Creating cards
Graphs – Line, Area, Bar & Column charts
Graphs – other graphs
Custom visuals
Calculated columns
Measures
Date tables
Creating a date table using DAX
Using Power Query
Creating new columns
Appending data
Merging data
Pivoting data
Using parameters
Building a data model
Understanding relationships
Understanding filter directions
Creating multiple relationships between tables.
Publishing data to the Power BI service
Microsoft Fabric
What is possible
Using Power Query on the cloud
Connecting to a cloud model
Scheduling refreshes
Sharing reports
Building dashboards
Building an app
The training went really well yesterday, Scott was really good.
Hannah Food Service
Sarah Humby
Complete Power BI
This is a 2-day course, intended to give learners a more in-depth understanding of the Power BI ecosystem than our 1-day course. In this course, learners will spend more time understanding how to import various formats of data into Power BI, how to format visualisations, use DAX to create various types of calculated columns and measures, use Power Query to transform data and publish the report to the Power BI service. Learners will also get an introduction to Microsoft Fabric use the online Power Query tool, and how to create an app to leverage the collaborative features in the Power BI ecosystem.
Introduction to Power BI
Importing data into Power BI
CSV & TXT files
Excel files
Creating tables
Creating matrixes
Creating cards
Graphs – Line, Area, Bar & Column charts
Graphs – other graphs
Custom visuals
Calculated columns
Measures
Date tables
Creating a date table using DAX
Using Power Query
Creating new columns
Appending data
Merging data
Pivoting data
Using parameters
Building a data model
Understanding relationships
Understanding filter directions
Creating multiple relationships between tables.
Publishing data to the Power BI service
Microsoft Fabric
What is possible
Using Power Query on the cloud
Connecting to a cloud model
Scheduling refreshes
Sharing reports
Building dashboards
Building an app
This is a 2-day course & can be delivered on-site or virtually.
Pricing for this course starts at £660 (2-day charge) and £90 (per delegate).
This course is intended for those who want to get to grips with Data Analysis Expressions (DAX). This course is for experienced users with strong Power BI and logic skills who want to build advanced measures, tables and calculated columns.
Introduction to DAX
DAX Formatting
Columns vs measures vs tables
Basic DAX Functions
Using Variables in DAX
Logical functions
Time Intelligence with DAX
Various other functions
Building a Date table using DAX
Using DAX Studio
Power BI DAX
This course is intended for those who want to get to grips with Data Analysis Expressions (DAX). This course is for experienced users with strong Power BI and logic skills who want to build advanced measures, tables and calculated columns.
Introduction to DAX
DAX Formatting
Columns vs measures vs tables
Basic DAX Functions
Using Variables in DAX
Logical functions
Time Intelligence with DAX
Various other functions
Building a Date table using DAX
Using DAX Studio
This is a 1-day course & can be delivered on-site or virtually.
Pricing for this course starts at £415 (day charge) and £60 (per delegate).
Very good course that gave me good background to some of the simpler DAX expressions I had previously used, and has give me confidence to go and build on those foundations with my own continued learning
Cundall
Course: Power BI DAX
Very good course that gave me good background to some of the simpler DAX expressions I had previously used, and has give me confidence to go and build on those foundations with my own continued learning
