This is a guide to all my data analysis and visualisation projects- SQL, Python and R.
You can connect with me on my LinkedIn profile.
Level: Intermediate
| Project Name | Description |
|---|---|
| 🍝 Danny's Diner- 8 Week SQL Challenge | I analyse the spending habits, visiting patterns and best-selling menu items for a diner and the benefits to expanding their loyalty program. |
| 🍕 Pizza Runner- 8 Week SQL Challenge | I analyse the pick-up and delivery times for "runners" who deliver pizza to customers, the number of successful deliveries, menu preferences and customer ratings. |
| 🥑 Foodie-Fi- 8 Week SQL Challenge | Analysing subscription sign-up and churn rates for a "Netflix for food recipes" streaming service |
Level: Advanced
| Project Name | Area | Description | Packages |
|---|---|---|---|
| 📢 Political Ads on Facebook | Data ingestion, cleaning, wrangling and visualisation | I combined data from the Meta Ad Library API and the Australian Electoral Commission to study expenditure 27,000+ political social media ads by electorate, party and candidate | dplyr, RAdLibrary, ggplot2 |
Also check out my ggplot projects under Data Visualisation!
| Project Name | Area | Description | Libraries |
|---|---|---|---|
| 📰 Scraping news headlines | Data Wrangling & EDA | I scraped news headlines from the Times of India that contained mentions of the two leading Prime Ministerial candidates two test for party-wise reporting bias. | BeautifulSoup, Pandas |
| Project Name | Software/program | Description |
|---|---|---|
| 🎓 The Oxbridge Gender Pay Gap | R (ggplot) | I look at the proportion of men and women who make up the lowest and highest salary quartiles at Cambridge and Oxford. Unsurprisibgly, women are overepresented in the lowest quartile, while men dominate the top quartile |
| 📺 Most popular Netflix Shows | R (ggplot) | I analyse how long various shows trended in the top 10 across different countries. Spoiler: Squid Game emerged as the undisputed winner🪆 |