Data Careers Resources & Job Updates | iamrupnath

_🚀 *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

Snowflake is hiring Data Engineer Intern For 2026, 2027 gards Location: Pune https://careers.snowflake.com/us/en/job/SNCOUS97879D11040B471CAB908A9497E6D01EEXTERNALENUS8904ED8575D648CFB01B7941677FDE4A/Data-Engineer-Intern-Pune-2026

✅ The 90-Day Execution Plan to Switch Careers in 2026 ⏳🚀 1️⃣ Days 1–30: Avoid "Course Overload" → Stop buying 10 different courses. Pick ONE core skill (like SQL or Power BI) for 30 days. → Master the basics by writing code, not just watching videos. 2️⃣ Days 31–60: Master AI Prompt Engineering → You can't ignore AI in 2026. Use it as your personal tutor. → Learn how to prompt AI to debug your code, explain complex syntax, or generate mock business data. 3️⃣ Days 61–90: Build a "Decision-Driving" Project → Great dashboards drive decisions; they don't just look pretty. → Build something real, like analyzing fresh funding announcements in the startup ecosystem, to show you understand business value. 4️⃣ Transition to "Income Extraction" → Stop passive learning and start actively putting your skills out there. → Share your daily progress and data stories on LinkedIn to catch a recruiter's eye. 🧠 Reality Check: 90% of people will fail to switch careers this year because they stay stuck in passive learning instead of building. ❤️ Double Tap for More

✅ 5 AI Tools to Hack Your Career Switch 🚀🤖 1️⃣ ChatGPT / Gemini for Interview Prep → Don't just ask for generic interview answers. → Prompt the AI to act as a strict hiring manager for your target role. → Ask it to grill you on your resume's weak points! 2️⃣ Teal / Huntr for Resume Tailoring → Stop sending the exact same resume to 50 different jobs. → These AI tools match your resume keywords directly to the job description. → They help you bypass the ATS (Applicant Tracking System) filters. 3️⃣ Perplexity AI for Deep Company Research → Skip basic Google searches before your next interview. → Use Perplexity to summarize recent news, tech stacks, and competitors. → Drop these insights during the interview to instantly impress recruiters. 4️⃣ Hemingway / Grammarly for Cold Emails → Networking on LinkedIn requires crisp, direct communication. → Use these to ensure your outreach is punchy, professional, and fluff-free. → Nobody replies to a confusing, 4-paragraph cold message. 5️⃣ Cursor / GitHub Copilot for Fast Learning → If you are learning SQL or Python, don't stay stuck on syntax errors for days. → Use AI coding assistants to explain complex logic line-by-line. → Treat them as your 24/7 personal tutor, not just a shortcut to copy-paste. 🧠 Pro Tip: AI won't automatically hand you a job, but it will make you 10x faster than the applicant refusing to use it. ❤️ Double Tap for More

𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝘁𝗼 𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 🔥 👉 LinkedIn Connect: https://www.linkedin.com/in/rupnath-shaw/ 1️⃣ Core Skills Every Data Analyst Must Learn 📈 Excel/ Spreadsheets Skills: – Formulas (IF, VLOOKUP/XLOOKUP) – Pivot Tables – Charts – Power Query (basic) Excel - https://www.w3schools.com/excel/ 2️⃣ SQL (Most Important Skill) Skills: – SELECT, WHERE, ORDER BY – JOINs – GROUP BY, HAVING – Subqueries & CTEs – Window Functions SQL - https://www.w3schools.com/sql/ 3️⃣ Python for Data Analysis Skills: – pandas – numpy – matplotlib – seaborn – Data cleaning & EDA Python - https://www.w3schools.com/python/ 4️⃣ Data Visualization Tools Power BI & Tableau Skills: – Data modeling – DAX basics – Filters & slicers – Dashboard design Power BI - https://www.datacamp.com/tutorial/tutorial-power-bi-for-beginners Tableau - https://www.datacamp.com/tutorial/tableau-tutorial-for-beginners For Free resources below channels are best & don't forget to join & share invitation with others as well 👉 WhatsApp Channel: https://whatsapp.com/channel/0029VaAVyoAEawe0EEAA4d1h Don't forget to share with others who are looking for learning more about Data Analyst 🙌 ☺️ Till then keep learning & keep exploring 🙌☺️