Interactive Business Intelligence Reports with Microsoft Power BI
Power BI Report 1: Adventureworks Cycles
The Adventureworks Cycles Dataset is a fake dataset produced by Microsoft for demonstration and testing purposes.
Power BI Report 2: State of Vermont Property Valuation Mapping
Click to set custom HTML
Automation with Visual Basic Programming
Spreadsheet Modeling and Dashboards
Spreadsheet Model 1: Vermont Renter Rebate Reform Proposal Cost Model
This model gives legislators a tool to compare the current renter rebate program with a new proposal. The proposed program would distribute benefits based on the place of residence and the family size instead of simply the annual income and rent amount.
| renter_rebate_reform_sandbox_calculator_v15.xlsb |
Spreadsheet Model 2: Simple 2-Period Economic Consumption Model for Economics Students
|
This is a simple 2-period consumption model designed for intermediate microeconomics students at the University of Vermont to get a dynamic understanding of consumer responses to changes in interest rates, inflation, income streams, and assets on current and future consumption decisions.
|
| ||
Spreadsheet Model 3: National "Doughnut" Accounting Spreadsheet Tool
English Economist Kate Raworth has written extensively about the need for our economy to operate within a safe and just space for humanity - one that meets basic social needs and sustains itself without exceed significant ecological boundaries. She conceives of this safe operating space as a "doughnut", which she describes in her 2017 book, Doughnut Economics.
The National Doughnut Accounting Spreadsheet tool was designed as a group project for Community Development students to gain experience with accessing and evaluating performance data from the World Bank, the United Nations and the Ecological Foodprint Network. Please note that this was designed as a teaching tool - the metrics included are imperfect and by no means exhaustive. |
|
| ||
Database Design and Development
This section is under construction.
The go-to tool for database development at Abt Associates is called Knack. Knack is an industry leader in low-code cloud-based database platforms (competing with other platforms like Caspio, Zoho, and Airtable). Knack licenses are relatively cheap and databases can be built relatively quickly. Knack has supplanted our use of Microsoft Access.
The go-to tool for database development at Abt Associates is called Knack. Knack is an industry leader in low-code cloud-based database platforms (competing with other platforms like Caspio, Zoho, and Airtable). Knack licenses are relatively cheap and databases can be built relatively quickly. Knack has supplanted our use of Microsoft Access.
Press Coverage
|
We developed an excel-based tool that was widely used by property owners in the state of Vermont to estimate household property taxes. The tool was covered by local news outlets in the state. See a story and video profiling the tool here.
|
|
