Tracking the market to help manage risk.
By tracking key construction commodities this report was aimed at identifying potential cost escalation risks before the happened.
This report used a combination of data sources from the web, cloud storage on SharePoint, and Power Automate flows to create a hands off report that refreshed itself weekly with no administration required.
Multiple Views - One Report Page
Using a combination of bookmarks, selections, and filters we deployed a report page with multiple views. This effectively turns this report page into 4 without having to navigate off the page.
Automatic Refreshing of Data from the Web
Using power automate we established a way to extract data from different websites then write that data to SharePoint where is was then used in the Commodity Report.
Extracting Data from emails
Using power automate we gained access to a new source of data by extracting information from a daily email and adding that to an existing data source.
Sample Report Pages
