Building your analytics infrastructure with Stitch and Chartio

Companies have been building enterprise data warehouses and business intelligence implementations using Oracle, SAP, and other enterprise vendors for decades. This technology, however, remained far out of reach for anyone without a seven-figure budget and a year of engineering time. That changed with the advent of cloud analytics data technology like Amazon Redshift and Google BigQuery.

First, modern warehouses made data storage affordable. With Amazon Redshift a company can afford to store and analyze terabytes of data for a few thousand dollars per month. Second, modern warehouses are highly optimized for analytics, which means that the analytics tools themselves no longer need to solve for speed. Historically, analytics tools had to solve two problems:

  1. providing an user interface that made the complicated task of analysis more accessible, and

  2. making the analytics run quickly.

Many tools built prior to 2012 (the year Redshift launched) prided themselves on building “fast caching layers” to make analytics fast. This was a big part of their secret sauce, but this is no longer the case. Technologies like Redshift and BigQuery are so fast that the tools that sit on top of them can largely ignore the speed problem and focus solely on providing amazing interfaces to data.

The result of this focus on interfaces is a market rich with powerful analytics tools. There has been a proliferation of open source tools and companies that provide beautiful, powerful analytics interfaces. Analytics tools on the market today are head and shoulders above what analysts and business leaders could dream of a decade ago.

Today, the Stitch team is excited to announce our partnership with one of these powerful, modern analytics platforms — Chartio.

Why Chartio

Chartio is an analytics platform that enables everyone to extract insights and value from their data. First, Chartio users are able to get up to speed within an hour of being introduced to it for the first time. Second, it’s built to suit the needs of a range of a wide range of technical ability, from analyst to marketer. As a result, more than 40% of Chartio users are active analyzers, creating reports and actually doing data analysis rather than just passively consuming charts and dashboards.

Chartio + Stitch

Once Chartio effectively solves the analysis problem, all that’s left is getting your data into a single, centralized location – and that’s where Stitch comes in. Stitch is an ETL service that connects to the data sources that run your business, from ad platforms like Facebook and Google AdWords to databases like MongoDB and PostgreSQL. Stitch then extracts that data and loads it into Amazon Redshift. Connect Chartio, and start analyzing.

Putting your analytics infrastructure to work

With Chartio, Stitch, and Amazon Redshift you have an analytics infrastructure that is every bit as powerful as legacy business intelligence platforms. So, what do you do with all this power at your fingertips? This is where things get fun.

One of the most popular Stitch integrations is Salesforce. Salesforce is home to an incredibly valuable data set, but the built-in reporting can be limiting. In addition, it only shows you data that lives in Salesforce. If you want to explore sales and marketing data together, Salesforce can’t help you with that.

With Stitch, you set up integrations for Salesforce and HubSpot, stream that data to Redshift, then connect Chartio. With Chartio, you’re able to create beautiful visualizations like this:

Chartio visualization

You have a complete picture of your purchase funnel from visit to closed deals. Salesforce alone simply can’t give you these kinds of insights.

Here’s another example of what you can do with HubSpot and Salesforce data once you have it in Chartio. Email drip campaigns are an incredibly popular conversion tactic, but which emails are resulting in prospects actually trying your product?

The Chartio visualization below shows trial signups on the y-axis, persona on the x-axis, and color-coded email numbers. At a quick glance you can see that, across personas, the fourth email in the drip sequence is resulting in the most trial signups.

Trial activation by email

These are two examples of the power of consolidated data and powerful visualization tools. But these are really just the beginning. Stitch integrates with a host of popular SaaS tools, databases, and platforms. And Chartio offers a rich feature set of data visualization and analytics capabilities.

Get started

With Chartio and Stitch, it has never been easier to get your analytics infrastructure up and running. Stitch offers a 14-day free trial so you can start syncing your data to Redshift today. Once your data is loaded into Redshift, you can get up and running on Chartio within minutes.