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
📰
📰
📰
📰
Your Pipeline Is 25.4h Behind: Catching Defence Sentiment Leads with Pulsebit
Dev.to · Pulsebit News Sentiment API
Value to the mentees?
Reddit r/datascience
I turned a public-domain government CSV into a searchable index of every port and airport on Earth
Dev.to · ZahidRahman47
New York Imposes One-Year Moratorium on New Hyperscale Data Centers
TechRepublic
🎓
Tutor Explanation
DeepCamp AI