Data & Schemas Knowledgebase

Business Schema Naming Standards

Similar to physical schemas, before designing your business schemas it is highly recommended to take the time to develop naming conventions if they are not already in place within your organization.

Variables

Read this article to review variable types in Incorta, when you use them, and best practices around using variables.

Incorta Data Agent

Learn how the Data Agent allows you to connect data sources behind your firewall to the Incorta Cloud

Incorta third-party AI/ML platform Integration

Overview Artificial intelligence(AI) and Machine learning(ML) are being applied to various industries. It is very exciting that Incorta supports integration with third-party AI/ML platforms. When you use AI/ML platform you can leverage the data tha...

Incorta for Data Scientist (Action On Insight).jpg

Copy of Incorta Machine Learning Roadmap 20211005 (1).jpg

Incorta with DataRobot Prediction API Overview

OverviewCode for call to the prediction APILinks to articles that use the APIs under different scenarios Overview This article is part of the series of articles for integrating Incorta with AI/ML platform. The assumptions are that you have created...

Incorta On-premises with DataRobot Real-time Prediction API

Overview In this article, we assume that Incorta is running in an on-premise env and we can call Data Robot real-time API to get the prediction. Solution 1. Read the Incorta data in Incorta Notebook. 2. The Data Robot Prediction assumes that t...

Share Prediction Results from AI/ML Platform with an Incorta on-premise deployment

Create analytics dashboards in Incorta with scored data from an outside AI/ML platform.

How to connect to Oracle Cloud (Autonomous) Database from Incorta On-Prem

A simple guide to getting connected to Oracle Cloud (Autonomous) Database

How to unpivot a source table in Incorta

Reorganize pre-pivoted data sources for analysis.

Exploratory Data Analysis using SweetViz and Incorta Notebook

You can generate the data profiling report using SweetViz from Incorta Notebook. This article shows you step by step instructions.

Generate profile reports using Pandas Profiling package within Incorta Notebook

Learn how to generate profile reports using Pandas Profiling package in Incorta Notebook

Screen Shot 2022-05-08 at 3.45.21 PM.png

Run SQL Queries from PySpark and Incorta Notebook

Incorta Notebook enables you to write SQL queries to create your data pipeline in Incorta Materalized Views.

Screen Shot 2022-04-19 at 10.30.07 AM.png

Screen Shot 2022-04-18 at 10.32.27 AM.png

Level Based Aggregate using Incorta Materialized View

Overview This is the second part of the articles that discusses level-based measures. The essential part of a level based measure is an aggregation that is calculated at a specific level of detail with a result can be repeated at the lower level ...