Impact & Data

Impact Report

Vermont First Impact reports are published yearly and are our way of communicating the work we are doing with the public and our stakeholders. It includes the data we’ve collected during the year on our local spending and shares stories about the work we do and producers we work with.

But how do we collect data?

We use a PowerBI dashboard to track our spending on all of the food we buy at every account. Each month, data is entered from invoices, and every item is categorized as local, regional, or neither, with additional tagging for farm impact. The dashboard aggregates this information, enabling us to filter the data by specific attributes, accounts, and time periods.

Above is a snapshot of the pie chart featured on our Power BI Dashboard. Here you see the total Local Spend in dollars broken down by each vendor. This is just one example of how the dashboard can take raw data files and categorize into a more digestible view. Power BI allows us to more efficiently identify trends and patterns within the data set.

Statewide Infographic