Fixed LOD Tableau vs SQL | Advanced Tableau Tutorial

In this video we will understand FIXED LOD in Tableau and how to implement the same in SQL.
Dataset Link:
docs.google.co...
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

[@uc7602]

Great explanation of using Tableau Fixed LOD. Also, including SQL query examples as a way validate Tableau calculated field results is super useful too. This extra effort provides viewers with unique and valuable information on your channel. Excellent job and thank you for sharing your knowledge and skill with us, Ankit! It is appreciated and I'm a subscriber now.

[@ankitbansal6]

Glad it was helpful! 🙂

[@stat_life]

I had this single question asked in my final practical viva for TABLEAU subject in university exam and I just watched this video 2 hrs before the exam, then the result came and i got 93 in practical, THANK YOU SIR

[@ankitbansal6]

Brilliant 😊

[@adreamer9999]

Definitely one of the better videos on KZbin. Well done. Thanks!

[@ankitbansal6]

Glad you liked it!

[@shafi123]

Thanks a lot Ankit. please make a video on Include and Exclude LOd as well. 1 more thing : I think we can do this query in single select statement. Let me know if it is correct or not select category, sub-category, sum(sales) as sub-cat-sales, sum(sales) over(partition by category) as cat-sales from table group by 1,2

[@ankitbansal6]

Yes you are right . You just need to use double sum when using partition by

[@madhvisingh9082]

very well explained the reason for fixed LOD in tableau. It would be great if you could make video on include and exclude LOD with SQL. Thank you.

[@ankitbansal6]

Sure

[@avi8016]

Wow great explanation And a great idea to cover the LOD implementation in SQL as well That definitely helped Thankyou sir🙏

[@djnepolian]

great explanation, also we can use table calculation in Tableau to get the % in more sort way.

[@dasoumya]

Hello! Ankit great explanation Please make a video on include and exclude lod too...with side by side SQL comparison ❤️

[@ankitbansal6]

Sure

[@komalpawar5124]

Hi Ankit, Hope this message finds you well!! I have one Question related to string- Suppose we have one string in which particular character occurs multiple times and we want to find all position of that character in whole string....how can we do this?can you please take this example in your Video ,that will be so helpful

[@digitalishant124]

Sir pls upload more content on tableau like sql

[@SunilKumar-oh8pe]

Ankit sir kindly made a video for join the topic in depth

[@user-hc8hj4tb2c]

Hi sir, Very well explained. Thank you for making these videos and sharing them. Could you please make a video on include and exclude load too similar to fixed lod. Thank you

[@ankitbansal6]

Sure I will

[@jececdept.9548]

hello Ankit..i always have this concern that can't we do all the calculations in sql and we can dirctly import in power BI or tableau,sql file and use(i mean all the kpi's done in sql)

[@leepthikamarichetty]

Hi @Ankit Clearly explained with example, please make a video on include and exclude LOD's as well

[@ankitbansal6]

Sure

[@HarshKukreja052]

Hi Ankit, Very clearly explained 👌 Please make video on Include and Exclude as well

[@ankitbansal6]

Sure

[@sabaparveen1099]

Ankit Sir, I upload database (in csv) given above in mysql workbench but only 137 rows are uploaded. How I can upload whole database.

[@mdsultanahemad]

Hi Ankit,thanks for the awesome content. I have just one request ,can u share how can we achieve this if we have multiple lod expression

[@ankitbansal6]

You can create multiple columns using different partition by

[@mdsultanahemad]

@@ankitbansal6 Sir, Can u plz help me in this. Select material, Sum ({fixed [product],[product area]: Sum( {Fixed [product],[working days],[shiftid]:avg(profit)})}) ) I am trying but not able to achieve this

[@suryap6518]

Thank your Sir

[@ankitbansal6]

Welcome

[@himanshusingh-ny6co]

Prepare a course on Tableau, Namate Tableau !!!

[@ankitbansal6]

Definitely 💯

[@anshalsingh6007]

Ankit sir pls convert sql course in hindi language for better understand sql who not comfort in english

[@anshalsingh6007]

Pls reply krna

[@anshalsingh6007]

If possible

[@ankitbansal6]

Next SQL course will be in Hindi