SQL
1 post4 projects
- US Emissions Analysis Dashboard using DatabricksImplemented SQL queries to create the US Emissions Analysis dashboard in DatabricksProject
- How to import data into PostgreSQL?Practical guide to importing CSV files and external data into PostgreSQL using psql, COPY command, and pgAdmin.Post
- Danny's Diner SQL Case StudyAnalyzed customer behavior and sales for a Japanese diner using PostgreSQL. Tackled real-world questions with CTEs and subqueries. Revealed purchase patterns and visit frequency.Project
- Clique Bait SQL Case StudyUsed SQL to evaluate ad performance and user behavior for an online seafood store. Found a 23% lift in purchases from ad engagement. Identified top campaigns and provided optimization strategies.Project
- Walmart Sales Analysis using SQLExplored Walmart transaction data to uncover sales trends, top products, and customer segments. Highlighted category performance and optimization areas. Used SQL CTEs for efficient querying.Project
Often used with