Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Learn the fundamentals of predictive analytics-without having to write code or understand high-level mathematics. Using Excel, understand how to frame a business challenge, train a predictive model using linear regression, and evaluate your results.
In this hands-on class, you will learn the fundamentals of predictive analytics using linear regression-all from within Microsoft Excel.
In survey after survey, data professionals report linear regression is their go-to method for understanding and optimizing the business. Now, you too can learn these techniques, and without having to write any code. Using Excel's out-of-the-box functionality makes linear regression analysis easily accessible to all.
After learning about the types of business problems that might benefit from linear regression analysis, we will teach you to use linear regression to answer interesting business questions such as:
- If we spend more money here, how much uplift in the business should we expect?
- What factors are most important in determining price/demand/supply?
- Does the interaction of certain product features have a disproportionate effect?
- Can we accurately predict future business performance?
Whether you are an Excel-based analyst looking to improve your skills or a manager interested in understanding the linear regression models produced by analytics teams, this is the class for you.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
After taking this course, you will be able to:
- Identify the types of business problems where linear regression can be useful.
- Explain why the arithmetic mean (a.k.a., the average) is a predictive model.
- Understand how simple linear regression improves upon the arithmetic mean.
- Use Excel to train simple and multiple linear regression models.
- Know how to interpret linear regression models in terms of business drivers.
- Evaluate the effectiveness of your linear regression models.
- Communicate your insights effectively.
Who Will Benefit
This course will benefit:
- Business analysts
- Data analysts
- Database developers
- BI developers
- Report developers
- Managers
- Anyone else interested in using linear regression for analyzing business data
Prerequisite(s)
This course requires that students have access to a licensed copy of Microsoft Excel 2016 or later.
How to Access the Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Dave Langer is the VP of analytics at Schedulicity, where he leads the team accountable for data warehousing, business intelligence, and analytics solutions. Dave holds a bachelor’s degree in economics and a master’s degree in computer science from the University of Washington. Dave is a hands-on practitioner with a passion for using the simplest technology/technique to quickly deliver insights that shape company strategy. Prior to Schedulicity, Dave was the VP of data science at Data Science Dojo where he trained hundreds of BI and analytics professionals in the fundamentals of machine learning and predictive analytics.
TDWI is the leading provider of education and research for business intelligence, analytics, and data management professionals. TDWI’s vendor-neutral training is led by experienced practitioners, and has earned a world-wide reputation for being comprehensive, practical, and actionable.