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
Inventory Management
- Inventory Basics
- Inventory Management Basics
- Types of Inventory
- Classification of Inventory Systems
- Inventory Management Models
- Inventory Control and Replenishment Techniques
- Inventory Accuracy and Cycle Counting
- Demand Forecasting
- Inventory Performance Measurement
- Selective Inventory Management
- Aggregate Inventory Planning
- Exchange Curve
- Deterministic Inventory Models
- Probabilistic Inventory Models
- Economic Order Quantity( EOQ)
- ABC Inventory Planning
- XYZ Analysis
- Inventory Control of Slow Moving Items
Warehousing
- Introduction
- Benefits of Warehousing
- Functions of Warehouses
- Need for Holding Stock
- Characteristics of Warehouses
- Warehousing Efficiency and Effectiveness
- Information Technology Requirements
- Measuring Performance
Warehouse Processes
- Introduction
- Receiving
- Pre-Receipt
- In-handling
- Preparation
- Offloading
- Checking
- Cross Docking
- Recording
- Quality control
- Put-away
Inventory Costing
- Inventory Cost Types and Affecting Factors
- Activity-Based Costing
- Acceptance Sampling Plans
- Accounting System
- Advance Payment
Forecasting Demand
- Methods of Forecasting
- Judgmental Forecasts
- Time Series
- Casual Forecasting
- Planning Forecasts
Distribution and Freight Management
- Central Place Theory
- Unit Load Concept
- Reducing Freight Costs
- Freight Costing
- Freight Routing and Scheduling
Advanced Analytics
- Lot Sizing
- Picking Strategies
- Reverse Logistics
- Obsolescence Management
- Predictive Analytics