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



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