Data Careers Resources & Job Updates | iamrupnath

I used to confuse 𝗜𝗡𝗡𝗘𝗥 𝗝𝗢𝗜𝗡 and 𝗟𝗘𝗙𝗧 𝗝𝗢𝗜𝗡. Every single time. https://www.linkedin.com/feed/update/urn:li:share:7481195414138920960/

_Best practices:_ ✔️ Create indexes ✔️ Avoid SELECT _ ✔️ Filter early ✔️ Optimize joins ✔️ Use execution plans _25. What are Views?_ Virtual tables based on SQL queries. CREATE VIEW EmployeeView AS SELECT EmployeeID, EmployeeName FROM Employees; _26. What are Stored Procedures?_ Reusable SQL programs stored in database. _Benefits:_ ✔️ Faster execution, ✔️ Reusable code, ✔️ Better security _27. What are Transactions?_ A group of SQL operations treated as one unit. _Example:_ Bank transfer transaction. _Commands:_ BEGIN TRANSACTION; COMMIT; ROLLBACK; _28. Explain ACID Properties_ _Atomicity:_ All or nothing. _Consistency:_ Data remains valid. _Isolation:_ Transactions don't interfere. _Durability:_ Committed changes stay permanent. _29. Find Duplicate Records_ SELECT Email, COUNT(*) FROM Customers GROUP BY Email HAVING COUNT(*) > 1; _30. Find Second Highest Salary_ SELECT MAX(Salary) FROM Employees WHERE Salary < ( SELECT MAX(Salary) FROM Employees ); _31. Calculate Running Totals_ SELECT OrderDate, Sales, SUM(Sales) OVER (ORDER BY OrderDate) AS RunningTotal FROM Orders; _32. Find Top Selling Products_ SELECT ProductName, SUM(Sales) AS TotalSales FROM Orders GROUP BY ProductName ORDER BY TotalSales DESC; _33. Calculate Month-over-Month Growth_ SELECT Month, Sales, LAG(Sales) OVER(ORDER BY Month) AS PreviousMonth FROM SalesData; _34. Difference Between UNION and UNION ALL?_ _UNION:_ Removes duplicates. _UNION ALL:_ Keeps duplicates. UNION ALL is faster. _35. What are NULL Values?_ NULL means missing or unknown value. SELECT * FROM Employees WHERE ManagerID IS NULL; _36. Difference Between CHAR and VARCHAR?_ _CHAR:_ Fixed length. _VARCHAR:_ Variable length. VARCHAR saves storage. _37. What is a Primary Key?_ A unique identifier for each record. _Properties:_ ✔️ Unique, ✔️ Not NULL _38. What is a Foreign Key?_ Maintains relationships between tables. Ensures referential integrity. _39. Difference Between Clustered and Non-Clustered Indexes?_ _Clustered Index:_ Stores actual table data. Only one per table. _Non-Clustered Index:_ Separate structure pointing to data. Multiple allowed. _40. Explain Query Execution Plans_ Execution plans show how SQL Server executes a query. _Used to identify:_ ✔️ Full table scans, ✔️ Expensive joins, ✔️ Missing indexes, ✔️ Performance bottlenecks _💡 Most Data Analyst SQL interviews focus heavily on:_ - Joins - Group By - Window Functions - CTEs - Subqueries - Ranking Functions - Real-world SQL scenarios _Double Tap ❤️ For Part-2_ 🚀

