Projects
DAta Analytics
Visualization
During his internship at RW Baird, Keller was tasked with quantifying the value wealth managers provide to retail investors — a challenge few firms, including Vanguard and Parametric, have explored. After weeks of data collection and modeling in Excel, he visualized the findings in Flourish, creating an interactive tool that highlights the key value drivers wealth managers offer. The graphic remains live on his team’s site. (For illustrative purposes only; not financial advice.)
VBA
During his advanced data science coursework, Keller learned the fundamentals of VBA and built a spreadsheet to analyze stock price data. Since the Yahoo Finance API no longer supports active pulls for historical pricing data, he wrote a script to scrape information directly from the site based on ticker symbols and integrated a charting library to visualize share price and volume trends for major tech companies over the past year. The spreadsheet is relatively simple, but with further development, it could be expanded to identify potential buy and sell signals through looping logic.
Click the icon to the right to download.
Web Design
One of Keller’s favorite courses was introductory web design, where he learned the fundamentals of HTML, CSS, and JavaScript, including jQuery and elements of the React library. Below are several examples of his work - click any image to view the project in more detail.
This simple portfolio site was created to showcase the projects Keller completed in his advanced web design class — all hand-coded using HTML, CSS, and JavaScript.
For his final project in an advanced web design class, Keller built a React/JSX app that generated fake tweets for Donald Trump. The app combined real Trump tweets with text from a Kanye West API, using Firebase on the backend to display user input. The result was a series of surprisingly convincing - and often funny - tweets that blurred the line between the two voices.
Graphic Design & Photography
