Analyze Data in a Model Car Database with MySQL Workbench
By External Provider
About this course
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
What you will learn
- Explore products currently in inventory
- Determine important factors that may influence inventory reorganization/reduction
- Provide analytic insights and data-driven recommendations