Data Science & Machine Learning
76.2K subscribers
823 photos
68 files
733 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
Which LOD expression calculates values at a specific level regardless of the current view?
Anonymous Quiz
25%
A) INCLUDE
19%
B) EXCLUDE
36%
C) FIXED
20%
D) FILTER
2
Which LOD expression adds dimensions to the current level of detail?
Anonymous Quiz
11%
A) FIXED
66%
B) INCLUDE
15%
C) EXCLUDE
8%
D) GROUP
1
Which LOD expression removes dimensions from the current level of detail?
Anonymous Quiz
6%
A) FIXED
9%
B) INCLUDE
75%
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
6
📊 𝗙𝗥𝗘𝗘 𝗧𝗮𝘁𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽 | 𝗪𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲 🚀

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
80%
B) Make dashboards interactive
7%
C) Write SQL queries
3%
D) Import data
👍1
Which Dashboard Action filters one visualization based on another?
Anonymous Quiz
14%
A) Highlight Action
9%
B) URL Action
61%
C) Filter Action
15%
D) Navigation Action
1
Which Dashboard Action highlights related data without hiding the remaining data?
Anonymous Quiz
10%
A) Filter Action
80%
B) Highlight Action
5%
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
73%
C) URL Action
16%
D) Navigation Action
1
📊 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗡𝗼 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 𝗡𝗲𝗲𝗱𝗲𝗱! 🚀

Want to start a career in Data Analytics but don't know where to begin?

These 5 FREE beginner-friendly courses will help you learn the most in-demand data skills and build a strong foundation.

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

https://pdlink.in/3SOk64h

🚀 Start Learning Today. Build Your Portfolio. Land Your Dream Data Job!
1
Essential Tools for Data Analytics 📊🛠️

🔣 1️⃣ Excel / Google Sheets
• Quick data entry & analysis
• Pivot tables, charts, functions
• Good for early-stage exploration

💻 2️⃣ SQL (Structured Query Language)
• Work with databases (MySQL, PostgreSQL, etc.)
• Query, filter, join, and aggregate data
• Must-know for data from large systems

🐍 3️⃣ Python (with Libraries)
Pandas – Data manipulation
NumPy – Numerical analysis
Matplotlib / Seaborn – Data visualization
OpenPyXL / xlrd – Work with Excel files

📊 4️⃣ Power BI / Tableau
• Create dashboards and visual reports
• Drag-and-drop interface for non-coders
• Ideal for business insights & presentations

📁 5️⃣ Google Data Studio
• Free dashboard tool
• Connects easily to Google Sheets, BigQuery
• Great for real-time reporting

🧪 6️⃣ Jupyter Notebook
• Interactive Python coding
• Combine code, text, and visuals in one place
• Perfect for storytelling with data

🛠️ 7️⃣ R Programming (Optional)
• Popular in statistical analysis
• Strong in academic and research settings

☁️ 8️⃣ Cloud & Big Data Tools
• Google BigQuery, Snowflake – Large-scale analysis
• Excel + SQL + Python still work as a base

💡 Tip:
Start with Excel + SQL + Python (Pandas) → Add BI tools for reporting.

💬 Tap ❤️ for more!
5
𝗧𝗖𝗦 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗢𝗻 𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁 - 𝗘𝗻𝗿𝗼𝗹𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘😍

TCS iON is offering a FREE Master Data Management Course with a Certificate,

100% FREE Learning
Certificate on Completion
Self-Paced Online Course
Beginner-Friendly Content
Industry-Relevant Skills
Resume & LinkedIn Profile Boost

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

https://pdlink.in/4jGFBw0

🚀 Start Learning Today. Upskill for Free. Get Career Ready!
2
Data Warehousing Basics 🏢📦

👉 A Data Warehouse is a central repository used to store large volumes of historical data from multiple sources for reporting and analysis.

It is designed for:
Business Intelligence BI
Reporting
Data Analytics
Decision-making

🔹 1. What is a Data Warehouse?
A Data Warehouse collects data from different systems into one centralized location.

Example
A retail company stores data from:
Sales system
Inventory system
Customer database
Finance system

All this data is combined into a Data Warehouse for analysis.

🔥 2. Why Do We Need a Data Warehouse?
Centralized data storage
Faster reporting
Historical data analysis
Better business decisions

🔹 3. Data Warehouse Architecture
Data Sources

ETL Extract, Transform, Load

Data Warehouse

Reports & Dashboards

🔹 4. What is ETL?
ETL stands for:

Extract
Collect data from different sources.

Transform
Clean, format, and prepare the data.

Load
Store the transformed data in the Data Warehouse.

🔹 5. OLTP vs OLAP
OLTP | OLAP
---|---
Daily transactions | Data analysis
Fast inserts & updates | Fast reporting
Current data | Historical data

Examples:
OLTP: Banking transactions, online shopping orders
OLAP: Sales reports, yearly revenue analysis

🔹 6. Star Schema
The most common Data Warehouse schema.
It contains:

Fact Table
Stores measurable values
Example: Sales Amount, Quantity

Dimension Tables
Store descriptive information
Example: Customer, Product, Date

🔹 7. Snowflake Schema
Similar to Star Schema but with normalized dimension tables.
👉 Uses more tables and relationships.

🔹 8. Popular Data Warehousing Tools
Snowflake
Google BigQuery
Amazon Redshift
Azure Synapse Analytics

🔹 9. Why Data Warehousing is Important?
Stores large amounts of data
Supports business intelligence
Enables faster analytics
Frequently asked in interviews

🎯 Today's Goal
Understand Data Warehouse concepts
Learn ETL process
Differentiate OLTP vs OLAP
Understand Star Schema & Fact/Dimension tables

👉 Double Tap ❤️ For More
4
🚀 𝗡𝗩𝗜𝗗𝗜𝗔 𝗙𝗥𝗘𝗘 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 | 𝗟𝗲𝗮𝗿𝗻 𝗙𝗿𝗼𝗺 𝗔𝗜 𝗜𝗻𝗱𝘂𝘀𝘁𝗿𝘆 𝗟𝗲𝗮𝗱𝗲𝗿𝘀

Want to build cutting-edge *AI skills* from one of the world's leading AI and GPU companies?

*NVIDIA* offers *FREE AI Certification Courses* to help students, freshers, developers, and professionals

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

https://pdlinks.in/nvdia

🚀 Start Learning Today. Earn Your Certificate. Build Your Future in AI!
1