Modeling Schemas, Tables, and Joins
The purpose of this article is help users understand data modeling concepts and best practices in Incorta .
Knowledge Base Articles
Data Validation Tips
How to validate data between a Incorta report and my legacy BI report.
Modeling Schemas, Tables, and Joins
The purpose of this article is help users understand data modeling concepts and best practices in Incorta.
Date Dimension
Date is a common dimension used in most application deployments. It is primarily used to roll up data so it can be viewed across a broad time range, facilitating trend analysis.
Organizing Business Schemas
Introduction Business Schemas are a useful way to group content for business users that can be used in one or more dashboards. They also remove the need to understand all of the underlying data relationships even when they span several source data ...
Formula Columns
An expression can consist of built-in functions, built-in system variables, and other referenceable objects valid for the expression context.
Performance of Materialized Views (MV)
Introduction Incorta Materialized Views are a powerful way to enrich data contained in Incorta tables. Leveraging Spark's processing engine, Materialized Views (MVs) can be defined to introduce enrichments and advanced analytics to reshape your dat...
Regular vs. Analyzer Views
Introduction Incorta offers two types of business schema views- regular and analyzer (Runtime or Incorta) views and both are useful to support various use cases. What you should know before reading this article We recommend that you be familiar with...
Using Formula Columns in Business Views
Introduction A formula column contains an expression that, depending on the expression and the expression context, returns a scalar or an array of values of a specific data type. An expression can consist of built-in functions, built-in system variab...
Handling Hierarchical Data
IntroductionIf you need to represent hierarchical data in Incorta, we provide several features that make this data modeling technique easier. Common use cases for hierarchy include HR org chart, chart of accounts, and even your Incorta dashboards' fo...
Snapshotting Data
Introduction If you need to create point in time reporting in Incorta, you may need to implement a snapshotting strategy. Often the source application itself will track changes to its data and thus you can get a full historical view of changes to d...
Business Views for 3rd Party Visualization Tools
Introduction As a Universal Data Analytics Platform (UDAP), Incorta provides a fully featured and rich experience from data acquisition, to data enrichment all the way through to data visualization - all with massive data sets and at incredible spee...
