es
Feedback

¡No caigas en manos de tramposos! Telemetrio encuentra y marca estos canales 👉 Si quieres ver la etiqueta, suscríbete

Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources

Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources

Ir al canal en Telegram

Covering all technical and popular stuff about anything related to Data Science: AI, Big Data, Machine Learning, Statistics, general Math and the applications of former. Ads/ Promo: @love_data

Mostrar más

📈 Análisis del canal de Telegram Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources

El canal Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources (@sqlproject) en el segmento lingüístico de Inglés es un actor destacado. Actualmente la comunidad reúne a 39 451 suscriptores, ocupando la posición 4 731 en la categoría Educación y el puesto 9 509 en la región India.

📊 Métricas de audiencia y dinámica

Desde su creación el невідомо, el proyecto ha mostrado un crecimiento acelerado, reuniendo a 39 451 suscriptores.

Según los últimos datos del 15 noviembre, 2026, el canal mantiene una actividad estable. En los últimos 30 días la variación de miembros fue de -234, y en las últimas 24 horas de -11, conservando un alto alcance.

  • Estado de verificación: No verificado
  • Tasa de interacción (ER): El promedio de interacción de la audiencia es 2.13%. Durante las primeras 24 horas tras publicar, el contenido suele obtener 0.62% de reacciones respecto al total de suscriptores.
  • Alcance de las publicaciones: Cada publicación recibe en promedio 839 visualizaciones. En el primer día suele acumular 246 visualizaciones.
  • Reacciones e interacción: La audiencia responde de forma activa: el promedio de reacciones por publicación es 2.
  • Intereses temáticos: El contenido se centra en temas clave como analytic, dataset, visualization, sql, learning.

📝 Descripción y política de contenido

El autor describe el recurso como un espacio para expresar opiniones subjetivas:
“Covering all technical and popular stuff about anything related to Data Science: AI, Big Data, Machine Learning, Statistics, general Math and the applications of former. Ads/ Promo: @love_data”

Gracias a la alta frecuencia de actualizaciones (últimos datos recibidos el 16 noviembre, 2026), el canal mantiene la vigencia y un amplio alcance. La analítica demuestra que la audiencia interactúa activamente con el contenido, lo que lo convierte en un punto de referencia dentro de la categoría Educación.

Buy Ad
39 451
Suscriptores
-1124 horas
-707 días
-23430 días
Archivo de publicaciones
𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗘𝘅𝗰𝗲𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 📊 🎓 Explore 4 FREE Excel Courses to upgrade your sk
𝟰 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗘𝘅𝗰𝗲𝗹 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 📊 🎓 Explore 4 FREE Excel Courses to upgrade your skills! ✅ Excel Formulas & Functions ✅ Pivot Tables & Charts ✅ Data Cleaning & Analysis ✅ Dashboards & Reporting 🎯 Perfect for Students, Freshers & Aspiring Data Analysts! 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/48mO4B2 📌 SAVE & SHARE with friends who want to master Excel! 🔥

𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝗪𝗜𝗧𝗛 𝗧𝗢𝗣 𝗖𝗢𝗠𝗣𝗔𝗡𝗜𝗘𝗦! 🎓 💻 Explore FREE Virtual Internship & Jo
𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗜𝗡𝗧𝗘𝗥𝗡𝗦𝗛𝗜𝗣𝗦 𝗪𝗜𝗧𝗛 𝗧𝗢𝗣 𝗖𝗢𝗠𝗣𝗔𝗡𝗜𝗘𝗦! 🎓 💻 Explore FREE Virtual Internship & Job Simulation Programs from leading companies! ✅ Learn Industry-Relevant Skills ✅ Work on Practical Tasks ✅ Self-Paced Online Learning ✅ Explore Completion Certificates ✅ Strengthen Your Resume & LinkedIn Profile 🎯 Perfect for Students, Freshers & Job Seekers 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/4t8DRlq 📲 SAVE & SHARE with friends looking for career opportunities!

𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗚𝗲𝘁 𝗬𝗼𝘂𝗿 𝗗𝗿𝗲𝗮𝗺 𝗝𝗼𝗯 𝗜𝗡 𝗚𝗼𝗼𝗴𝗹𝗲🔥 Discover *4 FREE resources* to help yo
𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗧𝗼 𝗚𝗲𝘁 𝗬𝗼𝘂𝗿 𝗗𝗿𝗲𝗮𝗺 𝗝𝗼𝗯 𝗜𝗡 𝗚𝗼𝗼𝗴𝗹𝗲🔥 Discover *4 FREE resources* to help you prepare for a career at Google! ✅ Improve Your Coding Skills ✅ Strengthen Interview Preparation ✅ Build Technical Knowledge ✅ Prepare for Top Tech Opportunities 🎓Perfect for Students, Freshers & Aspiring Software Engineers! 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/4AwRPQy 📲 SAVE & SHARE with friends dreaming of working at Google!

