Module 1: Introduction to Supply Chain Analytics

• Understanding the role of data in modern supply chains
• Key components of a data-driven supply chain strategy
• Introduction to the PowerBI ecosystem for supply chain analytics
• Setting up your PowerBI environment and connecting to basic data sources
• Practical session: Navigating the PowerBI Desktop interface and importing your first dataset.

Module 2: PowerBI Fundamentals for Data Analytics

• Core concepts of PowerBI: Reports, Dashboards, and Datasets
• Understanding the different views: Report, Data, and Model
• Creating basic visualizations: bar charts, pie charts, and line graphs
• Introduction to filtering, slicing, and drill-through functionality
• Practical session: Building a simple PowerBI report with multiple visualizations and filters.

Module 3: Data Preparation and Transformation in Power Query

• Connecting to various data sources (Excel, CSV, SQL)
• Cleaning and shaping data with Power Query Editor
• Handling missing values, duplicates, and data type errors
• Pivoting, unpivoting, and merging tables for analysis
• Practical session: Cleaning and transforming raw supply chain data for analysis.

Module 4: Supply Chain Performance Metrics and KPIs

• Defining and selecting relevant supply chain KPIs
• Inventory metrics: inventory turnover, days of supply, and stock-to-sales ratio
• Logistics metrics: on-time delivery, shipping cost per unit, and order cycle time
• Procurement metrics: supplier lead time, cost per purchase order, and purchase price variance
• Practical session: Building a KPI dashboard to track key supply chain metrics in PowerBI.

Module 5: Inventory Analytics and Optimization

• Analyzing inventory levels and historical trends
• Identifying and visualizing slow-moving and obsolete stock
• ABC/Pareto analysis for inventory classification
• Optimizing reorder points and safety stock levels
• Practical session: Creating an interactive dashboard to monitor inventory health and identify opportunities for optimization.

Module 6: Demand Forecasting and Planning

• Analyzing historical sales data to identify trends and seasonality
• Using PowerBI's built-in forecasting features
• Visualizing forecast accuracy and bias
• Developing basic demand planning models
• Practical session: Building a demand forecast visualization and measuring its accuracy against actual sales.

Module 7: Supplier Performance Management

• Setting up a data model to analyze supplier data
• Measuring supplier KPIs: on-time delivery, quality, and lead time
• Ranking and segmenting suppliers based on performance
• Creating a supplier scorecard dashboard
• Practical session: Analyzing and reporting on supplier performance using a scorecard visualization.

Module 8: Logistics and Transportation Analytics

• Analyzing transportation costs and efficiency
• Optimizing delivery routes and schedules with data
• Tracking and visualizing shipment status and delivery times
• Analyzing carrier performance and freight spend
• Practical session: Building a dashboard to visualize and analyze logistics performance and identify cost-saving opportunities.

Module 9: Warehouse Operations and Fulfillment Analytics

• Measuring warehouse productivity and efficiency
• Analyzing order fulfillment cycle time and accuracy
• Optimizing picking and packing processes
• Visualizing warehouse space utilization
• Practical session: Developing a dashboard to monitor warehouse key performance indicators.

Module 10: Building Interactive Supply Chain Dashboards

• Principles of effective dashboard design and user experience (UX)
• Designing an intuitive layout for maximum impact
• Adding interactive elements like slicers, buttons, and bookmarks
• Creating calculated fields to enhance dashboard functionality
• Practical session: Designing and building a multi-page, interactive supply chain dashboard from scratch.

Module 11: Advanced DAX for Supply Chain Modeling

• Advanced DAX functions: CALCULATE, ALL, FILTER, and iterators (SUMX, AVERAGEX)
• Creating time intelligence calculations: year-to-date, month-over-month, and rolling averages
• Building more complex measures and calculated columns
• Understanding the importance of context in DAX
• Practical session: Writing complex DAX measures to calculate inventory turn and other critical KPIs.

Module 12: Financial Analytics in the Supply Chain

• Analyzing the financial impact of supply chain decisions
• Calculating and visualizing landed cost, cost of goods sold (COGS), and return on investment (ROI)
• Linking supply chain data with financial reports
• Building cost-to-serve analysis dashboards
• Practical session: Creating a comprehensive financial performance dashboard for the supply chain.

Module 13: Risk Management and Resilience Analytics

• Identifying potential supply chain risks (e.g., supplier concentration, lead time variability)
• Using PowerBI to create risk visualization maps
• Analyzing the impact of disruptions on key metrics
• Developing scenario analysis models for risk mitigation
• Practical session: Building a risk dashboard to monitor and assess potential supply chain threats.

Module 14: Predictive Analytics for Supply Chain Operations

• Introduction to predictive modeling concepts in a supply chain context
• Using PowerBI with R and Python scripts for advanced analytics
• Predicting future demand or delivery delays
• Identifying patterns and correlations in data for predictive insights
• Practical session: Integrating and using a simple predictive model to forecast future demand.

Module 15: Presenting Insights with Data Storytelling

• Understanding the principles of data storytelling
• Structuring a compelling narrative around supply chain data
• Choosing the right visualizations to support your story
• Techniques for presenting data to different audiences
• Practical session: Creating a data story from your final project dashboard to present to a leadership team.

Module 16: Implementing a Supply Chain Analytics Strategy

• Steps for building a data governance framework for supply chain data
• Best practices for data collection and maintenance
• Aligning analytics projects with business objectives
• Developing a roadmap for continuous improvement
• Practical session: Creating a strategic plan for implementing a supply chain analytics initiative.

Module 17: Case Studies in Supply Chain Analytics

• Examining real-world examples of successful supply chain analytics projects
• Analyzing data from various industries (e.g., retail, manufacturing, e-commerce)
• Group discussion and analysis of complex supply chain challenges
• Identifying key takeaways and best practices from case studies
• Practical session: Deconstructing a provided case study to apply learned concepts.

Module 18: Final Project and Course Review

• Working on a capstone project to apply all learned skills
• Building a complete, end-to-end supply chain dashboard
• Presenting your final project and receiving constructive feedback
• Reviewing key concepts and Q&A session
• Practical session: Final project build and presentation.

Requirements:

·       Participants should be reasonably proficient in English.

·       Applicants must live up to Armstrong Global Institute admission criteria.

Terms and Conditions

1. Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

2. What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

3. Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

4. The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

5. Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@armstrongglobalinstitute.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training.

Or call us on +254720272325 / +254725012095 / +254724452588

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

1. Groups of 5 People and Above – Cheque Payments to: Armstrong Global Training & Development Center Limited should be paid in advance, 5 days to the training.

2. Invoice: We can send a bill directly to you or your company.

3. Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

1. Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

2. Participants may cancel attendance 14 days or more prior to the training commencement date.

3. No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Tailor Made Courses

This training course can also be customized for your institution upon request for a minimum of 5 participants. You can have it conducted at our Training Centre or at a convenient location. For further inquiries, please contact us on Tel: +254720272325 / +254725012095 / +254724452588 or Email training@armstrongglobalinstitute.com

Accommodation and Airport Transfer

Accommodation and Airport Transfer is arranged upon request and at extra cost. For reservations contact the Training Officer on Email: training@armstrongglobalinstitute.com or on Tel: +254720272325 / +254725012095 / +254724452588