Portfolio Projects of Sean Morris
  • Portfolio
  • About

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. 
Picture
renter_rebate_reform_sandbox_calculator_v15.xlsb
File Size: 353 kb
File Type: xlsb
Download File

 

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. 
2_period_consumption_model_comuna_v7.xlsb
File Size: 69 kb
File Type: xlsb
Download File

Picture
 

Spreadsheet Model 3: National "Doughnut" Accounting Spreadsheet Tool

Picture
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. 

Picture
national_doughnut_accounting_spreadsheet_v16.xlsx
File Size: 606 kb
File Type: xlsx
Download File


Picture
 

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. 

 

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.
Picture
Powered by Create your own unique website with customizable templates.