Data Careers Resources & Job Updates | iamrupnath

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/