I explored a sales dataset and generated various analytics and insights from customers' past purchase behavior. I used SQL to analyze sales revenue and create a customer segmentation analysis using the RFM technique.

An exploratory analysis on covid19 cases and deaths. Other interesting factors which are available in the dataset like, Stringency Index, Human Development Index, Percentage of smokers in population etc., are also explored in this analysis

SQL for Exploratory Data Analysis

Using TABLEAU to perform data visualization in different domains to show insights, trends and forecasts after doing Exploratory Data Analysis (EDA) using SQL queries.

Building a modern data warehouse with MS SQL Server, including ETL processes, data modeling, Exploratory data analysis on the database and analytics.

Exploratory Data Analysis using SQL in SQL Server Management Studio 19. Incorporated queries for KPIs Calculation (mathematical operations), sorting, data type conversions, joins and aggregations, Common Table Expressions (CTEs), Temporary Tables, Window Functions, Table Manipulation (Feature Engineering) etc.

I explored an e-commerce dataset and created a cohort retention analysis in SQL and Tableau. The dataset used for this analysis is: https://archive.ics.uci.edu/ml/datasets/Online+Retail

Modern data warehouse in SQL Server with GTFS data from Buenos Aires buses and exploratory analysis using Jupyter Notebook, built to facilitate data analysis and to provide clear insights on bus attributes

Data cleaning, transformation, standardization and exploration of data in MySQL server

A collection of SQL scripts demonstrating key analytical techniques, including trends over time, cumulative analysis, performance metrics, data segmentation, and part-to-whole analysis. Useful for data-driven insights and decision-making.

The repository contains Structured Query Language (SQL) Scripts. The Multiple SQL scripts for various projects which includes data cleaning, data pre-processing, data processing, data transformation and insights gaining through Query Language.

Contains data exploration projects related to the COVID-19 pandemic using SQL.

Learn MySQL Fundamental and create project with MySQL

An Advanced SQL Analytics Project demonstrating end-to-end data analysis using SQL — from EDA and ADA to data transformations and final business reports. Includes two analytical views summarizing Customer and Product performance with insights on revenue, trends, and growth.

Exploratory data analysis on COVID-19 dataset using SQL and T-SQL, followed by visualizations and an interactive dashboard.

🔥SQL Project🔥This project focuses on data cleaning and exploratory data analysis (EDA). The dataset was transformed using SQL queries to handle missing values, correct inconsistencies, and structure the data for analysis. Key trends and insights were explored through aggregations, filtering, and others.

🔥SQL Project🔥This project explores sales data from a U.S. national candy distributor to gain insights into top-performing product divisions, sales trends, and customer behavior. By analyzing this data, the goal is to identify opportunities to improve and optimize sales strategies

SQL EDA on SQL Server over a Medallion DW (Bronze/Silver/Gold). Six T-SQL scripts for DB, dimensions, date ranges, measures, magnitudes, and rankings. Includes vendored DW (deps/data-warehouse @ v1.0.1).

This project focuses on data exploration and analytics, including segmentation, ranking, trend analysis, and performance evaluation to uncover business insights.

In this project I perform EDA (Exploratory Data Analysis) on Covid19 dataset using T-SQL and visualize the data in a Tableau dashboard.