Panoply.io - A blog about data management and data infrastructure

Technical insights and creative ideas about data management, data infrastructure, and data analysis.

Subscribe to our emails and get Panoply updates on the fly.

Alon Brody

Recent Posts

Data Technology

Redshift Pricing: A Data Engineer's Guide

Although there are several data warehousing systems on the market, Amazon Redshift and Google BigQuery are the industry behemoths. There is a “prevailing consensus that Amazon is leading the pack.....

[+]
Written by Alon Brody |July 06, 2017

Data Technology

Redshift Data Types. Day to Day Challenges.

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.

[+]
Written by Alon Brody |May 15, 2017

Data Technology

Redshift Query Queues: The Complete Guide

Setting up a Redshift cluster that hangs on some number of query executions is always a hassle. When users run queries in Amazon Redshift, the queries are routed to query queues. Usually the....

[+]
Written by Alon Brody |April 25, 2017

Data Industry and Trends Data Technology

Amazon Athena Does Battle: Comparing Athena and Redshift

Data warehouse technologies are advancing towards interactive, real-time, and analytical solutions. In particular, cloud-based data warehouse technologies have reached new heights with the help of....

[+]
Written by Alon Brody |April 18, 2017

From raw data to analysis in under 10 minutes.

Sign up now for a demo or a free trail of the Panoply.io platform.

Learn more about platform features

Being Data Driven

SQL vs NoSQL: The Differences Explained

We all know that in the database and data warehouse technology world, it comes down to two main database types – SQL (relational) and NoSQL (non-relational). The differences between them are....

[+]
Written by Alon Brody |March 09, 2017

Data Technology

Redshift Security - Encrypting Loads with S3/KMS/Lambda

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 from a full comparison with....

[+]
Written by Alon Brody |February 22, 2017

Being Data Driven

Tableau & Redshift: How to Visualize Amazon Redshift Data

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 database speed with the....

[+]
Written by Alon Brody |February 08, 2017

Being Data Driven

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

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 looking to get more of this....

[+]
Written by Alon Brody |January 24, 2017

Data Technology

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

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 focus. The ETL process....

[+]
Written by Alon Brody |January 09, 2017

Data Industry and Trends Data Technology

Apache Spark Architecture, Use Cases and Issues

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 you want to perform on data,....

[+]
Written by Alon Brody |December 20, 2016

Being Data Driven

A Business Intelligence Example: How to Prepare Data for Analysis

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 raw data needs lots of....

[+]
Written by Alon Brody |November 01, 2016

Being Data Driven

Data Tools: How to Ace Product Evaluation

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 tedious work to none, but....

[+]
Written by Alon Brody |June 07, 2016

Being Data Driven Product

Introducing Panoply.io’s Upsert Mechanism

One of the most critical issue in data warehouse management is avoiding duplications. When you are periodically loading data into your data warehouse you will want to skip the rows that have been....

[+]
Written by Alon Brody |March 28, 2016

Being Data Driven Data Technology

Blitz Analyzing with Microsoft SandDance

Microsoft Research just released SandDance, a free web-based data visualization tool.

[+]
Written by Alon Brody |March 25, 2016

Being Data Driven

Go Raw: Why Raw Data Reigns Supreme

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

[+]
Written by Alon Brody |February 01, 2016

Being Data Driven

Build KPIs not One Time Reports

Businesses need to deliver insights fast if not immediately. If this were not true, we would not be writing this post, you wouldn’t be reading it and over all, big data would be less of a diamond....

[+]
Written by Alon Brody |January 19, 2016