DURATION
Two full days: 9:30am – 4:30pm
LOCATIONS
Exeter, Manchester, Liverpool, London, Bristol, Onsite at your premise, Remote Live Session via Teams
For onsite courses we can provide the rental of laptops with the software pre-installed.
SECTORS WE TRAIN
NHS and Healthcare, MOD, Police, Councils, Energy, Water
OVERVIEW AND OBJECTIVES
This 2-day course is intended for anyone new to designing and implementing self-service business intelligence solutions using Microsoft Power BI Desktop and the Power BI web service.
The delivered content pulls upon material from the 1-day bite sized “Power BI Level 1 – Introduction”, “Power BI Level 2 – Intermediate”, and “Power BI Level 3 – Advanced” courses, packaged in a more condensed format to enable delegates to quickly get up to speed with using Power BI.
The first part of the course introduces the capabilities and components of Power BI before delving into the realms of discovering and loading data from commonly used data sources such as CSV files, Excel, and databases, such as Microsoft SQL Server. Delegates will then learn how to cleanse, transform, and shape the loaded data.
The course then introduces delegates to data modelling concepts, preparing the data in readiness for analysis and report creation. The importance of implementing relationships is also covered. In order to enhance the data model, attendees will be introduced to the DAX expression language to enable them to implement calculated columns and measures. Consideration is also given to analysing data over time periods (otherwise known as time intelligence).
Next up, delegates will learn how to create and design reports using an array of different visualisations. We will first look at text-based visuals before moving on to graphical components like charts, gauges and KPIs (Key Performance Indicators). To make reports more interactive, you will learn how to implement slicers and also get to understand and control interactions between different types of visuals. Also, to further enhance the user experience, you will learn how to incorporate bookmarks into your reports.
Finally, we turn our attention to the Power BI web service. Attendees will learn how to publish reports to the service and organize content in workspaces. The creation and use of dashboards will also be considered. We will also look at various ways to share content in the service with other users.
As your source data changes over time, you will want these changes to be reflected in your reports and dashboards. So, to conclude proceedings, we will consider how to keep content current by regularly refreshing data in the published semantic model.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience. Also, as Power BI is continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum return from the learning experience.
Upon successful completion of this course, students will be able to:
🔹Understand Key Components of Power BI
🔹Load Data From Commonly Used Sources
🔹Shape and Transform Datasets
🔹Merge and Append Data
🔹Implement a Data Model
🔹Create and Manage Relationships
🔹Gain an Understanding of DAX
🔹Implement Calculated Columns
🔹Implement Measures
🔹Implement Time Intelligence
🔹Create Reports with Text-Based Visuals
🔹Implement Conditional Formatting
🔹Create and Implement Charts
🔹Implement Gauges and KPIs
🔹Implement Slicers
🔹Understand the Power BI Web Service
🔹Publish Reports and Create Dashboards
🔹Share Content in Workspaces
🔹Keep Reports Current with Data Refreshes
TARGET AUDIENCE
This Microsoft Power BI Essentials course is aimed at anyone new to self‑service business intelligence who needs to quickly learn how to analyse and report on data using Power BI.
WHATS INCLUDED
🔹Professional instructor‑led training
🔹Courseware included
🔹Lunch provided
🔹Free on‑site parking at our Exeter training suite
🔹Certificate of completion
COURSE PREREQUISITES
No previous knowledge of Power BI is required.
Attendees should be able to demonstrate a good level of computer literacy and skills. You will have a good understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
WHY CHOOSE OUR MICROSOFT POWER BI TRAINING?
With years of experience delivering Power BI courses to businesses and individuals, we make learning Power BI simple, practical, and enjoyable. The Microsoft Power BI Essentials course provides the ideal foundation for building your skills for work, study, and personal use.