Data Analytics

Customer Segmentation Project

SQL

First, I dumped the data (sourced from Kaggle) into MySQL. I cleaned it, and did some exploratory analysis. 

You can check out the details here on my GitHub

Excel

Next, I took my clean data from MySQL into Excel (online). I did more exploratory analysis and organized some information into Pivot Tables. My recommendations from the Excel analysis were a customer tier categorization and a retargeting campaign based on the buying patterns of this list of users.

You can check out the details here on my GitHub

Tableau

See below for the first dashboard of demographic data. It's interactive!

I also created a KPI dashboard, and a Campaign Performance Dashboard, which you can look at via the link below or by going to my GitHub

Executive Summary

After I completed the project, I created a "highlight reel" with the most important details from each step of my process, the key findings, and my recommendations. 

You can see that below, or on my GitHub.

Tableau Demographic Data Dashboard

(Click me, I'm interactive!)

Executive Summary PowerPoint