By using tdwi.org website you agree to our use of cookies as described in our cookie policy. Learn More

TDWI San Diego Update

At TDWI, we have been working hard to navigate this ever-changing landscape in the face of COVID-19, and we want to assure you that the health and well-being of our employees, customers, and vendor partners is our top priority. Therefore, we have unfortunately decided to cancel TDWI San Diego 2020.

We truly appreciate your support during this difficult time. Our registration team will be in contact with individual registrants and sponsors directly. View our virtual learning options at tdwi.org/virtualtraining.

Course Description

DL2 Data Literacy Bootcamp // Hands-on: Predictive Analytics for Everyone with ExcelNEW!

August 18, 2020

8:00 am - 5:30 pm

Duration: Full Day Course

Level: Beginner to Intermediate

Prerequisite: None

Caitlin Johnson

Data Scientist

Schedulicity

David Langer

VP of Analytics

Schedulicity

In this hands-on class, you will learn the fundamentals of applying linear regression to business data using Excel. In survey after survey, data professionals report linear regression is their go-to method for understanding and optimizing the business.

Using Excel’s out-of-the-box functionality makes linear regression analysis fun and easy—we promise!

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.

Want to know the best part? No programming or difficult mathematics are required!

You Will Learn

  • The types of business problems where linear regression can be useful
  • Why the arithmetic mean (a.k.a., the average) is a predictive model
  • How simple linear regression improves upon the arithmetic mean
  • How to use Excel to train simple linear regression models
  • Ways to use Excel to train multiple linear regression models
  • How to interpret linear regression models in terms of business drivers
  • Ways to evaluate the effectiveness of your linear regression models
  • How to communicate your insights effectively
  • Additional resources to extend your learning

Geared To

  • Business/data analysts
  • Database developers
  • BI/report developers
  • Managers
  • Anyone else interested in using linear regression for analyzing business data

Lab Setup

Participants should download and install the following prior to the event:

  • Microsoft Excel 2016 or later.

Instructions will be emailed to registrants prior to the event to prepare your laptop BEFORE the conference. There is no time allotted in class for laptop preparation.