Business Statistics in Excel

Overview

Solving Business Problems with Statistics training course teaches participants how to apply appropriate statistical procedures and models to answer business questions and, most importantly, effectively communicate impact to stakeholders.

Students participating in this 3-day course will learn how to:

  • Decide which tool or technique to use in a given situation
  • Apply data gathering and input considerations, including a conceptual groundwork of statistical reasoning
  • Set up appropriate hypotheses and run analyses in Excel
  • Interpret the results in context of the problem and communicate to stakeholders
  • Identify and avoid key pitfalls
  • Visualize and communicate the results in a fair, objective and unbiased manner
Polynomial Regression What If Analysis in Tableau

Overview

Polynomial Regression What If Analysis in Tableau

Solving Business Problems with Statistics training course teaches participants how to apply appropriate statistical procedures and models to answer business questions and, most importantly, effectively communicate impact to stakeholders.

Students participating in this 3-day course will learn how to:

  • Decide which tool or technique to use in a given situation
  • Apply data gathering and input considerations, including a conceptual groundwork of statistical reasoning
  • Set up appropriate hypotheses and run analyses in Excel
  • Interpret the results in the context of the problem and communicate to stakeholders
  • Identify and avoid key pitfalls
  • Visualize and communicate the results in a fair, objective and unbiased manner

Duration

3 days

Prerequisites

Students should be familiar with writing calculations and formulas within Excel

Training Materials

Manual and supporting materials included

Software Requirements

Access to Microsoft Excel

Course Objectives

Using a Polynomial Time Series for Future Values Prediction in Tableau Linear Regression

Students will leave the course able to use Excel to build statistical models that answer questions like:

  • What’s the relationship between a variable and an outcome?
  • If I adjust X, what will be the impact on Y? Are there natural limits I should be aware of?
  • Are we meeting expectations?
  • What’s coming next? Are we going up or down and by how much?
  • Why are we going up or down? How impactful is each variable? (in other words, what should I focus on first?)
  • Are there any unusual outliers? What caused those? Do I need to do something about this?
  • How likely is any given idea or decision or campaign to be successful?
  • Did any given change or decision make a material business impact?
  •  
  •  

Course Objectives

Using a Polynomial Time Series for Future Values Prediction in Tableau Linear Regression

Students will leave the course able to use Excel to build statistical models that answer questions like:

  • What’s the relationship between a variable and an outcome?
  • If I adjust X, what will be the impact on Y? Are there natural limits I should be aware of?
  • Are we meeting expectations?
  • What’s coming next? Are we going up or down and by how much?
  • Why are we going up or down? How impactful is each variable? (in other words, what should I focus on first?)
  • Are there any unusual outliers? What caused those? Do I need to do something about this?
  • How likely is any given idea or decision or campaign to be successful?
  • Did any given change or decision make a material business impact?

Course Outline

Seamless Live Virtual Training Experience

We custom built our group training platform to give students, managers, and teachers a best in class learning experience.

Dead-Simple Scheduling

Easy scheduling and rescheduling, student logins, and delivery of the course.

Engaging Live Instruction

Intuitive, easy to use, and fully featured live video capabilities with trained instructors. No need for outside tools like Zoom.

All-in-one

Live video instruction, practice exercises, course evaluations, course materials, and student collaborations all happen in the same intuitive platform.

Best In Class Security

We built this platform from the ground up with security in mind. No Zoom bombing here.

Outcome Tracking

Student progress, participation, and achievement is all available and can be integrated into your LMS.

Forever Student Access

Students have access to all course materials, certificates, badges, and live instruction session recordings forever.

Single Course

up to 30 students

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

3-Course Package

up to 30 students per class

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

Better knowledge retention

Enterprise

All courses available at a discount

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

Better knowledge retention

Branded Learning Portal

Custom LMS Integration

Our Training Quality Guarantee

RyanPhotoSmall

After over a decade of working in the trenches with Tableau to solve problems in a myriad of industries, I created this curriculum to not only help others gain technical skills, but also the business acumen they need to ask the right questions and get to insight for the business.

If you’re not 100% satisfied with the course and our instructors, we’ll give you a full refund, no questions asked.

Ryan Nokes, CEO of Data Crunch 

DeloitteLogoSlider
VerizonWirelessSmall
DeltaTransparentSlider
TWCTransparentSlider
USAASlider2
BcbsilTransparentSlider-1
WattsSlider
CityofColumbusTransparentSlider
EMDSeronoTransparentSlider
AAASlider3
RyanPhotoSmall

After over a decade of working in the trenches with Tableau to solve problems in a myriad of industries, I created this curriculum to not only help others gain technical skills, but also the business acumen they need to ask the right questions and get to insight for the business.

If you’re not 100% satisfied with the course and our instructors, we’ll give you a full refund, no questions asked.

Ryan Nokes, CEO of Data Crunch 

DeloitteLogoSlider
VerizonWirelessSmall
DeltaTransparentSlider
TWCTransparentSlider
USAASlider2
BcbsilTransparentSlider-1
WattsSlider
CityofColumbusTransparentSlider
EMDSeronoTransparentSlider
AAASlider3

Testimonials

Thorough and Applicable

“I really liked the step-by-step nature of the course. It was very easy to follow and therefore learn. The instructor did a great job catering examples to us (based on his knowledge of our work) when applicable. He was very thorough in covering different aspects of the course and I learned a great deal! The instructor answered our questions thoughtfully, and even followed up after breaks to make sure our questions were answered well and correctly. Thank you!”

Adaptable

“Informational and instructor was adaptable to explain subjects outside of the planned course material as questions aros”

Safe Space to Practice and Ask Questions

“The space to practice and ask technical questions without feeling hurried.”

Lots of Energy

“Great use of examples in class. Appreciate you taking the necessary time to make sure everyone was able to understand the concepts. Lots of energy to keep everyone engaged.”

Highly Rewarding

“The class was highly rewarding and covered more than what was expected. The training was very well presented and I never felt lost.”

Immediately Applicable

“I was able to quickly apply and see where Tableau could be valuable for my internal and external reporting clients.”

Contact Us to Schedule A Course

Other Courses You May Be Interested In