hughess
Evidence Studio - AI-powered analytics IDE
SpaceX Launch Tracker
What would you suggest as a better title?
Apache ECharts + Leaflet + shadcn for data viz
R and RMarkdown were big inspirations for what we're building at evidence.dev now, so very grateful to everyone involved in the R community
Dark mode and themes for BI
ChessRay – a deeper dive into major chess tournaments
Interactive Maps in Evidence
Is the World Happy?
I'm one of the maintainers of Evidence (open source tool based on markdown + SQL) and working on a similar approach to creating presentation tables configurable in code.
Some examples here for any SQL + table enthusiasts: https://docs.evidence.dev/components/data-table
Here's an example project with some filter components and custom styling: https://ecommerce.evidence.app/
This is still a static app - the data warehouse was only hit during the app's build process
https://github.com/evidence-dev/evidence
Previous HN discussions:
https://news.ycombinator.com/item?id=35645464 (97 comments)
https://news.ycombinator.com/item?id=28304781 (91 comments)
Previous HN discussion: https://news.ycombinator.com/item?id=35645464 (97 comments)
We started with D3 and a few other tools, but felt that we get a lot more out of the box with ECharts, like interactivity and an events API. ECharts is also a lot more extensible than people give it credit for.
If anyone is curious, we documented the process of selecting a charting library after assessing several options: https://github.com/evidence-dev/evidence/issues/136
Building the universal front-end for data
"Reporting should be treated like production software" - an overview of Evidence
The Future of BI: Exploring the Impact of BI-as-Code Tools with DuckDB
Previous HN discussions:
https://news.ycombinator.com/item?id=35645464 (97 comments)
https://news.ycombinator.com/item?id=28304781 (91 comments)
Version controlled data visualization [video]
In our team’s experience, the most important factor in getting engagement from users is including the right context directly within the report - definitions, caveats, annotations, narrative. This pre-empts a lot of questions about the report, but more importantly builds trust in what the data is showing (vs having a user self-serve, nervous that they’re making a decision with bad data - ultimately they’ll reach out to an analyst to get them to do the analysis for them).
The second most important factor was loading speed - we noticed that after around 8 seconds of waiting, business users would disengage with a report, or lose trust in the system presenting the information (“I think it’s broken”). Most often this resulted in people not logging in to look at reports - they were busy with tons of other things, so once they expected reports to take a while to load, they stopped coming back.
The third big finding was giving people data where they already are, in a format they understand. A complicated filter interface would drive our users nuts and turned into many hours of training and technical support. For this reason, we always wanted a simple UI with great mobile support for reports - our users were on the go and could already do most other things on their phones.
We couldn’t achieve these things in BI tools, so for important decisions, we had to move the work to tools that could offer text support, instant report loading, and a familiar and accessible format: PowerPoint, PDF, and email. Of course this is a difficult workflow to automate and maintain, but for us it was crucial to get engagement on the work we were producing, and it worked.
This experience inspired my colleague and I to start an open source BI tool which could achieve these things with a more maintainable, version controlled workflow. The tool is called Evidence (https://evidence.dev) if anyone is interested.