Latest Stories

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

A BI Example: Load & Transform To Prepare Data For Analysis

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

Redshift Pricing: A Data Engineer's Guide

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

Redshift Data Types. Day To Day Challenges.

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

Redshift Query Queues: The Complete Guide

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

Amazon Athena Does Battle: Comparing Athena And Redshift

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

SQL Vs NoSQL: The Differences Explained

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

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

Tableau & Redshift: How To Visualize Amazon Redshift Data

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

Step-by-Step: Loading Data From Google Analytics To Redshift

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

11 Great ETL Tools, And The Case For Saying “No” To ETL

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 Engineering

Apache Spark Architecture, Use Cases And Issues

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

Data Tools: How To Ace Product Evaluation

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

Introducing Panoply.io’s Upsert Mechanism

Microsoft Research just released SandDance, a free web-based data visualization tool.
BI And Data Visualization

Blitz Analyzing With Microsoft SandDance

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

How To Improve The ETL Process Flow With Row Data Processing

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

Build KPIs Not One Time Reports

Work smarter, better, and faster with weekly tips and how-tos.