Overview
SQL is one of my core tools for data analysis and data preparation. I use SQL to query structured datasets, combine multiple tables, and transform raw data into analysis-ready formats.
Most of my SQL work is done using Google BigQuery, where I work with large datasets and apply analytical queries to extract meaningful insights.
Skills demonstrated
- Writing SELECT queries
- Filtering and sorting data
- JOIN operations
- Aggregations (GROUP BY)
- Subqueries
- Data transformation
- Preparing datasets for visualization and modeling
Sample projects
Project: Sales Data Exploration (BigQuery)
Goal: Analyze transaction data to identify sales trends and top products.
Tools: SQL (BigQuery)
Key tasks:
- Joined transaction and product tables
- Aggregated monthly sales
- Identified top-selling categories
Outcome: Produced summary tables for reporting and visualization.
Project: Customer Insights Query Project
Goal: Use SQL queries to segment customers based on purchasing behavior.
Tools: SQL (BigQuery)
Outcome: Created grouped customer segments for analysis.