🚀 Holistics January 2025 Updates

Monday, January 27, 2025

How’s your first month of 2025?

Returning to work after a long holiday can feel like opening an old, cluttered dashboard—widgets are outdated, the layout feels clunky, and you’re not quite sure where to begin.

It’s overwhelming, but familiar.

The same thing happens when you work with metrics in a system that’s not built for them. Numbers conflict, dashboards contradict, and decisions are delayed as teams argue over whose data is “right.”

At Holistics, we believe metrics should be a shared language—clear, consistent, and tied to the way your business thinks. And this language is missing.

Without it, everything falls apart. Metrics are defined differently by different teams, manipulated awkwardly in rigid tools, and often presented without the context necessary to interpret or act upon them.

This is the problem we’re solving. In 2024, we released over 80 new features and updates, with each one a step closer to a system where metrics are consistent, intuitive, reusable, and meaningful.

We’re not there yet, but we’re getting close. We know it’s hard to keep track of all our new features and updates, so we put some of our best highlights in this newsletter.

It’s a long read, but I hope it’s worth your time.

:battery: Making Metrics Composable and Reusable

For years, analysts have relied on clunky tools and sprawling SQL scripts. Repetition and inconsistency ruled their workflows.

We knew this had to change. If metrics are to become a shared language, they must be easy to build, extend, and trust. Analysts needed simpler, smarter tools first.

To achieve this, in 2024, we released:

  • Reusable BI Components
  • Dynamic Data Sources
  • Improved Development Experience

:bamboo: Reusable BI Components

Analytics code often falls short of software engineering standards. We’ve all seen it – sprawling SQL queries, duplicated logic across reports, and metrics that somehow give different results depending on who ran the query. It’s a maintenance nightmare waiting to happen.

In 2024, we added reusability features to allow analysts to:

  • Build reusable chart components.
  • Define metrics once and use them everywhere.
  • Simplify ad-hoc analysis with modular design.

This ensures metrics are consistent, reliable, and scalable across your organization.

:ferris_wheel: Dynamic Data Sources

Switching data environments was a manual slog. Dynamic Data Sources was added in late 2024 and is coming out of beta as we type. Analysts can:

  • Use the same set of data setups for different clients, with each client pointing to a different database (or schema).
  • Automatically toggle between Dev and Prod databases based on your Holistics environment

No more manual updates. Just one system that adapts to your needs.

:ocean: Improved Development Workflow

With Holistics, you have a centralized, code-based modeling layer with a metric-centric query language that makes composing metrics easier, eliminating the need for cumbersome SQL workarounds.

Yet, the analytics development experience can always be improved. In 2024, we continue to eliminate bottlenecks in your development and Git workflow. We introduced:

1) Smoother Git Workflow: Fewer steps, faster syncs, and less friction. https://cdn.holistics.io/product-newsletter/aug24/git-workflow.mp4

2) Version Restore: Mistakes happen—now they’re easy to fix.

3) Branching URLs: Share links that take teammates straight to the right branch and object.

4) New Conflict Resolution Flow: Resolve Git conflicts with less hassle.

:diamond_shape_with_a_dot_inside: Making Metrics Easier To Manipulate

Without intuitive tools to drill into data or manipulate metrics, insights often remain surface-level, so we made metrics a bit easier to manipulate and explore.

:robot: Turning Common Analytics Functions Into 1-Click Operations

In 2023, we introduced AQL (Analytical Query Language), a powerful tool for advanced analytics. But we know not everyone wants to code. That’s why we built on AQL’s foundation to create a point-and-click interface for simpler analytics.

Now, with just a few clicks, business users can explore trends, identify patterns, and analyze distributions across metrics. Questions like “How are sales trending?” or “Are we hitting our targets?” are now as easy to answer as opening a report.

These analytic functions combine AQL’s power with simplicity. Here’s what you can do:

  1. Trend Lines: Identify and visualize trends over time.
  1. Reference Lines: Compare actuals against benchmarks or targets.
  1. Percent of Total: Understand each component’s contribution to the whole.
  1. Moving Calculations: Smooth out data fluctuations or calculate the cumulative sum.

5) Period-over-Period Comparisons: Compare metrics across different time periods.

:abacus: Excel-Like Table Interactions

We brought Excel’s flexibility to Holistics tables, so you can work with data the way you already know.

With a few clicks, you can rename, freeze columns, change aggregations on the fly, autosize columns, drag and drop to reorder, and more. It’s familiar, intuitive, and fast.

:abacus: Condition Group

Our Condition Group feature makes complex filtering simple. You can create OR conditions, group filters, and even nest groups within groups. Build filters that match your logic, not just what the tool allows.

:door: Context-Rich Tooltips

