Upcoming Talk: Data Platforms 2017 Conference

Go Further, Faster with a Data Lake in Amazon Web Services Increasingly, valuable customer data sources are dispersed among on-premise, SaaS providers, partners, 3rd party data providers and public data sets. Data Lakes in the cloud are the foundation for storing on-premises, 3rd party and public data sets at attractive price / performance. Atop this foundation, a portfolio of descriptive, predictive and real-time agile analytics…

Improving Redshift Query Performance by Reducing Query Steps

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. In our first and second blog posts in this series, we pointed out that our experience assisting clients with slow Redshift queries points to three main contributing factors: ineffective zone maps, excessive network traffic and too many query steps.…

Upcoming Webinar: Redshift Jumpstart – PH Tech’s Move to Offer Data-as-a-Service

Please join 47Lining CEO, Mick Bass, and PH Tech VP Information Technology, Chad Casady, for a live webinar – Redshift Jumpstart – PH Tech’s Move to Offer Data-as-a-Service When: July 20, 2016, 10:00am PT Presented by: 47Lining, PH Tech Registration: http://www.47lining.apncampaigns.com/Redshift-Jumpstart-PH-Tech In this webinar, you will learn about: How to jumpstart your data warehousing and business intelligence workload using Amazon Redshift Design patterns for ingest,…

Improving Redshift Query Performance by Decreasing Network Traffic

In our last Redshift Whisperer blog post, Improving Redshift Query Performance Through Effective Use of Zone Maps, we described Amazon Redshift as a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. Our experience assisting clients with slow Redshift queries has led us to the determination that most Redshift performance issues stem…

Improving Redshift Query Performance Through Effective Use of Zone Maps

Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse that makes it simple and cost-effective to analyze an organization’s data using existing business intelligence tools. Redshift is fast. Very fast! … except when it’s not. Right out of the box, Redshift can search through vast amounts of data and provide complex analytic results in shockingly short query times. Then why do we spend significant…