Business & Data Analytics

Lean Business & Data Analytics Specialized Skill Program (IM1004)


Description
90 Days | SCORM | info@imacia.org

Course Description:
This Data Analytics Pathway provides both foundational & applied knowledge in business data analytics for problem solving, continuous improvement, and decision making. It builds skills and satisfies the necessity for professionals to have the ability to use various tools to create, analyze, manage, and report data. Learners will be able to integrate concepts into application and practice.

After finishing this course you will be able to:
- Understand how to formulate and state a business problem
- Understand how to simply set a business analytics project to achieve results
- Learn the application and general difference of Descriptive analytics, Predictive analytics, and Prescriptive analytics
- Learn how to use some of Excel capabilities, how to Compare and contrast data, and use spreadsheet formats for analytics.
- Apply and compute descriptive analytics measurements of data sets to demonstrate knowledge and compare metrics between organizations or business.
- Produce Visual Analytics & interpret the meaning of measurement analysis outcomes and use Data Visualization
- Integrate the use of normal distributions with testing probabilities, hypothesis, or quality control approaches.
- Analyze data using Predictive Analytics tool for possible correlation values and associations of business variable.
- Learn how to build simple and multiple linear predictive models to represent relationships and predict variable behavior.
- Learn how to build simple and advanced forecasting models to represent relationships with time and forecast future variable behavior.
- Integrate risk aversion using simulation and optimization tools, and learn how to manage business objective functions
- Analyze and use linear programming optimization in Prescriptive Analytics to enhance business decision-making process and problem solving.

Course Outline:
•Introducing Business & Data Analytics
•Defining Business Problem
•Formulating & Prioritizing Problem Based Project
•Applying Business Analytics
•Descriptive Analytics
o Visualizing, Graphing & Exploring Data
o Descriptive Statistical Measures
o Probability Distributions and Data Modeling
o Sampling & Estimation
o Statistical Inference
•Predictive Analytics
o Trendline & Linear Regression Analysis
o Forecasting & Time Series Modeling
•Prescriptive Analytics
o Monte Carlo Simulation & Risk Analysis
o Linear Optimization

The learning is fluid, and time duration set to finish the Pathway is 90 days. Learners can finish sooner and obtain certificate if they like to speed up their learning pace. The certificate course cost may not refundable once course started.

Made especially affordable for IMACIA Social & Economic Mobility initiative./b>

Content
  • COURSE OVERVIEW
  • COURSE POLICY
  • COURSE MATERIALS
  • COURSE STRUCTURE
  • Introducing Business & Data Analytics
  • Introduction to Business & Data Analytics
  • Introduction to Business & Data Analytics
  • Business Analytics-Quick Review
  • Defining Business Problem
  • Simply Defining a Problem or Opportunity- How to?
  • Lesson
  • Defining the Problem
  • Defining the Problem
  • What Is a Problem Statement: Definition and Example
  • Formulating & Prioritizing Problem Based Project
  • Lesson: Defining a Project
  • Formulating & Prioritizing a Project
  • Project Priority & Screening
  • Applying Business Analytics
  • Introduction to Analytics on Spreadsheets
  • Learning Objectives
  • Lesson
  • Applying Business Analytics
  • Introduction to Excel 1
  • Excel Formulas & Functions
  • Excel Rows & Columns
  • Example on using Excel Functions
  • Date Function
  • Assessment - Practice Assignment [Go To Files]
  • Assessment -Quiz
  • Assessment - Practice Assignment [Go To Files]
  • Assessment - Quiz
  • Descriptive Analytics
  • Visualizing and Exploring Data
  • Introduction to Visualizing and Exploring Data
  • Learning Objectives
  • Lesson
  • Visualizing and Exploring Data
  • Create a chart from start to finish 1
  • How to Make a Histogram in Excel 2016
  • Pivot Table in Excel
  • Assessment - Practice Assignment [Go To Files]
  • Assessment - Quiz
  • Descriptive Statistical Measures
  • Introduction to Descriptive Statistical Measures
  • Learning Objectives
  • Lesson
  • Descriptive Analytics
  • Load the Analysis ToolPak & Solver in Excel
  • Installing Analysis ToolPack & Solver in Excel
  • Video: Descriptive Statistical Measures
  • Practice Assignment [Go To Files]
  • Practice Assignment Case Study: Drout Advertising
  • Quiz
  • Probability Distributions and Data Modeling
  • Introduction to Probability Distributions and Data Modeling sample
  • Learning Objectives
  • Lesson
  • Probability
  • Video1: Relative Freq. Definition of Prob. in Excel
  • Video2: Relative Freq. Definition of Prob. in Excel
  • Video3: Relative Freq. Definition of Prob. in Excel
  • Practice Assignment [Go To Files]
  • Quiz
  • Sampling & Estimation
  • Introduction to Sampling & Estimation
  • Learning Objective
  • Lesson
  • Populations and Samples
  • Sampling & Estimation
  • Sampling & Estimation in Excel
  • Practice Assignment [Go To Files]
  • Quiz
  • Statistical Inference
  • Introduction to Statistical Inference
  • Learning Objectives
  • Lesson
  • Statistical Inference
  • Statistical Inference 1
  • Statistical Inference 2
  • Materials - Statistical Inference Excel Tools
  • Assessment - Practice Assignment [Go To Files]
  • Predictive Analytics
  • Trendline & Linear Regression Analysis
  • Introduction to Trendline & Regression Analysis
  • Learning Objective
  • Practice Assignment [Go To Files]
  • Simple & Mutiple Regression
  • Simple Linear Regression Model in Excel
  • Multiple Regression Model
  • Forecasting Techniques
  • Introduction to Forecasting Techniques
  • Learning Objective
  • Forecasting & Time Series Modeling
  • Assessment - Practice Assignment [Go To Files]
  • Video 1: Forecasting Models for Practice Problems
  • Video 2: Forecasting Models for Practice Problems
  • Prescriptive Analytics
  • Monte Carlo Simulation & Risk Analysis
  • Introduction to Monte Carlo Simulation & Risk Analysis
  • Learning Objective
  • Monte Carlo Simulation and Risk Analysis
  • Monte Carlo Simulation in Excel
  • Monte Carlo Simulations: Run 10,000 Simulations
  • Monte Carlo Simulaiton for Practice Problem
  • Monte Carlo Simulation Practice Problem
  • Linear Optimization
  • Introduction to Linear Optimization
  • Learning Objective
  • Linear Optimization Using Solver
  • Application of Linear Optimization
  • Application of Linear Optimization using Excel Example
  • Application of Linear Optimization -Sensitivity
  • Module 15 Integer Linear Programming - Binary (0-1) Variables
  • Introduction to Linear Optimization 1
  • Introduction to Linear Optimization 2
  • Introduction to Linear Optimization 3
  • Introduction to Linear Optimization 4
  • Introduction to Linear Optimization 5
  • Introduction to Linear Optimization 6
  • Introduction to Linear Optimization 7
  • Using Solver for LP Practice Problems
  • LP Optimization Practice Problems
  • END
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: 1 year