{"repo":"dndn15/MySQL-Python-Data-Analytics-Mini-Project","free":true,"listed":false,"github":"https://github.com/dndn15/MySQL-Python-Data-Analytics-Mini-Project","clone":"git clone https://github.com/dndn15/MySQL-Python-Data-Analytics-Mini-Project.git","description":"MySQL Python Data Analytics Mini-Project - Database Normalization & Business Intelligence Dashboard","language":"Jupyter Notebook","stars":14,"topics":["business-intelligence","data-analytics-project","database-normalization","mysql","python"],"license":null,"category":"databases-storage","readme_excerpt":"MySQL Python Data Analytics Mini-Project Author: ShuhanYang Project Type: Database Normalization & Business Intelligence Dashboard Project Overview This project demonstrates comprehensive data analytics skills through database normalization and business intelligence visualization. Using a retail store dataset, the project transforms raw transactional data into a normalized database structure and creates insightful visualizations for business decision-making. Key Objectives - Database Normalization : Transform denormalized retail data into a proper relational database structure - Data Optimization : Achieve significant storage reduction through normalization - Business Intelligence : Create meaningful visualizations for strategic business insights - Performance Analysis : Implement efficient database design with proper indexing and foreign key relationships Dataset Description The project uses a comprehensive retail store dataset containing: - Order Information : Order IDs, dates, shipping details - Customer Data : Customer demographics and segmentation - Product Details : Categories, subcategories, product specifications - Geographic Data : Regional distribution across US states and cities - Financial Metrics : Sales, profit, discount, and quantity data Database Schema Original Structure - Raw Data: Single denormalized table with 21 attributes - Data Points: 209,874 total data points Normalized Structure The database is normalized into 5 optimized tables: 1. customers - Custo","default_branch":null,"files":null,"tree":[],"storefront":"/r/dndn15","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/dndn15/MySQL-Python-Data-Analytics-Mini-Project/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}