SugarDashBoard is a professional, interactive web-based dashboard designed to analyze and visualize the sales, distribution, and cultural heritage of Italian desserts (dolci).
This project was developed as a case study in Generative AI and Prompt Engineering, specifically exploring how advanced LLMs (Claude 4.5 Opus and Gemini 3.0 Pro) can be utilized to accelerate frontend development and data visualization workflows.
The dashboard combines quantitative business intelligence with qualitative cultural storytelling:
-
📊 Analytic Dashboard:
- KPI Tracking: Real-time monitoring of total sales, revenue, and order volumes.
- Sales Trends: Interactive charts showing monthly revenue trends across the entire fiscal year.
- Product Performance: Ranked lists of best-selling desserts with regional color-coding for immediate recognition (e.g., Red for Sicily, Blue for Veneto).
- Ingredient Analysis: Distribution of most frequently used ingredients in production.
-
🗺️ Interactive Cartography:
- A fully interactive map of Italy (powered by Leaflet.js) displaying the geographic origin of each dessert.
- Proportional markers indicate the density of dessert varieties per region.
-
🖼️ Regional Showcase ("Vetrina"):
- A visual gallery celebrating Italian culinary biodiversity.
- Detailed cards for regional specialties (e.g., Cannolo, Tiramisù, Panettone) with high-quality generative imagery.
The project adheres to a clean, standard-based architecture without heavy frontend frameworks:
- Core: HTML5, CSS3, JavaScript (ES6+)
- Visualization: Chart.js for analytics.
- Mapping: Leaflet.js for geographic data.
- Icons: FontAwesome.
- Fonts: Google Fonts (Inter, Roboto).
The development process followed an iterative prompt engineering approach, documented in prompts progetto.txt. The goal was to refine the dashboard through successive iterations:
- Structure Definition: Establishing the grid layout and entity-relationship schema.
- Geographic Implementation: Integrating map visualizations for regional analysis.
- Refinement: Improving map accuracy using external vector libraries.
- Temporal Extension: Expanding analytics from 6 months to a full year.
- Stylistic Polish: Applying chromatic categorization (regional color coding) to charts.
The project compares outputs between:
- Anthropic Claude 4.5 Opus: Used for the primary development and logic.
- Google Gemini 3.0 Pro: Used for comparative analysis (outputs available in
confronto*.htmlfiles).
SugarDashBoard/
├── index.html # Main dashboard entry point (Final Version)
├── css/ # Stylesheets
├── js/ # Application logic and data
│ ├── data.js # JSON-like data structures for desserts/sales
│ └── main.js # Chart initialization and UI logic
├── images/ # Dessert assets (partially AI-generated)
├── confronto[1-4].html # Intermediate/Comparative outputs from Gemini
├── prompts progetto.txt # Log of prompts used for generation
├── Data_Science_Generative.pdf # Full project report
└── README.md # Project documentation
Since this is a static web application, no build process is required.
- Clone the repository or download the source code.
- Open
index.htmlin any modern web browser.
This project is released for educational and academic purposes.
