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

Getting Started with Spark SQL

IntroductionWhat you need to know before reading this articleStepsNavigationIncorta Notebook for SparkSQLAutocomplete for SparkSQLUse the DESC command to get the list of columnsUse Incorta Notebook Visualization   Introduction Incorta Materialized Vi...

suxinji_1-1659564399051.gif suxinji_0-1659564366856.png suxinji_2-1659564782131.gif suxinji_0-1651700616193.png
suxinji by Employee Alumni
  • 671 Views
  • 0 comments
  • 0 kudos

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
  • 1125 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
  • 514 Views
  • 0 comments
  • 2 kudos

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
  • 1134 Views
  • 0 comments
  • 2 kudos

How Joins Work in Incorta

Introduction Incorta supports the following types of joins: One-to-one (1:1) Many-to-one (M:1) Many-to-many (M:M) joins using Materialized Views Example: Simple Many-to-one (M:1) Join Tables: Sales table Customer table The Sales table has mult...

KailaT by Employee Alumni
  • 1246 Views
  • 0 comments
  • 1 kudos
Best Practices Index
Best Practices

Just here to browse knowledge? This might help!