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.