logo

Power BI Essentials

Further Details
Course Code
LA18217
Location
Yale
Duration
Part Time, 9:00-16:00
Department
Digital Technologies, Computing & IT
Start Date
24 Jun 2025
End Date
24 Jun 2025
Course Overview
Power BI is Microsoft’s Business Intelligence solution for data analysis and visualising and sharing data. It enables you to quickly develop interactive reports and dashboards and share impactful visualisations with customers or your team. This one- day course will introduce you to the software, how to best use it, and the range of possible applications it might have in your organisation.

Beginning with how to import data into Power BI from various file formats and databases, you will then move on to exploring different visualisation techniques and filtering techniques. Next, you will focus on understanding and differentiating between different chart types and the data they can be used to represent. Finally, we will show you how to filter and highlight specific bits of information to enhance the presentation of your key messages.

What you will learn

● What is Power BI?
○ Introduction
○ Outline & Objectives
● Power BI Desktop
● Importing Files (Get Data)
● Data Relationships
○ Setting up Data relationships
○ Viewing Relationships
○ Editing Relationships
● Creating Interactive Visualisations and Dashboards
○ Pie, Line and Combination Charts
○ Working with Matrices
○ Working with Cards
○ Geo Data
○ Data Categorisation and Maps
○ Tables and Conditional Formatting
○ Maps and Geographic Data
○ KPI Cards
● Formatting Visualisations
○ Filtering data
○ Slicers
○ Visualisation Level Filters
○ Hierarchies and Re-Usable Hierarchies
○ Drill Down by Date
○ Editing Interactions Between Charts
● Calculating Data using DAX (desktop only)
○ Creating a calculated column
○ Completing DAX Formulae
● Sharing Reports and Dashboards

Do you want to create impactful data analysis and visualisations to help your business to move forward in its goals with confidence? Then this course is for you.
Ongoing assessment via tasks and tutor monitoring
No prior knowledge is required other than a familiarity with the standard workings of a computer and standard software systems – however, past experience or familiarity with general IT, Excel, and business systems is desirable.

Learn the technical skills you need to help you reach your goals and to give you the skills and tools you need for success.
The course provides you with the necessary knowledge and tools to help you learn how to understand how to use data visualisation software
£59
Useful downloads

Ready to begin your journey?

Our Open Days

Our Open Days are your chance to explore the College and find out about the range of courses we offer.

Bersham Road – Wheels Event
29/06/2024

10:00

Join us at Coleg Cambria site Bersham Road on Saturday 29th June

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

Follow Us

Follow us

Got a question?

Here’s how you can get in touch

A blue phone icon

Contact us

Email Us

Email

You have successfully added this course to
your shortlist, are you ready to apply?