Global Retail Analytics with AI: Prophecy Hackathon Runner-Up | Iftikar Alam

🥈 Runner-Up Submission | Prophecy Spring 2026 Hackathon Discover how to build a complete end-to-end retail analytics project using Prophecy's AI agent. In this hackathon demo, Iftikar Alam analyzes the Global Electronics Retailer dataset to uncover actionable business insights across customer demand, operations, and store strategy. What's covered: - 🔍 Exploratory data analysis (EDA) with auto-generated ER diagrams and star schema visualization - 🔧 AI-generated data pipeline for cleaning, joins, currency conversion, and feature engineering (delivery days, store efficiency, customer segmentation by generation) - 📊 3 production-ready dashboards built entirely by Prophecy's AI agent: - Customer Demand Insights – who buys what, by region and generation - Operations Performance – store efficiency vs. profit, supply chain health by region - Store Location Strategy – where to open, close, or resize stores based on profit and traffic Whether you're a data analyst, business intelligence professional, or exploring AI-powered data tools, this video shows how Prophecy turns a raw dataset into visual and decision-ready analytics. 🤝 Connect with Iftikar Alam on LinkedIn: https://www.linkedin.com/in/iftikaralam/ 🔗 Learn more about Prophecy: https://www.prophecy.ai?utm_source=youtube&utm_content=global_retail_analytics 📌 Join the Prophecy Community: https://community.prophecy.ai/ Timestamps 0:00 – Introduction & dataset overview 0:35 – Building the project with Prophecy's AI agent 0:41 – Exploratory data analysis 1:00 – Data pipeline overview 1:18 – Customer segmentation & enriched sales table 1:30 – Dashboard 1: Customer Demand Insights 2:23 – Dashboard 2: Operations Performance & Supply Chain Health 3:14 – Dashboard 3: Store Location Strategy 4:26 - Summary: the 3-dashboard framework for data-driven decisions 4:44 – Wrap-up