_🚀 Data Analytics Interview Questions & Answers – SQL (Part 1) 📊🔥_ _1. What is SQL?_ _Answer:_ SQL (Structured Query Language) is used to communicate with relational databases. It helps retrieve, insert, update, and delete data. SELECT * FROM Employees; _2. What is the difference between SQL and MySQL?_ _SQL_ : A language _MySQL_ : A database system _SQL_ : Used to write queries _MySQL_ : Executes SQL queries _SQL_ : Standard language _MySQL_ : Software product _3. What are Primary Keys and Foreign Keys?_ _Primary Key:_ Uniquely identifies each row in a table. _Foreign Key:_ Creates a relationship between two tables. _Example:_ - EmployeeID → Primary Key - DepartmentID → Foreign Key _4. What is Normalization?_ _Answer:_ Normalization organizes data into multiple related tables to reduce redundancy and improve data integrity. _Benefits:_ ✔️ Reduces duplicate data ✔️ Improves consistency ✔️ Saves storage _5. What is Denormalization?_ _Answer:_ Denormalization combines tables to improve query performance. _Benefits:_ ✔️ Faster reporting ✔️ Faster data retrieval _Drawback:_ ❌ More redundancy _6. Difference Between WHERE and HAVING?_ _WHERE:_ Filters rows before aggregation. _HAVING:_ Filters groups after aggregation. SELECT Department, COUNT(*) FROM Employees GROUP BY Department HAVING COUNT(*) > 10; _7. Difference Between DELETE, DROP, and TRUNCATE?_ _DELETE:_ Removes selected rows. DELETE FROM Employees WHERE EmployeeID = 101; _TRUNCATE:_ Removes all rows. TRUNCATE TABLE Employees; _DROP:_ Deletes entire table structure. DROP TABLE Employees; _8. Difference Between INNER JOIN and LEFT JOIN?_ _INNER JOIN:_ Returns matching records only. _LEFT JOIN:_ Returns all records from left table and matching records from right table. SELECT * FROM Employees E LEFT JOIN Departments D ON E.DepartmentID = D.DepartmentID; _9. What is RIGHT JOIN?_ Returns all rows from the right table and matching rows from the left table. _10. What is FULL OUTER JOIN?_ Returns all matching and non-matching rows from both tables. _11. What is SELF JOIN?_ A table joined with itself. _Example:_ Employee and Manager stored in same table. _12. What is CROSS JOIN?_ Returns every possible combination of rows. _If:_ - Table A = 5 rows - Table B = 4 rows _Result = 20 rows_ _13. What are Aggregate Functions?_ Used to perform calculations. _Examples:_ COUNT(), SUM(), AVG(), MIN(), MAX() _14. Difference Between COUNT and COUNT DISTINCT?_ _COUNT(EmployeeID):_ Counts all values. _COUNT(DISTINCT DepartmentID):_ Counts unique values only. _15. What is GROUP BY?_ Groups rows with similar values. SELECT Department, COUNT(*) FROM Employees GROUP BY Department; _16. Difference Between GROUP BY and ORDER BY?_ _GROUP BY:_ Groups data. _ORDER BY:_ Sorts data. _17. What is a Subquery?_ A query inside another query. SELECT * FROM Employees WHERE Salary > ( SELECT AVG(Salary) FROM Employees ); _18. What are CTEs?_ Common Table Expressions create temporary result sets. WITH SalesCTE AS ( SELECT * FROM Sales ) SELECT * FROM SalesCTE; _Benefits:_ ✔️ Readability ✔️ Reusability _19. What are Window Functions?_ Perform calculations without collapsing rows. _Examples:_ ROW_NUMBER(), RANK(), DENSE_RANK() _20. Explain ROW_NUMBER()_ Assigns unique numbers. SELECT EmployeeName, ROW_NUMBER() OVER (ORDER BY Salary DESC) AS RankNo FROM Employees; _21. Explain RANK() and DENSE_RANK()_ _RANK():_ Ranks with gaps. Example: 1, 2, 2, 4 _DENSE_RANK():_ Ranks without gaps. Example: 1, 2, 2, 3 _22. What are Indexes?_ Indexes improve query speed. _Benefits:_ ✔️ Faster searches, ✔️ Faster filtering _Drawback:_ ❌ Extra storage _23. What Causes Slow SQL Queries?_ _Common reasons:_ ✔️ Missing indexes ✔️ Too many joins ✔️ Large datasets ✔️ SELECT _ usage ✔️ Unoptimized subqueries _24. How Do You Optimize SQL Queries?_

