video1.0<iframe src="https://www.loom.com/embed/67701d47356344c08fc54783a7e2ea24" frameborder="0" width="2336" height="1752" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>17522336Loomhttps://www.loom.com17522336https://cdn.loom.com/os/loom-media-content/loom/d618d83f-8376-4a08-ba13-784248a9995f/53279c10-1f0c-4830-998e-e5ecafa072db/sessions-thumbnails-67701d47356344c08fc54783a7e2ea24-ad8bac164a70edc3.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS84dW03YzdlcWJybWdhNnB1IiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTQ3MDc4NDEsInRpIjoiNDM1MzY4YzctYzljYy00ZmU0LTgzY2ItNzMzODdlMTZkNDU2IiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiJmZTNmYmRkYy1iMDM2LTRkYWItYTdmNS02MDZiN2E1YmQ1ODUiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy02NzcwMWQ0NzM1NjM0NGMwOGZjNTQ3ODNhN2UyZWEyNC1hZDhiYWMxNjRhNzBlZGMzLmdpZiIsImV4cCI6MTc5NDcwODQ0MSwiaWF0IjoxNzk0NzA3ODQxLCJqdGkiOiIwN2MwNzMxOC0wMmFjLTQ0MWItYjBlMy1kOGEyYjNhMDIyYmYifQ.VXVAYeA814kYqD2tctIIwR8XAYNThuQ4BGjRJky7wq2z7z2BwoOfLxzE3u2KMSo88NWCCqErmaEuEI9Idp4p_TEFTv-x5nA2YQkOcoQ861xEnJu8Fv2vjOQGaz9dxiIGBxjBKsSrSQSmt2fbsrtd3qVQY4blo57sAeH_rOQxq3m5eDuCMWpUdoIkVg9i4jSf5iOaqw2RX7YXMu_76BFszteKtdjcf_tuFNiW2TuoaZbNzTu6l9MJjRMn5ZMQSfKZP5QKFek4us4sCsPqbdrNFAT8uDh0-3IRBr42v9wGhp1IfSDuKqoFJsoraZRctB8N-0499mfch97oNQgL7-s02A&Expires=1794708441&Signature=jfyTtjqtfHWQPB1cec4Oo4cGuGUkCV-dZh6TIxIpAQmygibM4OjS6reIWlRY%7EAhYSwy7ddm1ikBpGtOiSgMzGP7U7bsqELVW12aqttBOnb8oiPTqcW0v54Oo6HB4fY9zYl8Lm9jKq7Yc4Bh-bChAnCZ5-LIWM5UCA60Msi%7EVcYMryEiA3U9ozxmv80i-8x%7EQ2i2CwF1ewoxjekMif44kabNKBVrcenldk4vpLnKFrgGuCj9%7ErRaQKmyrLBCKHs0HvXy8gIpsdt7OO0ZNSvS86x5yWpKbtaaQeVf0-xmBdvjVoLaDs2WzDiYyNrAOdxSLyUxBGfBKalE7zQKR6c7xXg__&Key-Pair-Id=KQOSYIR44AIC0263.037HR Demographic & Attrition Dashboard Walkthrough Overview: A quick demonstration of a custom, real-time Employee Demographic and Attrition Dashboard designed to automate HR reporting using existing Google Workspace infrastructure. Key Features Highlighted: Zero Extra SaaS Fees: Runs natively via Google Apps Script and Google Sheets, eliminating the need for expensive third-party BI software licenses. Executive Visibility: Instant tracking of total headcount, active versus resigned employees, average age, and tenure. Interactive Drill-Downs: Clickable charts that instantly display granular employee lists in a modal, ready for real-time search or one-click CSV export. Attrition & Retention Tracking: Automated Turnover Rate (TOR) calculations and trend analysis across custom date ranges. Dynamic Data Explorer: On-the-fly cross-tabulation of multiple HR dimensions (such as Job Level by Gender or Department by Tenure) without complex pivot tables. Designed to show HR leaders and founders how to transform static spreadsheets into actionable, automated operational intelligence.