SHIVANK SHRIVASTAVA

Consumer Goods Ad-hoc Insights using SQL

Overview:
Developed a data analysis project focusing on providing ad-hoc insights for the consumer goods industry using SQL. This project aimed to extract valuable information from large datasets and derive actionable insights to drive business decisions

Key Responsibilities:

Identified relevant data sources and collected data from various databases using SQL queries.

Designed and implemented a data schema to organize and structure the collected data.

Developed complex SQL queries to analyze large datasets and extract meaningful insights.

Utilized advanced SQL techniques such as joins, subqueries, and aggregations to perform data analysis.

Generated ad-hoc reports using My SQL Dayabase

Achievements:

Successfully analyzed and provided actionable insights on customer purchasing patterns, product performance, and market trends.

Improved decision-making processes by enabling stakeholders to make data-driven decisions based on the insights derived.

Technologies Used:

SQL (Structured Query Language)
SQL MySQL(relational databases)

Key Skills Developed:

Proficiency in SQL and database management.
Data cleaning and transformation.
Advanced SQL querying techniques.

https://github.com/Shivank18/Consumer-Goods-Ad_Hoc-Insights.git

• Skills: Data Analytics · Extract, Transform, Load (ETL) · MySQL