SQL for Data Science Capstone Project (Coursera)

You will choose a dataset and develop a project proposal. You will explore your data and perform some initial statistics you have learned through this specialization. You will uncover analytics for qualitative data and consider new metrics that make sense from the patterns that surface in your analysis. You will put all of your work together in the form of a presentation where you will tell the story of your findings. Along the way, you will receive feedback through the peer-review process. This community of fellow learners will provide additional input to help you refine your approach to data analysis with SQL and present your findings to clients and management.
What You Will Learn

​- Develop a project proposal and select your data

​- Perform descriptive statistics as part of your exploratory analysis

- Develop metrics and perform advanced techniques in SQL

- P​resent your findings and make recommendations

Course 4 of 4 in the Learn SQL Basics for Data Science Specialization.

Syllabus

WEEK 1

Project Proposal and Data Selection/Preparation

In this first milestone, you will select your client and import your dataset. You will begin to explore your data to understand it and make assumptions about your data. You will draft a project proposal to act as a guide as you explore your data and prove or disprove your hypotheses.

WEEK 2

Descriptive Stats & Understanding Your Data

In this milestone, you will start to execute your project proposal. You will start looking at your data and perform initial statistic models to explore your data and determine what you have available to you.

WEEK 3

Beyond Descriptive Stats (Dive Deeper/Go Broader)

In this milestone, you will go beyond the descriptive statistics you completed in the last milestone. This milestone is really about diving deeper to analyze your data, beyond descriptive stats. Maybe you need to analyze qualitative data or textual data to get a full picture.

WEEK 4

Presenting Your Findings (Storytelling)

In this milestone, you will present your findings. You will identify your audience and create a presentation tailored to them. You will be able to tell the story of analyses and make recommendations.