About LukeG

LukeG · 02-22-2023

Quickly save Pandas DataFrames as materialized views without manually defining each column's data type and function. These simple functions allow the switch between Spark and Pandas more efficiently.

LukeG · 10-03-2022

Let's get up and running quickly with the Incorta Cloud.

LukeG · 08-03-2022

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

LukeG · 06-30-2022

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.

LukeG · 06-22-2022

Presentation variables allow dashboard viewers to customize their visualizations on the fly. Dashboard developers can guide their viewers with predefined input options. Follow this guide to steer users in the right direction as they self-serve.

LukeG · 03-29-2023

Hi @rajib76 , I have not used looker in the past, but it looks like a a PostgreSQL database can be connected. Incorta does not store data in a PostgreSQL database but instead presents data through the analytics service using a PostgreSQL connection. ...

LukeG · 03-15-2023

Here is my solution demo! https://youtu.be/dWhTLDDX9yE

LukeG · 03-15-2023

Hi @sambasiva - are you attempting to load data from a SQL Server/PostgreSQL server into your Incorta cloud instance? If so, here are the steps to connect to a PostgreSQL database and load data into a schema. As long as you have the right permissions...

LukeG · 03-09-2023

Here is a video of a code-friendly solution! The script for the MV using PySpark is in the description. Hope you enjoy! https://www.youtube.com/watch?v=Xj6FpwT4fp8

LukeG · 02-14-2023

Not the most elegant, but I got the end result! Here is my solution: Create analyzer table named MONTHLY_REVENUE with 3 columns: Year, Month, RevenueCreate analyzer table named PREVIOUS_MONTHLY_REVENUE with 3 columns: Year, Month, Previous Month Reve...

User Statistics

User Activity

Saving a Pandas DataFrame as a Materialized View (Convert to Spark)

Getting Started with Incorta Cloud

Data Harmonization for Multi-Source

Multi-Source Table Design

How to Configure Predefined Values for Presentation Variables

Re: How do I connect Incorta to Looker or looker studio

Re: Challenge #4 Filter Transactions data by the business days

Re: How to connect SQL server via cloud

Re: Challenge #3 Month over Month Growth Rate

Re: Challenge #3 Month over Month Growth Rate