📊 Employee Analytics Dashboard (MySQL & Excel)
📌 Project Overview This project demonstrates an end-to-end Employee Analytics Dashboard using MySQL and Microsoft Excel. The goal is to extract employee data using SQL, transform it using Power Query, and visualize insights through Pivot Tables and Charts.
🛠 Tools & Technologies
- MySQL
- SQL (SELECT, GROUP BY, HAVING)
- Microsoft Excel
- Power Query
- Pivot Tables & Pivot Charts
🔄 Workflow
- Created an employee database in MySQL
- Wrote SQL queries to fetch required data
- Connected MySQL to Excel using Power Query
- Cleaned and transformed data
- Built Pivot Tables, Charts, and an interactive dashboard
📈 Key Insights
- Department-wise employee count
- Salary analysis by department
- Performance analysis
🎯 Learning Outcome
- Practical experience with SQL and MySQL
- Hands-on data cleaning using Power Query
- Dashboard creation using Excel
🚀 Future Enhancements
- Add Power BI version
- Automate refresh using live database connection
- Include advanced SQL queries and KPIs