𝟯 𝗙𝗥𝗘𝗘 𝗛𝘂𝗯𝗦𝗽𝗼𝘁 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗦𝘁𝘂𝗱𝗲𝗻𝘁𝘀 & 𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲🎓 💫HubSpot
𝟯 𝗙𝗥𝗘𝗘 𝗛𝘂𝗯𝗦𝗽𝗼𝘁 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗳𝗼𝗿 𝗦𝘁𝘂𝗱𝗲𝗻𝘁𝘀 & 𝗙𝗿𝗲𝘀𝗵𝗲𝗿𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲🎓 💫HubSpot Academy offers three free online certifications that match these interests. 💫Pick one free course and try it out on your next college event and the certification is free. 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4iM5xaQ 📲 *Save & Share with your friends! 🔥*

🚀🔥𝗚𝗢𝗢𝗚𝗟𝗘 𝗖𝗟𝗢𝗨𝗗 – 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! ☁️📊 Learn *Data Analytics, BigQuery, Data Engineering & Looker* fo
🚀🔥𝗚𝗢𝗢𝗚𝗟𝗘 𝗖𝗟𝗢𝗨𝗗 – 𝟰 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! ☁️📊 Learn *Data Analytics, BigQuery, Data Engineering & Looker* for FREE! ✅ Beginner-Friendly Learning ✅ Build In-Demand Tech Skills ✅ Boost Your Resume & Career Opportunities 🎯 Perfect for Students, Freshers & Job Seekers! 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4AttkUb 📲 Save & Share with your friends! 🔥

Data Analytics isn't SQL. Data Analytics isn't Python. Data Analytics isn't Tableau. Data Analytics isn't Power BI. Data Analytics isn't R. Data Analytics isn't Statistics. Data Analytics isn't even spreadsheets. Data Analytics is exporting dashboards to Excel for people who make 3 times your salary.

🎓 𝟰 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀 Want to build job-ready skills and strengthen your resume?
🎓 𝟰 𝗖𝗲𝗿𝘁𝗶𝗳𝗮𝘁𝗶𝗼𝗻𝘀 𝗧𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗜𝗻 𝟮𝟬𝟮𝟲 🚀 Want to build job-ready skills and strengthen your resume? Start learning these in-demand technologies 📊 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 :- https://pdlink.in/45vk5ph 💫 𝗙𝘂𝗹𝗹𝘀𝘁𝗮𝗰𝗸 :- https://pdlink.in/3SuUeuD ☁️ 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 :- :- https://pdlink.in/48kyZjt 🛡️ 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 :- :- https://pdlink.in/4fWJVID 🔁 𝗦𝗵𝗮𝗿𝗲 this with your friends and classmates!

🚀 𝗠𝗜𝗖𝗥𝗢𝗦𝗢𝗙𝗧 + 𝗟𝗜𝗡𝗞𝗘𝗗𝗜𝗡 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! 🎓🔥 😍 Explore 5 FREE Career Learning Paths to boost your
🚀 𝗠𝗜𝗖𝗥𝗢𝗦𝗢𝗙𝗧 + 𝗟𝗜𝗡𝗞𝗘𝗗𝗜𝗡 𝗙𝗥𝗘𝗘 𝗖𝗢𝗨𝗥𝗦𝗘𝗦! 🎓🔥 😍 Explore 5 FREE Career Learning Paths to boost your resume! 📊 Data Analytics | ☁️ Cloud Computing | 🤖 AI | 🔐 Cybersecurity | 💻 Software Development ✅ Learn In-Demand Skills ✅ Explore Certificate Opportunities ✅ Perfect for Students, Freshers & Job Seekers 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4eOufX9 📲 Share with your friends! 🔥

