Date: December 2023
This project is the outcome of a collaborative hackathon event organized by the BEST (Board of European Students of Technology). Our team participated in SAP's challenge, where we developed a dashboard web application for RetailX, an online retail store. The application uses AI to provide solutions to supply-management problems and improve cost efficiency.
Our project is designed to tackle supply management and cost efficiency issues for online retail stores like RetailX. During the hackathon, our team created an AI-powered dashboard web application that leverages advanced data analytics to provide actionable insights and recommendations.
This project uses OpenAI's GPT-3.5-turbo model to classify product descriptions into predefined categories. The code first reads data from an Excel file, processes it, and sends each product description to the AI model for classification. The classified results are then saved in both JSON and Excel formats. The snippets below show the main steps involved: loading the product data, classifying products using AI, and saving the results.
Loads product data from an Excel file and prepares it for classification using OpenAI.
Classifies products using AI and saves the results in JSON and Excel formats.
AI-Powered Insights: Uses OpenAI to analyze data and provide recommendations.
Interactive Dashboards: Built with Microsoft PowerBI for dynamic and interactive data visualization.
User-Friendly Interface: Developed using React, HTML, and CSS to ensure a seamless user experience.
Real-Time Data Processing: Utilizes Node.js for efficient data handling and real-time updates.
The dashboards provide powerful, interactive insights into product categories. The Manager’s Dashboard focuses on individual product categories like lighting, offering tools for tracking sales trends and stock levels. The CEO’s Dashboard gives a high-level overview of all product categories, with options to input custom queries and filter data by different metrics:
An interactive dashboard for managing sales and stock levels in the Lighting Products category.
A customizable dashboard providing an overview of all product categories with custom query options.