Data Science & Machine Learning
76.5K subscribers
839 photos
68 files
751 links
Join this channel to learn data science, artificial intelligence and machine learning with funny quizzes, interesting projects and amazing resources for free

For collaborations: @love_data
Download Telegram
Tableau LOD Expressions Level of Detail 📊🔥

👉 LOD Level of Detail Expressions are one of the most powerful and frequently asked Tableau interview topics. 
They allow you to perform calculations at a different level of granularity than what is currently shown in the visualization.

🔹 1. What are LOD Expressions? 
LOD Expressions let you control how data is aggregated. 
👉 Normally, Tableau calculates values based on the current view. 
👉 LOD lets you calculate values independently of the visualization.

🔥 2. Why Use LOD Expressions? 
Calculate metrics at different levels 
Compare individual values to totals 
Create advanced KPIs 
Improve dashboard flexibility 

🔹 3. Types of LOD Expressions  
There are three main types:

FIXED 
Calculates values at a specific level. 
{ FIXED [Region] : SUM([Sales]) } 
👉 Calculates total sales for each region regardless of what's in the view.

INCLUDE 
Adds dimensions to the current view. 
{ INCLUDE [Customer Name] : SUM([Sales]) } 
👉 Includes customer-level calculations.

EXCLUDE 
Removes dimensions from the current view. 
{ EXCLUDE [Product] : SUM([Sales]) } 
👉 Ignores product-level detail.

🔹 4. Example of FIXED LOD 
Suppose you want: 
👉 Total Sales by Region 
Even when viewing sales by product. 
{ FIXED [Region] : SUM([Sales]) } 
This value remains constant for the region.

🔹 5. Real-World Example 
Calculate each customer's contribution to total regional sales: 
SUM([Sales]) / { FIXED [Region] : SUM([Sales]) }

🔹 6. Difference Between Aggregate & LOD 
Aggregate: Depends on current view, Simple calculations, Dynamic with visualization 
LOD: Independent of current view, Advanced calculations, Fixed granularity control 

🔹 7. When to Use LOD? 
Customer contribution analysis 
Regional benchmarking 
Advanced KPIs 
Performance comparisons 

🔹 8. Common Interview Question  
Q: Which LOD expression ignores the dimensions in the current view? 
Answer: FIXED 

🔹 9. Why LOD is Important? 
Advanced Tableau skill 
Frequently asked in interviews 
Used in enterprise dashboards 
Makes complex calculations easier 

🎯 Today's Goal 
Understand FIXED, INCLUDE, EXCLUDE 
Learn granularity concepts 
Build advanced Tableau calculations 

👉 Double Tap ❤️ For More
3🙏2
𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 - 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸𝗗𝗲𝘃 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗪𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜 😍

Curriculum designed and taught by alumni from IITs & leading tech companies.

Learn Coding & Get Placed In Top Tech Companies

𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:-

💼 Avg. Package: ₹7.2 LPA | Highest: ₹41 LPA

𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-

 https://pdlink.in/42WOE5H

Hurry! Limited seats are available.🏃‍♂️
4
🔰  Important Pandas Methods for Data Science
6
𝟳 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗘𝗻𝗿𝗼𝗹𝗹 𝗜𝗻 𝟮𝟬𝟮𝟲😍 

100% FREE & Beginner-Friendly
Learn AI, ML, Data Science, Ethical Hacking & More
Taught by Industry Experts
Practical & Hands-on Learning

📢 Start learning today and take your tech career to the next level! 🚀

𝐋𝐢𝐧𝐤 👇:- 
 
https://pdlink.in/4bQ6FpS
 
Enroll For FREE & Get Certified 🎓
4
📊 𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀

Here's an amazing opportunity from TCS to learn essential data analytics skills completely FREE and earn a certificate

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4waJYWJ

🔥 Data Analytics continues to be one of the most in-demand career paths, and this free course is a great first step toward building job-ready skills.

Don't miss this opportunity to upskill and boost your career!
5
💻 Popular Coding Languages & Their Uses 🚀

There are many programming languages, each serving different purposes. Here are some key ones you should know:

🔹 1. Python – Beginner-friendly, versatile, and widely used in data science, AI, web development, and automation.

🔹 2. JavaScript – Essential for frontend and backend web development, powering interactive websites and applications.

🔹 3. Java – Used for enterprise applications, Android development, and large-scale systems due to its stability.

🔹 4. C++ – High-performance language ideal for game development, operating systems, and embedded systems.

🔹 5. C# – Commonly used in game development (Unity), Windows applications, and enterprise software.

🔹 6. Swift – The go-to language for iOS and macOS development, known for its efficiency.

🔹 7. Go (Golang) – Designed for high-performance applications, cloud computing, and network programming.

🔹 8. Rust – Focuses on memory safety and performance, making it great for system-level programming.

🔹 9. SQL – Essential for database management, allowing efficient data retrieval and manipulation.

🔹 10. Kotlin – Popular for Android app development, offering modern features compared to Java.

🔥 React ❤️ for more 😊🚀
9
🎓 𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🚀

Learn job-ready skills from Google and boost your resume?🌟

✔️ Learn from Google Experts
✔️ Industry-Recognized Certificates
✔️ Beginner-Friendly Learning Paths
✔️ Self-Paced Courses
✔️ Enhance Resume & LinkedIn Profile
✔️ Build Job-Ready Skills

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4vjLGVq

