Table of Content
Analytics Introduction
- Evolution and Scope
- Data Management and Types
- Decision Models
- Problem Solving and Decision Making
Using Spreadsheets for Analytics
- Excel Formulas
- Excel Functions
- Spreadsheet Add-Ins
- What is Spreadsheet Modeling
Visualizing Data in Spreadsheets
- Excel Data Visualization Tools
- Data Queries in Excel
- Data Summarization in Excel
- PivotTables and Pivot Charts
Descriptive Statistical Measures
- Statistical Notation
- Measures of Location
- Measures of Dispersion
- Measures of Shape
- Measures of Association
- Frequency Distributions
- Excel Descriptive Statistics Tools
Probability Distributions
- Probability Basics
- Discrete Probability Distributions
- Continuous Probability Distributions
- Distribution Fitting
Sampling and Estimation
- Sampling Methods
- Statistical Sampling
- Sampling Distributions
- Estimation
- Interval Estimates
- Confidence Intervals
- Prediction Intervals
Statistical Inference
- Hypothesis Testing
- One-Sample Hypothesis Tests
- Two-Sample Hypothesis Tests
- ANOVA
Regression Analysis
- Simple Linear Regression
- Residual Analysis and Regression Assumptions
- Multiple Linear Regression
- Regression with Categorical Independent Variables
- Regression Models with Nonlinear Terms
Introduction to Logistics
- Concepts of Logistics
- Logistics Processes
- Logistics Intermediaries
- Integrated Logistics
Supply Chain Management
- Supply Chain Basics
- The Bullwhip Effect
- Global Supply Chain Management
- SCOR Model
Logistics and SCM Theories
- Systems Approach
- Resource-Based View Theory
- Knowledge-based view (KBV)
- Strategic Choice theory (SCT)
- Principle Agency theory (PAT)
- Systems theory (ST)
- Transaction Cost Economics
- Game Theory
- Available-to-promise (ATP)
- Theory of Constraints
Supply Chain Modeling
- Deterministic Analytical Models
- Stochastic Analytical Models
- Economic Models
- Simulation Models
Supply Chain Strategic Management
- Strategic Management Processes
- Supply Chain Strategy
- Environmental Analysis
- Pestle Analysis
- SWOT Analysis
- Value Chain Analysis
- Competitor Analysis
Supply Chain Design
- Supply Chain Decision Phases
- Supply Chain Process View
- Achieving Strategic Fit
- Supply Chain Segmentation
- Aggregate Planning
- Planning Strategies
Logistics Network Planning
- What is Logistics Network Design
- Design Issue and Data
- Distribution Centres and Warehouses
- Modeling Techniques
- Logistics Network Design Process
Demand Management
- Introduction
- Demand Forecasting
Distribution and Freight Management
- Central Place Theory
- Unit Load Concept
- Reducing Freight Costs
- Freight Costing
- Freight Routing and Scheduling
Logistics and SCM Costing
- What is Cost
- Fixed and Variable Costs
- Cost Analysis
- SCM Costing
- What are Logistics Costs
- Logistics Costs Types
- Logistics Cost Analysis and Approaches
- Activity-based costing (ABC)
- Target Costing
- Logistics Cost Analysis Formulas
Logistics and SCM Optimization
- What is optimization
- Business Process Optimization
- Modeling and Optimization
- Logistics Problems
- Logistics Optimization
- Supply Chain Optimization
- Time Compression
Advanced Analytics
- Capacity Analysis
- Order Management
- Spend Analysis
- Prescriptive Analytics
- Cognitive Analytics