Artificial Intelligence

AI or not AI? This is the question.

By Alon Brody   |   July 10, 2023

In data analytics, ETL describes the process of extracting, transforming, and loading data to make it ready to use for a predefined task. Note that ELT (extract, load, ...

ETL/ELT

5 Steps of the ETL Process

By Alon Brody   |   March 10, 2023

Earlier this year we partnered with Square to tackle a common problem: how can Square sellers unlock more robust reporting, without hiring a full data team? While we ...

Product

Analyzing Square Data with Panoply: No Code Required

By Alon Brody   |   April 27, 2022

MongoDB is fantastic...and challenging. This database is popular among developers due to its flexibility, but getting your data out of Mongo and into a BI tool isn’t a ...

Databases

MongoDB Business Intelligence: Connector Challenges and Alternatives

By Alon Brody   |   December 6, 2020

If you're thinking about creating a data warehouse from scratch, one of the options you are probably considering is Amazon Redshift. Redshift is very powerful, but ...

Redshift

A Redshift Pricing Guide for CTOs

By Alon Brody   |   August 6, 2020

Preparing data for Business Intelligence (BI) can be a very tedious and time consuming process. You want the data to turn into the best reports for analysis. But, the ...

BI and Data Visualization

How to Prepare Data for Business Intelligence and Analytics

By Alon Brody   |   October 24, 2017

Let's talk about data. The sheer volume of the data collected today is enormous. When I try to even imagine the amounts...it's staggering.

Data Warehousing

Redshift Data Types: Day To Day Challenges

By Alon Brody   |   May 15, 2017

Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached ...

Redshift

Athena vs Redshift: An Amazonian Battle or Performance and Scale

By Alon Brody   |   April 18, 2017

One of the main goals of this blog is to help developers and data architects, just like us, with their Amazon Redshift operations, including Redshift security. Starting ...

Redshift

Redshift Security - Encrypting Loads with S3/KMS/Lambda

By Alon Brody   |   February 22, 2017

Data analyst? You must be familiar with both Tableau and AWS Redshift. And you must know, or at least you should believe me that integrating the Redshift columnar-based ...

Data Warehousing

Tableau & Redshift: How to Visualize Amazon Redshift Data

By Alon Brody   |   February 8, 2017

The basic free Google Analytics (GA) functionality is great for small and medium websites and mobile applications, but as your online business expands, you will start ...

Data Warehousing

Step-by-Step: Loading Data from Google Analytics to Redshift

By Alon Brody   |   January 24, 2017

Extract, Transform, and Load (ETL) is a data warehousing process that uses batch processing to help business users analyze and report on data relevant to their business ...

ETL/ELT

11 Great ETL Tools, and the Case for Saying “No” to ETL

By Alon Brody   |   January 9, 2017

If you’re looking for a solution for processing huge chuncks of data, then there are lots of options these days. Depending on your use case and the type of operations ...

Data Stack

Apache Spark Architecture, Use Cases and Issues

By Alon Brody   |   December 20, 2016

We often come across new products aiming to help us with our lives or improve our productivity. It’s in our best interests to find the best products that will minimize ...

Data Stack

Data Tools: How to Ace Product Evaluation

By Alon Brody   |   June 7, 2016

ETL processes (extract, transform and load) might be fundamentally flawed.

ETL/ELT

How to Improve the ETL Process Flow with Row Data Processing

By Alon Brody   |   February 1, 2016