Introduction
Since saying the Common Availability of AI/BI Genie and introducing Databricks One at our most up-to-date Information + AI Summit, we’ve continued to enhance how organizations analyze and act on information. This month’s roundup highlights new capabilities in AI/BI Dashboards and Genie — from deeper semantic tooling to simpler customization and higher consumer expertise.
These updates are a part of our mission to make enterprise intelligence extra correct, versatile, and accessible. For context, Databricks AI/BI is a built-in suite of BI capabilities in Databricks SQL that lets customers ask questions in pure language, construct dashboards, and share insights — all powered by the Databricks Information Intelligence Platform.
What’s New?
As standard, let’s begin by taking a look at a few of the main new headlines for each AI/BI Dashboards and Genie.
Dashboard Themes
Theme customization—some of the ceaselessly requested options from clients—is now obtainable in AI/BI Dashboards. Authors can now configure coloration palettes and font kinds to raised align dashboards with their group’s branding requirements. These settings might be adjusted from the dashboard’s settings panelthe place customers can select a preset theme or outline a customized one—together with colours for textual content, background, widgets, and chart collection, in addition to title alignment and font kinds. Theme adjustments apply persistently throughout all the dashboard and are preserved throughout export and import, enabling scalable, brand-aligned reporting throughout groups.
International Dashboard Filters
Dashboard authors can now outline International Filters that apply throughout all pages of a dashboard. Accessed by clicking the filter icon within the dashboard toolbar, International Filters open a configuration panel the place you may add interactive filter widgets scoped throughout all the dashboard. Select from field-based filters (e.g., date pickers, categorical dropdowns) or parameter-driven filters, and specify default values to regulate conduct on preliminary dashboard hundreds. This function dramatically simplifies multi-page dashboard design—enabling constant, intuitive navigation and decreasing redundant setup—whereas giving customers a centralized filter expertise.
Dashboard Drill By way of
Drill By way of presents customers a strong new approach to discover dashboards by making use of choices from one web page as filters on one other. With this function, viewers can right-click on an information level in a supply visualization—reminiscent of a bar, pie chart and navigate to a goal web page the place their choice is utilized as an area filter. For instance, choosing “United States” in a sales-by-country bar chart on a abstract web page can routinely filter the element web page to indicate solely U.S. information. Drill By way of unlocks new workflows for investigative evaluation, serving to customers transfer seamlessly from high-level KPIs to deeper diagnostic insights while not having to reset filters or manually repeat choices.
Dashboards File Add
Now you can add Excel, CSV, or TSV information immediately into Unity Catalog from the Dashboards information tab. To outline a dataset from a file, after choosing a dashboard draft, navigate to Information, select Add file, and specify the goal Catalog, Schema, and Desk identify. You select whether or not to create a brand new desk or overwrite an current one—simply guarantee you’ve MANAGE privileges on the goal schema. As soon as uploaded, the file turns into a first-class dataset: question it utilizing SQL, visualize it instantly, or mix it with different Unity Catalog information—all with out leaving the dashboard interface. This empowers customers to discover advert hoc or exterior information seamlessly, decreasing friction within the analytics workflow.
Forecasting for Dashboard Line Charts
Now obtainable in Public Preview, AI/BI Dashboards now leverage the ai_forecast perform to let customers generate forecasts immediately from line chartsreworking historic developments information into forward-looking insights. To make use of it, choose any line chart with a temporal x‑axis and a numeric y‑axis, then click on the “+ Forecast” button within the visualization editor and select “Add AI Forecast”. This creates a brand new chart that seamlessly overlays a forecasted development line. The underlying ai_forecast perform calculates projections based mostly in your chosen information vary and aggregation logic. This function makes it straightforward to anticipate future patterns—whether or not that’s gross sales efficiency, internet visitors, or operational metrics—and incorporate proactive perception into your dashboards.
Enhanced Genie Data Retailer
AI/BI Genie’s information retailer is a foundational development for bettering the standard, relevance, and explainability of solutions returned by Genie. Out there inside every Genie area, the information retailer provides analysts a set of instruments to fine-tune how Genie understands information—enabling extra reliable pure language interactions with out having to change upstream Unity Catalog belongings to start out curating the area.
In style queries at the moment are routinely surfaced when new tables are added, giving enterprise customers steered Instance SQL based mostly on ceaselessly run queries that the creator has entry to.
Authors may also curate and edit dataset metadata for his or her Genie area with a number of new capabilities:
Native desk and column descriptions enable authors to shortly iterate on desk metadata inside a Genie area, while not having to overwrite the descriptions in Unity Catalog. That is significantly useful when an creator lacks permission to change Unity Catalog belongings, needs to check totally different descriptions earlier than making a modification, or needs descriptions that enhance Genie accuracy however don’t belong as a central definition.
Column synonyms make it simpler for Genie to map diverse enterprise phrases to the proper technical fields.
Column present/conceal lets authors declutter the semantic floor by excluding duplicate, irrelevant or overly technical fields, with out requiring new tables or views.
Instance values assist Genie higher perceive how your information is formatted throughout all totally different column varieties (strings, numerics, dates, and so forth).
Worth dictionaries assist Genie map consumer prompts to distinctive string values in your information (e.g. mapping a consumer immediate for “UK” to “nation = United Kingdom”). Genie area authors can now add worth dictionaries for as much as 60 columns and 1,024 distinctive values per column.
Be a part of relationships can now be declared for any dataset to specify joinable datasets, SQL JOIN expressions, and be part of varieties for use. This helps authors who lack permissions to set Major/Overseas Keys in Unity Catalog or are working with views that don’t assist Major/Overseas Keys. Current Major/Overseas Keys from Unity Catalog will routinely sync to cut back danger of duplication/battle.
Collectively, these new options give authors considerably extra management over Genie’s conduct and allow extra correct, context-aware responses—marking an necessary step towards delivering ruled, dependable, and business-aligned conversational analytics. These native variations of desk metadata let area authors shortly iterate and outline context helpful for Genie while not having to replace Unity Catalog globally. For extra info on Genie’s information retailer, please take a look at the product documentation.
Different notable options
We’re consistently working to increase and enhance AI/BI Dashboards and Genie with new options and capabilities. Our ongoing efforts spotlight our dedication to creating AI/BI extra user-friendly, strong, and impactful in supporting your group’s data-driven decision-making. Some noteworthy updates are included under; for a whole listing of options and fixes, please confer with the AI/BI product launch notes.
AI/BI Dashboards
Choropleth Maps. Choropleth maps enable information to be visualized geographically by coloring areas based mostly on aggregated values. Best for displaying patterns like income by state or incidents by nation, this new map kind helps U.S. and worldwide geographies and provides a spatial layer to decision-making in dashboards.
Parameterized Dashboard Schedules. Authors can now outline named dashboard schedules with customized filter parameters, enabling focused report supply with out duplicating dashboards. That is best for groups distributing stories to totally different areas, enterprise items, or buyer segments — all whereas sustaining a single supply of fact and decreasing upkeep overhead. For extra info on creating and sustaining schedules, please confer with the product documentation.
Schedule With out Embedded Credentials (Run as Viewer). Scheduled dashboard deliveries can now be executed utilizing the recipient’s viewer permissions as an alternative of embedding the creator’s credentials. This enhances safety and entry governance, making certain that every consumer sees solely the info they’re entitled to—and aligns supply conduct with enterprise compliance insurance policies.
Outline Customized Calculations Over a Vary: AGGREGATE OVER measures at the moment are supported in customized calculations, empowering analysts to create rankings, operating totals, or transferring averages. This removes the necessity to outline window capabilities inside the SQL question immediately, enabling filtering and aggregations on the identical base dataset throughout a number of widgets.
Ai/bi glyie
Editable Outcomes Filters. Genie customers can now refine Genie solutions by modifying filters immediately inside the outcomes panel. For instance, after receiving a solution filtered by a selected area or product, customers can shortly modify the filter values and regenerate outcomes — serving to customers shortly right queries and accelerating time to perception.
Level Maps Now Supported. Genie now helps level maps in visible responses, enabling customers to view geographic information plotted as particular person factors based mostly on coordinates. This enhancement brings location intelligence to conversational analytics and helps customers visualize patterns like retailer places, service requests, or supply routes.
Observe-up Questions for Textual content Responses. Genie now suggests follow-up questions for text-based responses that don’t embrace generated SQL or consequence units. Beforehand, follow-up prompts appeared solely after responses with information output. Now, even responses like “Clarify the dataset” embrace steered follow-up questions to assist customers uncover new questions they will ask and deepen their exploration inside a Genie area.
Genie API Checklist and Delete Operations. New API endpoints let builders programmatically listing and delete Genie areas and conversations inside an area— serving to organizations automate governance, handle content material at scale, and combine Genie into current workflows and tooling. These APIs are an necessary basis for groups rolling out Genie throughout giant enterprises.
What’s Subsequent?
We’re persevering with to construct towards a extra unified, clever, and accessible analytics expertise throughout Databricks AI/BI. Right here’s a fast take a look at what’s coming:
Enterprise semantics throughout Genie and Dashboards — Already in Public Preview for Dashboards, Metric Views will quickly energy Genie as nicely, bringing trusted KPIs into pure language workflows and shutting the loop between visible and conversational analytics.
APIs for embedded Genie experiences — New APIs will allow you to export/import areas and gather reply suggestions, unlocking scalable deployment and tighter integration into your individual apps.
Smarter Dashboards and simpler sharing — Quickly you’ll see a redesigned counter visualization, a brand new Apply button for filters, and assist for CSV attachments in e mail subscriptions — all designed to spice up usability and attain throughout your group.
We’ll be diving deeper into AI/BI semantics in upcoming blogs and sources — so keep tuned!
Be taught Extra
When you’re seeking to expertise the most recent AI/BI capabilities firsthand, the choices under are designed to information you thru.
Free Trial: Get hands-on expertise by signing up for a free trial.
Documentation: Dive deeper into the small print with our documentation.
Webpage: Go to our webpage to be taught extra.
Demos: Watch our demo movies, take product excursions and get hands-on tutorials to see these AI/BI in motion.
Coaching: Get began with free product coaching by Databricks Academy
eBook: Obtain the Enterprise Intelligence meets AI eBook
Supply hyperlink