_🚀 *Power BI Roadmap: Zero → Dashboard Hero → Job Ready*_ 📊✨ _🎯 Who Is This For?_ Beginners who want to master Power BI for Data Analyst/BI roles. Goal: Clean data, build dashboards, tell stories, crack BI interviews. ── *1️⃣ Power BI Basics* ├── *Install:* Power BI Desktop + Create free account ├── *UI Tour:* Ribbon, Fields, Visualizations, Filters pane ├── *Data Sources:* Excel, CSV, SQL Server, Web, SharePoint └── *Query Editor vs Report View vs Model View* ── *2️⃣ Power Query: Data Cleaning* 🧹 ├── Import & Transform Data ├── Remove Columns, Filter Rows, Change Data Types ├── Split Columns, Merge, Append Queries ├── Unpivot Data for analysis ├── Date/Time, Text, Number transformations └── *Best Practice:* Keep steps documented + renamed ── *3️⃣ Data Modeling* 🗄 ├── *Star Schema:* Fact + Dimension tables ├── Relationships: One-to-Many, Many-to-One, Cardinality ├── Active vs Inactive relationships + USERELATIONSHIP() ├── Primary Key, Foreign Key concepts └── *Golden Rule:* Model first, visualize second ── *4️⃣ DAX: The Brain of Power BI* 🧠 ├── *Calculated Columns vs Measures* – know the difference ├── *Basic DAX:* SUM, AVERAGE, COUNT, DIVIDE, IF ├── *Filter Context:* CALCULATE, FILTER, ALL, ALLEXCEPT ├── *Time Intelligence:* YTD, QTD, MTD, DATEADD, SAMEPERIODLASTYEAR ├── *Iterator Functions:* SUMX, AVERAGEX └── *Variables:* VAR + RETURN for readable DAX ── *5️⃣ Visualization & UX* 🎨 ├── *Charts:* Bar, Line, Combo, Scatter, TreeMap, Map, Funnel ├── *Cards + KPIs + Gauges* for key metrics ├── *Slicers + Filters + Drill-through* for interactivity ├── *Bookmarks + Buttons + Page Navigation* for app-like feel ├── *Themes:* Colors, Fonts, Corporate branding └── *Storytelling:* Titles, Insights, Tooltips, Annotations ── *6️⃣ Advanced Power BI* 🚀 ├── *Row Level Security:* Static + Dynamic RLS ├── *Parameters:* What-if analysis, Field Parameters ├── *Python/R Visuals* for custom charts ├── *Incremental Refresh* for large datasets └── *Power BI Service:* Publish, Schedule Refresh, Gateways ── *7️⃣ Portfolio Projects* 🧠 ├── *Project 1:* Sales Dashboard │ ├── KPIs: Revenue, Profit, Growth %, Top 5 Products │ └── Filters: Region, Year, Category + Drill-down ├── *Project 2:* HR Analytics Dashboard │ ├── Attrition Rate, Headcount, Diversity, Avg Tenure │ └── RLS for Manager vs HR view ├── *Project 3:* Financial Dashboard │ ├── P&L, Budget vs Actual, Variance Analysis │ └── Time Intelligence + Forecast └── *Share:* Publish to Web + Add to Portfolio + LinkedIn post ── *8️⃣ Interview Prep for BI Roles* 💼 ├── *Concepts:* Star Schema, DAX, RLS, Incremental Refresh ├── *Scenarios:* “Sales dropped 20% – how will you debug?” ├── *Live Test:* Given raw Excel, build dashboard in 45 mins ├── *Explain:* Your projects end-to-end + business impact └── *Questions to Ask:* Data sources, refresh frequency, user base ── *9️⃣ Next Steps After Power BI* 📈 ├── *SQL Advanced:* For faster data prep ├── *Python:* For complex transformations + ML integration ├── *Power Platform:* Power Apps + Power Automate └── *Certifications:* PL-300 Microsoft Power BI Data Analyst ── *🔁 30-Day Power BI Sprint* ├── *Days 1-5:* Power Query + Data Cleaning ├── *Days 6-10:* Data Modeling + Relationships ├── *Days 11-20:* DAX Measures + Time Intelligence ├── *Days 21-25:* Dashboard Design + UX └── *Days 26-30:* 2 Full Projects + Publish + Resume Update _💡 Golden Rule_ A good dashboard answers questions. A great dashboard asks better questions. _Double Tap ❤️ For More_

