Tableau launches new data model with Tableau 2020.2
Tableau Software, the analytics platform, has announced the general availability of Tableau 2020.2. The release delivers a new data model that simplifies the analysis of complex data with no coding or scripting skills required. The latest release also introduces Metrics, a new mobile-first way for customers to instantly monitor key performance indicators (KPIs).
“Now more than ever, organisations need a combination of speed, agility, and empowerment to ensure everyone is able to make data-driven decisions quickly,” said Francois Ajenstat, Chief Product Officer at Tableau Software.
“With new data modelling capabilities, Tableau 2020.2 reduces the effort needed to analyse even the most complex datasets and simplifies analysis for anyone, regardless of expertise. In addition, Metrics enables everyone to instantly access the most vital data at their fingertips so they can make better decisions about their business from anywhere.”
Data modelling
Tableau’s new data modelling capabilities make it even easier to analyse data across multiple tables at different levels of detail. With a simple and visual drag-and-drop experience, relationships between tables can be created that automatically create accurate aggregations. This eliminates complex coding and reduces the risk of inaccuracies encountered with traditional database joins.
For example, an organisation can better plan for expected product return rates in a certain region by relating a table of sales orders with a table of historical returns, through a common zip code ID field. Relationships also make queries more efficient and performant, and data sources easier to maintain. Tableau’s modern data model will automatically aggregate at the appropriate level of detail for the customer’s analysis.
“With Tableau’s data model improvements we are able to work faster in our COVID-19 analysis. We have COVID-19 case data at a county level, testing data at a date level, and hospital data at an institution level, and we’re overlaying census population data to normalise everything per capita,” said James Smith, Co-Founder & Director at Vantage Information Services, an analytics consultancy.
“This would have required multiple join combinations into several disparate data sources to analyse the data, but with the improvements to Tableau’s data model, we can easily relate tables in a single, flexible data source. Looking ahead, the ability to easily combine tables at different levels of granularity will save time and allow us to do more complex analysis.”
Faster analysis
Relationships can also bring unprecedented flexibility to make data sources more efficient and accurate, only querying relevant tables to improve dashboard performance. Because multiple levels of detail are preserved in a single data source with industry-standard star and snowflake schema support, customers are able to streamline their data source management process, share combined sources across the organisation, and enjoy a more intuitive analytics experience - with fewer distinct data sources for organisations to create and maintain.
“Historically, we have spent a lot of time designing and building underlying data models in our warehouse to optimise for analysis. With relationships, we can seamlessly bring in multiple tables, automatically aggregating at the right level of detail without any calculations or custom SQL, reducing the total number of data sources we need to manage,” said James Baker, Global Director of business intelligence at JLL, a real estate and investment management firm with a strong Asia Pacific presence.
“Being able to drill down within a single data source is a game-changer and enables lots of possibilities. This will provide our analysts and stakeholders with a much better experience as we’ll be able to get them the data they need in one place where they can explore at different levels of detail.”
Data at-a-glance
The introduction of Metrics gives people a simple way to monitor KPIs for their organisation, providing a custom, at-a-glance view of the most critical data.
“Metrics will allow us to easily deliver our most important KPIs, like month-over-month and year-over-year revenue, customer churn, and upgraded or downgraded subscriptions, to our CEO and senior managers,” said Dominik Ruf, Data Analyst at Enscape, a provider of real-time 3D rendering and visualisation technology.
“Even when they aren’t in the office, Tableau’s Metrics will quickly give them a personalised view right on their phone of the numbers they need to make decisions.”
Additional features in 2020.2 include:
- Esri ArcGIS support: Users can now visualise their Esri geo-spatial data directly in Tableau. They can easily solve more location-based questions, and make their Esri data more accessible.
- Ask Data improvements: Create custom suggestions to give users relevant prompts and now use data roles to add consistent semantic context across data sources.
- Advanced data management: Tableau Prep Builder adds a native, direct connection to customer Salesforce data, as well as incremental data refresh to add only new data to a workflow, eliminating the need to refresh an entire data set.
- Data accuracy: Tableau Catalog ensures customers are using the most trusted data with new High Visibility Data Quality Warnings, highlighting the most pressing issues that may impact the accuracy of their data.
Explore:
Customers can instantly access these features, as well as new connectors for geospatial data, by upgrading to Tableau 2020.2.
Start a free trial
Get free resources and starter dashboards
“Now more than ever, organisations need a combination of speed, agility, and empowerment to ensure everyone is able to make data-driven decisions quickly,” said Francois Ajenstat, Chief Product Officer at Tableau Software.
 |
