Sean Morris's Portfolio
  • Portfolio
  • About
  • Blog
I am a business analyst, Excel, and Power BI enthusiast. I constantly draw from my experience as a visual basic application developer, a financial manager, and data analyst to help my teams perform at their best and build great products.

This page contains a small selection of my technical work including:
  • Power BI Dashboards
  • Python Scripting Web Bots
  • Spreadsheet Applications and Automation with VBA
  • Data Modeling & Analysis
  • Data App Development with Python and Streamlit
  • Low-Code Application Development

 

Interactive ​Power BI Dashboards

 

Power BI: Vermont State Property Valuation Map

Most of my Power BI dashboards I can't show you, but here's one that turned out to be super useful to the Property Assessment Team at the State of Vermont Department of Taxes. 

 

Python Scripting Web Bots 

In September of 2025, I implemented a web bot using Python and the Playwright web automation library to automate signing myself up to play in pick-up Pickleball sessions posted publicly online. See the project on my github page: github.com/SeanJMorris/pyckleball
 

Spreadsheet Applications and Automation

I produced and edited this video back in 2016. Since then it's had more than 70,000 views. I still love VBA for super-charging my use of Excel. However, these days when I need to automate processes I turn more and more to simple python scripts.

 

Data Modeling & Analysis

CFPB Student Loan Support Toolkit

CFPB, one of our clients, asked me to build a model that would help consumers plan for supporting their children's college tuition. This was published publicly on the CFPB website. 
Picture

Vermont Renter Rebate Reform Proposal Cost Model

Vermont legislators asked me to build a tool that they could use to show their constituents the impacts of a proposed reform to the state's renter rebate. This tool was a big hit because it's intuitive to see the difference between the old plan and the new proposed one. Legislators were excited to share this with their constituents. 
Picture
vermont_legislative_renter_rebate_reform_calculator_v17.xlsb
File Size: 353 kb
File Type: xlsb
Download File

Press Coverage - Vermont Property Tax Assessment Calculator

Picture
At the State of Vermont Office of Policy Outreach and Legislative Affairs, I developed an Excel-based tool that was used in town meetings across the state to estimate household property taxes. The tool was covered by local news outlets - my boss, Doug Farnham, took the tool on the road and presented it to taxpayers around the state -- see a news story profiling the tool here. 

Picture

 

Data App Development with Python and Streamlit

Streamlit is a popular tool to publish small data-oriented web applications quickly using Python. Check out the website that I built for my own wedding here: aliandseanwedding.streamlit.app/.
 

Low-Code Application Development

One of my go-to tools for simple low-code applications is called Knack. Knack is an industry leader in low-code cloud-based database platforms (competing with other platforms like Caspio, Zoho, Pega Systems, and Appian). Knack licenses are cheap, and applications can be built quickly. Most recently, I built an song listening and sharing application that I have guide my friend and I through listening sessions to songs from Bruce Springsteen's newest album my friend undergoes treatment for chemotherapy. I don't share that app here, but I include a gif of a sample Knack app below that shows the database schema and live application.
Picture
© 2024 by Sean Morris. All rights reserved. 
Portfolio |  About