Data Analytics Project
Demonstrating data-driven decision-making
Last updated
Demonstrating data-driven decision-making
Last updated
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.
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
SQL Lab for Ready-to-Go Data: https://sql.launchboard.app/
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.
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.
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
