Blog Post

Azure Data Explorer Blog
2 MIN READ

Introducing Dashboards Base Queries: Enhancing Productivity and Consistency

Michal_Bar's avatar
Michal_Bar
Icon for Microsoft rankMicrosoft
Feb 01, 2024

At the heart of data visualization and analytics lies the quest for efficiency and consistency. Picture this scenario: you're crafting a dashboard, meticulously arranging tiles to present insightful data. However, as you delve deeper, you realize that many tiles share commonalities in their underlying queries. How do you streamline this process without sacrificing precision?

 

Introducing Dashboards Base Queries

 

Imagine a dashboard where numerous tiles draw insights from the same tables and parameters. Traditionally, each tile's query starts from scratch, redundantly repeating query snippets. Not only is this process time-consuming, but it also invites inconsistencies across tiles.

With Base Queries, you can create query snippets and define them as foundational elements within the context of a single dashboard.

 

Let's break down the essence of Base Queries

 

Enhanced Productivity: By centralizing common query segments, Base Queries amplify your productivity. No longer do you need to retype or copy-paste redundant snippets across multiple tiles. With a simple reference to the Base Query, you streamline your workflow and focus on deriving meaningful insights.

 

Consistency Across Tiles: Base Queries ensure uniformity in your dashboard design by standardizing query segments. Whether you're analyzing sales data, monitoring performance metrics, or tracking user engagement, each tile benefits from a cohesive foundation, fostering clarity and reliability in your visualizations.

 

Tailored Flexibility: Base Queries adapt to your unique dashboard requirements. Crafted within the context of a single dashboard, they provide the flexibility to fine-tune queries according to specific data sets and visualization needs. From dynamic parameters to evolving datasets, Base Queries offer agility without compromising on precision.

 

Getting Started

 

Ready to harness the power of Base Queries? Getting started is a breeze:

  1. Define Your Base Query: Identify recurring query segments within your dashboard.
  2. Create a Base Query: Craft a query snippet encapsulating common elements.
  3. Apply to Your Tiles: Seamlessly integrate Base Queries into individual tiles, amplifying efficiency and consistency.

 

 

Create a new Base Query

 

 

 

Enter a Variable name to be used as reference to this base query

 

 

 

Explore the full potential of Base Queries and learn more here.

 

Updated Feb 01, 2024
Version 3.0
  • wernerzirkel's avatar
    wernerzirkel
    Brass Contributor

    I am a little bit disappointed of these base queries. I expected that a base query is executed once and the results can be re-used several times. So the base query would simply pass the result data to multiple tiles. So I created a very complex query, defined a base query and created 30 tiles referring to the base query. Not he best idea. The .show queries command reveals that the base query is not executed once. Instead it is executed 30 times.