CCC Consulting Curriculum

Consulting application tracker

Networking

Explore

CCC Data Analysis project

What is this project?

Choose a dataset of your choice to conduct a data-driven business analysis project

Assume the role of a consultant and analyze a business trend

Present analysis through deliverables (deliverable report, dashboard, slides, whatever you want)

Why you should do this?

Pad the resume with a portfolio project

Learn in-demand and technical data analysis skills(Python, Excel, SQL, Tableau)

Receive feedback to improve analytical/presentation skills

Logistics/Timeline

Can collaborate individually or with a partner(s)

Due end of winter quarter with a presentation

What if I get stuck? What if I don’t know where to start

Message me at

sajin@ucsd.edu⁠

or dm me on slack

Google is your best friend! You can almost always find the answer on Google

This is meant to be challenging but well worth it!

Step by step

Pick a dataset from:

https://www.mavenanalytics.io/data-playground?page=4&pageSize=5⁠

Spotify Top 100

Airbnb Listings & Review

Anything here or anywhere

Create a few key business questions you want to investigate through your data analysis (Descriptive Analytics, Causal relationships, Predictive modeling) You want to tell a story with your data analysis.

What factors affect AirBnB listings in urban/rural living areas?

What is the connection between class status and survival rate on the Titanic?

How do demographic factors affect consumption behaviors in the fashion industry?

How can I predict if a customer had a positive experience with X website?

Project timeline:

Explore your data

Generate summary statistics

Explore data with visualizations(bar graphs, histograms, line graphs, scatter plots, etc)

Create a central research question(s)

Clean data

Ensure data doesn’t contain NULL values, duplicates, weird values, etc.

Click

here⁠

for an intro in Excel

Analysis you can provide

Descriptive analytics

Find the number of Spotify Artists in the top 10 and their genres?

Which types of locations are most popular for AirBnB rentals?

More advanced statistical analysis

statistics tests

regressions

predictive models

Create visualizations

Write down insights shown through data

Now that you have your analysis, create a final presentable deliverable

Tableau

Python

Excel

Powerpoint presentation [Optional]

create a 5-10 slide presentation of your findings

present this to the consulting group

Examples of final deliverables

⁠

Citi Bike Excel Analysis⁠

⁠

Running Analytics⁠

⁠

Superstore sales Tableau dashboard⁠

⁠

Global Market Tableau Dashboard⁠

⁠

COVID-19 India Python⁠

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.