Real Time SQL Project | SQL Project from Start to End | SQL for Data Analysis #sql #dataanalysis

#sql #dataanalysis #powerbi

Real Time SQL Project | SQL Project from Start to End | SQL for Data Analysis

In this video, we walk through a real-time SQL project from start to finish, covering essential SQL queries, data analysis techniques, and database management. Whether you're a beginner or an experienced analyst, this project will help you understand how to work with real-world datasets using SQL.

We will cover key concepts like data extraction, transformation, aggregation, and reporting, making it a perfect hands-on learning experience.

This project is applicable across various databases, including MySQL, PostgreSQL, MS SQL Server, and Oracle.

📌Content:
Intro 00:00
Business Requirement 02:51
Raw Data Walkthrough 11:21
Creating New Database 20:00
Importing Data in DB 21:35
Data Processing 28:24
Data Cleaning using SQL 31:26
SQL Query for KPI's 37:49
Sales & Other metrics by Fat Content Query 54:58
Sales by Item Type 01:02:46
Fat Content by Outlet Type 01:06:34
Sales by Outlet Establishment 01:11:40
Percentage of Sales & Total Sales by Outlet Size 01:15:07
By Outlet Location 01:19:41
All Metrics by Outlet Type 01:22:35
Outro :01:24:10

Checkout my other videos on dashboards design in Tableau, Power BI and Excel below-

=

➖➖➖➖➖➖➖➖➖➖➖➖➖
WhatsApp - [phone]

Keywords:
portfolio project, sql project for data analyst, sql project, data analyst project, data analysis project, data analyst portfolio project ,project for data analyst, data analysis sql project, data analyst projects for beginners, data project, data analysis projects for beginners, sql for beginners, projects for data analysts, power bi project start to end, sql for data analysis, how to copy project from github, data tutorials, power bi, sql, my sql, tableau, power bi project,
excel tutorial,excel,excel tutorial for beginners,microsoft excel tutorial,advanced excel,excel tutorials,ms excel tutorial,microsoft excel,excel for data analysts,how to use excel,basic excel tutorial,complete excel course,excel formulas,excel latest version tutorial,advanced excel full course,advanced excel functions,advanced excel tutorial,complete ms excel tutorial for beginners,complete microsoft excel tutorial,excel formulas and functions, power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project

[prisadeb]

Wow, I just followed your steps to complete an assignment. I must say you are a genius. I started since yesterday, pausing and I only go a few errors which was fixed in a short time, Thank you so much. more grace!!!

[pallavitsaxena]

Thank you so much sir for this video. after watching this video i am really feeling confident. you beautifully explained why we are using this logic and why not. Also you precisely taught the business requirement. Thanks a lot 👍👍

[mohamedasiq]

Overall slogan for your YouTube content that is
DON'T JUDGE A BOOK BY IT'S COVER ❤

[atulshinde]

Wow sir, very nice project ..its so much affirmative....

[RajanSowri]

thank you so much. you may have to do a separate video for sub query issues.

[dgopalsuri]

after so many research I found what I wanted 🙂

[NaveenreddyKasireddy]

Excellent bro. thanks for sharing wonderful project. Please do more .

[invincible]

Please make a project on Recruitment Data Analysis

[anushaanu-ibzi]

Can you create more SQL videos that demonstrate how SQL is used in real-world data analytics projects, like the ones companies work on?

[akhilathangellapally]

Thnak you for such wonderful project.Can you please do a project using plsql and Apex sir.

[shahzan]

just a little correction, for KPI Q3. Number of Items: The total count of different items sold.
here is the actual query : select count(distinct Item_Identifier) from blinkit_data

[rishabhchauhan]

-- 3 Fat Content by Outlet for Total Sales

SELECT Outlet_Location_Type,
ROUND(SUM(CASE WHEN item_fat_content = 'Low Fat' THEN Total_Sales END), 2) AS Low_Fat,
ROUND(SUM(CASE WHEN item_fat_content = 'Regular' THEN Total_Sales END), 2) AS Regular
FROM blinkitgrocerydata
GROUP BY Outlet_Location_Type

MYSQL query for Q3

[rsru]

Sir is this project related to blinkit part 1 power bi project or is this completely different

[priyaanbalagan]

Can you do sql project on this financial fraud detection?plz

[explorewithpk]

fat content by outlet type
another simple approach to solve this question without any nested queries and pivot function




SELECT
outlet_location_type,
ROUND(SUM(CASE
WHEN item_fat_content = 'Regular' THEN total_sales
ELSE 0
END), 2) AS Regular,
ROUND(SUM(CASE
WHEN item_fat_content = 'Low Fat' THEN total_sales
ELSE 0
END), 2) AS Low_Fat
FROM sales_data
GROUP BY outlet_location_type;

[GovardhanreddyMadireddy-th]

No of employees working in each location add one more row

[shreyanayak]

Sir please ek video csv upload karne ka daaliye MySQL par, it's not working on MySQL

[healthinsurance]

All data is not loading in MySql, it truncate Item Weight at row 1, 1265

[shahzan]

alternate solution for those who facing difficulties to understand Pivot,
i used CaseWhen instead of Pivot

Topic : Granular Requirements
Q- 3. Fat Content by Outlet for Total Sales:

select Outlet_Location_Type,
round(sum(case when Item_Fat_Content = 'Regular' then total_sales end), 2) as Regular,
round(sum(case when Item_Fat_Content = 'Low Fat' then total_sales end), 2) as Low_fat
from blinkit_data
group by Outlet_Location_Type
order by Outlet_Location_Type asc

[explorewithpk]

outlet size by sales percentage another approach here we can solve without any window functions

SELECT
outlet_size,
CONCAT(
ROUND(SUM(total_sales) * 100.0 / (SELECT SUM(total_sales) FROM sales_data), 2),
' %'
) AS sales_percentage
FROM sales_data
GROUP BY outlet_size
ORDER BY SUM(total_sales) DESC;