Andy Klatt

Andy Klatt

Forecasting the Seattle Housing Market: 2023-2024

Economics Featured

Forecasting the Seattle Housing Market: 2023-2024

What's next for the Seattle housing market?

My Resume

Resumes are text heavy and, let's face it, often skimmed. This makes them ripe for visualization. In creating my interactive and visual resume in Tableau, I took a layered approach where most text is hidden behind hover-overs and clicks. I designed the backend in Google Sheets so it

Berkeshire Hathaway and their 'Four Giants'

Economics Featured

Berkeshire Hathaway and their 'Four Giants'

In my latest personal Data Viz project, I explore the most expensive publicly traded stock of all time. Berkshire Hathaway is not just one business, but a holding company for dozens of companies and well-known brands. You’ve likely heard of its 91-year-old CEO, Warren Buffett, the ‘Oracle of Omaha’

How Much Does Your State Rely on Property, Sales, & Income Taxes?

politics Featured

How Much Does Your State Rely on Property, Sales, & Income Taxes?

I live in the state of Washington which has no state income tax. Instead, the state largely relies on sales tax revenue to fund state and local public services like education, utilities, etc. Meanwhile, across the Columbia River in Oregon they have no sales tax, but the highest state income

Visualizing SNL's Stefon

entertainment Featured

Visualizing SNL's Stefon

Tableau Public's 'Iron Viz' is the world's largest data visualization competition. The 2022 Global Qualifier theme was 'Visualizing the Arts'. My mind immediately went to building a submission that features the art of sketch comedy like that of Saturday Night Live. I

D3.js Course Assignment - Airline Routes

D3.js Course Assignment - Airline Routes

I recently completed a Coursera course [https://www.coursera.org/learn/information-visualization-programming-d3js] called Information Visualization: Programming with D3.js A module of the Information Visualization Specialization offered by NYU, it was my second attempt at learning D3.js Below is the final project that was pieced together in assignments as

Workforce Diversity at Starbucks

Workforce Diversity at Starbucks

UPDATE: This visualization was updated in January 2022 with subsequent years numbers. I'm very proud to have been a part of a cross-functional team that pushed for, and contributed to this simple, but meaningful disclosure [https://stories.starbucks.com/stories/2020/workforce-diversity-at-starbucks/] of workforce demographics at Starbucks. My

City Fruit - Fruit Trees in Seattle

seattle Featured

City Fruit - Fruit Trees in Seattle

In Spring of 2020, some colleagues and I took on a volunteer data visualization project for local non-profit City Fruit. City Fruit [https://www.cityfruit.org/] is an organization that ensures the urban orchard of Seattle's fruit trees don't go to waste. I myself have a

2019 Klatt Oscar Pool

2019 Klatt Oscar Pool

Open to all. No stakes. Just for fun. If you haven't already make your picks via this link! [https://goo.gl/forms/YwEZwKgMtirl8vWD3] See below for selections and results. Don't see your entry? Data might take 24 hours to refresh. Winners and standings will update live

Min/Max Temperatures in U.S. Cities

Min/Max Temperatures in U.S. Cities

I was recently inspired by a recent Seattle Times article [https://www.seattletimes.com/seattle-news/data/seattle-is-least-air-conditioned-metro-area-in-the-u-s-census-data-show-so-how-do-locals-keep-cool/] heralding the Emerald City as the least air-conditioned metro area in the country. The U.S. Census Bureau’s American Housing Survey estimates that only 1 in 3 Seattle households have the luxury

Precipitation in U.S. Cities

science Featured

Precipitation in U.S. Cities

Sure it rains often in my hometown of Seattle, but not necessarily in the summer and it's not close to the volume of precipitation some other cities receive. Explore the viz below and discover your own insights. Toggle between three recent calendar years, select a city on the

2018 Klatt Oscar Pool

entertainment Featured

2018 Klatt Oscar Pool

Open to all. No stakes. Just for fun. If you haven't already make your picks via this link! [https://goo.gl/forms/PYoHeVwPhLBL12bP2] See below for selections and results. Don't see your entry? Data might take 24 hours to refresh. Winners and standings will update live

Cord-cutter's Guide to the 2017 MLB Postseason

sports Featured

Cord-cutter's Guide to the 2017 MLB Postseason

I've been shopping around for live TV streaming services the last few weeks. I think I've settled on YouTubeTV (available in Seattle and other select metro areas). But, before I pull the trigger, I'll do some "try-before-I-buy" research as I watch the

NHL.TV U.S. Blackouts - 2017-18 Season

sports Featured

NHL.TV U.S. Blackouts - 2017-18 Season

NHL's streaming service for U.S. customers disallows live viewing of games broadcast nationally in the U.S. on NBC, NBC Sports Network, & NHL Network. The above data visualization displays which teams are blacked out as a result of NBC or NBCSN broadcasts and October 2017 NHL

Super Bowl Squares Probability

sports Featured

Super Bowl Squares Probability

Super Bowl Squares is a game where one buys a square and payouts are dolled out based on the the last digits of the score at the end of each quarter and the final score. Because American football's scoring of (mostly) 7's and 3's

Does The Dog Die?

entertainment Featured

Does The Dog Die?

DoesTheDogDie.com [http://www.doesthedogdie.com] is crowd-sourced website logging whether a dog, or another animal, dies in a film. Users submit ratings that determines 'Does The Dog Die?' status. Below is an aggregation of that data merged with IMDb ratings, where available.

Fact Check: Trump vs. Hillary

politics Featured

Fact Check: Trump vs. Hillary

> Wherever the people are well informed they can be trusted with their own government. - Thomas Jefferson (1789) [http://tjrs.monticello.org/letter/118] Whether in error, or to serve their own interests, politicians too often play fast and loose with the truth, exploiting the public's trust

Fact Check Viz: Behind the Scenes

Data Extraction * Import.io [http://www.import.io] 'Crawler' to scrape tabular data from Politifact [http://www.politifact.com]. Data Scrubbing * A calculated field to format text as dates * Parsed out the fact check ruling from the 'Truth-o-Meter' image URL and assigned them a numerical value

KEXP 2016 Hood-to-Hood Challenge

KEXP 2016 Hood-to-Hood Challenge

Each year, KEXP [wwww.kexp.org] holds a one-day fundraising drive in which Seattle neighborhoods compete for who can give the most dollars in support of the station. In 2016, we adopted a Game of Thrones theme for the event. Using Tableau Public [https://public.tableau.com] I kept track

Seattle Parking Violations

I set out to determine where and when Seattle's parking enforcement officers were issuing the most citations through a data visualization. The purpose: to determine if, at certain times and/or locations, your odds of getting a ticket were ever low enough to risk not shelling out the

Pittsburgh Marathon Training

sports Featured

Pittsburgh Marathon Training

> "Because I always feel like running. Not away, because there is no such place." -Gil Scott-Heron The hardest thing about running your first marathon is the time commitment necessary for training. During all those mind-freeing hours spent running, I occupied my thoughts with creating a visualization to

Politifact - 2016 POTUS Candidates

Politifact - 2016 POTUS Candidates

Last Updated: 3/15/16 Below is an interactive data visualization aggregating fact checked statements of 2016 US Presidential Candidates by Politifact.com [http://www.politifact.com] . In the top table, click a candidate name or '%' to drill down to those fact checks in the bottom table. Or,