Be the first to know when new training courses are scheduled or dates are updated.
We run this course regularly across Nairobi, Mombasa, Kampala, Dar es Salaam, Kigali, Johannesburg, Dubai, Singapore, China and many more locations. The next intake dates will be published here shortly.
Need it sooner? Reach out and we'll fast-track a session for you or your team.
Prefer email? Submit a scheduling request and we'll get back to you shortly.
The Excel for Data Analysis, Advanced Excel, Data Analytics and Visualization, Power BI, Business Intelligence, Inventory Management, Warehouse Management, Supply Chain Management, Procurement and Logistics Training Course is a comprehensive practical programme designed to equip professionals with integrated digital, analytical and operational skills required for modern business management and supply chain decision-making. The programme combines Microsoft Excel for Data Analysis, Advanced Excel, Data Analytics and Visualization, Power BI dashboards, Business Intelligence, inventory control, warehouse operations, supply chain management, procurement management and logistics management. Participants will learn how to transform raw operational data into meaningful information, develop management reports, automate repetitive tasks, visualize key performance indicators and use data-driven insights to improve procurement, inventory, warehouse and logistics performance.
The Excel and Data Analytics component develops practical competence in data cleaning, data preparation, spreadsheet modelling, formulas and functions, lookup functions, conditional calculations, PivotTables, PivotCharts, data validation, what-if analysis and advanced reporting. Participants will progress from core Excel data analysis techniques to advanced Excel modelling and business analytics, enabling them to analyze large datasets and identify trends, exceptions, performance gaps and operational opportunities. The Power BI and Business Intelligence component introduces data modelling, data transformation, dashboard development, interactive visualizations, KPI reporting and management intelligence, helping participants communicate complex business and supply chain information through clear and decision-oriented dashboards.
The Inventory Management, Warehouse Management and Supply Chain Management component focuses on stock control, inventory optimization, demand planning, inventory accuracy, safety stock, reorder levels, ABC analysis, warehouse layout, receiving, storage, picking, packing, dispatch, stock reconciliation and warehouse performance measurement. Participants will also examine supply chain planning, supplier performance, procurement processes, logistics coordination, transportation management, order fulfilment, lead-time management and supply chain KPIs. Practical exercises will demonstrate how Excel and Power BI can be applied to inventory records, procurement spend, supplier analysis, warehouse productivity, stock movement, logistics costs and supply chain performance.
The Procurement and Logistics component strengthens participants' ability to connect analytical tools with procurement and operational decisions. Participants will learn how to analyze procurement expenditure, evaluate supplier performance, monitor purchase orders, identify cost-saving opportunities, track delivery performance, manage logistics information and develop executive dashboards. General case studies, practical datasets, spreadsheet exercises, Power BI reporting activities and integrated supply chain scenarios will enable participants to apply the skills across real-world organizational environments. The course is suitable for organizations seeking to improve data-driven decision-making, operational efficiency, inventory accuracy, warehouse productivity, procurement performance, logistics visibility and overall supply chain resilience.
By the end of the training, participants should be able to:
1. Apply Microsoft Excel for data analysis, reporting, business modelling and operational decision-making.
2. Use Advanced Excel formulas, functions, PivotTables, PivotCharts, data validation and analytical tools effectively.
3. Clean, transform, organize and analyze large business, inventory, procurement and supply chain datasets.
4. Develop professional data visualizations, management reports, dashboards and KPI scorecards.
5. Use Power BI for data transformation, data modelling, interactive dashboards and Business Intelligence reporting.
6. Analyze inventory levels, stock movements, reorder points, safety stock, ABC classification and inventory performance.
7. Apply warehouse management principles to improve receiving, storage, picking, dispatch, stock accuracy and warehouse productivity.
8. Analyze supply chain performance using demand, procurement, inventory, logistics, supplier and delivery data.
9. Apply procurement analytics to supplier evaluation, spend analysis, purchasing performance and cost optimization.
10. Develop integrated Excel and Power BI solutions for evidence-based supply chain, procurement, inventory and logistics management.
Organizations will benefit from:
1. Improved employee competence in Excel, Advanced Excel, Data Analytics and Business Intelligence.
2. Better data-driven decision-making through accurate and timely management information.
3. Improved reporting efficiency through automated Excel models and Power BI dashboards.
4. Enhanced inventory visibility, stock accuracy and inventory control.
5. Reduced stock-outs, overstocking, inventory losses and inefficient stockholding.
6. Improved warehouse productivity, space utilization and operational control.
7. Stronger procurement analytics, supplier performance management and expenditure control.
8. Improved logistics visibility, delivery monitoring and transportation performance.
9. Better integration of procurement, inventory, warehouse and supply chain information.
10. Stronger organizational performance through KPI-based monitoring, analytics and evidence-based management.
The course is designed for data analysts, business analysts, finance professionals, procurement officers, procurement managers, purchasing officers, supply chain professionals, logistics officers, logistics managers, inventory controllers, warehouse managers, warehouse supervisors, stock controllers, operations managers, business intelligence professionals, monitoring and evaluation officers, project managers, administrative managers, management accountants, finance managers, sales and marketing professionals, business owners, entrepreneurs, consultants, ICT professionals, data managers and executives responsible for business reporting, procurement, inventory, warehouse, logistics and supply chain decision-making.
1. Excel workbook structure, worksheets, tables, ranges and professional spreadsheet design.
2. Data entry, formatting, sorting, filtering and organizing business datasets.
3. Essential Excel formulas and functions for operational and management analysis.
4. Relative, absolute and mixed cell references for reliable spreadsheet modelling.
5. Data validation, conditional formatting and error identification.
6. General case study: Building an Excel-based operational database for sales, purchasing, inventory and supplier records.
1. Advanced Excel functions including IF, SUMIFS, COUNTIFS, XLOOKUP and INDEX-MATCH.
2. Nested formulas and logical functions for complex business analysis.
3. PivotTables and PivotCharts for multidimensional data analysis.
4. What-if analysis, scenario analysis and sensitivity analysis.
5. Excel tables, named ranges and structured references for scalable models.
6. General case study: Developing an advanced Excel management model to analyze monthly sales, costs, inventory and procurement performance.
1. Identifying duplicate, incomplete, inconsistent and inaccurate business data.
2. Data cleaning and transformation techniques using Excel.
3. Text, date, time and numerical data manipulation.
4. Data consolidation and integration from multiple worksheets and sources.
5. Preparing analytical datasets for dashboards and Business Intelligence.
6. General case study: Cleaning and consolidating procurement, inventory and supplier datasets before management analysis.
1. Principles of effective business data visualization and analytical storytelling.
2. Selection and design of charts for trends, comparisons, distributions and performance.
3. Interactive Excel dashboards and management reporting.
4. KPI development for sales, procurement, inventory, warehouse and logistics.
5. Trend analysis, variance analysis and exception reporting.
6. General case study: Designing a management dashboard showing inventory turnover, supplier performance, purchasing expenditure and delivery trends.
1. Introduction to Power BI, Business Intelligence and data-driven decision-making.
2. Importing and connecting business, procurement, inventory and supply chain datasets.
3. Data transformation and preparation using Power Query.
4. Data modelling, relationships and analytical structures.
5. Development of interactive Power BI reports, dashboards and KPI visualizations.
6. General case study: Creating a Power BI executive dashboard for integrated procurement, inventory, warehouse and logistics performance.
1. Advanced Power BI visualizations and interactive reporting techniques.
2. Measures, calculated columns and analytical calculations.
3. Drill-down, filtering, slicers and interactive dashboard functionality.
4. Designing executive dashboards for strategic and operational decisions.
5. Performance monitoring through real-time or regularly updated management information.
6. General case study: Developing an executive Business Intelligence dashboard to identify procurement costs, stock risks, supplier delays and logistics performance.
1. Inventory management principles, objectives and inventory classification.
2. Stock records, stock movements, inventory accuracy and reconciliation.
3. Reorder levels, reorder points, safety stock and minimum/maximum stock levels.
4. ABC analysis, inventory turnover and slow-moving and obsolete inventory.
5. Demand forecasting and inventory planning using Excel analytics.
6. General case study: Using Excel to analyze stock movements and determine inventory risks, reorder priorities and slow-moving stock.
1. Warehouse management principles, functions and performance objectives.
2. Receiving, inspection, put-away, storage and inventory location management.
3. Picking, packing, dispatch and order fulfilment processes.
4. Warehouse layout, space utilization and material-handling efficiency.
5. Warehouse KPIs including order accuracy, picking productivity, inventory accuracy and turnaround time.
6. General case study: Analyzing warehouse performance data to identify bottlenecks in receiving, storage, picking and dispatch operations.
1. Supply chain structure, planning, coordination and end-to-end visibility.
2. Demand planning, supply planning and inventory synchronization.
3. Supplier, procurement, warehouse, distribution and customer-service integration.
4. Supply chain KPIs, performance measurement and dashboard reporting.
5. Supply chain risk identification, resilience and business continuity analytics.
6. General case study: Developing a supply chain performance dashboard covering supplier lead times, inventory availability, order fulfilment and delivery performance.
1. Procurement cycle, purchasing processes and procurement performance management.
2. Procurement planning, purchase requisitions, purchase orders and supplier records.
3. Supplier evaluation, supplier performance and vendor scorecards.
4. Procurement spend analysis and identification of cost-saving opportunities.
5. Excel and Power BI applications for procurement reporting and KPI monitoring.
6. General case study: Conducting procurement spend analysis to identify supplier concentration, price variations, purchasing trends and potential savings.
1. Logistics management principles and the role of transportation in supply chain performance.
2. Transport planning, route management, delivery scheduling and fleet performance.
3. Freight costs, logistics expenditure and transportation efficiency analysis.
4. Order fulfilment, delivery performance and customer service metrics.
5. Logistics KPIs including on-time delivery, cost per delivery, lead time and vehicle utilization.
6. General case study: Using Excel and Power BI to analyze delivery records and identify transportation cost and service-performance improvement opportunities.
1. Integrating Excel data analysis, Advanced Excel and Power BI into operational reporting.
2. Building an integrated procurement, inventory, warehouse and logistics data model.
3. Developing supply chain KPI dashboards for operational and strategic management.
4. Performing scenario analysis for inventory, procurement, logistics and supply chain decisions.
5. Presenting analytical findings and converting data insights into management actions.
6. General case study: Developing an end-to-end Business Intelligence solution combining procurement spend, supplier performance, inventory levels, warehouse operations and logistics delivery data.
1. Customized Training: All our courses can be tailored to meet the specific needs of participants.
2. Language Proficiency: Participants should have a good command of the English language.
3. Comprehensive Learning: Our training includes well-structured presentations, practical exercises, web-based tutorials, and collaborative group work. Our facilitators are seasoned experts with over a decade of experience.
4. Certification: Upon successful completion of training, participants will receive a certificate from Foscore Development Center (FDC-K).
5. Training Locations: Training sessions are conducted at Foscore Development Center (FDC-K) centers. We also offer options for in-house and online training, customized to the client's schedule.
6. Flexible Duration: Course durations are adaptable, and content can be adjusted to fit the required number of days.
7. Onsite Training Inclusions: The course fee for onsite training covers facilitation, training materials, two coffee breaks, a buffet lunch, and a Certificate of Successful Completion. Participants are responsible for their travel expenses, airport transfers, visa applications, dinners, health/accident insurance, and personal expenses.
8. Additional Services: Accommodation, pickup services, flight booking, and visa processing arrangements are available upon request at discounted rates.
9. Equipment: Tablets and laptops can be provided to participants at an additional cost.
10. Post-Training Support: We offer one year of free consultation and coaching after the course.
11. Group Discounts: Register as a group of more than two and enjoy a discount ranging from 10% to 50%.
12. Payment Terms: Payment should be made before the commencement of the training or as mutually agreed upon, to the Foscore Development Center account. This ensures better preparation for your training.
13. Contact Us: For any inquiries, please reach out to us at training@fdc-k.org or call us at +254712260031.
14. Website: Visit our website at www.fdc-k.org for more information.