The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

Amazon Redshift

How to Optimize Amazon Redshift Performance

This post will take you through the most common issues Amazon Redshift users come across, and will give you advice on how to address each of those issues in relation to performance.

Operational Use Cases for Analytics

From predictive analytics to customer analytics, learn the how a data analytics solution can transform your business data into insights.

Building a Data Stack: An Overview on Amazon Redshift

Get an overview on Amazon Redshift, the petabyte-scale and cloud-based data warehouse from AWS. This blog post will cover concurrency, throughput, security, data operations and cost for Amazon Redshift. Read to learn more.

Calculating Your Data Warehouse Cost

As data becomes more voluminous, accessible and cost efficient—businesses must leverage data for their advantage. Learn how to calculate the cost of popular data warehouse solutions including Amazon Redshift and Google BigQuery.

An Overview on Amazon Redshift and Google BigQuery Security

In this blog post, we cover features that Amazon Redshift and Google BigQuery provide to manage data warehouse security for their customers.

Warehouse Maintenance: Amazon Redshift and Google BigQuery

Examine the differences in how cloud-based Amazon Redshift and Google BigQuery perform maintenance on their cloud-based systems, which is often seen as a point of contention for many users. Read about the differences.

How to Load Data into Amazon Redshift or Google BigQuery

In this blog post, examine how data warehouses Amazon Redshift and Google BigQuery handle how data loads, its speed, accessibility, and more.

How Amazon Redshift and Google BigQuery Handle Provisioning

Data warehouses, like Amazon Redshift and Google BigQuery, are meant to handle a large volume of data. Read this blog post as we examine how Amazon Redshift and Google BigQuery handle data provisioning.

Impact of Throughput and Concurrency on Your Data Warehouse

In this blog post, we discuss throughput and concurrency on your data warehouse and the impact it has on your ability to run analyses.

Choosing Between Amazon Redshift and Google BigQuery

Choosing a data warehouse that meets your business needs doesn't have to be difficult. Read our white paper examining the differences between cloud-based, data warehouse leaders Amazon Redshift and Google BigQuery.

How Meteor Uses Segment Sources and Chartio to Drive Growth

Dan Ahmadi, Director of Growth at Meteor sat down with us and outlined how Meteor uses Segment Sources and Chartio to drive growth.

Leveraging Your Data Warehouse as a Competitive Advantage

Data warehouses are optimized to analyze data by turning massive amounts of data into analytics that are easy to understand. Learn the advantages in using a data warehouse for analysis and how they are a competitive advantage.

When to Invest in a Data Warehouse

A data warehouse, or a reporting database, is an online analytical processing (OLAP) database and acts as a layer on top of an operational database. Learn when you should invest in a data warehouse for your data stack.

Interleaved Sort Keys in Amazon Redshift, Part 2

An interleaved sort gives equal weight to each column, or subset of columns, in the sort key. Read the second installment on understanding interleaved sort keys in Amazon Redshift.

Interleaved Sort Keys in Amazon Redshift, Part 1

Amazon Web Services has introduced interleaved sort keys for Amazon Redshift. Learn about the role of sort keys and compare how it works.

Roundtable: Amazon Redshift Best Practices for BI, Part 2

In part two of our panel discussion on Amazon Redshift best practices, our panelist spoke about schemas designs, tables and overall Amazon Redshift performance optimization. Read this blog post to learn more.

Roundtable: Amazon Redshift Best Practices for BI, Part 1

In this blog post, watch our panel discussion on Amazon Redshift best practices with speakers from Amazon Web Services, Clever, Chartio and Lumosity. Get Amazon Redshift performance optimization and ETL best practices.