Previously we built this Human Resource dashboard using Excel as the data source. The same can be built by putting the data in Google Spreadsheet and then slightly changing the queries.
Checkout the entire HR video series for the tutorial
In the same note, we replicated the data into a MySQL database so that we can share the dashboard with the world and here is the actual URL. Infact we built it once and then defined several versions of it with different look and feel.
What are the benefits of this HR dashboard
- Total Compensation summary for any given year
- Head count growth by location
- Head count growth by department
- Drill down into employee details
HR Dashboard on Bricks
HR Dashboard Wood