Data Careers Resources & Job Updates | iamrupnath
رفتن به کانال در Telegram
👉 Connect LinkedIn : https://www.linkedin.com/in/rupnath-shaw Google Search => Techcompreviews IG: @iamrupnath Perfect channel for Data Careers, Job Updates Learn Excel, SQL, Python, Tableau, Power BI, AI tools, AI tips & tricks and many more
نمایش بیشتر📈 تحلیل کانال تلگرام Data Careers Resources & Job Updates | iamrupnath
کانال Data Careers Resources & Job Updates | iamrupnath (@codewithrup) در بخش زبانی انگلیسی بازیگری فعال است. در حال حاضر جامعه شامل 21 400 مشترک است و جایگاه 6 134 را در دسته فناوری و برنامهها و رتبه 19 532 را در منطقه الهند دارد.
📊 شاخصهای مخاطب و پویایی
از زمان ایجاد در невідомо، پروژه رشد سریعی داشته و 21 400 مشترک جذب کرده است.
بر اساس آخرین دادهها در تاریخ 28 ژوئیه, 2026، کانال فعالیت پایداری دارد. در ۳۰ روز گذشته تغییر اعضا برابر -413 و در ۲۴ ساعت گذشته برابر -15 بوده و همچنان دسترسی گستردهای حفظ شده است.
- وضعیت تأیید: تأیید نشده
- نرخ تعامل (ER): میانگین تعامل مخاطب 4.36% است و در ۲۴ ساعت نخست پس از انتشار، محتوا معمولاً 1.29% واکنش نسبت به کل مشترکان کسب میکند.
- دسترسی پستها: هر پست به طور میانگین 933 بازدید دریافت میکند. در اولین روز معمولاً 277 بازدید جمعآوری میشود.
- واکنشها و تعامل: مخاطبان بهطور فعال حمایت میکنند؛ میانگین واکنش به هر پست 1 است.
- علایق موضوعی: محتوا بر موضوعات کلیدی مانند apply, qualification, bachelor, degree, engineer تمرکز دارد.
📝 توضیح و سیاست محتوایی
نویسنده این فضا را محل بیان دیدگاههای شخصی توصیف میکند:
“👉 Connect LinkedIn :
https://www.linkedin.com/in/rupnath-shaw
Google Search => Techcompreviews
IG: @iamrupnath
Perfect channel for Data Careers, Job Updates
Learn Excel, SQL, Python, Tableau, Power BI, AI tools, AI tips & tricks and many more”
به لطف بهروزرسانیهای پرتکرار (آخرین داده در تاریخ 29 ژوئیه, 2026)، کانال همواره بهروز و دارای دسترسی بالاست. تحلیلها نشان میدهد مخاطبان بهطور فعال با محتوا تعامل دارند و آن را به نقطه اثرگذاری مهم در دسته فناوری و برنامهها تبدیل کردهاند.
21 400
مشترکین
-1524 ساعت
-937 روز
-41330 روز
در حال بارگیری داده...
کانالهای مشابه
ابر برچسبها
اشارات ورودی و خروجی
---
---
---
---
---
---
جذب مشترکین
ژوئیه '26
ژوئیه '260
در 0 کانالها
ژوئن '260
در 0 کانالها
Get PRO
مه '26
+2
در 0 کانالها
Get PRO
آوریل '26
+1
در 0 کانالها
Get PRO
مارس '26
+2
در 0 کانالها
Get PRO
فوریه '26
+18
در 0 کانالها
Get PRO
ژانویه '26
+4
در 0 کانالها
Get PRO
دسامبر '25
+2
در 0 کانالها
Get PRO
نوامبر '25
+8
در 0 کانالها
Get PRO
اکتبر '25
+21
در 0 کانالها
Get PRO
سپتامبر '25
+42
در 0 کانالها
Get PRO
اوت '25
+411
در 0 کانالها
Get PRO
ژوئیه '25
+738
در 0 کانالها
Get PRO
ژوئن '25
+768
در 0 کانالها
Get PRO
مه '25
+1 136
در 0 کانالها
Get PRO
آوریل '25
+515
در 0 کانالها
Get PRO
مارس '25
+449
در 0 کانالها
Get PRO
فوریه '25
+413
در 0 کانالها
Get PRO
ژانویه '25
+752
در 0 کانالها
Get PRO
دسامبر '24
+681
در 0 کانالها
Get PRO
نوامبر '24
+134
در 1 کانالها
Get PRO
اکتبر '24
+112
در 0 کانالها
Get PRO
سپتامبر '24
+35
در 0 کانالها
Get PRO
اوت '24
+81
در 0 کانالها
Get PRO
ژوئیه '24
+226
در 0 کانالها
Get PRO
ژوئن '24
+78
در 0 کانالها
Get PRO
مه '24
+146
در 0 کانالها
Get PRO
آوریل '24
+163
در 0 کانالها
Get PRO
مارس '24
+412
در 0 کانالها
Get PRO
فوریه '24
+190
در 0 کانالها
Get PRO
ژانویه '24
+214
در 0 کانالها
Get PRO
دسامبر '23
+789
در 0 کانالها
Get PRO
نوامبر '23
+809
در 0 کانالها
Get PRO
اکتبر '23
+1 076
در 0 کانالها
Get PRO
سپتامبر '23
+1 180
در 0 کانالها
Get PRO
اوت '23
+1 230
در 0 کانالها
Get PRO
ژوئیه '23
+1 416
در 0 کانالها
Get PRO
ژوئن '23
+15 354
در 0 کانالها
| تاریخ | رشد مشترکین | اشارات | کانالها | |
| 29 ژوئیه | 0 | |||
| 28 ژوئیه | 0 | |||
| 27 ژوئیه | 0 | |||
| 26 ژوئیه | 0 | |||
| 25 ژوئیه | 0 | |||
| 24 ژوئیه | 0 | |||
| 23 ژوئیه | 0 | |||
| 22 ژوئیه | 0 | |||
| 21 ژوئیه | 0 | |||
| 20 ژوئیه | 0 | |||
| 19 ژوئیه | 0 | |||
| 18 ژوئیه | 0 | |||
| 17 ژوئیه | 0 | |||
| 16 ژوئیه | 0 | |||
| 15 ژوئیه | 0 | |||
| 14 ژوئیه | 0 | |||
| 13 ژوئیه | 0 | |||
| 12 ژوئیه | 0 | |||
| 11 ژوئیه | 0 | |||
| 10 ژوئیه | 0 | |||
| 09 ژوئیه | 0 | |||
| 08 ژوئیه | 0 | |||
| 07 ژوئیه | 0 | |||
| 06 ژوئیه | 0 | |||
| 05 ژوئیه | 0 | |||
| 04 ژوئیه | 0 | |||
| 03 ژوئیه | 0 | |||
| 02 ژوئیه | 0 | |||
| 01 ژوئیه | 0 |
پستهای کانال
5 SQL Mistakes That Make Queries 100x Slower
Cover:
SELECT *, missing indexes, functions in WHERE, unnecessary JOINs, subqueries.
https://www.linkedin.com/feed/update/urn:li:share:7488197667341385728/| 2 | ✅ Top 10 Excel Interview Questions & Answers 📊💼
1️⃣ What is Excel and why is it used?
Excel is a spreadsheet program used for organizing, analyzing, and storing data in tabular form. It's widely used for data analysis, reporting, and financial modeling.
2️⃣ Key Excel components?
- Ribbon: Main menu
- Worksheet: A single sheet
- Workbook: A collection of worksheets
- Cell: Intersection of a row and column
3️⃣ What are Excel Functions?
Predefined formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP).
4️⃣ VLOOKUP vs. INDEX/MATCH?
- VLOOKUP: Searches for a value in the first column and returns a corresponding value.
- INDEX/MATCH: More flexible and overcomes VLOOKUP limitations, better for larger datasets.
5️⃣ What are Pivot Tables?
Interactive tables that summarize and analyze large datasets, allowing you to easily rearrange and filter data.
6️⃣ Conditional Formatting?
Applies formatting (e.g., colors, icons) to cells based on specific criteria, making it easier to identify trends and outliers.
7️⃣ How to remove duplicates?
Use the "Remove Duplicates" feature in the Data tab to eliminate redundant rows based on selected columns.
8️⃣ What are Excel Charts?
Visual representations of data (e.g., bar charts, line charts, pie charts) that help communicate trends and insights.
9️⃣ How to protect a worksheet?
Use the "Protect Sheet" feature in the Review tab to prevent unauthorized changes to the worksheet structure and content.
🔟 What are Macros?
Automated sequences of commands that can be recorded and replayed to perform repetitive tasks efficiently.
👍 React ❤️ if you found this helpful! | 183 |
| 3 |  𝗜 𝗽𝗿𝗲𝗽𝗮𝗿𝗲𝗱 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗺𝘆 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗶𝗻 𝟳 𝗱𝗮𝘆𝘀.
Cracked it too.
No bootcamp. No paid course.
Just YouTube, docs, and my own notes written by hand.
https://www.linkedin.com/feed/update/urn:li:activity:7488076056520941568/ | 188 |
| 4 | https://www.linkedin.com/posts/rupnath-shaw_pandas-activity-7487835774466535426-eyJG?utm_source=share&utm_medium=member_android&rcm=ACoAAC7vPAUBaCDnaBBrKBrYdulPuQnHWSoWPc8 | 297 |
| 5 | Most freshers write their resume before they even know what role they want.
That's backwards.
I broke down a simple framework, the 3-circle career sweet spot, why applying everywhere beats nothing but strategy beats applying everywhere, how your skills are more transferable than you think, and one networking move that actually gets replies.
Full post here 👇
https://www.linkedin.com/posts/rupnath-shaw_data-analyst-roadmap-ugcPost-7487717090469142528-KLem/
Save it if you're job hunting right now. | 378 |
| 6 | 🚨 Most people waste months applying for remote jobs... on the wrong websites.
I analyzed the 8 biggest WFH job platforms and ranked them by real hiring chances, not popularity.
One platform gives you a much better shot at startup jobs.
Another has dollar-paying roles that most Indians ignore.
A few are simply wasting your time.
If you're planning to apply for remote jobs this week, read this first. It could save you hundreds of applications.
👇 Full ranking + reasons:
🔗 https://www.linkedin.com/feed/update/urn:li:activity:7487348656522575872/
If this helps, share it with someone who's actively job hunting. | 471 |
| 7 | https://www.linkedin.com/posts/rupnath-shaw_%F0%9D%97%98%F0%9D%97%BB%F0%9D%98%81%F0%9D%97%BF%F0%9D%98%86-%F0%9D%97%B9%F0%9D%97%B2%F0%9D%98%83%F0%9D%97%B2%F0%9D%97%B9-%F0%9D%97%B1%F0%9D%97%BC%F0%9D%97%B2%F0%9D%98%80%F0%9D%97%BB%F0%9D%98%81-%F0%9D%97%BA%F0%9D%97%B2%F0%9D%97%AE%F0%9D%97%BB-activity-7487095031455965184-ybBe?utm_source=share&utm_medium=member_android&rcm=ACoAAC7vPAUBaCDnaBBrKBrYdulPuQnHWSoWPc8 | 496 |
| 8 | 🚀 Immediate Joiners Only: Data Engineer | Gurugram / Noida
We're looking for a Data Engineer with expertise in Python/PySpark, Snowflake, SQL, and cloud platforms (AWS/Azure/GCP).
📍 Location: Gurugram / Noida
🏢 Work Mode: Hybrid
Requirements:
✅ Experience building scalable ETL/ELT pipelines and data warehousing solutions
✅ Strong data modeling and cloud data engineering skills
🔴 Pharma/Healthcare domain experience is MANDATORY(profiles without Pharma/Healthcare experience will not be considered)
✅ Strong problem-solving and stakeholder management skills
📩 Interested candidates can share their resume at Charul.chhabra@axtria.com or send me a DM.
https://www.linkedin.com/posts/charul-chhabra-100ab5120_hiring-dataengineer-dataengineering-share-7485562178335305728-Fnky/ | 790 |
| 9 | https://www.linkedin.com/posts/rupnath-shaw_sql-dataanalytics-dataanalyst-share-7485904555172519936-cfXE/?utm_source=social_share_send&utm_medium=android_app&rcm=ACoAAC7vPAUBaCDnaBBrKBrYdulPuQnHWSoWPc8&utm_campaign=share_via | 677 |
| 10 | I Tested 100 AI Tools. These Are the Only 12 Worth Using in 2026.
Every week, a new AI tool promises to change your life. Almost all of them disappear from your workflow within days.
https://www.linkedin.com/feed/update/urn:li:share:7485546295512866816/ | 681 |
| 11 | 3 months back, I cleared the 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗔𝘀𝘀𝗼𝗰𝗶𝗮𝘁𝗲 (𝗣𝗟-𝟯𝟬𝟬) exam.
Let me be honest with you guys, it was not easy.
I still remember opening the exam portal, hands little bit sweaty, thinking "kya pata pass hoga ya nahi."
But I did it. And here is what actually helped me.
What the exam really tests:
→ 𝗗𝗮𝘁𝗮 𝗺𝗼𝗱𝗲𝗹𝗶𝗻𝗴 (𝘀𝘁𝗮𝗿 𝘀𝗰𝗵𝗲𝗺𝗮, 𝗿𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝘀𝗵𝗶𝗽𝘀)
→ 𝗗𝗔𝗫 (𝗺𝗲𝗮𝘀𝘂𝗿𝗲𝘀, 𝗰𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗰𝗼𝗹𝘂𝗺𝗻𝘀, 𝘁𝗶𝗺𝗲 𝗶𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲)
→ 𝗗𝗮𝘁𝗮 𝘁𝗿𝗮𝗻𝘀𝗳𝗼𝗿𝗺𝗮𝘁𝗶𝗼𝗻 𝘂𝘀𝗶𝗻𝗴 𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆
→ 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗶𝗻𝗴 𝗮𝗻𝗱 𝗮𝗻𝗮𝗹𝘆𝘇𝗶𝗻𝗴 𝗱𝗮𝘁𝗮
→ 𝗗𝗲𝗽𝗹𝗼𝘆𝗶𝗻𝗴 𝗮𝗻𝗱 𝗺𝗮𝗶𝗻𝘁𝗮𝗶𝗻𝗶𝗻𝗴 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝘀𝘀𝗲𝘁𝘀
https://www.linkedin.com/feed/update/urn:li:share:7485182817547698176/ | 717 |
| 12 | 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this SQL query.
Find the employee(s) who have worked on the highest number of distinct projects.
Assume the table structure: employee_projects(employee_id, project_id)
𝗠𝗲: Challenge accepted! 💪
SELECT
employee_id,
total_projects
FROM (
SELECT
employee_id,
COUNT(DISTINCT project_id) AS total_projects,
DENSE_RANK() OVER (
ORDER BY COUNT(DISTINCT project_id) DESC
) AS rnk
FROM employee_projects
GROUP BY employee_id
) ranked
WHERE rnk = 1;
💡 Explanation:
This query counts the number of unique projects each employee has worked on and identifies those with the highest count.
• COUNT(DISTINCT project_id) counts unique projects for each employee
• GROUP BY employee_id creates one record per employee
• DENSE_RANK() ranks employees based on the number of projects
• The outer query returns all employees tied for the highest number of projects
This question tests your understanding of:
✅ COUNT(DISTINCT)
✅ GROUP BY
✅ Window Functions DENSE_RANK
✅ Ranking Aggregated Results
🎯 Expected Output Example
Employee ID | Total Projects
101 | 12
205 | 12
Both employees have worked on the highest number of distinct projects.
🚀 Alternative Without Window Functions
SELECT
employee_id,
COUNT(DISTINCT project_id) AS total_projects
FROM employee_projects
GROUP BY employee_id
HAVING COUNT(DISTINCT project_id) = (
SELECT MAX(project_count)
FROM (
SELECT
COUNT(DISTINCT project_id) AS project_count
FROM employee_projects
GROUP BY employee_id
) t
);
This solution uses nested subqueries and MAX() instead of window functions.
🚀 Tip for SQL Job Seekers:
Many interview questions involve ranking aggregated results, such as:
Highest number of projects, Most orders, Maximum sales, Highest attendance, Most logins
Practice combining GROUP BY with window functions like DENSE_RANK() to solve these efficiently.
❤️ React with ❤️ for more interview challenges! | 823 |
| 13 | https://www.linkedin.com/feed/update/urn:li:share:7484458215964008448/ | 632 |
| 14 | https://www.linkedin.com/posts/rupnath-shaw_china-just-dropped-a-%F0%9D%9F%AE%F0%9D%9F%B4-%F0%9D%98%81%F0%9D%97%BF%F0%9D%97%B6%F0%9D%97%B9%F0%9D%97%B9%F0%9D%97%B6%F0%9D%97%BC-activity-7484192771180949504-hfZE?utm_source=share&utm_medium=member_android&rcm=ACoAAC7vPAUBaCDnaBBrKBrYdulPuQnHWSoWPc8 | 740 |
| 15 | "𝗗𝗼 𝗜 𝗿𝗲𝗮𝗹𝗹𝘆 𝗻𝗲𝗲𝗱 𝗦𝗤𝗟 𝗮𝘀 𝗮 𝗳𝗿𝗲𝘀𝗵𝗲𝗿?"
I get this question every week in my DMs.
𝗦𝗵𝗼𝗿𝘁 𝗮𝗻𝘀𝘄𝗲𝗿: yes. Non-negotiable. Here's why.
SQL isn't just querying. It's 𝗳𝗼𝘂𝗿 𝗿𝗲𝗮𝗹 𝘀𝗸𝗶𝗹𝗹𝘀 in one:
https://www.linkedin.com/feed/update/urn:li:ugcPost:7484095948722458624/ | 721 |
| 16 | 𝟵𝟬% of your dashboards need just 𝘁𝗵𝗿𝗲𝗲 𝗰𝗵𝗮𝗿𝘁 𝘁𝘆𝗽𝗲𝘀.
https://www.linkedin.com/feed/update/urn:li:activity:7483728449409576960/ | 835 |
| 17 | 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗔𝗫 has two types of context:
→ 𝗥𝗼𝘄 𝗰𝗼𝗻𝘁𝗲𝘅𝘁
→ 𝗙𝗶𝗹𝘁𝗲𝗿 𝗰𝗼𝗻𝘁𝗲𝘅𝘁
https://www.linkedin.com/feed/update/urn:li:share:7482994441742544901/ | 1 045 |
| 18 | Every 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗱𝗮𝘀𝗵𝗯𝗼𝗮𝗿𝗱 that "feels slow and messy" has one root cause.
https://www.linkedin.com/feed/update/urn:li:share:7482649043878375424/ | 1 033 |
| 19 | 𝗜 𝗳𝗮𝗶𝗹𝗲𝗱 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝘁 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗯𝗲𝗰𝗮𝘂𝘀𝗲 𝗼𝗳 𝗼𝗻𝗲 𝗚𝗥𝗢𝗨𝗣 𝗕𝗬 𝗺𝗶𝘀𝘁𝗮𝗸𝗲.
https://www.linkedin.com/feed/update/urn:li:share:7482281819254542336/ | 1 167 |
| 20 | Before I learned 𝘄𝗶𝗻𝗱𝗼𝘄 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀, my queries looked like this:
https://www.linkedin.com/feed/update/urn:li:activity:7481550338576216065/ | 1 196 |
