• Exeter, Devon EX2 7AE
  • hello@amesolutions.co.uk
  • Office Hours: Monday - Friday 8:30 AM – 5:00 PM
Thumb
Microsoft Power BI Essentials Training Course

Microsoft Power BI Essentials Overview

This page gives you a full overview of our Microsoft Power BI Essentials Course, what’s included, the key topics we cover, and what you can expect to learn as a complete beginner.

    Microsoft Power BI Essentials Training Overview

    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.

    SUBJECT AREAS

    • Describe the Power BI Products and Services
    • Introducing Power BI Desktop
    • The Components of Power BI
    • Load Data from Text Files
    • Load Data from Excel Workbooks
    • Load Data from Databases (Microsoft SQL Server)
    • Compare Import and DirectQuery Storage Modes
    • Why You Should Clean Your Data
    • Cleansing Data in Power Query
    • Transform Data
    • Shape Datasets
    • Merge and Append Data
    • Data Modelling Concepts
    • Fact and Dimension Tables
    • Configure Table and Column Properties
    • Create and Manage Relationships
    • Understand Filter Propagation
    • Introducing DAX
    • Create Calculated Columns
    • Create Custom Groups
    • Aggregate Data (Implicit Measures)
    • Create Explicit Measures
    • Manipulate the Filter Context with CALCULATE
    • Create a Date Table
    • Analyse Data over Time (Time Intelligence)
    • Implement and Format Table and Matrix Visuals
    • Implement and Format Charts
    • Conditionally Format Visual Content
    • Use the Card Visual
    • Use Tooltips
    • Scatter Charts and Bubble Charts
    • Gauges and KPIs
    • Slicers and the Filters Pane
    • Cross-Filtering and Cross-Highlighting
    • Implement Bookmarks
    • Control the Display of Content
    • Introduction to the Power BI Web Service
    • Publish Reports to the Power BI Web Service
    • Manage and Organise Content in Workspaces
    • Create and Manage Dashboards
    • Share Content and Workspaces
    • Create and Distribute Workspace Apps
    • Refresh Data
    Ready to book?

    For more information, or to book onto our Microsoft Power BI Essentials training course, please get in touch.

    If there’s a Power BI course you’re interested in that isn’t listed on our website, let us know — we can arrange one‑to‑one onsite training with our trainer.

    You can view our full list of training courses here.

    Office Location

    2nd Floor Wear House, Topsham Road,
    Exeter, Devon. EX2 7AE.

    Phone

    01392 824022

    Email

    info@amesolutions.co.uk

    Name