Getting Started with Machine Learning in Excel and Power BI Training Course

Share this course

Duration

1 Day

Course Overview

Spreadsheet users and report builders learn to make simple predictions inside the tools they already open every day, Excel and Power BI. The day starts by comparing what each tool can do for machine learning and exploring a dataset in both. Next, the Excel Analysis ToolPak runs regression and forecasting, and attendees read the output to make predictions. Power BI AI visuals follow, including Key Influencers and Decomposition Tree. A business case closes the day, solved with both tools and presented by each group. People leave able to build a basic predictive model and show its results in a report.

Format of Training

  • Live demos in Excel and Power BI, side by side
  • Labs on an Analysis ToolPak regression and Power BI AI visuals
  • Business datasets used across all three labs
  • Group case where teams present a data-driven answer to a business question

Course Objectives

  1. Describe the ML features built into Excel and Power BI.
  2. Run regression and forecasting with the Excel Analysis ToolPak.
  3. Use Power BI AI visuals and predictive features.
  4. Build basic predictive models in Excel and Power BI and test them.
  5. Present ML results as visuals that support business decisions.
  6. Identify practical business uses for machine learning.
  7. Plan how to add ML methods to the workflows your team already has.

Prerequisites

Course Outline

Day 1

Session 1: Introduction to Machine Learning in Excel and Power BI

  • ML ideas and why they matter to business
  • Excel and Power BI ML features compared in brief
  • Hands-on lab: looking through datasets in Excel and Power BI

Session 2: Predictive Analytics in Excel

  • Regression and forecasting with the Excel Analysis ToolPak
  • Reading regression output and producing predictions
  • Hands-on lab: creating a regression model in Excel

Session 3: Leveraging Power BI for Machine Learning

  • AI visuals and predictive features in Power BI
  • Building Key Influencers and Decomposition Tree visuals and reading them
  • Hands-on lab: drawing insights with Power BI AI features

Session 4: Case Study: Applying Machine Learning to Solve a Business Problem

  • Working a practical problem with Excel and Power BI
  • Group activity: building a data-driven solution and presenting it

Book This Course

Customise This Course for Your Team

Send us an export from your sales or finance reports and the regression and Power BI labs can use it in place of sample data. If your team mainly works in Power BI, Session 3 can take more of the day. Tell us which Excel and Power BI versions your staff use.
Need help with the right course to choose?

Explore more opportunities

Introduction to Machine Learning and AI Training Course

Machine Learning with Python for Beginners Training Course

Machine Learning Fundamentals with TensorFlow Training Course

Data Preprocessing and Feature Engineering for Machine Learning Training Course

Supervised and Unsupervised Learning Essentials Training Course

Introduction to Machine Learning with R Training Course

Getting Started with Machine Learning in Excel and Power BI Training Course