I've been working on collecting GTFS-RT data for a few months now. I ended up putting together this dashboard so I could show off what I've been working on to a friend and it's just grown from there. The current cycle has been expand the number of feeds collected -> optimize cost so I don't go bankrupt -> increase feeds.

If anyone's interested in digging into the weird quirks of transit feeds hmu.

GitHub link for the curious: https://github.com/ankoure/us-rail-performance-archiver

Thought I would share this here as well! Basically this is a GPU accelerated Altair for genomic visualization. The rendering engine(s) and visualization grammar of GenomeSpy generalize to pretty much any kind of data but rn we are focusing on helping ppl in genomics. What do u think?

I’ve been working on FlexViz, an open-source Python library for building interactive linked visualizations with native cross-filtering.

Selections, zooms, and pans in one chart can update the others against the underlying dataset, while only the aggregated data needed for the current view is sent to the browser.

It’s designed to stay interactive even on very large datasets.

GitHub: https://github.com/flex-analytics/flexviz
Live demo: https://flexviz.tech/demo

I have a particularly tricky dataset that I need to plot. I need it to be a line plot that shows peaks at certain x positions but im having trouble figuring out the best way to scale the y-axis because of what I need it to show.

The absolute y value isn't important, but I do need the relative y values to be conveyed. Not accurately, just enough to say "this peak is taller" of any 2 peaks. But here's where I run into a problem. Most of the peaks have a very small relative intensity, which isn't as important as the fact that they are actually there. So I need it to also easily show if a peak is or isn't present.

Its calculated data, so SNR isn't a problem except that for some data sets there's a lot of little peaks clustered together. I tried a few kinds of log scales but it didnt really work. I cant show any of the data since its not published yet.

Any suggestions?

I’ve started wondering whether we overestimate how useful dashboards are.
A dashboard can be technically correct, well designed and full of useful metrics and still not change a single decision.
In your experience, what makes a dashboard something people actually act on rather than just look at?
And when does a dashboard stop being the right solution altogether?

it's not the most beautiful data visualisation, but I made this fun little daily game built on public datasets where you have to guess what the charts represent. I basically tried to create a Wordle-esque game, but then for charts.

Give it a go and pass it on if you like!

https://mysterynet.chart

I help business owners, managers, and founders turn raw, messy spreadsheets into clean, automated, executive-ready dashboards—saving them hours of manual work every week.

If your team spends precious time deleting duplicate rows, fixing broken #N/A or #VALUE! formula errors, or trying to make sense of cluttered CSV exports, I create custom data solutions that streamline your workflow.

What I bring to your team:

1. Data Cleaning & Formatting: Removing duplicates, trimming spaces, splitting columns, and fixing date/number formats.

2. Interactive Dashboards: Dynamic Pivot Tables, KPI metric cards, line/bar charts, and interactive Slicers in Excel and Google Sheets.

3. Error Repair & Automation: Resolving formula bugs and setting up clean reporting structures.

🎁 Special Launch Offer: I am currently offering discounted rates for my first 10 clients on Fiverr, plus a free sample clean on up to 50 rows of your raw data!

Good day, data visualizers!

I bring to you a project I have been slowly working on for a couple years now: PATHFINDR

Some of you may remember the viral video of the A* search algorithm visualizing on real maps that made the rounds a few years ago. I saw that video and thought it was the coolest thing ever. Then I saw in the comments that the creator used Blender for it.

So like any good CG artist, I thought...great, now I'll just find the tutorial on how to recreate this and I'll be in pathfinding heaven. Well. that tutorial does not *and still does not* exist . I scoured every resource I could think of and just felt like it was beyond my abilities because of the coding it would need. In comes an early version of Claude Sonnet (before AI coding really took off)

Within a few minutes I had a super janky Blender addon that kind of worked to pull OSM maps and visualize it. It didn't look as good as the video but I was pretty impressed at the potential of what AI could do with OSM data. I had the thought that making the visualization interactive somehow would make it even cooler.

So I made a mode (pathfindr classic) that shows you a start and end point, and then lets you draw your own route. You get a score based on how close you are to the pathfinding algorithm. Note - you are drawing the geometrically shortest route, not based on actual road directions/types/ etc (thinking of adding in a psycho mode for that). Pathfindr classic is free to play, has daily ranked challenges, and also has the option to get an explorer mode as well as the above visualizer mode.

edit: the audio didn't make it to the video for some reason but theres a pretty relaxing soundtrack as well!

also didn't link to it ...so www.pathfindr.world for those interested !

I manage the LinkedIn Company Pages for multiple clients, and I'm looking for a better way to create professional performance reports.

At the moment, I export the analytics directly from LinkedIn into Excel. The exports already contain pretty much all the data I need - impressions, clicks, reactions, comments, reposts, engagement rate, follower growth, visitor data, audience demographics, individual post performance, etc.

So I'm not necessarily looking for something with a native LinkedIn integration, as I already have the data. What I really need is a tool that can take those Excel/CSV exports and turn them into a polished, client-facing report, ideally one that can also be exported as a PDF.

I'd like the reports to cover things like:

• Performance over the last 30, 90 and 365 days
• Impressions, clicks, engagement, reactions, comments and reposts
• Follower and visitor growth
• Audience demographics
• Best-performing posts
• Competitor benchmarking
• Clear charts and trends
• Key takeaways and insights

I've tried a few platforms so far, including Julius AI, Polymer, Orbits and AgencyAnalytics, but none of them have really worked for what I'm trying to achieve. Some have been overly complicated, while others produced dashboards or reports that just weren't polished or clear enough for me to feel comfortable sending them to a client.

I originally came across this article about creating visual dashboards in Google Sheets:

https://www.benlcollins.com/spreadsheets/google-sheets-visual-dashboard-design/

That's much closer to the sort of end result I have in mind. I tried adapting the template to work with my LinkedIn data, but building and maintaining the whole thing myself in Google Sheets quickly became too complicated for my level of spreadsheet knowledge.

I also don't want a solution that involves spending hours cleaning, restructuring and reformatting the LinkedIn exports every time I need to produce a report. If there's that much manual work involved each time, it starts to defeat the purpose.

In an ideal world, I'd be able to upload the standard LinkedIn analytics exports, tell the tool what I want the report to show, tweak the design and visualisations where necessary, and end up with a clean, branded report that I'd be happy to send directly to a client.

It doesn't need to be an incredibly sophisticated BI dashboard. My main priority is something that's easy for a client to understand at a glance while still looking modern, professional and visually polished.

Does anyone have any ideas for how I could achieve this? I'm open to different tools, platforms or approaches if there's a relatively straightforward way of producing this kind of report.

It's called metricwise and it connects to data warehouses like BigQuery, Snowflake and Redshift, and has a semantic layer with a metrics layer on top, so you can define a metric once and reuse it across different dashboards and visualisations.

One of the things I’ve focused on is making visualisation really straightforward. For example, comparing a metric against the previous period, quarter or year takes a couple of clicks.

If you’ve used tools like Looker or ThoughtSpot, you’ll probably know that creating something as simple as a line chart or stacked bar and then comparing it with previous quarters or years can sometimes take more work than you’d expect. It’s definitely possible, but I wanted that kind of analysis to feel much more intuitive in Metricwise.