Designed and implemented centralized internal dashboards for HR, recruitment, talent pool, and finance reporting. Integrated Workday with Google Sheets for automated employee data updates, standardized KPIs, and automated dashboard refreshes. Reduced manual reporting time by 50% and improved data consistency by 35% while ensuring privacy and compliance for all sensitive information.
Project Overview
Challenges & Solutions
Challenges
All company reporting was done in scattered Excel files with no centralized repository
No visual dashboards to provide leadership with quick, actionable insights
Financial data was unstructured and not optimized for dashboard integration
HR, recruitment, and talent pool reporting lacked consistency and standard KPIs
No automated process for importing employee data from core HR systems
No defined process for maintaining and updating reports across departments
Solutions
Conducted data discovery sessions with HR, recruitment, finance, and other departments to understand reporting needs and data sources
Integrated Workday with Google Sheets to automate the retrieval of employee data for HR and recruitment dashboards
Created a centralized repository for storing and accessing reports with proper access controls
Learned Google Looker Studio to design and implement dashboards for HR, recruitment, talent pool, and finance teams
Built data transformation processes within Google Sheets to restructure financial data for dashboard integration without changing the source format
Established standardized KPIs and reporting formats to ensure consistency across departments
Worked with privacy and cybersecurity teams to ensure all dashboards met data handling and compliance requirements