Attendance Analyzer

An internal tool to automate attendance data analysis.

  • Author: Potter White
  • Date: July 2025

Project Overview

The Attendance Analyzer is an in-house efficiency tool developed to tackle the complex and time-consuming task of analyzing employee attendance data within a corporate environment. The application transforms raw Excel exports into clear, actionable reports via a highly flexible, rule-driven engine, significantly improving HR workflow efficiency.

Demo

Below is a short video demonstrating the application’s core workflow.

Application Core Workflow Demo

Core Features & Tech Stack

  • Rule-Driven Engine: All logic is controlled by a rules.toml file.
  • Comprehensive Metrics: Calculates attended days, overtime, lateness, etc.
  • Dual-View Reporting: Generates both “Public” and “Detailed” reports.
  • Tech Stack: Python, Pandas, Streamlit, TOML.

Core Algorithm Design (V1.6)

As the project’s architect, I designed a rigorous analysis algorithm based on a three-state unit model (“Attended”, “Absent”, “Abnormal”) and an “Attended Unit First” principle.

The Story Behind The Project

This project is a case study in AI-assisted development. My role evolved from coder to Architect, Director, and QA Lead. This human-AI partnership reduced the development lifecycle from weeks to days.

This project was developed as an internal corporate asset, and its source code is not publicly available.