Data & Schemas Knowledgebase
A solid data foundation leads to analytics. Build that foundation here.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

A/B Testing Analysis with Incorta PySpark

OverviewWhat is A/B testing?Case StudyData SetTest HypothesesAnalysis in PySparkLoad the data into SparkClean up the dataCalculate the summary of controlled and treatment groupZTest PySpark UDFCall the PySpark UDFConvert the Resulted Array to DataFra...

suxinji_0-1654185327137.png suxinji_1-1654185771798.png Screen Shot 2022-06-08 at 6.37.37 PM.png Screen Shot 2022-06-08 at 6.37.49 PM.png
suxinji by Employee Alumni
  • 1133 Views
  • 0 comments
  • 2 kudos

Data Harmonization for Multi-Source

Introduction When creating visualizations based on multiple source systems, tables must be aligned to achieve a wholistic view of a business. For example, organizations that migrate from one ERP to another align invoice tables from each ERP to see al...

Screen Shot 2022-07-29 at 1.33.36 PM.png Screen Shot 2022-07-29 at 1.36.13 PM.png Screen Shot 2022-07-29 at 5.10.16 PM.png
LukeG by Employee
  • 515 Views
  • 0 comments
  • 2 kudos

Create an ODBC Connection to Incorta

Applies to: Any Incorta version On-Prem/Cloud Question: How to configure an ODBC connection?Unable to connect to Incorta using ODBC Overview: Any program that uses Open Database Connectivity (ODBC) to connect to a remote database needs a way to iden...

Noureldin_0-1658354132173.png Noureldin_1-1658354159123.png Noureldin_2-1658354181612.png Noureldin_3-1658354215841.png

Multi-Source Table Design

Struggling to wrangle data from multiple sources? Learn about how and when to combine similar data points from disparate sources with three different approaches using the Incorta Platform.

Screen Shot 2022-08-16 at 8.12.06 PM.png Screen Shot 2022-08-16 at 8.13.11 PM.png Screen Shot 2022-08-16 at 9.04.54 PM.png Dashboard.gif
LukeG by Employee
  • 1137 Views
  • 0 comments
  • 2 kudos

Getting Started with Incorta Notebook

Introduction In this article you'll learn how to open the Incorta Notebook. The Incorta Notebook was designed for creating materialized views in Incorta. A materialized view is a physical schema that defines an Apache Spark job. The job consists of a...

suxinji_0-1655491258478.png suxinji_1-1655491994355.png suxinji_2-1655492310894.png suxinji_3-1655492397528.png
suxinji by Employee Alumni
  • 636 Views
  • 0 comments
  • 2 kudos

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.

naming.jpg
TomW by Employee
  • 882 Views
  • 0 comments
  • 0 kudos

Variables

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

variables.jpg
VinayR by Employee Alumni
  • 1352 Views
  • 0 comments
  • 0 kudos

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...

suxinji_0-1649872411148.png
suxinji by Employee Alumni
  • 497 Views
  • 0 comments
  • 0 kudos