ConCreTE Logo

DSG.Reta.001 DSG.Reta.001

Context

Introduction

• The retail industry is undergoing a rapid shift as companies leverage AI and data analytics to optimize store layouts, product placement, and customer experiences. • Lowe’s, a major U.S. home improvement retailer, is using AI, spatial intelligence, and digital twin simulations to redesign store layouts and align inventory with shifting customer trends.

Role

• The learner takes on the role of a Retail Data Analyst within the company’s customer experience and merchandising strategy team. • They are responsible for analyzing historical sales patterns, identifying top- and underperforming products, and recommending layout or inventory changes that could increase conversions.

Business Objectives

• The task is to use sales and inventory data to identify actionable opportunities for optimizing store layouts, stocking decisions, and product promotions. • The learner’s analytical skills and familiarity with retail data equip them to generate insights that can be integrated into digital twin simulations or AI-based recommendations.

Products

The product is an interactive dashboard and written report summarizing key product performance metrics, layout optimization opportunities, and suggested inventory adjustments.

Codebook

Store, Date, Temperature, Fuel\_Price, MarkDown1, MarkDown2, MarkDown3, MarkDown4, MarkDown5, CPI, Unemployment, IsHoliday

Dataset

rdso.DatasetLocation.None

License

Not Provided

Tags

  • CSV

Data Provenance

Within the Excel Sheet, there are 3 Tabs – Stores, Features and Sales