Industry Connect
  • Industry Connect
  • Team
  • Automation Lab
    • Proposed Automation Lab
  • Founding Cohort
    • Program Details
    • Program Tech Skills Schedule
    • Google Data Analytics Pacing
    • Kaggle Tutorial Pathway & Pacing
    • Weekly Sessions
      • W1 January 12 ✓
      • W2 January 19 ×
      • W3 January 26 ✓
      • W4 February 2 ✓
      • W5 February 9 ✓
      • W6 February 16 ×
      • W7 February 23 ✓
      • W8 March 1 ✓
      • W9 March 8 ✓
      • W10 March 15 ✓
      • W11 March 22 ×
      • W12 March 29 ×
      • W13 April 5 ✓
      • W14 April 12 ✓
      • W15 April 19 ✓
      • W16 April 26 ✓
      • W17 May 3 ✓
      • W18 May 10 ✓
      • W19 May 17 ✓
    • Projects
      • Data Analytics Project
      • Cobot Project
    • Reference
      • Cobot Reference
      • Files
      • Your Learning Strategy
Powered by GitBook
On this page
  • Learning Objectives
  • Resources
  • Instructions
  • 1. Research the Problem Domain
  • 2. Process the Data
  • 3. Chart the Data and Tell the Story
  • Example Layout
Export as PDF
  1. Founding Cohort
  2. Projects

Data Analytics Project

Demonstrating data-driven decision-making

PreviousProjectsNextCobot Project

Last updated 1 year ago

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

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

SQL Lab for Ready-to-Go Data:

Report Template:

https://sql.launchboard.app/
https://docs.google.com/document/d/18qyWfMSiyTQIM8daPGdSCb-1sYZv8dk6HTitKrWW0Fk/edit?usp=sharing