Hi there! ππ»ββοΈ
Welcome to my Portfolio Guide where I provide a walkthrough to all of my data analytics projects and courses.
Feel free to chat with me on LinkedIn about my projects!
Click on the project's title (bold and coloured in Blue) to view my projects! Thank you!
Level: Intermediate SQL
Functions: Aggregations, Joins, CTEs, Window functions (aggregates, ranking, running total, partitioned averages), CASE WHEN statements, subqueries, nested subqueries, DATETIME functions, data type conversion, text and string manipulation
Project Name | Description | SQL Functions |
---|---|---|
π Maven Fuzzy Factory - Ongoing | I analyse and optimise marketing channels, measure and test website conversion performance and use data to understand impact of new product and campaign launches for an online retailer. | Advanced SQL |
π¬ Marketing Analytics Case Study - Ongoing | ||
πDanny's Diner | I gather and analyze customer data to determine their visiting patterns, spending habits, and favorite menu items. | |
πPizza Runner | I analyze pizza orders, runner and customer experience, and ingredient optimization. | |
π₯Foodie-Fi | I use subscription-style digital data to analyze customer journey, payments, and business performance. | |
π¦Data Bank | Using the Data Bank data, I calculate metrics and growth, and analyze data for future planning and development through linking customers' cloud data storage limits to their account balances. | |
π½Data Mart | In this project, I measure the effect of changes in June 2020 on Data Mart's sales performance, identifying the most affected platform, region, segment, and customer types, and finding ways to minimize future sustainability updates' impact on sales. | |
π£Clique Bait | To support the founder and CEO Danny's vision, I analyze the dataset for the Clique Bait online store, and develop creative solutions for calculating funnel fallout rates. | |
πFresh Segments | I analyse customer behavior and interests to help clients understand their customers. | |
π©π»ββοΈ Health Analytics Case Study | Temporary tables, Aggregations, Joins, CTEs, Window functions (summary statistics: mode, median) | |
π¦ Covid-19 and the Impact on Malaysia Stock Market | A project close to π‘ home. Inspired by Alex Freberg's Data Exploration Project, I analysed global and local Covid-19 cases & the impact on Malaysia stock market from Jan 2020 to Jul 2021 using SQL and Tableau. | |
π©π»βπΌ Streamlining Employee Data |
Skills: Data cleaning, wrangling, visualisation, analysis
Libraries: pandas, numpy, matplotlib, seaborn
Project Name | Area | Description | Libraries |
---|---|---|---|
πΊ TMDb Movie Analysis | Data Wrangling & EDA | Analysing more than 10,000 TMDb movies and getting the answers to - Which actor(s) is associated with higher revenue and profit, Does a higher budget constitute to a higher profit, and Which director produced the highest grossing movie? | pandas, matplotlib |
β½οΈ Fuel Economy | Data Wrangling & EDA | Analysis on vehiclesβ fuel economy in 2008 and 2018 to understand usage of alternative sources of fuel, changes in greenhouse gas and smog ratings over the decade, and vehicle features associated with better fuel economy. (It's more interesting than the summary sounds, I promise!) | pandas, matplotlib |
π· Wine Quality | Data Wrangling & EDA | A study on red and white wine samples and understanding whether certain types of wine and their qualities (alcohol level, sugar content and acidity level) are associated with higher wine quality. | pandas, matplotlib |
π€ Explore Weather Trends | Time-series analysis | In this time-series analysis, I use moving average method to analyze local and global temperature data and compare the temperature trends where I live to overall global temperature trends. | pandas, matplotlib |
π Super Store Analysis | EDA | Analysis of sales data to find out highest revenue and profit product categories and top customer segments. | pandas, matplotlib, seaborn |
ππ»ββοΈ Bellabeat Fitness Tracking Analysis | EDA | Discovered insights into whether users are using the FitBit app for tracking health habits, their frequency of usage across the week and whether there is correlation between the hours logged, number of steps taken and calories burnt. | pandas, matplotlib, seaborn |
Project Name | Area | Description | Libraries |
---|---|---|---|
πΆ Online Music Streaming | Machine Learning | I learn how to create and train a model called Music Recommender which suggests music genre based on user profiles. | pandas, scikit-learn |
π Exploring the NYC Airbnb Market | EDA | Exploring Airbnb datasets and conducting a pricing analysis between Airbnb and private rentals. | pandas, numpy, datetime |
π’ Generating Keywords for Google Ads | EDA | pandas, pprint | |
π Investigating Netflix Movies and Guest Stars in The Office | EDA | pandas, matplotlib |
Project Name | Description | Tableau Dashboard |
---|---|---|
π¦ Maven Unicorn Challenge | Link | |
π¦ Covid-19 and the Impact on Malaysia Stock Market | A project close to π‘ home. Inspired by Alex Freberg's Data Exploration Project, I analysed global and local Covid-19 cases & the impact on Malaysia stock market from Jan 2020 to Jul 2021 using SQL and Tableau. | Link |
I compiled a comprehensive list of free SQL resources ranging from YouTube videos, courses, interactive websites, practice sites, and projects.
Click here to view the post on LinkedIn!
After receiving several messages asking for tips on how to create a GitHub portfolio, I decided to create a step-by-step tutorial with images to teach beginners to set up their portfolio.
What you will learn in my guide:
- How to Create Your Profile?
- How to Customize Markdown files?
- How to Create New Repository?