Supply Planning Analyst
Profile Code: AL-FMC-05
- ₹7.5 LPA (Median Salary)
- Lecture Duration 2hrs
- Course Duration 10 Weeks
Skills You Learn: Supply Planning | Demand & Supply Balancing | Inventory Management | Supply Chain Analytics | Production Planning | Forecasting Techniques | Advanced Excel | ERP Systems (SAP/Oracle) | Power BI & Dashboards | S&OP Planning | Capacity Planning | Risk Management
Overview Video
About This Course
A Supply Planning Analyst in the FMCG industry focuses on aligning supply with demand to ensure product availability while minimizing costs and inventory risks. This course equips learners with the skills to plan production and replenishment, track KPIs such as inventory levels, service levels, and stockouts, and coordinate across procurement, manufacturing, and distribution. Participants gain hands-on experience with tools like Excel, SQL, and BI dashboards for planning and performance analysis. The program emphasizes supply planning, inventory optimization, and cross-functional coordination in fast-moving environments. Learners will understand how to manage demand variability, reduce excess inventory, and improve service levels. By the end of the course, they are prepared for roles in supply chain planning and analytics, with career progression into supply chain strategy, planning leadership, and operations management positions.
Course Content
3 modules · 10 weeks · 2hrs/dayExcel Course
The **Excel Course** covers basic to advanced concepts for Supply Planning Analysts in the FMCG industry, including workbook management, formulas, functions, data validation, sorting, filtering, conditional formatting, Pivot Tables, Pivot Charts, XLOOKUP, INDEX-MATCH, Power Query, Power Pivot, demand planning, inventory analysis, production planning, replenishment planning, safety stock calculations, forecasting support, statistical functions, dashboards, What-If Analysis, Solver, VBA automation, KPI reporting, logistics analysis, variance reporting, and interactive dashboards to optimize supply planning, improve inventory availability, reduce operational costs, and support data-driven business decisions.
BI Course
The **BI Course** covers basic to advanced business intelligence concepts for Supply Planning Analysts in the FMCG industry, including data integration, data transformation, data modeling, KPI development, dashboard creation, interactive visualizations, inventory dashboards, demand planning analytics, production performance reporting, replenishment tracking, supplier performance analysis, logistics monitoring, predictive analytics, DAX fundamentals, drill-through reports, automated reporting, executive dashboards, forecasting visualization, performance monitoring, and business intelligence techniques to transform supply chain data into actionable insights for efficient planning and operational excellence.
SQL Tools Course
The **SQL Tools Course** covers basic to advanced database concepts for Supply Planning Analysts in the FMCG industry, including database fundamentals, SELECT queries, filtering, sorting, joins, aggregate functions, GROUP BY, HAVING, subqueries, Common Table Expressions (CTEs), window functions, CASE statements, views, stored procedures, indexing, query optimization, transaction management, inventory data extraction, demand analysis, production reporting, supplier analytics, logistics performance monitoring, data validation, and large dataset management to retrieve, transform, and analyze supply chain data for effective planning, inventory optimization, and strategic business decision-making.
Key Responsibilities
- Develop supply plans based on demand forecasts
- Monitor inventory levels and product availability
- Coordinate production and replenishment schedules
- Analyze supply chain performance and capacity constraints
- Balance demand and supply requirements
- Track stock movements and service levels
- Identify supply risks and mitigation strategies
- Prepare supply planning reports and dashboards
- Collaborate with procurement, manufacturing, and logistics teams
- Recommend strategies to optimize inventory and improve supply chain efficiency
Growth Path
Tools Used
Perfect For
Supply Chain Professionals | Industrial Engineers | Operations Executives | Manufacturing Professionals | Logistics Analysts | Procurement Professionals | FMCG Professionals | MBA Graduates | Data Analysts | Early-Career Supply Chain Aspirants
Fee Structure
Mentor
Analytics Learners
Professional Analyst & Mentor
Explore Various Career Paths in FMCG
Related analyst roles inside the same industry.
