Customer Purchase Behavior (Python)
- Analyzed 100,000+ transactions using Python to find out customer purchasing trends.
- Discovered that 50% of customers are rare shoppers, which helped the business target certain marketing strategies.
- Presented the insights to help improve customer satisfaction.
Derive Insights from BigQuery Data (SQL Challenge)
- Wrote SQL queries, created and managed database tables in Cloud SQL, queried public tables, and loaded sample data into BigQuery.
- Using Google Apps Script, created a chart in Google Sheets, exported that data to Google Slides, and created reports in Google Data Studio connecting all to BigQuery data.
120 Years of Olympic History
- Scanned through 120 years of Olympic history using SQL & Python.
- Discovered the athletes who won the most medals per category.
- Uncovered the top 10 countries with the most total medals.