Certified Inventory and Warehouse Analytics Professional

Course details

Analytics involves data collection, processing, analysis and interpretation for better decision making and gain ;

The emergence of new technologies like internet, smart phones, etc has led to e-commerce and JIT based inventory and warehouse management. Increased competition has also brought more focus on making inventory and warehouse management lean an agile by using informed business decisions. Analytics provide informed insights for informed and effective decision making by data collation, processing and analysis.

Inventory and Warehouse analytics has emerged as the prominent contributor for optimized and lean inventory and warehousing affecting inventory management, warehousing, inventory costing, distribution, demand forecasting and reverse logistics.
The course covers

• Basics of Analytics and statistics 
• Using MS-Excel for analytics
• Inventory Management
• Warehousing
• Inventory Costing
• Forecasting Demand
• Reverse Logistics

Why should I take Inventory and Warehouse Analytics Certification?
This Course is intended for store, inventory, logistics, SCM and warehousing professionals, managers, consultants and graduates wanting to excel in inventory and warehouse analytics. It is also well suited for those who are already working and would like to take certification for further career progression.

Earning Vskills Certified Inventory and Warehouse Analytics Professional Certification can help candidate differentiate in today's competitive job market, broaden their employment opportunities by displaying their advanced skills, and result in higher earning ;

How will benefit from taking this Certification?
Job seekers looking to find employment in store, inventory, warehouse, logistics, or SCM departments of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.
 
Benefits of Certification

• Government certification
• Certification valid for life
• Lifelong e-learning access
• Learning Hours: 18+ hrs

 
How It Works

1. Select Certification & Register
2. Receive Online e-Learning Access (LMS)
3. Take exam online anywhere, anytime
4. Get certified & Increase Employability

Test Details

• Duration: 60 minutes
• No. of questions: 50
• Maximum marks: 50, Passing marks: 25 (50%).
• There is NO negative marking in this module.
• Online exam.

 
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

Updated on 19 December, 2023