1.Automating Macroeconomic Labor Data Consolidation
HR Workforce Analyst · 2026
An HR Workforce Analyst automated the consolidation of disparate Bureau of Labor Statistics datasets to replace the manual merging of four JSON files containing irregular missing-data placeholders. The resulting dashboard features a multi-line chart indexing metrics to January 2020, capturing the massive unemployment spike to 400, alongside a dual-axis chart contrasting a flat 60% to 63% labor-force participation rate against average hourly earnings climbing from $26 to $36. Automated narrative insights highlight specific trends, such as hourly earnings running 3.7% above the previous year and weekly hours increasing by 1.17 over 12 months, streamlining monthly executive briefings.
What it shows:
Automating macroeconomic data consolidation eliminates manual formatting and instantly surfaces critical workforce trends for executive review.




