Uploaded January 2024 | Updated September 2026, 2 weeks ago

---

Welcome back to the #DatatoDecisions series where we create an #interactive #dashboard from a publicly available dataset from the Bureau of Labor Statistics

In continuation with the previous steps where we extracted data from the web into Excel using Power Query and built a foundation for slicers that will interact with our visual,
Today’s video focuses on the next, key steps:

0:48 How to calculate metrics for our report?
6:32 How to create data bars in the report?

Check the previous video where we extracted and explored data from the website using Power Query here: youtu.be/LKg8zFYPylk

Video link for setting up a foundation for slicers: youtu.be/kL37CZkDM3g

For tutorials that address common Excel problems, visit indzara.com/datatodecisions

#InteractiveDashboard #exceldashboards #excelmadeeasy #powerquery #DatatoDecisions #metrics #excelreport