Foundation of Data Analytics

• Opening Case
• Introduction
• Managers and Decision Making
• The Business Analytics Process
• Business Analytics Tools
• Business Analytics Models: Descriptive Analytics, Predictive Analytics, and Prescriptive Analytics
• Summary
• Discussion Questions
• Closing Case 1
• Closing Case 2

1 LiveLab in this lesson — see the labs panel →

• Some Sample Data
• Moving Quickly with the Control Button
• Copying Formulas and Data Quickly
• Formatting Cells
• Paste Special Values
• Inserting Charts
• Locating the Find and Replace Menus
• Formulas for Locating and Pulling Values
• Using VLOOKUP to Merge Data
• Filtering and Sorting
• Using PivotTables
• Using Array Formulas
• Solving Stuff with Solver
• OpenSolver: I Wish We Didn't Need This, but We Do

13 LiveLab in this lesson — see the labs panel →

• Opening Case
• Introduction
• Managing Data
• The Database Approach
• Big Data
• Data Warehouses and Data Marts
• Knowledge Management
• Summary
• Discussion Questions
• Problem-Solving Activities
• Closing Case 1
• Closing Case 2

2 LiveLab in this lesson — see the labs panel →

• Introduction to Probability
• Structure of Probability
• Marginal, Union, Joint, and Conditional Probabilities
• Addition Laws
• Multiplication Laws
• Conditional Probability
• Revision of Probabilities: Bayes' Rule
• Introduction to Hypothesis Testing
• Testing Hypotheses About a Population Mean Using the z Statistic (σ Known)
• Testing Hypotheses About a Population Mean Using the t Statistic (σ Unknown)
• Testing Hypotheses About a Proportion
• Testing Hypotheses About a Variance
• Solving for Type II Errors
• Summary
• Formulas
• Supplementary Problems
• Analyzing the Databases
• Case - Colgate-Palmolive Makes a “Total” Effort

4 LiveLab in this lesson — see the labs panel →

• Why Should Data Scientists Know Optimization?
• Starting with a Simple Trade-Off
• Fresh from the Grove to Your Glass…with a Pit Stop through a Blending Model
• Modeling Risk
• Wait, What? You're Pregnant?
• Don't Kid Yourself
• Predicting Pregnant Customers at RetailMart Using Linear Regression
• Predicting Pregnant Customers at RetailMart Using Logistic Regression
• For More Information
• Correlation
• Introduction to Simple Regression Analysis
• Determining the Equation of the Regression Line
• Residual Analysis
• Standard Error of the Estimate
• Coefficient of Determination
• Hypothesis Tests for the Slope of the Regression Model and Testing the Overall Model
• Estimation
• Using Regression to Develop a Forecasting Trend Line
• Interpreting the Output
• Summary
• Formulas
• Supplementary Problems
• Analyzing the Databases
• Case - Caterpillar, Inc.

2 LiveLab in this lesson — see the labs panel →