Data Science & Machine Learning
77.8K subscribers
898 photos
1 video
68 files
817 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
โค2๐Ÿ‘1
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!
โค11๐Ÿ‘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
52%
A) Tableau Desktop
10%
B) Tableau Server
32%
C) Tableau Public
5%
D) Tableau Cloud
โค3
Which of the following is a Measure in Tableau?
Anonymous Quiz
15%
A) Region
9%
B) Customer Name
33%
C) Product Category
43%
D) Sales
What type of data is considered a Dimension in Tableau?
Anonymous Quiz
26%
A) Numerical values
16%
B) Calculated fields
44%
C) Categorical data
14%
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
72%
B) Create new data using formulas
15%
C) Publish dashboards
5%
D) Import CSV files
โค1
Which of the following is an example of a Calculated Field?
Anonymous Quiz
5%
A) Region Filter
85%
B) SUM([Profit]) / SUM([Sales])
7%
C) Data Source Connection
3%
D) Dashboard Layout
โค2
Which Tableau feature is commonly used for "What-If Analysis"?
Anonymous Quiz
19%
A) Worksheets
22%
B) Dimensions
39%
C) Parameters
19%
D) Data Blending
โค7๐Ÿ”ฅ1๐Ÿฅฐ1๐Ÿ‘1๐ŸŽ‰1
๐ŸŽ“๐Ÿฑ ๐—™๐—ฅ๐—˜๐—˜ ๐—œ๐—•๐—  ๐—–๐—ฒ๐—ฟ๐˜๐—ถ๐—ณ๐—ถ๐—ฐ๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—–๐—ผ๐˜‚๐—ฟ๐˜€๐—ฒ๐˜€ ๐Ÿฎ๐Ÿฌ๐Ÿฎ๐Ÿฒ ๐Ÿš€

IBM SkillsBuild offers FREE online courses, digital credentials, and career-focused learning paths to help students and professionals become job-ready. ๐ŸŒŸ

โœ”๏ธ 100% Free Learning Resources
โœ”๏ธ Industry-Recognized Digital Badges
โœ”๏ธ Self-Paced Learning
โœ”๏ธ Hands-On Projects & Assessments
โœ”๏ธ Resume & LinkedIn Profile Enhancement

๐Ÿ”— ๐—˜๐—ป๐—ฟ๐—ผ๐—น๐—น ๐—™๐—ผ๐—ฟ ๐—™๐—ฅ๐—˜๐—˜๐Ÿ‘‡:

https://pdlink.in/4vPMTDO

โณ Start Learning Today & Boost Your Career!
โค2๐Ÿฅฐ1
๐Ÿง  Technologies for Data Analysts!

๐Ÿ“Š Data Manipulation & Analysis

โ–ช๏ธ Excel โ€“ Spreadsheet Data Analysis & Visualization
โ–ช๏ธ SQL โ€“ Structured Query Language for Data Extraction
โ–ช๏ธ Pandas (Python) โ€“ Data Analysis with DataFrames
โ–ช๏ธ NumPy (Python) โ€“ Numerical Computing for Large Datasets
โ–ช๏ธ Google Sheets โ€“ Online Collaboration for Data Analysis

๐Ÿ“ˆ Data Visualization

โ–ช๏ธ Power BI โ€“ Business Intelligence & Dashboarding
โ–ช๏ธ Tableau โ€“ Interactive Data Visualization
โ–ช๏ธ Matplotlib (Python) โ€“ Plotting Graphs & Charts
โ–ช๏ธ Seaborn (Python) โ€“ Statistical Data Visualization
โ–ช๏ธ Google Data Studio โ€“ Free, Web-Based Visualization Tool

๐Ÿ”„ ETL (Extract, Transform, Load)

โ–ช๏ธ SQL Server Integration Services (SSIS) โ€“ Data Integration & ETL
โ–ช๏ธ Apache NiFi โ€“ Automating Data Flows
โ–ช๏ธ Talend โ€“ Data Integration for Cloud & On-premises

๐Ÿงน Data Cleaning & Preparation

โ–ช๏ธ OpenRefine โ€“ Clean & Transform Messy Data
โ–ช๏ธ Pandas Profiling (Python) โ€“ Data Profiling & Preprocessing
โ–ช๏ธ DataWrangler โ€“ Data Transformation Tool

๐Ÿ“ฆ Data Storage & Databases

โ–ช๏ธ SQL โ€“ Relational Databases (MySQL, PostgreSQL, MS SQL)
โ–ช๏ธ NoSQL (MongoDB) โ€“ Flexible, Schema-less Data Storage
โ–ช๏ธ Google BigQuery โ€“ Scalable Cloud Data Warehousing
โ–ช๏ธ Redshift โ€“ Amazonโ€™s Cloud Data Warehouse

โš™๏ธ Data Automation

โ–ช๏ธ Alteryx โ€“ Data Blending & Advanced Analytics
โ–ช๏ธ Knime โ€“ Data Analytics & Reporting Automation
โ–ช๏ธ Zapier โ€“ Connect & Automate Data Workflows

๐Ÿ“Š Advanced Analytics & Statistical Tools

