on 03-18-202201:49 PM - edited on 03-29-202310:46 AM by Tristan
Organizations who choose to accelerate their Tableau dashboards with Incorta can perform direct query against 100s of millions of records with sub-second performance. With this integration, data can easily be brought together from multiple data sources without the need to do complex data modeling first. Additionally, Incorta can simplify the development of Tableau dashboards, by offering semantic layer in Incorta (called business views). These business views can contain human readable fields and complex business formulas that abstract away the complexities of the underlying data.
Many of Incorta's customers choose to power their Tableau dashboards with Incorta's extremely performant data platform. To maximize performance and avoid as many configuration headaches as possible, there are a few best practices that should always be followed that are outlined below:
Design business schema with one view for a Tableau Report. Each Tableau visualization should be built against a single Incorta business view. With this approach joins do not have to be defined (again) in Tableau. And why would you want to define them in Tableau since they're already defined in Incorta?
Every Incorta business view used by Tableau should have a base table defined. This enforces a well-understood "record grain" to the Incorta view such that it cannot change as different fields within the business view are used on the Tableau dashboard.
Every Incorta business view used by Tableau should generate valid SQL. From the Analyzer, create a simple listing table based on each business view and then click the SQL icon in the upper right corner to view the SQL that is generated. If the SQL does not generate, the business view will not work in Tableau.
Set up User Impersonation if using Tableau Server. In order to enable record level security through Tableau, you must first define record level security in Incorta. Tableau Server will connect to Incorta using a "service user" account, but will also send the Tableau Server "user" info to Incorta so that Incorta can apply row level security before sending the response back.
Define your formulas in Incorta, not in Tableau. Take advantage of Incorta's lightning fast in-memory DDM analytics and push all the formulas to Incorta. They will be much slower if rendered on the Tableau side.
Configure Incorta to use a higher value for “Max Group” in the Incorta CMC. The default is 1M, but this should be increased to 5M or 10M. Be careful though. If set too high this can have a negative affect on Incorta system performance.
Avoid creating visualizations in Tableau which download thousands of records. If you add a table visualization in Tableau which is fetchingthousands of records, unlike Incorta, Tableau will download all records and will take time to download and then render data in the sheet. Please add a default filter for the Tableau table visualization to limit number of records downloaded.
Please reach out to your Incorta customer success team for more guidance delivering these design practices in an optimal way.