1.Consolidating Macroeconomic Labor Market Data
workforce reporting · 2026
An HR workforce analyst automated the consolidation of four separate JSON files containing Bureau of Labor Statistics datasets to prepare monthly executive briefings. The resulting dashboard features a multi-line chart that indexes participation, hourly earnings, weekly hours, and unemployment to a January 2020 baseline, capturing the massive unemployment spike and subsequent recovery. A dual-axis line chart further contrasts the relatively flat labor-force participation rate against a steady climb in average hourly earnings from roughly $26 to $36 between 2016 and 2025.
What it shows:
Automating the synthesis of external labor indicators eliminates manual formatting and accelerates executive reporting.




