Data Science & Machine Learning
76.5K subscribers
840 photos
68 files
752 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
What helps users interact with dashboard data?
Anonymous Quiz
12%
A) Variables
5%
B) Loops
70%
C) Slicers and filters
14%
D) SQL joins
1👏1
📊 𝗗𝗲𝗹𝗼𝗶𝘁𝘁𝗲 𝗙𝗿𝗲𝗲 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 | 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄!🚀

🔥 Program Highlights:
Free Certificate from Deloitte
Real-World Data Analytics Tasks
Self-Paced Learning
Industry-Relevant Projects
Resume & LinkedIn Booster
Perfect for Students & Freshers

No prior experience required! Build in-demand skills and stand out to recruiters. 💼

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

https://pdlink.in/3RVHcFU

📢 Share with friends who want to start a career in Data Analytics!
4
Excel for Data Analysis 📊📈

👉 Excel is one of the most widely used tools in:

Data Analysis

Business Reporting

Finance

Operations

Even today, Excel is heavily used in companies worldwide.

🔹 1. Why Excel is Important?

Easy to use

Fast data analysis

Great for reporting

Common interview skill

🔥 2. Important Excel Features for Data Analysis

Formulas & Functions

Sorting & Filtering

Conditional Formatting

Pivot Tables

Charts & Dashboards

🔹 3. Basic Formulas

SUM

Adds values.

=SUM(A1:A10)

AVERAGE

Finds average value.

=AVERAGE(A1:A10)

COUNT

Counts numbers.

=COUNT(A1:A10)

MAX & MIN

=MAX(A1:A10)

=MIN(A1:A10)

🔹 4. IF Function

Used for conditions.

=IF(A1>50,"Pass","Fail")

🔹 5. VLOOKUP

Searches for values in tables.

=VLOOKUP(101,A2:D10,2,FALSE)

👉 Very important interview topic.

🔹 6. Pivot Tables

Used for:

Summarizing data

Grouping information

Quick analysis

Example:

👉 Total sales by region.

🔹 7. Conditional Formatting

Highlights important values.

Examples:

High sales → Green

Low sales → Red

🔹 8. Charts in Excel

Popular charts:

Bar Chart

Pie Chart

Line Chart

Combo Chart

🔹 9. Why Excel Still Matters?

Used in almost every company

Important for quick analysis

Frequently asked in interviews

🎯 Today’s Goal

Learn formulas

Understand Pivot Tables

Learn VLOOKUP

Create basic charts

👉 Excel Resources: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

💬 Tap ❤️ for more!
6
Which Excel function is used to calculate the total of a range of numbers?
Anonymous Quiz
28%
A) COUNT()
18%
B) AVERAGE()
49%
C) SUM()
5%
D) MAX()
1
Which Excel feature is commonly used to summarize large datasets?
Anonymous Quiz
14%
A) Conditional Formatting
23%
B) VLOOKUP
59%
C) Pivot Table
4%
D) Filter
2
Which chart is best for showing trends over time in Excel?
Anonymous Quiz
13%
A) Pie Chart
72%
B) Line Chart
13%
C) Doughnut Chart
3%
D) Radar Chart
1🔥1😢1
💫 𝗔𝗧𝗧𝗘𝗡𝗧𝗜𝗢𝗡 𝗦𝗧𝗨𝗗𝗘𝗡𝗧𝗦 & 𝗙𝗥𝗘𝗦𝗛𝗘𝗥𝗦 🔥

This could be the biggest opportunity you join in 2026!

🏆 Win from ₹50 Lakh+ Prize Pool
🎓 Open to All Students
🤖 Explore AI & Innovation
📜 Earn Recognition
💯 Registration is FREE

Imagine adding a national innovation challenge to your resume before graduation.

Registration Closes Soon

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4fFWOqX

Share with your friends, classmates, teammates & colleagues who shouldn't miss this opportunity.
2
Tableau Basics 📊🚀

👉 Tableau is one of the most popular Data Visualization and Business Intelligence (BI) tools.

It helps transform raw data into:

Interactive dashboards

Visual reports

Business insights

🔹 1. What is Tableau?

Tableau is a drag-and-drop data visualization tool used by:

Data Analysts

Business Analysts

Data Scientists

Managers & Executives

👉 It allows users to analyze data without extensive coding.

🔥 2. Why Tableau is Popular?

Easy to learn

Interactive dashboards

Fast visualization creation

Connects to multiple data sources

🔹 3. Tableau Products

Tableau Desktop: Used to create visualizations and dashboards.

Tableau Server: Used to publish and share dashboards.

Tableau Public: Free version for learning and sharing public dashboards.

🔹 4. Connecting Data Sources

Tableau can connect to:

Excel files

CSV files

SQL Databases

Cloud platforms

APIs

🔹 5. Tableau Interface

Main areas:

Data Pane: Contains fields and tables.

Shelves: Used to build charts.

Marks Card: Controls color, size, labels, and details.

Worksheet: Area where visualizations are created.

