company project · ongoing
StackLogix Analytics Demo
Full-featured jewelry retail analytics and AI demo — forecasting, inventory, marketing, purchase assistant with approval workflow, ML monitoring, and Excel-driven KPIs.
Reports & Dashboard — Sales analytics
Problem
Jewelry businesses needed a compelling demo showcasing AI forecasting, inventory intelligence, and analytics capabilities for sales and investor presentations.
Solution
Built StackLogix Dubai demo with multi-pillar analytics dashboard, ML forecasting, purchase assistant with approval workflow, Excel import/export hooks, and StackSense AI chat.
Architecture
React 18 + TypeScript + Vite + shadcn/Radix UI frontend with TanStack Query. FastAPI backend with SQLAlchemy, pandas, Groq AI, and Parquet data storage.
Business Impact
Demonstrates StackLogix product capabilities for jewelry retail analytics, forecasting, and AI-driven decision support.
Technical Decisions
- FastAPI + Parquet for performant analytics data serving
- TanStack Query for dashboard data fetching and caching
- shadcn/ui for consistent demo UI components
Feature Breakdown
Responsibilities
- Built multi-pillar analytics dashboard with forecasting and inventory modules
- Implemented purchase assistant with approval workflow UI patterns
- Developed Excel import/export hooks and ML model accuracy monitoring
- Integrated StackSense AI chat and marketing analytics views
Challenges
- Balancing demo richness with maintainable mock/real data pipelines
- Integrating ML forecasting visuals with Excel-driven KPI data sources
Performance Considerations
- Parquet columnar storage for analytics queries
- TanStack Query caching for dashboard widgets
Lessons Learned
- Demo platforms need clear separation between showcase data and production APIs
- Approval workflow UI patterns reuse well across analytics and operational modules