Data Analytics Project
Demonstrating data-driven decision-making
It's time to demonstrate your new knowledge by applying it to a real-world scenario. Specifically, you want to demonstrate a data-driven decision-making process by applying spreadsheet and SQL skills. This is an individual project, but you can help each other out.
Learning Objectives
Demonstrate skills in filtering and sorting data using SQL
Demonstrate skills in creating well-formatted spreadsheet charts
Compose a short report applying a data-driven decision-making process
Resources
SQL Lab for Ready-to-Go Data: https://sql.launchboard.app/
Instructions
1. Research the Problem Domain
Determine a domain you are interested investigating. (e.g. movies, sports stats, health data, financial data, etc.)
Define a scenario for your project that includes decisions — or questions that need answered. For example, an upstart movie production firm wants to investigate what genre of movies they should focus on, and they may use recent data on movies, including budget, sales, genre, location, etc. Formulate at least two well-defined questions.
Identify potential data sources You can use thoughtful internet searches or use platforms like Kaggle to look for data. You may also find organizations that post data on specific topics.
2. Process the Data
Filter, sort, and clean the data as needed with SQL and spreadsheets The process you use will be unique to your project, but you will need to do drill down to the data you want to look at related to your questions.
3. Chart the Data and Tell the Story
Create at least two charts that visually help answer your project questions. Ensure that you format and label them well. They should be easy to view and provide a concise representation of the data.
Compose a short report that explains the purpose and analysis of your project. Follow this basic outline. One to two pages should be sufficient.
Title
Introduction to the project background
Data sources
Charts with an explanation of each
Conclusions
Example Layout
Last updated