Getting Started with Machine Learning in Excel and Power BI Training Course
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
- Describe the ML features built into Excel and Power BI.
- Run regression and forecasting with the Excel Analysis ToolPak.
- Use Power BI AI visuals and predictive features.
- Build basic predictive models in Excel and Power BI and test them.
- Present ML results as visuals that support business decisions.
- Identify practical business uses for machine learning.
- Plan how to add ML methods to the workflows your team already has.
Prerequisites
- Basic Excel and Power BI skills
- Some data analysis knowledge helps but is not required
- An interest in practical uses of machine learning
- Readiness for hands-on exercises
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
- Duration: 1 Day
- 4.5 Ratings
Introduction to Machine Learning and AI Training Course
- Duration: 2 Days
- 4.5 Ratings
Machine Learning with Python for Beginners Training Course
- Duration: 3 Days
- 4.5 Ratings
Machine Learning Fundamentals with TensorFlow Training Course
- Duration: 2 Days
- 4.5 Ratings
Data Preprocessing and Feature Engineering for Machine Learning Training Course
- Duration: 3 Days
- 4.5 Ratings
Supervised and Unsupervised Learning Essentials Training Course
- Duration: 3 Days
- 4.5 Ratings
Introduction to Machine Learning with R Training Course