Analyze Data in a Model Car Database with MySQL Workbench
Offered By: Coursera Project Network via Coursera
Course Description
Overview
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
Syllabus
- Project
- In this 8-10-hour project, you'll conduct entry-level data analysis at the fictional Mint Classics Company, helping to analyze data with the goal of supporting inventory-related business decisions that lead to the closure of a storage facility.
Taught by
David Dalsveen and Judy Richardson
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX