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:
This page contains a small selection of my technical work including:
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.
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.
| vermont_legislative_renter_rebate_reform_calculator_v17.xlsb | |
| File Size: | 353 kb |
| File Type: | xlsb |
Press Coverage - Vermont Property Tax Assessment Calculator
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.
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.