𝗚𝗢𝗢𝗚𝗟𝗘 𝟱 𝗙𝗥𝗘𝗘 𝗧𝗘𝗖𝗛 𝗖𝗢𝗨𝗥𝗦𝗘𝗦 𝟮𝟬𝟮𝟲! 🎓💻 Explore 5 FREE Google learning courses to build in-demand tec
𝗚𝗢𝗢𝗚𝗟𝗘 𝟱 𝗙𝗥𝗘𝗘 𝗧𝗘𝗖𝗛 𝗖𝗢𝗨𝗥𝗦𝗘𝗦 𝟮𝟬𝟮𝟲! 🎓💻 Explore 5 FREE Google learning courses to build in-demand technical skills and strengthen your resume! 🚀 ✅ FREE Learning Resources ✅ Beginner-Friendly Courses ✅ Learn at Your Own Pace ✅ Explore Hands-On Learning Opportunities ✅ Build Skills for AI, ML & Cloud Careers 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4kMcA5X ⚡ Don't wait to upgrade your skills — start learning today!

🔥 SQL Interview Case Studies & Real-World Business Problems 🧠 Case Study 1: Top 3 Customers by Revenue 📊 Orders Table order_id customer_id amount 1 101 500 2 102 1000 3 101 700 ❓ Business Question Find the top 3 customers by total revenue. ✅ Solution SELECT customer_id, SUM(amount) AS total_revenue FROM orders GROUP BY customer_id ORDER BY total_revenue DESC LIMIT 3; 🧠 Case Study 2: Department with Highest Average Salary ❓ Business Question Which department has the highest average salary? ✅ Solution SELECT department, AVG(salary) AS avg_salary FROM employees GROUP BY department ORDER BY avg_salary DESC LIMIT 1; 🧠 Case Study 3: Customers Who Never Ordered 📊 Tables Customers customer_id name Orders order_id customer_id ❓ Business Question Find customers who never placed an order. ✅ Solution SELECT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id WHERE o.customer_id IS NULL; 🧠 Case Study 4: Second Highest Salary ❓ Business Question Find employees with the second highest salary. ✅ Solution SELECT * FROM employees WHERE salary = ( SELECT MAX(salary) FROM employees WHERE salary < ( SELECT MAX(salary) FROM employees ) ); 🧠 Case Study 5: Monthly Sales Trend ❓ Business Question Calculate monthly sales. ✅ Solution SELECT YEAR(order_date) AS year, MONTH(order_date) AS month, SUM(amount) AS sales FROM orders GROUP BY YEAR(order_date), MONTH(order_date) ORDER BY year, month; 🎯 Practice Tasks 1️⃣ Find top-selling product 2️⃣ Find employee with highest salary in each department 3️⃣ Find customers with more than 5 orders 4️⃣ Find month with highest sales 5️⃣ Find departments having more than 10 employees ⚡ Mini Challenge 🔥 E-commerce Scenario Tables: Customers customer_id name Orders order_id customer_id amount order_date Business Question Find the top 5 customers by total spending in the last 12 months. 🔥 Interview Tip Most SQL interviews are NOT about syntax. They're about: ✅ Understanding business problem ✅ Choosing the right approach ✅ Writing efficient SQL Double Tap ❤️ For More

🚀 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 😍| 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮𝗻 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿 This AI engineering course online
🚀 𝗔𝗜 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 😍| 𝗕𝗲𝗰𝗼𝗺𝗲 𝗮𝗻 𝗔𝗜 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿 This AI engineering course online is structured around AI fundamentals, full-stack development, real-world AI projects 💫2000+ Students Placed 🎥 Live Classes + Session Recordings 👨‍💻 1:1 Mentorship & Doubt Support 💼 Interview Preparation & Placement Assistance 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼👇:- ​ https://pdlink.in/4fWJVID 🔥 Take the next step towards building your career in AI!

Data Analyst Interview Preparation Roadmap ✅ Technical skills to revise - SQL Write queries from scratch. Practice joins, group by, subqueries. Handle duplicates and NULLs. Window functions basics. - Excel Pivot tables without help. XLOOKUP and IF confidently. Data cleaning steps. - Power BI or Tableau Explain data model. Write basic DAX. Explain one dashboard end to end. - Statistics Mean vs median. Standard deviation meaning. Correlation vs causation. - Python. If required Pandas basics. Groupby and filtering. Interview question types - SQL questions Top N per group. Running totals. Duplicate records. Date based queries. - Business case questions Why did sales drop. Which metric matters most and why. - Dashboard questions Explain one KPI. How users will use this report. - Project questions Data source. Cleaning logic. Key insight. Business action. Resume preparation - Must have Tools section. - One strong project. - Metrics driven points. Example: Improved reporting time by 30 percent using Power BI. Mock interviews - Practice explaining out loud. - Time your answers. - Use real datasets. Daily prep plan 1 SQL problem. 1 dashboard review. 10 interview questions. - Common mistakes Memorizing queries. No project explanation. Weak business reasoning. - Final task - Prepare one project story. - Prepare one SQL solution on paper. - Prepare one business metric explanation. Double Tap ♥️ For More

🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊 Learn Excel, SQL, Python & Power BI Live Online Dat
🚀 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗖𝗼𝘂𝗿𝘀𝗲 📊 Learn Excel, SQL, Python & Power BI Live Online Data Analytics Program 💰 Highest Salary: ₹12.6 LPA 📈 Average Salary: ₹5.7 LPA 🏢 500+ Partner Companies 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :- https://pdlink.in/45vk5ph 🔥 Turn your interest in data into practical, job-ready skills!

𝗝.𝗣. 𝗠𝗢𝗥𝗚𝗔𝗡 𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗣𝗥𝗢𝗚𝗥𝗔𝗠𝗦 𝟮𝟬𝟮𝟲! 🎓 Explore J.P. Morgan's FREE Virtual Job Simulation P
𝗝.𝗣. 𝗠𝗢𝗥𝗚𝗔𝗡 𝗙𝗥𝗘𝗘 𝗩𝗜𝗥𝗧𝗨𝗔𝗟 𝗣𝗥𝗢𝗚𝗥𝗔𝗠𝗦 𝟮𝟬𝟮𝟲! 🎓 Explore J.P. Morgan's FREE Virtual Job Simulation Programs ✅ 100% FREE Virtual Learning ✅ Work on Practical, Industry-Based Tasks ✅ Learn at Your Own Pace ✅ Build Valuable Professional Skills 🎯 Perfect For:- College Students | Freshers | Graduates | Job Seekers 🔗 𝗟𝗶𝗻𝗸 👇:- https://pdlink.in/3X8KJmE ⚡ Learn New Skills • Gain Practical Exposure • Boost Your Career!

𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝘄𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜 - 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 😍 💰 Highest Salary: ₹
𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗺𝗲𝗻𝘁 𝘄𝗶𝘁𝗵 𝗚𝗲𝗻𝗔𝗜 - 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 😍 💰 Highest Salary: ₹41 LPA 📈 Average Salary: ₹7.4 LPA 🎓 2,000+ Students Placed 🏢 500+ Hiring Partners 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗡𝗼𝘄 👇 :- https://pdlink.in/3SuUeuD 🔥 Take the first step towards your high-paying tech career in 2026!

𝗕𝗘𝗦𝗧 𝗙𝗥𝗘𝗘 𝗣𝗬𝗧𝗛𝗢𝗡 𝗖𝗘𝗥𝗧𝗜𝗙𝗜𝗖𝗔𝗧𝗜𝗢𝗡𝗦 𝗜𝗡 𝟮𝟬𝟮𝟲! 🎓 Discover some of the best FREE Python learning
𝗕𝗘𝗦𝗧 𝗙𝗥𝗘𝗘 𝗣𝗬𝗧𝗛𝗢𝗡 𝗖𝗘𝗥𝗧𝗜𝗙𝗜𝗖𝗔𝗧𝗜𝗢𝗡𝗦 𝗜𝗡 𝟮𝟬𝟮𝟲! 🎓 Discover some of the best FREE Python learning and certification opportunities ✅ Free Python Learning Resources ✅ Beginner-Friendly Courses ✅ Practical Programming Knowledge ✅ Explore Available Certificates & Badges ✅ Strengthen Your Resume & LinkedIn Profile 🔗 𝗟𝗶𝗻𝗸 :- 👇 https://pdlink.in/4iVDpmN 📌 SAVE this post & SHARE with friends preparing for tech careers! 🔥

💸 *Your next salary hike might not come from your appraisal. It might come from your next skill!* Looking to upskill or swit
💸 *Your next salary hike might not come from your appraisal. It might come from your next skill!* Looking to upskill or switch to a career in Data Analytics? 📊 Coding Ninjas' Data Analytics Job Bootcamp helps working professionals get career-ready with: ⚡ GenAI-infused curriculum 💻 10+ real-world projects 👨‍🏫 1:1 expert mentorship 📄 Resume & interview preparation 🚀 Placement support + 1200+ hiring partners 📈 Up to 128% average salary hike 🎯 Upgrade your skills. Unlock your next career move. 👉 Register for the FREE webinar: https://tinyurl.com/3a3nrbww

