New demo for embedding Shaper dashboards into your own software. It uses a healthcare dataset. Pick an insurance to log in as and the dashboard only shows that insurance's data. The video also shows my workflow for developing embedded dashboards. www.youtube.com/watch?v=9ilz...

Workflow for creating embedded analytics dashboards with Shaper

YouTube video by Taleshape Analytics

youtube.com

We just added Single Sign-On functionality to Shaper. And we made it open source. Here is why. taleshape.com/blog/why-ope...

Why is Shaper's Single Sign-On Feature Open Source?

TODO

taleshape.com

New Shaper Feature: Single Sign-On Shaper now supports external user management with JWT-based SSO. No separate user login to manage. No password to remember. And it's open source and free to use. See it in action:

How does Shaper compare to other data visualization tools? @dataders.bsky.social built a cool project to compare 10+ code-based dashboarding tools. The project is completely code-based and processes data with DBT, then visualizes the results. Most of the tools directly generate static HTML. 1/2

Added a new chart type to @taleshape.com: Scatter Plots This is how you define this chart in SQL: SELECT 'Session Durations'::LABEL; SELECT created_at::XAXIS, category::CATEGORY, duration::SCATTERPLOT, FROM dataset GROUP BY ALL ORDER BY ALL; Docs for more: taleshape.com/shaper/docs/...

Did you know you can download @taleshape.com dashboards with SQL? Use Shaper's API to download PDFs, images, Excel files and so on. Call the API with the DuckDB http_client extensions from a Shaper task to post charts to Slack, email a weekly PDF report or automate anything else you can think of.

And as always, defined directly in the SQL query. More in the docs: taleshape.com/shaper/docs/...

New @aleshape.com Visualization Option: Confidence Bands Allows you to show a band for a line chart which is great to show extra statistical context (the confidence of a prediction, the spread of a distribution, etc) It's a nice middle ground between only show a line and showing a full Boxplot

It's not pretty but works. In the future I will add SQL functions similar to the macro to generate files without needing an API key. And I am thinking to create a generic DuckDB extension to send mail, slack messages and so. Can also generate png, excel, csv & json. Will dm you the code!

Skills for @taleshape.com are here: Use with Claude Code/Codex/Gemini to create dashboards quickly. With the skills the agent knows Shaper SQL, validates the create dashboard and gives you a preview URL once ready. More here: github.com/taleshape-co...

The @taleshape.com CLI just got an upgrade 🚀️ New Commands: - fetch the database schema - validate a dashboard - open a preview in the browser Task Support: - Tasks a files: mytask.task.sql - Run task on startup: `SELECT 'init'::SCHEDULE;` 1/3

Did you know duckdb.org's UNPIVOT feature? You rarely need them but from time to time PIVOT and UNPIVOT really help to keep your SQL easy to read: PIVOT turns one row into multiple columns. UNPIVOT turns columns into multiple rows. 1/2

We updated our handle: Taleshape is now @taleshape.com on BlueSky.

@taleshape.bsky.social Cloud is now in beta! The simplest way to start building dashboards and customer-facing analytics with Shaper. Let me know what you think: taleshape.com/plans-and-pr...

The @taleshape.bsky.social docs now have live examples 📊 Examples are now embedded as live dashboards instead of only screenshots. With this you can also directly see the differences between light and dark mode:

I have seen @taleshape.bsky.social provide the most value to companies in healthcare and other regulated industries. I like to double down on that and need your help: 1/2

Did you know that with @duckdb.org you can directly query your database schema? When you combine this with considerate comments on your tables and columns it becomes a powerful tool to build agents and other systems that dynamically discover and learn to use your data.

I built a Slack data analytics agent on top of @taleshape.bsky.social. The agent answers your questions and uses our new API to directly send charts, Excel files or PDF reports into Slack. taleshape.com/blog/build-y...

Build Your Own Data Analytics Slack Agent With Shaper

Learn how to build a custom Slack AI agent for data analytics using Shaper to generate charts, Excel files, and PDF reports directly from SQL.

taleshape.com

I set up a minimal self-hosted data lake platform with DuckDB, DuckLake and @taleshape.bsky.social. The whole setup is a single docker compose file that covers all basic data needs from ingest and storage to transform and visualization: taleshape.com/blog/simple-...

Self-hosted Data Lake Platform with DuckDB, DuckLake and Shaper

Learn how to build a simple data lake platform that scales from $5 VM to petabytes of data with DuckDB, DuckLake and Shaper

taleshape.com

Shaper - a a duckdb powered dashboarding tool Interesting approach of extending SQL with dashboarding instructions. Slight difference to evidence with using SQL in markdown and then custom tags. taleshape.com/shaper/docs/

Welcome to Shaper

Shaper is an open source, minimal data platform to create analytics dashboards and embed them into your software.

taleshape.com

Today @taleshape.bsky.social launched on Uneed and people seem to like it 👀 If you have a minute, I am happy about your support 🙏 www.uneed.best/tool/taleshape

@taleshape.bsky.social now offers hosting + support for Shaper! Fully-managed, On-Premise BI with White-Labeling for 150/month anyone? I am happy about any feedback🙏 And if you can think of any company that might be interested in code-first embedded analytics powered by DuckDB, please reach out 👀

I haven't updated my personal blog since starting @taleshape.bsky.social so I used that as a chance to give an update on why I am building Taleshape and where things stand right now: jorin.me/building-tal... Also: I am always happy about any ideas on where to take Taleshape next 🙏

On that note, we are currently experimenting with AI agents using @taleshape.bsky.social to run SQL and generate charts. I see the strength of Shaper's SQL approach in how transparent + auditable everything is. Reviewing SQL is much more doable than JSON definitions or even completely custom code.

My biggest recap from FOSSASIA this year: It's all AI now. I felt a stark contrast to last year that basically every talk is about AI. No one writing code by hand is already old news. And now everyone is automating all their processes with agents. It's a wild time to build a software product!

What's cool is not only this new feature itself, but that I didn't built it: You can now download @taleshape.bsky.social tables directly as CSV. Last week Shaper got attention on HN and now people start to actively contributing and making it better for everyone. That's why Shaper is open source 💙

@taleshape.bsky.social now has "watermarks" for chart download to make it easy for your customers to credit you. One of the companies I work with integrated Shaper into their product. And now their customers use various dashboards regularly as part of their daily work. 1/2

Got curious why there is a sudden spike in github stars and turns out someone posted @taleshape.bsky.social on HN: news.ycombinator.com/item?id=4705...

I couldn't imagine a better fit than DuckDB for @taleshape.bsky.social: Shaper is all about using SQL to build data visualizations and sharing them. There are many databases, but DuckDB and its powerful extension system allow Shaper to query many different data sources, all from a single binary.

I sometimes forget that @taleshape.bsky.social supports dark mode: