BACKGROUND
Client needed consulting support to design and develop an executive dashboard and reporting solutions using Tableau and other tools to support HR Benefit reporting. PPT assigned a Senior Data Analyst to design and develop interactive reports and dashboards with visualizations, KPI’S
GOALS
- Conduct interviews and perform analysis to develop dashboard and reporting requirements
- Analyze source data files as required to develop Extract, Transform, Load (ETL) requirements for importing data into data marts
- Develop ETL processes and procedures to transform and consolidate data into a single source location to support reporting and dashboards
- Develop Tableau Dashboards and Reports to support reporting requirements
ACCOMPLISHMENT & BENEFIT
-
Created the automated Open enrollment dashboard resulting in a significant reduction of manual work
-
Created specifications for LOA data
-
Developed and launched the Brightside dashboard which assisted with viewing specifications for the resources contacting Brightside for financial help.