uCertify

ITM3310 - Introduction to Data Analytics

(ANC-ITM3310.AE1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

The Value of Data

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

Working With Data, Typologies and Governance

  • 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
  • Opening Case
  • Introduction
  • Managing Data
  • The Database Approach
  • Big Data
  • Data Warehouses and Data Marts
  • Knowledge Management
  • Discussion Questions
  • Problem-Solving Activities
  • Closing Case 1
  • Closing Case 2
3

Business Statistics, Optimizing and Forecasting

  • 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
  • Case - Colgate-Palmolive Makes a “Total” Effort
  • 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
  • Formulas
  • Supplementary Problems
  • Analyzing the Databases
  • Case - Caterpillar, Inc.
4

Other Data Analytic Tools

  • Getting Up and Running with R
  • Doing Some Actual Data Science
5

Data Visualization

  • Why Do We Visualize Data?
  • How Do We Visualize Data?
  • Color
  • Common Chart Types
  • When Our Visual Processing System Betrays Us
  • Every Decision Is a Compromise

1

The Value of Data

  • Summarizing the Aspects of Business Analytics and its Applications
2

Working With Data, Typologies and Governance

  • Using the AVERAGE Function
  • Creating a PivotTable Automatically
  • Using the VLOOKUP Function
  • Sorting Data
  • Understanding Big Data
  • Understanding the Relational Database Model
3

Business Statistics, Optimizing and Forecasting

  • Understanding Business Statistics
  • Calculating the Statistics
4

Other Data Analytic Tools

  • Using the length() Function
  • Using the print() Function
5

Data Visualization

  • Visualizing Data
  • Understanding Data Visualization
  • Creating and Analyzing Chart Types

Related Courses

All Courses