SQL For Business Intelligence | YoY, QoQ, MTD, YTD, QTD etc. in a Single SQL

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.com/file/d/1oQTY...
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

[@ankitbansal6]

Please do like the videos to increase its reach . Thank you in advance 🙏

[@Shortbrainsofficial]

Please share these queries script in a document for download🙏

[@umesh6600]

it's same fiscal year

[@chiranjib-konwar]

Ankit sir, please share the advanced SQL course link to buy. Hindi English both are fine

[@ankitbansal6]

@chiranjib-konwar www.namastesql.com/course-detail/think-sql-go-from-zero-to-hero-english

[@anandmahajan943]

@ankitbansal6 can u share whole query of time frame table please

[@sravyasrinivas]

Ankit, Really you are the god of SQL. Please keep helping people like us 🙏

[@Ashu23200]

agreed!!! god of sql

[@dfkgjdflkg]

never thought it was possible, once I saw the title of your video I was convinced it is possible. Keep up the great work

[@subhajitdey6806]

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 !

[@srinubathina7191]

wow superb never thought that it was possible
Thank you Ankit Bro

[@theraizadatalks14]

One word, tooooo good. How to handle all scenarios, you beautifully explained. Thanks

[@ankitbansal6]

Glad you liked it

[@srinubathina4495]

Your sql videos are fantastic. Its really helped improve my skills keep up the great work sir thanknyou so much❤❤

[@mohitsanskar1688]

sir, you are true champion.

[@sparshkapoor8517]

Simply Awesome!!

[@bankimdas9517]

Thank you sir for making this video

[@addhyasumitra90]

this video is top notch !! awesome work

[@ankitbansal6]

Cheers 🥂

[@akashjha7277]

Superb❤

[@rishabhjain133]

How awesome is that, thanks for the video.😀

[@ankitbansal6]

Thanks for watching!

[@Gaurav-wy2wm]

Hi Ankit
Please try to create videos on data modelling for any product

[@Gareeb_]

Thanks 😊🙏

[@Gareeb_]

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

[@HariKrishna-uy5bc]

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!!

[@gayatri7536]

This is really good video 👍

[@ankitbansal6]

Glad you think so!

[@santoshkiran5858]

Awesome 😎

[@ankitbansal6]

Thank you! Cheers!

[@adharshsunny5154]

When to start AWS training

[@Pirate_Hunter_Zoro11x]

My SQL GOD🙏

[@ankitbansal6]

🙏

[@ankitachougule4711]

Awesome video. I am new subscriber to your channel. Could you please share the link for datasets used in your video and also queries.

[@ankitbansal6]

In the description

[@shashank2004]

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?

[@ankitbansal6]

Learn python

[@pateldh23]

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

[@ankitbansal6]

description box

[@gazart8557]

Please show what commands can be used in AWS redshift and postgres ❤

[@ankitbansal6]

The same will work in redshift. For Postgres just some date functions changes

[@gazart8557]

@ankitbansal6 thank you sir 🙏

[@pateldh23]

Sir, please share query files please

[@gazart8557]

Csn we use this in postgresql?

[@ankitbansal6]

Absolutely 💯

[@user-jf8fd3gy9w]

Is calendar year table will refreshing automatically as per the time frame ? So we dont need hardcode anything

[@ankitbansal6]

Exactly

[@avneet_webdeveloperdepartm4182]

Hello sir please share the query so that we can practice

[@ankitbansal6]

in the description

[@MITHUNKUMAR-nx8rd]

Where is create and insert statement for practice?

[@ankitbansal6]

description box

[@chiranjib-konwar]

I want to buy course in advanced SQL. Please share the link to buy the advanced sql course.
Thanks 🙏

[@ankitbansal6]

www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354

[@g-ij9km]

where is the insert statement?

[@ankitbansal6]

check description