โ–ช๏ธ R โ€“ Statistical Computing & Analysis
โ–ช๏ธ Python (SciPy, Statsmodels) โ€“ Statistical Modeling & Hypothesis Testing
โ–ช๏ธ SPSS โ€“ Statistical Software for Data Analysis
โ–ช๏ธ SAS โ€“ Advanced Analytics & Predictive Modeling

๐ŸŒ Collaboration & Reporting

โ–ช๏ธ Power BI Service โ€“ Online Sharing & Collaboration for Dashboards
โ–ช๏ธ Tableau Online โ€“ Cloud-Based Visualization & Sharing
โ–ช๏ธ Google Analytics โ€“ Web Traffic Data Insights
โ–ช๏ธ Trello / JIRA โ€“ Project & Task Management for Data Projects
Data-Driven Decisions with the Right Tools!

React โค๏ธ for more
โค14๐Ÿ‘3๐Ÿ˜1
๐Ÿ”ฅ Top SQL Interview Questions with Answers

๐ŸŽฏ 1๏ธโƒฃ Find 2nd Highest Salary
๐Ÿ“Š Table: employees
id | name | salary
1 | Rahul | 50000
2 | Priya | 70000
3 | Amit | 60000
4 | Neha | 70000

โ“ Problem Statement: Find the second highest distinct salary from the employees table.

โœ… Solution
SELECT MAX(salary) FROM employees WHERE salary < ( SELECT MAX(salary) FROM employees );

๐ŸŽฏ 2๏ธโƒฃ Find Nth Highest Salary
๐Ÿ“Š Table: employees
id | name | salary
1 | A | 100
2 | B | 200
3 | C | 300
4 | D | 200

โ“ Problem Statement: Write a query to find the 3rd highest salary.

โœ… Solution
SELECT salary FROM ( SELECT salary, DENSE_RANK() OVER(ORDER BY salary DESC) r FROM employees ) t WHERE r = 3;

๐ŸŽฏ 3๏ธโƒฃ Find Duplicate Records
๐Ÿ“Š Table: employees
id | name
1 | Rahul
2 | Amit
3 | Rahul
4 | Neha

โ“ Problem Statement: Find all duplicate names in the employees table.

โœ… Solution
SELECT name, COUNT(*) FROM employees GROUP BY name HAVING COUNT(*) > 1;

๐ŸŽฏ 4๏ธโƒฃ Customers with No Orders
๐Ÿ“Š Table: customers
customer_id | name
1 | Rahul
2 | Priya
3 | Amit

๐Ÿ“Š Table: orders
order_id | customer_id
101 | 1
102 | 2

โ“ Problem Statement: Find customers who have not placed any orders.

โœ… Solution
SELECT c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id WHERE o.customer_id IS NULL;

๐ŸŽฏ 5๏ธโƒฃ Top 3 Salaries per Department
๐Ÿ“Š Table: employees
name | department | salary
A | IT | 100
B | IT | 200
C | IT | 150
D | HR | 120
E | HR | 180

โ“ Problem Statement: Find the top 3 highest salaries in each department.

โœ… Solution
SELECT * FROM ( SELECT name, department, salary, ROW_NUMBER() OVER( PARTITION BY department ORDER BY salary DESC ) r FROM employees ) t WHERE r <= 3;

๐ŸŽฏ 6๏ธโƒฃ Running Total of Sales
๐Ÿ“Š Table: sales
date | sales
2024-01-01 | 100
2024-01-02 | 200
2024-01-03 | 300

โ“ Problem Statement: Calculate the running total of sales by date.

โœ… Solution
SELECT date, sales, SUM(sales) OVER(ORDER BY date) AS running_total FROM sales;

๐ŸŽฏ 7๏ธโƒฃ Employees Above Average Salary
๐Ÿ“Š Table: employees
name | salary
A | 100
B | 200
C | 300

โ“ Problem Statement: Find employees earning more than the average salary.

โœ… Solution
SELECT name, salary FROM employees WHERE salary > ( SELECT AVG(salary) FROM employees );

๐ŸŽฏ 8๏ธโƒฃ Department with Highest Total Salary
๐Ÿ“Š Table: employees
name | department | salary
A | IT | 100
B | IT | 200
C | HR | 500

โ“ Problem Statement: Find the department with the highest total salary.

โœ… Solution
SELECT department, SUM(salary) AS total_salary FROM employees GROUP BY department ORDER BY total_salary DESC LIMIT 1;

๐ŸŽฏ 9๏ธโƒฃ Customers Who Placed Orders
๐Ÿ“Š Tables: Same as Q4
โ“ Problem Statement: Find customers who have placed at least one order.

โœ… Solution
SELECT name FROM customers c WHERE EXISTS ( SELECT 1 FROM orders o WHERE c.customer_id = o.customer_id );

๐ŸŽฏ ๐Ÿ”Ÿ Remove Duplicate Records
๐Ÿ“Š Table: employees
id | name
1 | Rahul
2 | Rahul
3 | Amit

โ“ Problem Statement: Delete duplicate records but keep one unique record.

โœ… Solution
DELETE FROM employees WHERE id NOT IN ( SELECT MIN(id) FROM employees GROUP BY name );

๐Ÿš€ Pro Tip:
๐Ÿ‘‰ In interviews:
First explain logic
Then write query
Then optimize

Double Tap โ™ฅ๏ธ For More
โค8๐Ÿ‘1