To explore trends in healthcare labor statistics, hospital ownership, and healthcare fraud, Jung Hoon Son, M.D. created a data app using Observable Framework to display "data insights with unlimited versatility." Learn more about how the dashboard was built, and see the live version👇
Whether you are a front-end designer, data engineer, analytics engineer, data visualization specialist or any combination of above, this ought to get your attention. Observable Framework is personally one of my favorite data "expression" framework because it really enables expression of data insights with unlimited versatility. One of the more powerful capabilities has been it's ability to run SQL queries off files. Publishing data visualization on the open-web has never been easier. Personally took BLS's Occupation and Employment dataset published over the past 10+ years on occupation-level employment statistics, I wanted to compile a web-demo of BLS's dataset to explore longitudinal trends across entire U.S., with focus on healthcare employment and "where are healthcare workers moving to?". (I'll use this tool to generate a report) On the technical backend: this showcase is running TWO ~1.5 million row data (~8MB parquet each) and live aggregation SQL query in-browser (the "top category" selector). Without a backend SQL server. Generally this is unadvisable, but note that the Excel files off BLS website are 200 MB for each year 😲. Note it's responsive enough to hide in the background / bottom sections of the page. This is possible due to DuckDB-WASM that's been under development (https://lnkd.in/eNYdvCWT) by the DuckDB community. Recorded a quick live demo to showcase the speed and versatility. Oh and it's live on: https://lnkd.in/eMPiPRQV Kudos to Mike Bostock for creating this tool and Allison Horst, PhD's demos tutorial - have inspired me to create my own (my code is too ugly given it's first shot at a project, but will try to tutorialize it). Observable Slack has been very helpful and the constant Github activity is telling of the team's passion to get this even better.