SQL For Data Analysis Full Portfolio Project with Explanation | End-to-End SQL Project 2024
Вставка
- Опубліковано 17 тра 2024
- Welcome to the_dataholics channel, the vernacular upskilling platform revolutionizing career development!🚀
Who doesn't love pizza? But can SQL help you analyze it? Let's find out!
In this video, we dive into a delicious SQL case study - analyzing pizza data! We'll explore a sample pizza database, write SQL queries to answer interesting questions, and unlock insights about pizza preferences.
Medium Blog Link -
/ sql-pizza-case-study-p...
Github Link (to get the dataset and queries) - github.com/akshatagrawal1998/...)
By the end of this video, you'll be equipped to tackle real-world data analysis problems using SQL. This case study is a perfect start for aspiring data/ business analysts.
Join us to master SQL and elevate your data analytics expertise!
Business Analyst Interview Question
• Ace your Business Anal...
SQL Order of Execution -
• SQL Order of Execution...
Group BY & Having vs where in SQL
• Where vs Having clause...
SQL Joins
• SQL JOINS | INNER JOIN...
SQL Joins Interview Question
• SQL Joins Vid #2
CTE vs Temp Tables in SQL -
• CTE vs Temp Tables in ...
Window Functions Explained
• Window Functions in SQ...
Don't forget to like, comment, and subscribe for more insightful content.
#sql #dataanalyst #businessanalyst #project #pizza #casestudy
GitHub Link for the project
github.com/akshatagrawal1998/SQL-Project-Pizza-Case-Study/tree/main/SQL%20Project%20Case%20Study%20(Pizza%20Sales%20Analysis)
Amazing detailed explanation for the data modelling intro
I'm glad that it helped you
Great learning!!
Glad you think so! Share with your friends who might get help from it
Concepts well explained !!
Glad you got some help. Stay tuned for more such interview questions also
Full Projects are always the most helpful learning tool. Please upload more "Full Projects". Thank you so much for this wonderful Project.
Ofcourse, next will you'll get a project wherein we'll write SQL and then their corresponding Python queries to learn Data analysis better. Share with your friends so that people may be benefited. Thanks
@thedataholics Really grateful to you for your kind reply to me. Yes, I will share with others. But I am very new in Python programming for data analysis 😀
@@Userm2040 don't worry. Learn gradually.. master SQL first and then I assure you Python will become more easy as you'll have a logic building mindset.
Best wishes to you 🙏
Also could you make some different projects like on different problem statements?
@@Shruti_Gore sure. we'll soon come with diff domain projects and using diff tools for analysis.
Amazing explanation Akshat 👌🏿👌🏿
Thanks
Amazing explained
Thanks man!
Amazing sir
Thanks Hitesh
Done with project...
Thank you so so much for project 🙌🏻🙌🏻...
Beginner level question 3 answer - in output pizza name is showing but price is not showing..only price as string is coming in the output.
Few suggestions..
(1) Don't get into excel sheets again n again to chk data column ..take a snap of 5 records from each table and keep all together at one place ..so it ll be easier for us too to recognise.
(2) First explain how to know which 2 or 3 tables should we join.. like - a bit confusion occurs why this table why not that table!!
(3) - whole explanation is a bit faster... Plz explain slowly...
Pls take my words in just positive way.. 🙌🏻
great initiative, great going..
Public demands more SQL projects ✅❤️❤️❤️
Surely! Noted as constructive feedback. Thanks
Nice sir please upload SQL basic to advanced level playlist really helpful
for sure.. you'll soon get a complete playlist. meanwhile watch joins, window functions on my channel and understand them well
sir the explanation is really good.. i liked the way you explained
thanks.. keep learning
although I am not from tech background, but i liked the way u explain concepts
Thanks..
Also could you make some different projects like on different problem statements?
Yes. Working on them. You'll get a project maybe next week in which we'll do analysis on Python and SQL both. We'll see their connection and much more.. stay tuned..
hi , got stuck at while importing pizza_types csv file , am getting the following error "unhandled exception:'CP-UTF8' codec cant decode byte 0xfd in position 1710:No mapping for the unicode character exists in the target code page . pls help me on this
Please send me a screenshot of your error at
dataacademy.training@gmail.com
I'll check surely and revert back asap.
I again imported this file but found no as such issues. You might retry it and see if the issue persists.
git hub link showing page not found .. could u plz give the data sets only .. that ll be very helpful
github.com/akshatagrawal1998/SQL-Project-Pizza-Case-Study/tree/main/SQL%20Project%20Case%20Study%20(Pizza%20Sales%20Analysis)
Try this link please
while importing pizza types file in sql server it is showing this error "Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "ingredients" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)"
please help me
I'm happy to see that you're implementing things..
So the solution is that you might need to change the datatype of the ingredients column to varchar (max) or nvarchar(100) while importing the table. The reason being it contains a lot of text which might be truncated with your current datatype.
@@thedataholics thank you for informing..I will try this
@@putulsaini6788 sure and let me know for any other doubts
@@thedataholics sure sir
After importing the dataset, how to fetch that data or table.
I have used select * from table name but nothing is happening.
Check if the import was successful and ensure you are querying on the correct database in which you have imported the data.
@@thedataholics Yeah , it's working
@@thedataholics I want ask you one more thing, how to import a database.
I need to do a bit of research on it as i have never done it..but thanks for a new question.
@@thedataholics I'm looking forward for your response.
Determine the top 3 most ordered pizza types based on revenue.(Intermediate)
with cte as ( select pt.name as pizza_name,sum(od.quantity * p.price) as revenue,
rank() over(order by pt.name desc) as rnk
from order_details od
join pizzas p on od.pizza_id=p.pizza_id
join pizza_types pt on p.pizza_type_id = pt.pizza_type_id
group by pt.name
)
select pizza_name, revenue
from cte
where rnk = 3
order by revenue desc,
sir could you correct my query, i am unable to understand where I'm doing mistake
You have to sort by quantity in the rank function. Check my solution and compare yours. Let me know in case of any other doubts.
Hi, can you help me with the solution query for the following question:-->
Q. Which are the overall top 5 most used ingredients in the preparation of pizzas?
I could not come up with any solution for this. Can we write a sql query to determine the results for the following question using pizza_types table?
Hey, that's a good question, what I can think as of now is that we can see the top 5-10 pizzas by quantity and size and then get a list of ingredients used in them. As of now in this data we don't have amount of each ingredients used, so can't go much deeper, but at least we can get a list of frequently used ingredients. Hope this helps
@@thedataholics oh okay, thanks for the help.... Just a follow up question:
We are given multiple ingredient names in a single row. While making the list of most frequently used ingredient in top 5 pizza, how can we extract and single down the ingredient by checking which one occurs most in the provided ingredient list of top 5 pizza?
I hope I am able to explain it clearly.
We can extract it in different columns, like text to column in excel.
We can achieve the same in sql. The query is a bit complicated but it's achievable
@@thedataholics thanks for the help 🙌
Can I use Bigquery?
Yes, take the data there and then write queries. The majority syntax will also be the same. Let me know in case of any doubts
@@thedataholics Yeah bro Sure , thanks for the response.
I'm facing issues in bigquery , pizza type table , all tables are updated correct format , but the pizza types table header is not considering in bigquery, and its assigns the column name as string_field_0,1,2 etc..
Kindly help me to solve this issues.
@@ridergk1557 i think you are not using the right schema. don't opt out for auto detect schema. Give your own column names like -> pizza_type_id, name, category, ingredients. I have done the same way and it worked. Let me know your feedback
@@thedataholics okay thanks bro , let me check and update you