Excel Intermediate
image

Excel and Power BI Data Modelling Training Course

Excel and Power BI Data Modelling

Master the essentials of data modelling with our Excel and Power BI Data Modelling Training Course. This comprehensive course covers Power Query, Power Pivot, and Power BI, equipping you with the tools to clean, structure, and visualise your data effectively. Gain the skills to build powerful data models, create impactful reports, and make smarter decisions for your business.

  • Virtually Online Or On-Site

  • 2 Days

Need a custom package or team booking?

    Expert Trainers

    Real experts. Real experience.

    Small Class Sizes

    More time with your trainer
    Rated 4.8/5 by learners

    Rated 4.8/5 by learners

    High feedback from professionals
    image

    Money-Back Guarantee

    100% guarantee for peace of mind
Why Choose Us

Why Choose Training with
Future Savvy?

image

Trusted by top UK Organizations

From NHS teams to FTSE 100 companies, over 1,000 professionals have trusted Future Savvy to upskill their teams with results-driven training.

image

Real Experts, not Just Instructors

Our courses are delivered by seasoned professionals with real-world experience using the tools they teach, not just theory, but practical insight.

image

Small Class Sizes for Big Impact

Our class sizes are intentionally small, usually no more than 6, to ensure every learner gets personal attention and time with the trainer.

image

Hands-on, Interactive Learning

You won’t just sit and watch, you'll get stuck in with practical exercises, real scenarios, and immediate feedback from your trainer.

image

Ongoing Support, even after the Course

Have questions after the training? We’re still here. All delegates get unlimited post-course email support at no extra cost.

image

100% Satisfaction Guarantee

We stand by the quality of our training. If you're not completely satisfied, we'll give you a full refund.

Course Information —Excel and Power BI Data Modelling.

Quick Links

Course Information

This 2-day Excel and Power BI Data Modelling Training Course provides a complete toolkit for transforming raw data into actionable insights. From mastering Power Query for data preparation to exploring Power Pivot for building robust models and diving into Power BI’s visualisation capabilities, this course empowers you to take control of your data workflows.

With hands-on guidance from an expert trainer, you’ll learn to create effective reports, manage multiple data sources, and use advanced features like DAX formulas, time intelligence, and publishing to the cloud. This course is designed to provide practical, real-world skills you can apply immediately to your business.

What you will learn

By the end of this Excel and Power BI Data Modelling course, you will be able to:

  • Use Power Query to clean, combine, and transform data efficiently.
  • Create and manage robust data models in Power Pivot with multiple data sources.
  • Write and apply DAX formulas and measures for advanced data analysis.
  • Build interactive reports and dashboards using Power BI visualisations like tables, charts, maps, and KPIs.
  • Leverage time intelligence functions and date tables to analyse trends effectively.
  • Publish, share, and export reports from Power BI to collaborate with your team.

Make smarter decisions with better data

This course provides the skills to optimise your organisation’s data processes, helping you transform raw datasets into valuable insights. You’ll learn how to build data models that simplify complex information, visualise trends with dynamic reports, and collaborate effectively using Power BI’s sharing and publishing tools. With these practical skills, you’ll be able to make confident, data-driven decisions that drive your business forward.

image

CourseOutline

  • 1
    Introduction to Power Query
    • Introduction to Power Query
    • Power Query User Interface – A Walkthrough
    • Importing Data Rules and Best Practice
  • 2
    Data Preparation
    • Combine or Merge Multiple Files from a Folder
    • Importing Data from the Web
    • Merge Queries vs. Append Queries
    • JOIN Types for Beginners
    • Understanding JOIN Concept and its Types
    • JOINS in Action – Basic Example
    • Quick DOs and DONTs for Merge Queries
    • Merging Queries with More than 1 KeyID Column
    • Fuzzy Lookup
  • 3
    Power Pivots
    • Introduction to Power Pivots
  • 4
    Connecting to Different Sources
    • Pasting Data into a Power Pivot
    • Overview of Results
    • Importing Data from Excel and SharePoint Lists to Power Pivot
  • 5
    Working with Multiple Table Data Sources
    • Importing Data from Data Feeds into Power Pivot
    • Managing Data in a Power Pivot Window
    • Excel (Linked Tables) as a Data Source
  • 6
    Power BI
    • Introduction to Power BI
  • 7
    Introduction to DAX Formula & Measures
    • Formula
    • Measures
    • Quick Measure
  • 8
    Date Tables and Time Intelligence
    • Creating Date Tables
    • Time Intelligence Formulas and Measures
  • 9
    Visualisations
    • Table
    • Matrix
    • Charts
    • Maps
    • KPI (Key Performance Indicator)
    • Conditional Formatting
    • Spatial Intelligence
  • 10
    Publishing Reports
    • Publishing Reports to the Cloud
    • Sharing Reports with Others
    • Exporting Data to PowerPoint or Excel

Private courses.

We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!

  • Tailored
  • Post Course Support
  • Cost Effective
Enquire

You’re in Good Company

Over 1,000 professionals from industry-leading brands have chosen Future Savvy for their training needs.

image

Registered England and Wales: 11477692 VAT Number: GB 3123317 52All trademarks are owned by their respective owners. Click here for details.

  • image
  • iamge
  • image
© 2025 Future Savvy. All Rights Reserved.