Analyze Data in a Model Car Database with MySQL Workbench
In this project, you’ll perform exploratory data analysis for Mint Classics Company, a retailer of model cars. The company is looking to close one of its storage facilities. Your objective is to recommend inventory reduction strategies that won’t negatively impact customer service.
Using MySQL Workbench, you’ll familiarize yourself with the sample database, run SQL queries to identify factors affecting storage space and propose inventory reduction approaches. Upon completion, you’ll demonstrate your ability to perform exploratory data analysis and present the results in a format that supports your recommendations.
There isn’t just one right approach or solution in this scenario, which means you can create a truly unique project that helps you stand out to employers.
ROLE: Data Analyst
SKILLS: SQL
PREREQUISITES:
Run a script and use the modeling tool to view a relational model in MySQL Workbench
Access data from related tables with SQL
Watch on Coursera ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: SQL Analytics
View skill →Related AI Lessons
⚡
⚡
⚡
⚡
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup
Dev.to · Michael
5 Production Stacks for Live Data Ingestion at Scale (Without Getting Blocked)
Dev.to · Prithwish Nath
BI plus process mining for Insurance: seeing variants, bottlenecks, conformance,+B87 and recovery economics
Dev.to · Ananthapathmanabhan A
I built web analytics with no dashboard, only an MCP
Dev.to · Henrik Holen
🎓
Tutor Explanation
DeepCamp AI