We queried employee compensation history data from BambooHR into PowerBI and created visuals to show pay rate % changes over time by department or division automatically.