Add measures, calculations, and AQL metrics directly to chart tooltips. Provide clarity without cluttering your visuals.

:sunrise: Turning Metrics into Visual, and Business-Centric Tools

Metrics matter most when they’re presented in a way that fits your business context and drives actions. But traditional BI dashboards often fall short. They’re rigid, lack reusability, and reduce storytelling to static charts and numbers.

So we built Canvas Dashboard—a tool designed to turn metrics into sense-making stories. With it, you can present data, tell stories, and provide clarity that aligns with your business needs.

:rice_scene: Free-Form Dashboard Design

Canvas treats every element as a “block.”

Charts, filters, text, and more can be arranged freely. Add explanations, embed business models, or organize layouts to match how your business thinks.

:national_park: Dashboard Themes and Custom CSS Styling

Define reusable themes, set typography styles, and create consistent branding with custom CSS. Whether it’s light mode, dark mode, or a dashboard that looks like a magazine cover, the choice is yours.

:floppy_disk: Taking Action: From Metrics to Decision

Static dashboards are no longer enough. Once you understand your metrics, the next step is to act on them. That’s why we introduced Actions, a feature that lets you define workflows directly in dashboards. Imagine:

  • Noticing low stock in a report and emailing a vendor with one click.
  • Spotting customer inactivity in a CRM dashboard and opening their profile instantly.

Actions turn your Holistics dashboard into a dynamic tool for decision-making, closing the gap between insight and action.

:zap: Delivering Metrics Faster

Now you have your metrics. It’s easy to create, manipulate, and beautifully presented, but no one will know when every dashboard visit is a game of “spin the loading wheel”.

In 2024, we’re committed to getting rid of dashboard dawdling in Holistics. Everything is now a little faster, a little smoother, and a whole lot more enjoyable to work with.

:zap: Aggregate Awareness

With Holistics Aggregate Awareness, the query engine automatically picks the most optimal aggregated tables per each query for maximal query performance. It uses smaller pre-aggregated tables to deliver accurate results, allowing analysts to maintain pre-aggregates with less effort.

:zap: Canal - a fast query streaming engine

Our performance team introduced a new query execution engine, which delivers 5-30x faster performance for large dashboards of up to 500K records.

:zap: Customer Persistent DDL

You can declare the custom_ddl for a Persistence, and customize how the persistence table is created in your Data Warehouse. This allows you to apply Data Warehouse optimization features and techniques such as indexing, clustering, applying SORTKEY, etc. to improve the performance of your physically persisted tables.

:zap: Job Performance Analytics

With Job Performance Analytics, you can:

  • Spot the slowest reports in your workspace.
  • Identify dashboards that need performance boosts.
  • Monitor if your Holistics Job Workers are overloaded.
  • Monitor dashboard speed after optimizing SQL or your data warehouse.

:house: Quality of Life Improvements

It’s these little things and attention to detail that make the software invisible (seamless) to the users. In 2024, we polished the details to make every interaction more seamless.

Here are some highlights:

1) Filter Dashboards by URL: Pre-filter dashboards by adding parameters to the URL.

2) Date Drills: Add multiple date drill options, with results persisting in exports and schedules.

3) Public Dashboard Embedding: Embed dashboards anywhere—blogs, Notion, wikis—so your data lives where it’s needed.

What’s Next?

If you’ve made it this far, let me begin by saying thank you. Truly.

Holistics has been on this journey since 2015. We’re one of the very few BI tools that bootstrapped our way here, brick by brick, and we couldn’t have done it without you.

This has been our busiest year yet — more projects, more features, more ambition. We’re excited. Hopeful. Anxious, too, in the way anyone would be when they sense the future closing in fast.

This is the year of better end-user experience—where accessing, exploring, and manipulating data feels as natural as breathing. And we’re not stopping there.

While we continue to invest in the fundamentals, we’re also reaching higher with experiments that might just reimagine what’s possible with Holistics.

Here are a few examples of where we’re headed:

Sheety (Self-service BI in spreadsheets): An extension that allows business users to explore Holistics data within the Google Sheet interface while allowing data teams to maintain a single source of truth.

Askwitch: A chat copilot that answers your data questions in seconds. It can summarize, aggregate, plot, and even run what-if scenarios. Sometimes, you just need to ask.

We’ll share more about these experiments with you in a separate newsletter. But for now, that’s all. I hope to see you in the days to come, and I hope I continue to hear from you. :slight_smile:

End Notes

If you’re curious about our upcoming direction, check out our Product Roadmap. If you’re interested in what we just released in the past few months, check out our Release Note.

Do you have any feedback for us? If you do, hit Reply and let me know. Or connect with me on LinkedIn and we can chat.

I’ll see you again real soon!