SQL For Business Intelligence | YoY, QoQ, MTD, YTD, QTD etc. in a Single SQL
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- In this video we will learn how we can leverage SQL for Business Intelligence and build metrics like month to date, quarter to date, year of year comparisons etc using a single SQL statement. This video shows you the real power of SQL. We will use the calendar table which I created in this video:
• Building Calendar Dime...
dataset and queries : drive.google.c...
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #dataengineer
Please do like the videos to increase its reach . Thank you in advance 🙏
Please share these queries script in a document for download🙏
it's same fiscal year
Ankit sir, please share the advanced SQL course link to buy. Hindi English both are fine
@chiranjib-konwar www.namastesql.com/course-detail/think-sql-go-from-zero-to-hero-english
@ankitbansal6 can u share whole query of time frame table please
Ankit, Really you are the god of SQL. Please keep helping people like us 🙏
agreed!!! god of sql
One word, tooooo good. How to handle all scenarios, you beautifully explained. Thanks
Glad you liked it
never thought it was possible, once I saw the title of your video I was convinced it is possible. Keep up the great work
Ankit , this is the top class things of Analystics , kindly share more videos like this where we get to know more real world problems; KPI metrices etc !
this video is top notch !! awesome work
Cheers 🥂
Hi Ankit, Thank you very much for your content. You explain in simple layman terms and understandable way. I am facing a problem in finding the difference between two dates in hours excluding the weekend hours. Can you please make a video on this.This should cover all scenarios like first date and second date on weekdays and firstdate, seconddate on weekends, firstdate on weekday and 2nd date on weekend and firstdate on weekend and second date on weekday. I hope you understood the requirement. Giving one example for this requirement. date1 = 2024-02-24 21:00:00 and date2 = 2024-02-26 04:00:00 and the difference should give 4 hours as 2024-02-24 and 2024-02-25 are weekends and hours should be considered only for 2024-02-26 which is a weekday. Solution should cover all scenarios. Thanks!!
Bhaiya only adha samajh me aaya baaki isiliye nhi aaya qki mere concept clear nhi h .
Soon I'll join your course.
But I can say it's very advanced and important for a successful data analyst
Thanks a lot
wow superb never thought that it was possible
Thank you Ankit Bro
Your sql videos are fantastic. Its really helped improve my skills keep up the great work sir thanknyou so much❤❤
sir, you are true champion.
Hi Ankit
Please try to create videos on data modelling for any product
Simply Awesome!!
Respected Ankit Sir,
Best video for learning new things,
Sir will you please share query I write query but i forgot what is the next step. And my concern is that i want to calculate for financial year which is starting from 1st April and ends on 31st march so please sir help me. First quarter is April to June then second then third and final last is january to march.
Sir, I am poor in my english communication skills but trying my best for learning new things so please help me
description box
How awesome is that, thanks for the video.😀
Thanks for watching!
Thank you sir for making this video
My SQL GOD🙏
🙏
Superb❤
Thanks 😊🙏
This is really good video 👍
Glad you think so!
Csn we use this in postgresql?
Absolutely 💯
Is calendar year table will refreshing automatically as per the time frame ? So we dont need hardcode anything
Exactly
Awesome video sir...i have 9 yrs exp in Oracle database developer so to boost the profile which other tool or technology should be learn?
Or sq/ plsql is enough?
Learn python
Please show what commands can be used in AWS redshift and postgres ❤
The same will work in redshift. For Postgres just some date functions changes
@ankitbansal6 thank you sir 🙏
Awesome 😎
Thank you! Cheers!
Awesome video. I am new subscriber to your channel. Could you please share the link for datasets used in your video and also queries.
In the description
I want to buy course in advanced SQL. Please share the link to buy the advanced sql course.
Thanks 🙏
www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354
When to start AWS training
Where is create and insert statement for practice?
description box
Hello sir please share the query so that we can practice
in the description
Sir, please share query files please
where is the insert statement?
check description