*Microsoft interview experience for Software Engineer II (L62) role* : ⏳ The process: 1️⃣ Online Assessment 2️⃣ Recruiter call: 3 days later 3️⃣ Interview loop scheduled: 7 days later 4️⃣ 1 DSA round 5️⃣ 1 LLD round 6️⃣ 1 HLD round 7️⃣ 1 AA round 💻 The interviews: 1️⃣ OA round: 2 medium problems on HackerRank; 60 mins timer. - Shortest directed cycle for every node in a weighted graph. - Given array of servers that are connected in a cluster if they share a common factor (GCD > 1). Return the size of the cluster for each server. - Solved 1st one fast ~15 min. - And the 2nd one in about 25 min. All 15 visible test cases passed. If you're familiar with Djikstra and DSU mediums on LC, you can solve both of these. 2️⃣ DSA round: - Brief intro + discussion about my tech stack. - Asked for a challenge my team faced. - Then 2 DSA questions: a. Longest Subarray with max difference = k. b. Count submatrices that have sum = k. - The first problem was straight up sliding window. - The second one was objectively a hard. After some time, I was able to give the optimal approach. The interviewer seemed satisfied and said they did not expect the code for second one anyway. 3️⃣ Round 3: LLD Design an In-Memory File System. - I gave my understanding of a file system. - Named a few public APIs we'd need - create(), delete(), ls(), mkdir(). - Then coded 3 of the functions. - The interviewer asked me about the underlying DSA. - To which I answered Trie and explained how it models nested directories. - Also touched on Composite, Factory and Singleton design patterns. This round went well. 4️⃣Round 4: HLD Design a notification service to send Emails and SMS. - I designed the overall system, APIs, queues, workers, retries, etc. - Later, the interviewer said that what I have made is fine but they wanted focus on different notification types: Urgent, Promotional and Transactional. 🎯 Result: - Positive feedback on OA, DSA and LLD. - Negative for the HLD round. As a result, they did not proceed with the final AA round. :") Overall, the DSA problems were same/similar to Leetcode mediums. The LLD and HLD questions are also in common design prep books. The only challenge, in design rounds, was that you had to accurately decipher what the interviewer is looking for. 📚 My learnings from this interview loop Microsoft: - HLD is *not just* about solving the problem. It is about what the interviewer is looking for in that problem. - Time spent on requirement gathering is worth it. Prevents unnecessary design work. - Keep reading interviewer's reaction. If they're not engaging, you are likely optimizing for the wrong thing. - Give a few mocks to peers/seniors. Explaining while drawing out boxes takes some getting used to. Save this. I interviewed with Microsoft again shortly after this loop. If you found this useful, you'll find the other one to be even more.

Most dashboard errors don't come from Power BI or Tableau. They start with one SQL JOIN. And nobody notices until decisions are already being made. Full post 👇 https://www.linkedin.com/feed/update/urn:li:share:7470012471056084992/

I Learned SQL for 3 Months. Why Am I Still Failing Interviews? https://www.linkedin.com/feed/update/urn:li:share:7469964025611579392/

ZOMATO SQL Interview Questions and Answers https://www.linkedin.com/feed/update/urn:li:activity:7468152423916851200/