| Source: Tableau website. The set control allows users to dynamically change the members of a set using a familiar, quick filter-like interface. |
Data modelling
Tableau’s new data modelling capabilities make it even easier to analyse data across multiple tables at different levels of detail. With a simple and visual drag-and-drop experience, relationships between tables can be created that automatically create accurate aggregations. This eliminates complex coding and reduces the risk of inaccuracies encountered with traditional database joins.
For example, an organisation can better plan for expected product return rates in a certain region by relating a table of sales orders with a table of historical returns, through a common zip code ID field. Relationships also make queries more efficient and performant, and data sources easier to maintain. Tableau’s modern data model will automatically aggregate at the appropriate level of detail for the customer’s analysis.
“With Tableau’s data model improvements we are able to work faster in our COVID-19 analysis. We have COVID-19 case data at a county level, testing data at a date level, and hospital data at an institution level, and we’re overlaying census population data to normalise everything per capita,” said James Smith, Co-Founder & Director at Vantage Information Services, an analytics consultancy.
“This would have required multiple join combinations into several disparate data sources to analyse the data, but with the improvements to Tableau’s data model, we can easily relate tables in a single, flexible data source. Looking ahead, the ability to easily combine tables at different levels of granularity will save time and allow us to do more complex analysis.”
Faster analysis
Relationships can also bring unprecedented flexibility to make data sources more efficient and accurate, only querying relevant tables to improve dashboard performance. Because multiple levels of detail are preserved in a single data source with industry-standard star and snowflake schema support, customers are able to streamline their data source management process, share combined sources across the organisation, and enjoy a more intuitive analytics experience - with fewer distinct data sources for organisations to create and maintain.
“Historically, we have spent a lot of time designing and building underlying data models in our warehouse to optimise for analysis. With relationships, we can seamlessly bring in multiple tables, automatically aggregating at the right level of detail without any calculations or custom SQL, reducing the total number of data sources we need to manage,” said James Baker, Global Director of business intelligence at JLL, a real estate and investment management firm with a strong Asia Pacific presence.
“Being able to drill down within a single data source is a game-changer and enables lots of possibilities. This will provide our analysts and stakeholders with a much better experience as we’ll be able to get them the data they need in one place where they can explore at different levels of detail.”
Data at-a-glance
The introduction of Metrics gives people a simple way to monitor KPIs for their organisation, providing a custom, at-a-glance view of the most critical data.
“Metrics will allow us to easily deliver our most important KPIs, like month-over-month and year-over-year revenue, customer churn, and upgraded or downgraded subscriptions, to our CEO and senior managers,” said Dominik Ruf, Data Analyst at Enscape, a provider of real-time 3D rendering and visualisation technology.
“Even when they aren’t in the office, Tableau’s Metrics will quickly give them a personalised view right on their phone of the numbers they need to make decisions.”
Additional features in 2020.2 include:
- Esri ArcGIS support: Users can now visualise their Esri geo-spatial data directly in Tableau. They can easily solve more location-based questions, and make their Esri data more accessible.
- Ask Data improvements: Create custom suggestions to give users relevant prompts and now use data roles to add consistent semantic context across data sources.
- Advanced data management: Tableau Prep Builder adds a native, direct connection to customer Salesforce data, as well as incremental data refresh to add only new data to a workflow, eliminating the need to refresh an entire data set.
- Data accuracy: Tableau Catalog ensures customers are using the most trusted data with new High Visibility Data Quality Warnings, highlighting the most pressing issues that may impact the accuracy of their data.
Explore:
Customers can instantly access these features, as well as new connectors for geospatial data, by upgrading to Tableau 2020.2.
Start a free trial
Get free resources and starter dashboards
Comments
Post a Comment