inflearn logo

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.

6 learners are taking this course

Level Intermediate

Course period Unlimited

AI
AI
prompt engineering
prompt engineering
Python
Python
ChatGPT
ChatGPT
Business Productivity
Business Productivity
AI
AI
prompt engineering
prompt engineering
Python
Python
ChatGPT
ChatGPT
Business Productivity
Business Productivity

What you will gain after the course

  • 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
This is andrew0904

Career Verified

유통 실무 강사 류강호 소개.png.webp

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.

More

Curriculum

All

14 lectures ∙ (52min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

andrew0904's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$7.70

25%

$7.70