Analyze Data in a Model Car Database with MySQL Workbench
Key Takeaways
Analyzes data in a model car database using MySQL Workbench for inventory reduction strategies
Original Description
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 External: Coursera ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
More on: SQL Analytics
View skill →Related Reads
📰
📰
📰
📰
GBase 8a unpivot Function: Turning Columns into Rows
Dev.to · Michael
Bulut Bilişim ve Veri Bilimi: Model Eğitiminden Canlıya Uzanan Bootcamp Yolculuğu
Medium · Data Science
10 Benefits of Enterprise AI Analytics Every Organization Should Know
Dev.to · Ravi Teja
Your rolling_std Is Lying — The 21,000× Error You Can’t See
Medium · Data Science
🎓
Tutor Explanation
DeepCamp AI