AI-Powered Retail & Merchandising Operations: From Sales Analysis to Order Optimization
This hands-on course teaches you how to use AI to analyze sales and inventory data and create evidence-based ordering plans.
You’ll learn how to clearly communicate your objectives, constraints, and desired outputs to AI, then apply those skills to sales analysis, demand forecasting, and multi-item order optimization.
Using the provided training data, prompts, and code, you’ll verify calculation results and test the basis for your decisions by changing the conditions.
By the end, you’ll complete an ordering plan for 30 products and a one-page decision-making report, which you can use for job preparation and to expand your practical skills.
Designing analysis requests that clearly communicate goals, constraints, deliverables, and completion criteria to AI
Break down sales changes into price, volume, and product mix, and analyze the incremental profit from promotions
Decompose sales changes into price, quantity, and product mix, and analyze the incremental profit from promotions; forecast demand by store and product, and validate forecast errors and uncertainty.
Decompose changes in sales into price, volume, and product mix, and analyze the incremental profit from promotions; forecast demand by store and product, and validate forecast errors and uncertainty; develop an ordering plan for 30 products reflecting budgets, available space, and product-specific order units.
Decompose sales changes into price, volume, and product mix, and analyze the incremental profit from promotions
Forecast demand by store and product, and validate forecast errors and uncertainty
Develop an ordering plan for 30 products that reflects budget, space, and product-specific order-unit constraints
Change demand and budget conditions to compare alternatives, and check AI analysis for errors, omissions, and assumptions
Complete the analysis project with a product-specific purchase order sheet, a constraint validation sheet, and a one-page decision report.
This is a hands-on course that uses AI to analyze sales, inventory, and ordering issues in retail and merchandising. You will make specific requests about the desired outcomes and completion criteria, then run AI-generated code to verify the calculation results and constraints. The course covers sales change analysis, promotional profitability, demand forecasting, and multi-item order optimization step by step. Using educational sample data for 30 products, you will complete an order quantity table and a one-page decision-making report, along with course notes, practice data, AI prompts, and templates.
Recommended for these people
Who is this course right for?
Those preparing for careers in distribution or merchandising (MD) who want to create a project showcasing their analytical skills
Those who want to expand their learning into AI-powered sales analysis, demand forecasting, and order optimization after learning the basics of distribution and merchandising.
Practitioners who want to explain the rationale behind product management and ordering decisions based on sales and inventory data
Those who want to learn how to accurately communicate work objectives and conditions to AI, and even verify errors in the analysis results.
Need to know before starting?
Understanding basic distribution terms such as sales, purchase costs, inventory, and purchase orders will help with learning.
You should be able to open the CSV file in Excel or a similar program and check the rows, columns, and numbers in the table.
We recommend a basic user experience of asking questions to generative AI and checking the answers.
The coding exercises require a Python execution environment. Basic experience running the provided code and modifying inputs such as the budget is recommended; this is not a course that explains Python syntax from the beginning.
Hello. I’m Kang-ho Ryu, sharing my 24 years of retail experience as practical knowledge that can be applied in the field.
Since 2002, I have gained experience in large-scale retail operations as a Category/Section Manager, assistant store manager, head of the online and strategic marketing team at headquarters, and in regional headquarters operations. I have handled retail operations from various perspectives, from working directly with products and customers in the field to developing strategies at headquarters.
■ Retail, Merchandising, and Product Planning Based on an understanding of products and customers, I handled merchandising changes, commercial area and competitor analysis, and initiatives to strengthen store competitiveness. In this course, you will learn how to establish a basis for product planning and turn your analysis into action plans and portfolios.
■ Sales and inventory management and store operations I gained experience managing key KPIs such as sales, customer count, average transaction value, inventory, and service, as well as standardizing store operations. I share a perspective on reading changes in the numbers, identifying their causes, and turning them into improvement initiatives to implement in the field.
■ Online commerce and digital marketing As the head of the online and strategic marketing team at headquarters, I gained experience in online commerce operations, CRM, targeted marketing, UI/UX improvements, and partnership marketing. I explain how to assess marketing performance from the perspectives of sales and profitability while considering both the customer purchase journey and operational conditions.
■ Project Execution and Collaboration I have worked on repeat and renewal PM, reopening marketing, customer experience (CX) improvement, and coaching for field employees and leaders. Based on my experience coordinating among headquarters, regional headquarters, stores, and partner companies, we will also cover the execution process needed to apply plans to actual work.
In the course, these experiences are complemented by data analysis and the use of AI to explain specifically how product planning, sales, inventory, store operations, and marketing are connected. The focus is on what to check, what evidence to base decisions on, and how to put them into action.
From job seekers preparing for careers in retail, merchandising, and marketing to practitioners and leaders looking to strengthen their on-the-job capabilities, we will help you explain and execute your analyses and proposals with sound reasoning.