🔥 6. Dimensions vs Measures

Dimensions: Categorical data.

Examples: Region, Product, Customer Name

Measures: Numerical data.

Examples: Sales, Profit, Quantity

🔹 7. Common Charts in Tableau

Bar Chart

Line Chart

Pie Chart

Map

Scatter Plot

Heat Map

🔹 8. Filters in Tableau

Filters help users focus on specific data.

Example:

View sales for only one region,

Show data for a selected year

🔹 9. Dashboards in Tableau

A dashboard combines multiple charts into one screen.

Example:

📊 Sales Trend,

📈 Profit Analysis,

🌍 Regional Performance

🔹 10. Why Tableau is Important?

Highly demanded skill

Common in analytics jobs

Great for storytelling with data

Frequently asked in interviews

🎯 Today's Goal

Understand Tableau basics

Learn dimensions & measures

Understand dashboards

Learn Tableau workflow

👉 Tableau Resources: https://whatsapp.com/channel/0029VasYW1V5kg6z4EHOHG1t

💬 Tap ❤️ for more!
9👏1
𝗜𝗻𝗳𝗼𝘀𝘆𝘀 𝗦𝗽𝗿𝗶𝗻𝗴𝗯𝗼𝗮𝗿𝗱 – 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 & 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀🎓

Upgrade your skills without spending a single rupee

The platform provides digital, technical, soft-skill, and career-focused learning opportunities.

💡 Why Join?
✔️ Free Learning Platform
✔️ Industry-Relevant Courses
✔️ Skill Development Programs
✔️ Certificates on Completion
✔️ Learn Anytime, Anywhere

𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:-

https://pdlink.in/4eBH3Aa

🔥 Start learning today and build skills that top companies are looking for!
2
Which Tableau product is free and commonly used for learning?
Anonymous Quiz
53%
A) Tableau Desktop
11%
B) Tableau Server
30%
C) Tableau Public
5%
D) Tableau Cloud
2
Which of the following is a Measure in Tableau?
Anonymous Quiz
14%
A) Region
9%
B) Customer Name
34%
C) Product Category
42%
D) Sales
What type of data is considered a Dimension in Tableau?
Anonymous Quiz
25%
A) Numerical values
17%
B) Calculated fields
43%
C) Categorical data
15%
D) Aggregated data
𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 & 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 🎓

Looking to land a high-paying tech job in 2026? This is your chance to learn the most in-demand skills 🔥

60+ Hiring Drives Monthly
👉100% Placement Assistance
💫500+ Hiring Partners
💼 Avg. Package: ₹7.2 LPA
💰Highest: ₹41 LPA

👨‍💻Fullstack :- https://pdlink.in/4fdWxJB

📈 DataAnalytics :- https://pdlink.in/42WOE5H

📌 Start Learning Today & Upgrade Your Career!
2
Tableau Calculated Fields

What are Calculated Fields?

Custom formulas you create in Tableau to do calculations beyond default aggregations. Think: Excel formulas inside Tableau.

Why use them?

1. Create new metrics like Profit Margin, YoY Growth

2. Categorize data: High/Medium/Low sales

3. Date math: Days between orders, fiscal periods

4. Conditional logic: IF/THEN/ELSE rules

Basic Syntax

IF [Sales] > 10000 THEN "High" ELSE "Low" END

[Profit] / [Sales] → Profit Ratio

DATEDIFF('day', [Order Date], [Ship Date])

Key Functions

Logical: IF, IIF, CASE

Math: ROUND, ABS, SQRT

Date: YEAR, MONTH, DATEDIFF

String: LEFT, RIGHT, CONTAINS

Pro Tips

1. Calculated fields compute row-level or aggregate depending on formula

2. Use ATTR() to avoid aggregation errors

3. Name fields clearly: Profit Margin % not Calc1

4. Test with a few rows before using in dashboards

👉 Tableau Resources: https://whatsapp.com/channel/0029VasYW1V5kg6z4EHOHG1t

💬 Tap ❤️ for more!
8🥰1
🎓 𝗜𝗜𝗠 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝟮𝟬𝟮𝟲 🚀

Here's your chance to access FREE online courses offered by IIMs and earn valuable certifications! 🌟

📚 Popular Learning Areas:
Business Management
Digital Marketing
Leadership Skills
Data Analytics
Finance & Accounting
Operations Management
Entrepreneurship
Strategic Management

💫IIMs offer a variety of online learning opportunities through platforms like SWAYAM and their digital learning initiatives.

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

https://pdlink.in/4xsgu7T

Enroll Now & Start Learning for FREE!
1
What is the primary purpose of a Calculated Field in Tableau?
Anonymous Quiz
8%
A) Connect to databases
70%
B) Create new data using formulas
16%
C) Publish dashboards
6%
D) Import CSV files
1
Which of the following is an example of a Calculated Field?
Anonymous Quiz
5%
A) Region Filter
84%
B) SUM([Profit]) / SUM([Sales])
7%
C) Data Source Connection
3%
D) Dashboard Layout
1