🧠 SQL Concepts You'll Practice ✔ DDL & DML ✔ Joins ✔ Aggregate Functions ✔ GROUP BY ✔ HAVING ✔ CASE WHEN ✔ Subqueries ✔ Common Table Expressions (CTEs) ✔ Window Functions ✔ Date Functions  📊 Business KPIs You Can Build 📈 Total Employees 📈 Active Employees 📈 Employee Attrition Rate 📈 Average Employee Salary 📈 Salary by Department 📈 Salary by Designation 📈 Average Performance Rating 📈 Top Performers 📈 Bonus Distribution 📈 Department-wise Headcount 📈 Gender Diversity Ratio 📈 Age Distribution 📈 Average Employee Tenure 📈 New Hires by Month 📈 Employee Attendance Rate 📈 Leave Utilization 📈 Absenteeism Rate 📈 Highest Paying Department 📈 Highest Paying Job Role 📈 Promotion Eligibility List 📈 Performance Rating Distribution 📈 Employee Growth Trend 📈 Employees by City 📈 Department-wise Attrition 📈 Workforce Dashboard Metrics  🎯 This project simulates the work performed by HR Analysts, People Analytics teams, and Business Intelligence professionals to support workforce planning and strategic decision-making. 💡 Double Tap ❤️ For More

🚀 SQL Project Series #9 HR Analytics Project 👨‍💼 Analyze employee data to understand workforce trends, employee performance, attrition, hiring, salaries, and organizational health using SQL. 🎯 Business Objectives ✅ Analyze employee demographics ✅ Measure employee attrition ✅ Track hiring trends ✅ Analyze salaries and compensation ✅ Evaluate department performance ✅ Monitor attendance and leave patterns ✅ Identify high-performing employees ✅ Generate HR dashboards 📂 Step 1: Create Database
CREATE DATABASE hr_analytics_db;

USE hr_analytics_db;
📂 Step 2: Create Departments Table
CREATE TABLE departments (
    department_id INT PRIMARY KEY,
    department_name VARCHAR(100)
);
📂 Step 3: Create Employees Table
CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    employee_name VARCHAR(100),
    gender VARCHAR(10),
    age INT,
    department_id INT,
    designation VARCHAR(100),
    salary DECIMAL(10,2),
    hire_date DATE,
    city VARCHAR(50),
    employment_status VARCHAR(20),
    FOREIGN KEY (department_id)
        REFERENCES departments(department_id)
);
📂 Step 4: Create Attendance Table
CREATE TABLE attendance (
    attendance_id INT PRIMARY KEY,
    employee_id INT,
    attendance_date DATE,
    status VARCHAR(20),
    FOREIGN KEY (employee_id)
        REFERENCES employees(employee_id)
);
📂 Step 5: Create Performance Table
CREATE TABLE performance (
    review_id INT PRIMARY KEY,
    employee_id INT,
    review_year INT,
    performance_rating DECIMAL(3,2),
    bonus DECIMAL(10,2),
    FOREIGN KEY (employee_id)
        REFERENCES employees(employee_id)
);
📂 Step 6: Insert Sample Departments
INSERT INTO departments VALUES
(1,'Engineering'),
(2,'Human Resources'),
(3,'Finance'),
(4,'Sales'),
(5,'Marketing');
📂 Step 7: Insert Sample Employees
INSERT INTO employees VALUES
(101,'Rahul Sharma','Male',30,1,'Software Engineer',85000,'2022-01-15','Mumbai','Active'),
(102,'Priya Verma','Female',28,4,'Sales Executive',65000,'2023-03-10','Delhi','Active'),
(103,'Amit Patel','Male',35,3,'Financial Analyst',92000,'2021-06-20','Pune','Active'),
(104,'Sneha Joshi','Female',31,2,'HR Manager',78000,'2020-11-12','Bangalore','Active'),
(105,'Rohan Gupta','Male',29,5,'Marketing Specialist',70000,'2024-02-01','Hyderabad','Resigned');
📂 Step 8: Insert Sample Attendance
INSERT INTO attendance VALUES
(1,101,'2025-01-01','Present'),
(2,102,'2025-01-01','Present'),
(3,103,'2025-01-01','Absent'),
(4,104,'2025-01-01','Present'),
(5,105,'2025-01-01','Leave');
📂 Step 9: Insert Sample Performance Data
INSERT INTO performance VALUES
(1,101,2024,4.8,20000),
(2,102,2024,4.3,12000),
(3,103,2024,4.9,25000),
(4,104,2024,4.5,18000),
(5,105,2024,3.9,10000);