Headcount Forecast based on an HR Roster

Corporate finance teams and financial analysts can learn how to create a headcount forecast based on an employee roster by utilizing employee types to drive the employee direct and indirect expense forecast at the individual level. The employee forecast then feeds dashboards and refreshes Google Sheets.

Consolidate data from multiple data sources, such as an HR Roster, an Applicant Tracking System, and a Google Sheet into a single source of truth. It's as easy as the video shows to get started - no implementation at all, simply start by loading your headcount and press the generate forecast button!

🔍 What you'll learn:
00:00 Introduction
00:07 Headcount calculation rules
00:25 Adding a new Employee Type
00:33 HR Template
00:37 Loading an HR Roster
00:55 Consolidating data sets from different locations
01:20 Visualizations & refreshing financial models

🎥 Related Videos:

👉 Let's connect on LinkedIn!