🔋🔥 3 Hidden Settings to Double Your Phone Battery Life 😳 Charging your phone 2–3 times daily? Always carrying a power bank? 😩 👉 These hidden Android settings may help improve battery life instantly. 🔹 1. Turn OFF Hidden Wi-Fi & Bluetooth Scanning 📶 Even when Wi-Fi & Bluetooth look OFF… your phone may still scan for networks in the background 😳 👉 Go to: Settings → Location → Wi-Fi & Bluetooth Scanning Turn both OFF. 💥 Result: Less background scanning = better battery life 🔋 🔹 2. Use Dark Mode on AMOLED Phones 🌑 If your phone has an AMOLED display: 👉 Go to Settings 👉 Turn ON Dark Mode 💥 Why it helps: Black pixels on AMOLED screens consume much less power. 🔹 3. Disable Haptics/Vibration ⚡ Every tap vibration uses a small motor inside the phone. 👉 Go to: Settings → Sound & Vibration → Haptics / System Haptics Turn it OFF. 💥 Result: Less vibration = reduced battery usage. ⚡ Why These Tricks Matter • Less background battery drain • Longer battery backup • Better performance on older phones 📌 Save this post before you forget these settings 📤 Share with friends who are always searching for a charger 😏🔋

FREE sites to improve your coding knowledge👨🏻‍💻📝 🌐 HTML - w3schools.com 💅 CSS - web.dev/learn/css 🔥 JavaScript - javascript.info 🐙 Git and Github - git-scm.com 📚 API - https://free-apis.github.io/#/ 🐍 Python - learnpython.org ⚛️ React - react-tutorial.app 🎡 Laravel - laracasts.com 🌟 VueJS - learnvue.co 🔍 SQL - SQLbolt.com 🌈 Tailwind CSS - tailwindcss.com 🚀 Go - gobyexample.com 🐳 Docker - docker-curriculum.com 🦋 Flutter - flutter.dev/learn 🦀 Rust - rust-lang.org/learn #techinfo 🧠 AI/ML - fast.ai ⚙️ DevOps - roadmap.sh/devops 🧩 TypeScript - https://www.codecademy.com/learn/learn-typescript

80% of your time will be this: Cleaning data. Blank cells. Duplicate rows. Dates in 7 different formats. https://www.linkedin.com/feed/update/urn:li:share:7460899274147520513/

2025 tools helped you work faster. 2026 tools will replace how you think, search, create & automate. Most people are still using AI like Google search. That’s the gap. 👀 Which tool surprised you the most? 🚀 Follow @iamrupnath for more AI content.

241 people voted Python the most valuable skill in 2026. The job market disagrees. Here's the real data: → SQL appears in 80% of analyst job postings → Python appears in 60% → Yet 46% of you voted Python. Only 29% voted SQL. People want to learn Python. Companies are hiring for SQL. https://www.linkedin.com/feed/update/urn:li:share:7459817626186321920/

✅ How to Use AI to Learn 10x Faster 🤖⚡️ 1️⃣ Don't Ask for Answers → Asking ChatGPT to write your code teaches you nothing. → Ask it to "explain the logic behind this function like I'm 5." 2️⃣ Build a Custom Tutor → Tell AI your exact background (e.g., "I am an accountant switching to tech"). → Ask it to explain new concepts using analogies from your old job. 3️⃣ Debug Without Cheating → When your code breaks, don't just paste the error. → Ask the AI: "Give me a hint on which line is broken, but don't solve it." 🧠 Pro Tip: Use AI as a senior mentor, not a magical answer key. ❤️ Double Tap for More

The Python Trap for Beginners 🐍❌ 1️⃣ Skipping the Basics → Many beginners jump straight into Python or Machine Learning. → They fail interviews because they can't write a basic SQL query. 2️⃣ The Real World Hierarchy → 70% of business problems can be solved with Excel or SQL. → Python is powerful, but it's often overkill for daily reporting tasks. 3️⃣ The Winning Order → Master Excel (Pivot Tables, XLOOKUP) first. → Master SQL (Joins, CTEs) second. Learn Python last. 🧠 Pro Tip: Walk before you run. A master of SQL is more hirable than a beginner in Python. ❤️ Double Tap for More