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
Больше📈 Аналитический обзор Telegram-канала Data Careers Resources & Job Updates | iamrupnath
Канал Data Careers Resources & Job Updates | iamrupnath (@codewithrup) языкового сегмента Английский является активным участником. Сейчас сообщество объединяет 20 762 подписчиков, занимая 6 185 место в категории Технологии и приложения и 19 620 место в регионе Индия.
📊 Показатели аудитории и динамика
С момента создания невідомо проект демонстрирует стремительный рост, собрав аудиторию из 20 762 подписчиков.
Согласно последним данным от 18 сентября, 2026, канал показывает стабильную активность. За последние 30 дней изменение числа участников составило -354, а за последние 24 часа — -9, при этом общий охват остаётся высоким.
- Статус верификации: Не верифицирован
- Уровень вовлечённости (ER): Средний показатель вовлечённости аудитории составляет 3.78%. В первые 24 часа после публикации контент обычно набирает 1.17% реакций от общего числа подписчиков.
- Охват публикаций: В среднем каждый пост получает 786 просмотров. В течение первых суток публикация набирает 243 просмотров.
- Реакции и взаимодействия: Аудитория активно поддерживает контент: среднее количество реакций на один пост — 0.
- Тематические интересы: Контент сосредоточен на ключевых темах, таких как 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”
Благодаря высокой частоте обновлений (последние данные получены 19 сентября, 2026) канал поддерживает актуальность и высокий уровень охвата публикаций. Аналитика показывает, что аудитория активно взаимодействует с контентом, что делает его важной точкой влияния в категории Технологии и приложения.
20 762
Подписчики
-924 часа
-817 дней
-35430 дней
Архив постов
Arcadis is hiring Graduate Engineer
For 2022, 2023, 2024, 2025 grads
Location: Bangalore
https://jobs.arcadis.com/careers/job/563671532643966?domain=arcadis.com
Notion is hiring Software Engineer (Developer Expereince)
For 2015, 2016, 2017 grads
Location: Hyderabad
https://jobs.ashbyhq.com/notion/49bdf081-6e20-4323-8c73-6d6b19544ff5
𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄e𝗿:
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee Department Salary
John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000
How would you find the second highest salary in the IT department?
𝗠𝗲: Challenge accepted! 💪
=LARGE(FILTER(C2:C6,B2:B6="IT"),2)
💡 Explanation:
This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.
- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.
The result is 75,000.
This challenge tests your understanding of: ✅ FILTER()
✅ LARGE()
✅ Conditional Filtering
✅ Combining Excel Functions
🚀 Bonus (Without FILTER)
For older Excel versions, you can use:
=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)
Here:
14 represents LARGE.
6 ignores errors.
B2:B6="IT" filters the calculation to the IT department.
2 returns the second largest value.
❤️ React with ❤️ for more Excel interview challenges!
“Your resume says you know SQL.
But can you actually think in SQL?”
This can become a technical + career post.
Give a simple example:
https://www.linkedin.com/feed/update/urn:li:share:7493510053992439809/
6 parts to a 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁's job.
AI is already taking some of them.
Not all.
Some.
It will expose weak ones.
https://www.linkedin.com/feed/update/urn:li:share:7492169595961688064/
𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 𝗶𝘀 𝗻𝗼𝘁 𝘁𝗵𝗲 𝘀𝗮𝗳𝗲 𝗱𝗲𝗳𝗮𝘂𝗹𝘁.
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand what each one does to unmatched rows.
Here's the breakdown that actually matters:
https://www.linkedin.com/feed/update/urn:li:share:7490972311278407680/
Google, PwC, Salesforce, Adobe, IBM, EY.
All hiring. Right now.
August and September are peak hiring months.
https://www.linkedin.com/feed/update/urn:li:activity:7490613808328224768/
✅ Power BI Interview Questions 🎯📊
1️⃣ What is Power BI?
A Microsoft tool for data visualization, reporting, and business intelligence.
2️⃣ What are the building blocks of Power BI?
• Datasets
• Reports
• Dashboards
• Tiles
• Visualizations
3️⃣ Difference between Power BI Desktop and Power BI Service?
• Desktop: Used to create and design reports
• Service: Cloud-based platform to share and collaborate
4️⃣ What is Power Query?
A data transformation tool for cleaning and shaping data before loading into the model.
5️⃣ What is DAX?
Data Analysis Expressions – a formula language used for calculations in Power BI.
6️⃣ What are measures and calculated columns?
• Measure: Calculated on aggregation (e.g. SUM of sales)
• Calculated Column: Row-level computation (e.g. profit = revenue - cost)
7️⃣ What is a slicer?
A visual filter that allows users to dynamically filter data on a report.
8️⃣ How do you handle data refresh in Power BI?
• Schedule refresh via Power BI Service
• Use gateways for on-prem data sources
9️⃣ What is the difference between direct query and import mode?
• Import: Data is loaded into Power BI
• Direct Query: Queries run directly on the source in real time
🔟 What is the Power BI Gateway?
A bridge between on-premise data sources and Power BI cloud service.
💬 Tap ❤️ for more
𝗭𝗲𝗽𝘁𝗼 𝗹𝗼𝘀𝗲𝘀 𝗥𝘀.𝟳𝟵 𝗼𝗻 𝗲𝘃𝗲𝗿𝘆 𝗼𝗿𝗱𝗲𝗿. 𝗔𝘀𝗸𝗶𝗻𝗴 𝗳𝗼𝗿 𝗮 𝗥𝘀.𝟲𝟯,𝟬𝟬𝟬 𝗰𝗿𝗼𝗿𝗲 𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻.
Broke down Zepto's DRHP: the revenue model, the real cost per order, where the actual profit comes from, and the red flags most people are missing.
Also stacked it against DMart's numbers for context.
A DRHP is a public dataset. Learning to read one is a skill most analysts skip.
Read more: https://www.linkedin.com/feed/update/urn:li:share:7488884143083347968/
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/✅ 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!
𝗜 𝗽𝗿𝗲𝗽𝗮𝗿𝗲𝗱 𝗦𝗤𝗟 𝗳𝗼𝗿 𝗺𝘆 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗶𝗻 𝟳 𝗱𝗮𝘆𝘀.
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/
