How dndn15/mysql-python-data-analytics-mini-project works
This project turns retail transaction data into a normalized MySQL design and business-intelligence analysis. The documented workflow covers the raw dataset, five relational tables, and visualizations that support business decisions. The notebook and SQL file are represented as implementation components, but no source excerpts were available to verify their internal calls or data handling; relationships shown here rely on README statements.
Main entry points: mini_project_store.csv Retail Dataset · miniproject.sql Normalized Schema · Miniproject.ipynb Data Analysis · README.md Business Insights
Components 7
Retail Data
- Retail Dataset
mini_project_store.csv
Data Model
- Normalized Schema
miniproject.sql - ER Diagram
Mini Porject-ER and Visualizations.docx
Business Intelligence
- Data Analysis
Miniproject.ipynb - Business Visualizations
Miniproject.ipynb - Business Insights
README.md
Other components
- Analyst
Connections 7
- Analyst → Retail Dataset: provides data
README.md - Retail Dataset → Normalized Schema: normalizes into
README.md - Normalized Schema → ER Diagram: documents relationships
README.md - Retail Dataset → Data Analysis: analyzes
README.md - Data Analysis → Business Visualizations: creates
README.md - Business Visualizations → Business Insights: supports decisions
README.md - Analyst → Business Insights: uses findings
README.md