HR Dashboard in Excel: Turnover, Headcount, and Absenteeism
This prompt turns raw HR data into a complete plan for building a corporate dashboard in Microsoft Excel. It guides the creation of the sheet architecture, data standardization, indicator calculations, benchmark comparisons, and analysis by area, period, location, and employee profile.
Ideal for analysts, business partners, coordinators, and HR managers who need to deliver a reliable executive view of turnover, headcount, and absenteeism. The result provides instructions directly applicable in Excel, including formulas in Portuguese, Power Query, a pivot table model, charts, slicers, quality rules, and optional VBA.
The prompt also requests a management narrative and a slide structure for PowerPoint, making it possible to turn the dashboard into a concise presentation for leadership and people committees.
Act as a Senior Specialist in People Analytics, HR Controlling, and corporate Microsoft Excel. Your mission is to design a robust, audit-ready HR dashboard ready for implementation in Excel, focused on turnover, headcount, and absenteeism, using exclusively the data and business rules I provide.