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.
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.
Which course was completed by the most participants? Which course was completed by the least number of participants?
Which race/ethnicity completed the most courses? Which race/ethnicity completed the least courses?
Which gender completed the most courses? Which gender completed the least courses?
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?
Which “highest level of education” completed the most courses? Which “highest level of education” completed the least courses?
Which zip codes completed the most courses? Which zip codes completed the least courses?
We want to understand as much as possible about the participants who withdrew from the courses. What can you tell us?
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.
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.
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:
The most courses completed
The most courses completed by particular demographics
Engagement/Interest - how many people were interested in taking tech courses in the Louisville Metro area?
Something else you think is an important measure of success
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?
JCPS Free/Reduced Lunch Overall
What is the current state of free and reduced lunch by race, for elementary, middle, and high schools?
JCPS Homeless Students
Based on student race, gender, and school location, what can be said about JCPS's homeless student population?
Data N Grits
FWI started the Data N Grits networking event to connect data professionals of all levels. During the event, we had a grit bar where participants could try sweet and savory grits with various toppings. Participants then filled out a survey to tell us about themselves and their grits preferences. What trends can you find in regard to who likes what grits the best?
Data source: October Data 'n Grits Survey Results
Data source: October & November Data 'n Grits Survey Results