tgindex

Career Connect India - Analytics Adda

описание

This channel is all about technology and jobs updates. Join my WhatsApp Channel - https://whatsapp.com/channel/0029VajSCJP2Jl8EEDRRKp0F Connect with me for Best Career Advice: https://topmate.io/shivan_kumar1/110983

← к каналу@analyticsadda
9 903
подписчиков
Охват к подписчикам
28,4%
ERR
Реакции к просмотрам
0,10%
60 на 21 постов
Пересылки к просмотрам
0,24%
140
Постов в день
0,0
всего 21

Где отзываются чаще

доля реакций к просмотрам
  • 30 авг. 2025 г.Complete Data Analyst Interview Guide (0–2 Years of Experience) 🔹 Round 1: SQL + Scenario-Based Questions Q1. Get top 3 products by revenue within each category SELECT * FROM ( SELECT p.product_id, p.category, SUM(o.revenue) AS total_revenue, RANK() OVER(PARTITION BY p.category ORDER BY SUM(o.revenue) DESC) AS rnk FROM products p JOIN orders o ON p.product_id = o.product_id GROUP BY p.product_id, p.category ) ranked WHERE rnk <= 3; Q2. Find users who purchased in January but not in February SELECT DISTINCT user_id FROM orders WHERE MONTH(order_date) = 1 AND user_id NOT IN ( SELECT user_id FROM orders WHERE MONTH(order_date) = 2 ); Q3. Avg. ride time by city + peak hours SELECT city, AVG(DATEDIFF(MINUTE, start_time, end_time)) AS avg_ride_mins FROM trips GROUP BY city; -- For peak hour detection (example logic) SELECT DATEPART(HOUR, start_time) AS ride_hour, COUNT(*) AS ride_count FROM trips GROUP BY DATEPART(HOUR, start_time) ORDER BY ride_count DESC; ⸻ 🔹 Round 2: Python + Data Cleaning Q1. Clean messy CSV with pandas import pandas as pd df = pd.read_csv('data.csv') df.columns = df.columns.str.strip().str.lower() df.drop_duplicates(inplace=True) df['date'] = pd.to_datetime(df['date'], errors='coerce') df.fillna(method='ffill', inplace=True) Q2. Extract domain names from email IDs emails = ['abc@gmail.com', 'xyz@outlook.com'] domains = [email.split('@')[1] for email in emails] Q3. Difference: .loc[] vs .iloc[] • .loc[] → label-based selection • .iloc[] → index-based selection Q4. Handle outliers using IQR Q1 = df['column'].quantile(0.25) Q3 = df['column'].quantile(0.75) IQR = Q3 - Q1 filtered_df = df[(df['column'] >= Q1 - 1.5*IQR) & (df['column'] <= Q3 + 1.5*IQR)] ⸻ 🔹 Round 3: Power BI / Dashboarding Tasks you should know: • Create a dashboard with weekly trends, margins, churn % • Use bookmarks/slicers for KPI toggles • Apply filters to show top 5 items dynamically • Exclude visuals from slicer using “Edit Interactions” → turn off filter icon on card visual 🔗 Try replicating dashboards from Power BI Gallery ⸻ 🔹 Round 4: Business Case + Logic-Based Thinking Q1. Sales dropped last quarter — what to check? • Compare YoY/QoQ data • Identify categories/geos with the biggest drop • Analyze order volume vs. avg. order value • Check marketing spend, discounts, stockouts Q2. App downloads ⬆️, activity ⬇️ — what’s wrong? • Check Day 1/7/30 retention • Is onboarding working? • UI bugs or crashes? • Compare install → sign-up → usage funnel Q3. Returns increasing — how to investigate? • Analyze return % by brand, category, SKU • Check return reasons (defects, sizing, etc.) • Compare returners’ order history • Seasonal impact? ⸻ 🔰 Free Practice Tools: • 🔹 SQL on LeetCode • 🔹 Python on Hackerrank • 🔹 Power BI Gallery0,45%
  • 13 июн.💰 Want to start earning with AI SaaS without building from scratch? I’ve already built 4 complete, ready-to-sell AI products for working professionals & founders. No coding. No months of effort. Just plug, launch, and monetize 🚀 🔥 What’s available: 🎙️ DriveU Voice Onboarding Agent – Automate user onboarding via voice AI 🏥 AI Appointment Automation (Healthcare) – Reduce no-shows & manage bookings smartly 💼 Voice AI Hiring Portal – End-to-end recruitment with AI interviews 📊 AI CRM for Candidate Shortlisting – Hire faster with intelligent filtering 💡 These are fully built, ready-to-deploy systems (not just ideas) 👉 If you want to own, use, or resell these: https://topmate.io/shivan_kumar1 DM me if you want demo access or details.0,37%
  • 23 янв. 2025 г.7 Best GitHub Repositories to Break into Data Analytics and Data Science If you're diving into data science or data analytics, these repositories will give you the edge you need. Check them out: 1️⃣ 100-Days-Of-ML-Code 🔗 https://github.com/Avik-Jain/100-Days-Of-ML-Code ⭐️ Stars: ~42k 2️⃣ awesome-datascience 🔗 https://github.com/academic/awesome-datascience ⭐️ Stars: ~22.7k 3️⃣ Data-Science-For-Beginners 🔗 https://github.com/microsoft/Data-Science-For-Beginners ⭐️ Stars: ~14.5k 4️⃣ data-science-interviews 🔗 https://github.com/alexeygrigorev/data-science-interviews ⭐️ Stars: ~5.8k 5️⃣ Coding and ML System Design 🔗 https://github.com/weeeBox/coding-and-ml-system-design ⭐️ Stars: ~3.5k 6️⃣ Machine Learning Interviews from MAANG 🔗 https://github.com/arunkumarpillai/Machine-Learning-Interviews ⭐️ Stars: ~8.1k 7️⃣ data-science-ipython-notebooks 🔗 https://github.com/donnemartin/data-science-ipython-notebooks ⭐️ Stars: ~27.2k Explore these amazing resources and take your data science journey to the next level! 🚀 #DataScience #DataAnalytics #GitHub #MachineLearning #CodingSkills0,32%
  • 27 авг. 2025 г.Zomato is hiring AI Engineers (2–5 yrs exp) for our GenAI team What you’ll do: • Build evaluation pipelines for model quality & performance • Optimize LLMs (fine-tuning, LoRA, quantization, distillation) • Apply prompting strategies (zero/few-shot, CoT, RAG) • Develop agentic AI systems (reasoning + retrieval + automation) • Work across text, image, video & voice generation • Strong ML + data engineering foundation Nice to have: • System design, ML deployment, Docker/K8s • Cloud ML (AWS SageMaker / GCP Vertex AI / Azure ML) If you love building at the edge of GenAI, send us your resume at genaihiring@zomato.com0,31%
  • 30 авг. 2025 г.👋 Say Bye Bye to basic YouTube tutorials! It’s time to Build Production-Ready POCs & MVPs for Industry. 🚀 From next week, I’m starting a new batch on Building a Production-Grade Agentic AI System – all within the price of 2 pizzas 🍕🍕. The goal is simple: 👉 Help the community move beyond toy projects 👉 Learn to design real-world, industry-standard applications 👉 Gain hands-on experience with FastAPI, Streamlit, CrewAI & MongoDB If you want to build AI products that actually scale in the real world, this is for you. 💡 📩 Enroll here → https://topmate.io/shivan_kumar1/1700938 Complete Syllabus: https://docs.google.com/spreadsheets/d/1qKKC2j90KEkyRlrLXNExgoxyjdB4X2Oa2vtWg8UEM7A/edit ⚡ Limited seats only for this batch! ⏳ Price will increase by evening — enroll fast!0,28%
  • 9 нояб.🚨 𝐁𝐢𝐠𝐠𝐞𝐬𝐭 𝐒𝐜𝐡𝐨𝐥𝐚𝐫𝐬𝐡𝐢𝐩 𝐀𝐥𝐞𝐫𝐭 𝐟𝐨𝐫 𝐈𝐧𝐝𝐢𝐚𝐧 𝐒𝐭𝐮𝐝𝐞𝐧𝐭𝐬! 🚨 Hey everyone! If you're a school or college student dreaming of financial support to fuel your education, this is your moment. Top companies are stepping up with massive scholarships to help you thrive: 💰 Amazon Future Engineer Scholarship: Up to ₹𝟐,𝟎𝟎,𝟎𝟎𝟎 for undergrads in Computer Science & related fields Apply here:- https://www.amazonfutureengineer.in/scholarship-and-internship 💰 HDFC Bank Scholarship: ₹𝟕𝟓,𝟎𝟎𝟎 to ease your academic journey 💰 Kotak Kanya Scholarship: ₹𝟏,𝟓𝟎,𝟎𝟎𝟎 empowering young women in professional courses 💰 SBI Platinum Jubilee Asha Scholarship: Up to ₹𝟏,𝟎𝟎,𝟎𝟎𝟎 (and more for higher studies—details: https://www.sbiashascholarship.co.in/ These opportunities are open to students across India, covering everything from school fees to college tuition. To simplify things, I've put together a comprehensive PDF guide packed with everything you need to apply successfully: ✅ 𝐀𝐥𝐥 𝐭𝐡𝐞 𝐜𝐮𝐫𝐫𝐞𝐧𝐭 𝐬𝐜𝐡𝐨𝐥𝐚𝐫𝐬𝐡𝐢𝐩𝐬 (including Amazon, HDFC, Kotak, SBI, and extras) ✅ 𝐃𝐢𝐫𝐞𝐜𝐭 𝐚𝐩𝐩𝐥𝐲 𝐥𝐢𝐧𝐤𝐬—no hunting required! ✅ 𝐂𝐨𝐦𝐩𝐥𝐞𝐭𝐞 𝐞𝐥𝐢𝐠𝐢𝐛𝐢𝐥𝐢𝐭𝐲 𝐝𝐞𝐭𝐚𝐢𝐥𝐬 tailored for Indian students ✅ 𝐒𝐭𝐞𝐩-𝐛𝐲-𝐬𝐭𝐞𝐩 𝐚𝐩𝐩𝐥𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐠𝐮𝐢𝐝𝐞 to avoid mistakes ✅ 𝐔𝐫𝐠𝐞𝐧𝐭 𝐝𝐞𝐚𝐝𝐥𝐢𝐧𝐞𝐬 so you don't miss out 💡 Pro tip: These aren't just funds—they're your ticket to covering costs, boosting your resume, and unlocking internships or placements down the line. Imagine starting your career debt-free! 🌟 ⏰ Deadlines are approaching fast—don't wait!0,11%
  • 16 сент. 2025 г.Top Companies Hiring TODAY - Business Analyst 1. Amazon: https://lnkd.in/dUVcs2Ac 2. Deutsche Bank: https://lnkd.in/dpAHXCBM 3. LISSEN.IO: https://lnkd.in/dp-vUavW 4. Accenture: https://lnkd.in/dyZnACf8 5. HCLTech: https://lnkd.in/dhtzkFee 6. VLaunchU: https://lnkd.in/d2RdSaJC 7. PhonePe: https://lnkd.in/d3M3mqtS 8. HSBC: https://lnkd.in/dSuGWSQv 9. Burns & McDonnell: https://lnkd.in/dQTbYV5N 10. Citi: https://lnkd.in/d4pCe7Kz 11. EY: https://lnkd.in/dpP3YjNQ 12. Deloitte: https://lnkd.in/dTUW6KxU 13. BCG X: https://lnkd.in/dqbYQUfc 14. NTT DATA North America: https://lnkd.in/d5VpBtwr 15. PwC Acceleration Center India: https://lnkd.in/d3Kg38W9 Join for Daily Update: https://whatsapp.com/channel/0029VajSCJP2Jl8EEDRRKp0F Don't miss your chance 🏆❤️0,11%
  • 9 нояб.🚀 We’re Hiring! CARSOME Malaysia is looking for a Senior Data Scientist with 3+ years of experience — someone who loves turning messy business problems into elegant data solutions. If you live and breathe Python, SQL, and ML, and enjoy working on real-world systems like pricing, recommendations, computer vision, and MLOps, come build real impact with us! 📍 Please note: No remote options are available If you’re interested, kindly share your resume via email to kunal.gaur@carsome.com along with the following details: • Overall experience • Experience in Data Science • Current role & company • Current location • Willing to relocate to Malaysia (onsite) • Current & expected salary (per month in MYR) • Notice period / Serving notice (Yes/No) • If serving notice, how many days are left Thanks!0,10%
  • 30 авг. 2025 г.📊 Data Scientist Opportunity at Jaipur Data Scientist (Generative AI) | Jaipur (On-site) Company: kainskep.com Role: Data Scientist – Generative AI Location: Jaipur (On-site) Experience: 1–2 years Batch: 2023/2024 🔹 Requirements: Strong in Python, R, SQL, ML, Statistics, Data Cleaning & EDA, Visualization NLP, Web Scraping, Big Data Tools, SQL/NoSQL Familiarity with Git, Agile & SDLC ✨ Nice to Have Skills: Computer Vision, Generative AI (GANs/LLMs) Azure AI Studio, Copilot Studio 📩 How to Apply: Send your updated resume to nikita.bisht@kainskep.com0,10%
  • 20 дек.🔥 Production-Ready Generative AI Project — Now Live! Turn customer calls into revenue-driving insights 📈 Our AI-Powered Call Center Analytics Platform is a full Frontend + Backend solution that converts raw call audio into actionable intelligence—ready for real-world deployment. 👉 Explore the live project: https://topmate.io/shivan_kumar1/1854486 Built to analyze faster, decide smarter, and sell better. 🚀0,09%
  • 1 сент. 2025 г.🏗️ A 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐨𝐧-𝐆𝐫𝐚𝐝𝐞 𝐀𝐠𝐞𝐧𝐭𝐢𝐜 𝐀𝐈 𝐒𝐲𝐬𝐭𝐞𝐦 𝐟𝐨𝐫 𝐑𝐞𝐚𝐥 𝐄𝐬𝐭𝐚𝐭𝐞 𝐂𝐮𝐬𝐭𝐨𝐦𝐞𝐫 𝐌𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 𝐓𝐡𝐢𝐬 𝐬𝐲𝐬𝐭𝐞𝐦 𝐥𝐞𝐯𝐞𝐫𝐚𝐠𝐞𝐬 𝐀𝐠𝐞𝐧𝐭𝐢𝐜 𝐀𝐈 𝐅𝐫𝐚𝐦𝐞𝐰𝐨𝐫𝐤, 𝐅𝐚𝐬𝐭𝐀𝐏𝐈, 𝐒𝐭𝐫𝐞𝐚𝐦𝐥𝐢𝐭, 𝐚𝐧𝐝 𝐌𝐨𝐧𝐠𝐨𝐃𝐁 , 𝐂𝐥𝐨𝐮𝐝, 𝐑𝐞𝐚𝐥𝐭𝐢𝐦𝐞 𝐀𝐏𝐈 𝐭𝐨 𝐝𝐞𝐥𝐢𝐯𝐞𝐫: ✔ Intelligent customer analysis ✔ Personalized communication ✔ Data-driven insights 🎯 𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬 ✅ 𝐓𝐫𝐮𝐞 𝐀𝐠𝐞𝐧𝐭𝐢𝐜 𝐀𝐈 𝐒𝐲𝐬𝐭𝐞𝐦 – 6 autonomous AI agents with specialized expertise ✅ 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐨𝐧-𝐑𝐞𝐚𝐝𝐲 𝐀𝐫𝐜𝐡𝐢𝐭𝐞𝐜𝐭𝐮𝐫𝐞 – FastAPI backend, Streamlit dashboard, MongoDB integration,Cloud, Realtime API ✅ 𝐃𝐨𝐦𝐚𝐢𝐧 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 – Real estate expertise, customer psychology, negotiation strategies ✅ 𝐄𝐫𝐫𝐨𝐫 𝐇𝐚𝐧𝐝𝐥𝐢𝐧𝐠 & 𝐌𝐨𝐧𝐢𝐭𝐨𝐫𝐢𝐧𝐠 – Health checks, observability, and graceful degradation https://www.linkedin.com/feed/update/urn:li:ugcPost:7368272359780249600/0,06%
  • 9 нояб.Fresher Hiring for Data Analyst and Business Analyst Role. HSBS Hiring Business Analyst https://portal.careers.hsbc.com/careers/job/563774608051265 American Express Hiring Analyst-Data Analytics https://aexp.eightfold.ai/careers/job/38565926 Siemens Hiring Data Scientist https://jobs.siemens.com/en_US/externaljobs/JobDetail/482626 Gainwell Technologies Hiring Analyst https://jobs.gainwelltechnologies.com/job/Bangalore-Workforce-Management-%28RTA%29-KA-560100/1338158200/ Resume Sample: https://drive.google.com/drive/folders/1tVBozS35lBTH9wzyDgCfw6-T8vV3svS9?usp=sharing Don't forget to share the reel with your friends.0,05%