EventBrite Headers (15).jpg

Sharpen your data skills with these
DIY Data Projects

Use the information below to create your own portfolio of data analytics projects to show future employers. Here is how it works so PLEASE READ CAREFULLY:

1.  Download Power BI to your computer (all project dashboards must be completed in Power BI). 

  • Windows: download PowerBI at this link

  • Mac: download Parallels at this link. Then, within Parallels, download PowerBI at this link.

2.  Watch this tutorial to learn how to create dashboards in Power BI.

3.  Choose one of the data projects below. 

 

4.  Watch this quick tutorial on presenting a Power BI dashboard.

 

 

 

 

 

 

 

 

5.  Start your projects and create your own dashboard to share with prospective employers. 

 

DATA PROJECTS

Beginner Level

African American Business Data Analyst Woman Using Computer.jpg

01

General Assembly Courses

Our goal is to promote and administer data education for underrepresented groups in the Metro Louisville area. We want to understand the background of participants who took General Assembly courses, so please answer the following questions to determine if we are progressing towards our goal.​

  1. Which course was completed by the most participants? Which course was completed by the least number of participants?

  2. Which race/ethnicity completed the most courses? Which race/ethnicity completed the least courses?

  3. Which gender completed the most courses? Which gender completed the least courses?

  4. Which combination of race/gender (I.e. Black female, Black male. etc.) completed the most courses? Which combination of race/gender (I.e. Black female, Black male. etc.) completed the least courses?

  5. Which “highest level of education” completed the most courses? Which “highest level of education” completed the least courses?

  6. Which zip codes completed the most courses? Which zip codes completed the least courses?

  7. We want to understand as much as possible about the participants who withdrew from the courses. What can you tell us?

Data source: General Assembly Participants

Beginner Level

02

JCPS F/R Lunch - Top 10

JCPS has a free/reduced lunch program where students are able to receive meals at school either at a reduced cost or for free. Use the JCPS data to determine if there is an increase or decrease between the 2020-2021 and 2021-2022 of the number Black students who qualify for free/reduced lunch. Your findings should only include the ten elementary, middle, and high schools with the most Black students who qualify for free/reduced lunch.

Data source: JCPS Free Reduced Lunch

AI (Artificial Intelligence) concept. Deep learning. GUI (Graphical User Interface)..jpg

One thing to note when starting the intermediate projects is that there is not much guidance provided as compared to the beginner projects. This is because when you are tasked with data projects in the real world, you will be provided with less information so that you as the data analyst can ask the right questions and form the right hypotheses that will frame your visualizations. Use your own creativity in asking questions and  forming hypotheses to guide you in creating dashboards that support answers to the following intermediate questions.

Intermediate Level

Portrait of smiling afro-american office worker in offfice holding her arms up.jpg

03

General Assembly Success

Which General Assembly courses were most successful? To begin, you will need to think about how you will define success. Choose two measures of success to determine how you will define success in efforts of answering the question:

  1. The most courses completed

  2. The most courses completed by particular demographics

  3. Engagement/Interest - how many people were interested in taking tech courses in the Louisville Metro area?

  4. Something else you think is an important measure of success

 

Data source: General Assembly Participants

Intermediate Level

04

General Assembly Participant Progression

What significant findings can we gather from the participants at each stage (start-point, midpoint, and end point) of the General Assembly courses?

Data source: General Assembly Participants

Young african man working with analitycs sitting at the beautiful working place with compu

Intermediate Level

A man pointing at his laptop screen

05

JCPS Free/Reduced Lunch Overall

What is the current state of free and reduced lunch by race, for elementary, middle, and high schools?

Data source: JCPS Free Reduced Lunch

Intermediate Level

06

JCPS Homeless Students

Based on student race, gender, and school location, what can be said about JCPS's homeless student population?

Data sources: JCPS Homeless Students

Happy businesswoman and african man dancing in motion isolated on white studio background.