Perform fast and efficient data analysis with the power of SQL

A Quick, Interactive Approach to Learning Analytics with SQL

Optimize Laravel queries using SQL JSON aggregation - reduce multiple relation queries to a single SQL statement

MongoDB CRUD and Aggregation Pipeline Challenges

SQL projects using the different functions from basic to advance

This project uses Terraform to deploy a BigQuery Data Clean Room on Google Cloud

Reduce multi-relation Doctrine queries to a single SQL statement using JSON aggregation. Solves Doctrine's N+1 problem.

In this repository, I've added all the classes regarding Pandas that I've covered at SMIT

120 years of Olympic history: athletes and results from basic biodata on athletes and medal results from Athens 1896 to Rio 2016.

Personal R Programming Project

SQL Case Studies solved using Microsoft SQL Server and PostreSQL

Curated SQL problems and solutions for interview prep.

Data Modeling, Data Warehouses, Snowflake, DBT, BI, SQL, Aggregate Functions.

Creating Report for decision making in Film Rental Store

BOM(Bill of Materials) Business Analyst Case Study Solution using Python, Pandas manipulation and Visualization Technique

I have started a new playlist called MySQL on my YouTube channel. Watch the videos to learn SQL from scratch.

Analysis of past years' IPL data with help of complex SQL queries, visualized the outcome in tableau and drawn meaningful conclusions on the outcome

Structured practice and projects to master SQL from basics to advanced.

Capstone Project: Analyzing the Instacart dataset (Microsoft SQL) with a 10-minute live video presentation on YouTube

objective of this project is to explore and visualize India's CPI inflation data using Excel. The project includes data preprocessing, visualizations, and key insights into inflation trends by category (food, fuel, clothing, etc.), helping to understand how inflation affects various sectors and demographics in India.

Exploratory Analysis of the Indian Census data using SQL

State machine example

50 sql tasks w/ description and solution (mysql, select, joins, subqueries, aggregate functions, sorting and grouping, advanced select and joins, advanced string functions)

This repository is managed by LeetPush extension: https://github.com/LeetPushExtension/LeetPush

Master Detail CRUD using ASP.NET CORE MVC and EF CORE (Stored Procedure) and use of Aggregate Functions. Data Types: Text, number, boolean, image, date, relational data.

End-to-End Data Cleaning and Preparation on a raw FIFA players dataset using PostgreSQL and pgAdmin 4.

SQL project to analyze global debt stats. collected by the World Bank.

This project includes data modeling, engineering and analysis of employee data. Demonstrates use of SQL, creating schemas, queries, joins, aggregate functions, primary keys, and foreign keys.

Display multiple group summaries within a group footer cell.

This repository contains a collection of interactive Power BI and EXCEL dashboards, offering insights across various datasets. Key dashboards include career data analysis, store product pricing, NIA case trends, and Uber ride data analysis. They provide valuable visualizations for decision-making.