The following SQL queries written in Microsoft SQL Server count the headcount of current employees at a fictitious company by 6 different segments:
- Performance Score
- Employee Satisfaction
- Compensation
- Company Tenure
- Department
- Employee Engagement
The query results were then visualized in a Tableau Dashboad and can be viewed on Tableau Public by clicking here.