Start Learning Today & Upgrade Your Career!
2👏1
Which LOD expression calculates values at a specific level regardless of the current view?
Anonymous Quiz
26%
A) INCLUDE
20%
B) EXCLUDE
34%
C) FIXED
20%
D) FILTER
2
Which LOD expression adds dimensions to the current level of detail?
Anonymous Quiz
11%
A) FIXED
64%
B) INCLUDE
15%
C) EXCLUDE
9%
D) GROUP
1
Which LOD expression removes dimensions from the current level of detail?
Anonymous Quiz
6%
A) FIXED
8%
B) INCLUDE
76%
C) EXCLUDE
10%
D) REMOVE
2
𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝟭𝟬𝟬+ 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗔𝘇𝘂𝗿𝗲, 𝗔𝗜, 𝗖𝘆𝗯𝗲𝗿𝘀𝗲𝗰𝘂𝗿𝗶𝘁𝘆 & 𝗠𝗼𝗿𝗲 🚀

Learn the most in-demand tech skills from Microsoft completely FREE🌟

Microsoft Learn offers 100+ free courses designed to help students, freshers, and professionals build job-ready skills in today's fastest-growing technology domains.

100% Free Learning
Beginner to Advanced Levels

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4f0GNuH

🚀 Learn. Practice. Upskill. Get Career Ready
6
📊 𝗣𝘄𝗖 𝗶𝘀 𝗼𝗳𝗳𝗲𝗿𝗶𝗻𝗴 𝗮 𝗙𝗥𝗘𝗘 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺

This helps tolearn data visualization, dashboard creation, KPI analysis, and business intelligence skills that companies actively look for.

Free Certificate
Self-Paced Learning
Hands-On Power BI Projects
Beginner Friendly
Resume & LinkedIn Boost

Don't miss this opportunity to add an in-demand skill to your profile and stand out from the crowd! 💼🔥

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4g5sKFa

Share with yours friends who wants to start a career in Data Analytics
4
Tableau Dashboard Actions & Interactivity 📊

👉 A dashboard becomes truly powerful when users can interact with it.

Dashboard Actions allow users to click, hover, or select visuals to explore data dynamically.

🔹 1. What are Dashboard Actions

Dashboard Actions are interactive features that connect worksheets and dashboards.

👉 Instead of viewing static charts, users can:

Click on charts

Filter data

Navigate between dashboards

Highlight related information

🔥 2. Types of Dashboard Actions

There are three main types:

Filter Action

Filters one visualization based on another. 

Example: Click "West Region" in a map → Only West Region sales appear in all other charts.

Highlight Action

Highlights related data without hiding other values.

Example: Hover over a product category → Related bars are highlighted.

URL Action

Opens a web page when users click a mark.

Example: Click a customer name → Open the customer's profile page.

🔹 3. Filter Action Example

Dashboard contains:

📊 Sales by Region

📈 Monthly Sales Trend

When you click South Region:

Monthly chart automatically shows only South Region data.

🔹 4. Highlight Action Example

Dashboard contains:

📊 Product Category

📈 Profit Analysis

Hover over Electronics

Related profit data gets highlighted.

🔹 5. URL Action Example

Click on:

Customer ID → Opens CRM profile

Product → Opens Product Website

🔥 6. Dashboard Objects

Common objects used in Tableau dashboards:

Horizontal Container

Vertical Container

Text

Image

Web Page

Navigation Button

🔹 7. Best Practices

Keep dashboard simple

Use meaningful filters

Avoid too many actions

Maintain consistent colors

Use descriptive titles

🔹 8. Real-World Uses

Executive dashboards

Sales dashboards

HR analytics

Financial reporting

Customer analysis

🔹 9. Why Dashboard Actions are Important

Improve user experience

Make dashboards interactive

Help users explore data independently

Frequently asked in Tableau interviews

🎯 Today's Goal

Understand Dashboard Actions

Learn Filter, Highlight & URL Actions

Build interactive dashboards

Follow dashboard best practices

👉 Interactive Dashboards = Better insights and better decisions 📊🚀

👉 Double Tap ❤️ For More
7
📊 𝗙𝗥𝗘𝗘 𝗧𝗮𝘁𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽 | 𝗪𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲 🚀

Here's an amazing opportunity to complete the FREE Tata Data Analytics Virtual Internship and earn a certificate that you can showcase on your Resume and LinkedIn.

100% FREE
Self-Paced & Online
Beginner-Friendly
Certificate on Completion
Real Business Case Studies
Resume & LinkedIn Boost

🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘👇:

https://pdlink.in/4eybW8J

🚀 Upskill Today. Build Your Portfolio. Get Career Ready!
1
What is the main purpose of Dashboard Actions in Tableau?
Anonymous Quiz
10%
A) Create databases
79%
B) Make dashboards interactive
8%
C) Write SQL queries
3%
D) Import data
👍1
Which Dashboard Action filters one visualization based on another?
Anonymous Quiz
15%
A) Highlight Action
9%
B) URL Action
60%
C) Filter Action
16%
D) Navigation Action
1
Which Dashboard Action highlights related data without hiding the remaining data?
Anonymous Quiz
9%
A) Filter Action
80%
B) Highlight Action
6%
C) URL Action
5%
D) Image Action
Which Dashboard Action opens a web page when a user clicks a mark?
Anonymous Quiz
3%
A) Filter Action
8%
B) Highlight Action
72%
C) URL Action
16%
D) Navigation Action
1