SQL Portfolio Project | Data Analytics | Danny's Diner SQL Challenge

Here's the consolidated video that comprises of all solved questions in Danny's Diner SQL Case Study # 1. The questions discussed here help you understand the concepts of Aggregate functions, windows functions, basic SQL syntax and CTEs. Dive deep into the world of Data Analytics by learning SQL with ‪@TurnToData‬
Table creation and insert statements are provided here:
embed.db-fiddl...
🎤🎤 Mic I use for recording videos: amzn.to/3HcF6cb
📚📚 Book Recommendation:
Learn Storytelling with Data: amzn.to/3vv8Xdg
Timecodes:
0:00 - Intro
4:40 - Question No. 1
10:36 - Question No. 2
14:45 - Question No. 3
23:52 - Question No. 4
29:42 - Question No. 5
36:42 - Question No. 6
44:03 - Question No. 7
46:08 - Question No. 8
50:32 - Question No. 9
58:18 - Question No. 10
01:07:41 - Bonus Question No. 1
01:12:21 - Bonus Question No. 2
Checkout the Videos page to explore other videos that you may find interesting!
💜💜 Spread some love by Subscribing to the channel. Hit the 👍Like button if you enjoyed this video! 💜💜
I would really appreciate your feedback. Please let me know your thoughts via comments.
🌱 "Never cease to Learn & Grow!" 🌱
#sql #dannydiner #sqlcasestudy #dataanalyst #dataanalytics #windowfunctions #aggregate #commontableexpression #turntodata

[@karunakaranr2473]

Thanks for your time and effort. Awesome explanation.

[@TurnToData]

Appreciate your feedback. Glad it was helpful!

[@Userm2040]

Full Projects are always helpful. Thank you so much for this Full Project.

[@TurnToData]

You are most welcome! Stay tuned for more such projects.

[@slrahman8723]

Highly appreciated ..expecting to upload more videos regarding real life projects.

[@TurnToData]

Thanks, glad you enjoyed the video :)

[@PriyaSathya-ng3bi]

I am thankful for your time and effort ,it was very useful .Looking forward for more such SQL Projects .

[@TurnToData]

I'm glad you liked it. Stay tuned for more such projects!

[@pradeeppapireddy]

Thank you Anna , you are really so kind to share such quality information

[@TurnToData]

Thanks. Glad to know you liked it. More videos coming out soon.

[@ganakc1837]

Great work, keep them coming 👏👏

[@TurnToData]

Thanks, Gana! Glad you liked it :)

[@user-ex5oj4fb9g]

Thanks for the video👏, waiting for next project, Good work

[@TurnToData]

You are welcome! Glad you liked the video. More projects coming very shortly. Please subscribe and hit the bell icon to stay updated!

[@BHARATHEEYUDU.]

Great job 👍

[@TurnToData]

Thank you! Cheers!

[@koa1663]

How do you document your findings for the portfolio? What format is the information presented in?

[@TurnToData]

It's a good question. Thoroughly describe the goals of your project (in this case, it is to analyze the data from a fictional diner to help the owner, Danny, understand his customers' behaviors and preferences.), the SQL queries you executed, and the insights you derived (these are the results of each query). This documentation demonstrates your analytical thinking and ability to communicate effectively. From next video onwards, I will also showcase how you can document your findings. This information can be presented in any form you wish, but a PDF is highly recommended. Just upload your SQL queries onto your github repository as that will be the best source of your portfolio.

[@VickyShrivastav-oi4pm]

good explanation

[@TurnToData]

Thanks. I'm glad you enjoyed the video!

[@vicky1840]

I hope u can bring more project like this ❤​@@TurnToData

[@TurnToData]

Definitely. More SQL Projects will be uploaded in the coming days 👍

[@romikonlinepotapenko3475]

I think you made a mistake in the 10th question. You don't need to check if product_name = 'sushi', you just need to check for all products if they were purchased within the first week to get twice as many points, and in all other cases get regular number of points.

[@TurnToData]

Thanks for your response. The question says "not just sushi". Hence, while you assign points to products purchased in 1st week, you will need to continue to consider points for sushi products as in the previous questions.

[@srikantha2884]

Hi Sir, I need SQL training for Azure Data engineering. Any possibility to provide 1:1 training. I will pay accordingly. Please reply 🙏.

[@TurnToData]

Hi, appreciate your request, but I'm presently unavailable for a 1:1 training. I would recommend taking a 1:1 training through an established training center near you (or online) as you are interested in a particular domain.

[@lenkaladivya5707]

Where r u from ,,,

[@srikantha2884]

@@lenkaladivya5707 :: Vijayawada

[@soheilpalermo491]

thanks

[@TurnToData]

Glad you liked it!