Latest Stories In: Panoply Blog - Data Management, Data Infrastructure, And Data Analysis. | Data Warehousing

Good Business Intelligence (BI), allows your organization to query data obtained from trusted sources and use the answers to gain a competitive edge in your industry. ...
Data Warehousing

Data Warehouse Design: The Good, The Bad, The Ugly

Data warehouses and data lakes are two different types of data storage repositories. Data warehouses integrate data from various sources and structures them for business ...
Data Warehousing

Key Differences Between A Data Warehouse And A Data Lake

Following the steady growth trajectory of customer onboarding, with a select-user rollout in late 2016 and a quiet launch in February 2017 that has ballooned to over 100 ...
Product

Announcing General Availability On Data Warehouse In The Cloud

Is it easy to connect to a data warehouse? Selecting the right tool can help make this connection attainable. Tableau Desktop makes this connection easy, from opening ...
BI And Data Visualization

Connecting To Data Warehouses In Tableau

In the past, designing a data warehouse and data warehouse architecture has taken too long to complete. Executing numerous semi-automated steps results in a data ...
Data Warehousing

The Basics Of Automated Data Warehouse Lifecycle Management

I gotta hand it to Oracle and Larry Ellison, the guy knows how to put on a show! They also know how to do business. When they announced their quarter highlights on ...
Data Warehousing

The Power Struggle In The Cloud DB War Just Shifted To A New Paradigm (and Not Everybody Knows It)

There’s no question that the cloud offers many potential benefits. Major companies everywhere are lining up to reap the benefits by moving their back-office systems to ...
Data Warehousing

Enterprises Eye Big Benefits From Cloud Data Warehouses

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

Yesterday at AWS San Francisco Summit, Amazon announced a powerful new feature - Redshift Spectrum. Spectrum offers a set of new capabilities that allow Redshift ...
Redshift

AWS Spectrum, Athena And S3: Everything You Need To Know

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

It is an exciting time for cloud data warehousing with significant disruptions expected throughout 2017. As Gartner, in March 2016, showed, warehousing enterprises ...
Data Warehousing

Cloud Data Warehousing Trends 2017

I loved this line from an article I recently stumbled upon:  “Choosing between the different types of data warehouse platforms can be simplified once you know which ...
Data Warehousing

Which Type Of Data Warehouse Is Right For You?

Today’s considered data management best practices, advocate building resilient architectures that span multiple data centers, regions or even continents.
Redshift

Introducing Panoply Multi Zone Redshift Cluster

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

Amazon re:Invent is a great place to gather feedback from industry professionals, and especially gauge cloud-industry trends. This past year, we used the opportunity to ...
Data Warehousing

Future Of Data Warehousing Is Cloud: This 2017 Survey Proves It

The premise that to build a perfect data warehouse you must have perfect business understanding is simply irrelevant. We must look to technology to empower us to keep ...
Data Warehousing

Data Warehouse Automation. A Question Of When Not If

This is the second part in a 101 series covering Big Data concepts, terminology and technology.
Data Engineering

How Data Structures Impact The Data Warehouse

This is the first part in a 101 series covering Big Data concepts, terminology and technology. Starting with the data warehouse and data warehouse concepts.
Data Warehousing

Data Warehouse What?

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