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.

The Guide to Building an End-to-End Data Stack

If you have yet invest in an end-to-end data stack, this white paper will be core to your evaluation process. For more insight, download our white paper The Guide to Building an End-to-End Data Stack.

Off the Charts: Jake Stein, Yaniv Leven and Dave Fowler

In this edition of Off the Charts, an interview series where we chat with individuals doing industry-changing work in the data space, we spoke with Jake Stein, Yaniv Leven and Dave Fowler about the current state and future of data technologies.

How to Optimize Amazon Redshift Performance

In running complex queries against large amounts of data within your Amazon Redshift data warehouse, it can be taxing on the overall system. It’s important to apply best practices and resolve optimization issues fast, because the longer you wait, the fewer real-time insights you’ll have access to and the more deep debugging awaits you in the future. 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.

How to Track Your Sales Opportunities in a Dashboard

A sales opportunities dashboard visualizes your CRM data with marketing data to track opportunities as they move through the sales pipeline. In this blog post, learn how to create a dashboard to track sales opportunities in Chartio.

How to Choose the Right ETL Tool for Your Business

For many companies, data comes from many places. Most companies utilize various cloud applications to run different parts of their business. With all this data, it brings about new challenges in gleaning insights from your data. But before you can sync your Salesforce data with a data warehouse, you need to realize one thing: you need an ETL tool. 

In this blog post, we'll break down everything you need to know about evaluating an ETL tool. 

How to Choose Metrics for Your Sales Dashboard

We’ve all heard the saying, "what gets measured gets done." As companies make hundreds of decisions a day, you simply cannot afford to make decisions solely on intuition alone. You need to measure everything. And dashboards are the way to measure performance insights, key results and growth indicators.

Before we all start creating dashboards, let's figure out which metrics to choose for our Sales dashboard.

There is A Lot of Data Out There, How Are You Governing It?

There is more information about you in a database than you can possibly fathom, or probably care to know. Current estimates for the amount of data created in the year 2020 is 1.7 megabytes per human being on Earth, per second.

If you were to convert that to mp3s you would have approximately 6.8 quadrillion hours of music. That is enough listening material to last each individual member of the human race 102 years of music. That's a lot of data

If the above statistic doesn't fuel your need to think about data governance, in this blog post, I'll dive into the importance of implementing a data governance strategy. 

Data Wars Episode I: The Democratization of Data

Centralized or Decentralized Analytics, which one is right for your organization? There's no right answer and that's leading to an internal data war. While there are defined pros and cons between the two analytics approaches, it's entirely up to you to implement the right one for your organization. 

In this blog post I'll provide examples and best practices on how either can work for your organization. 

The Mailchimp Email KPIs You Can Start Using Today

Undoubtedly, Mailchimp offers robust KPIs and analytics within their own platform and even compare your numbers to industry standards. This is a great starting point. But, it can be to your advantage to track those Mailchimp KPIs outside of the platform and alongside your other marketing KPIs (like numbers from your Google Analytics or Marketing Automation) to get the full picture.

In this guest blog post by Kostas Pardalis, co-Founder of Blendo, he'll cover the top KPIs for Mailchimp and provide a guide to implementing each one into your own dashboards.

The Age of Analytics: Data Governance

As more companies move through the four stages of data analytics and overcome the false fears of democratized data, this has reiterated the importance data governance and quality for organizations. With more people having access to data, creating data sources and analyzing data, it’s changed the way business departments manage their data.

In this blog post, learn how important data governance is to your growing organization and how to implement a strategy today. 

How to Create a Web Analytics Dashboard

A web analytics dashboard visualizes your web data and monitors your website performance in detail by tracking critical metrics. In this blog post, get a breakdown on which metrics to track and how to create your own dashboard in Chartio. 

The Four Stages of Data Analytics

Through Chartio I’ve had the pleasure of meeting with hundreds of organizations, big and small, to learn (and help with) the ins and outs of how they work with data. While each company is unique, I’ve found that companies go through four stages toward an ideal analytics destination that I call Decentralized (aka. Democratized) analytics.

In this post, I describe each of these stages, their pros and cons, useful tool suggestions and some tips on getting on to the next stage. I hope this will be helpful to you as you identify where you are and where you’d like to go.

Four Growth Marketing Strategies to Implement at Every Company

Growth Marketing is never static. While more general marketing strategies focus on the top of funnel, Growth Marketing focuses on impacting the entire funnel and is instrumental in growing the business as a whole.

Continue reading to learn Growth Marketing strategies and tips from seasoned pros Sean Ellis, Jack Mardack and Riaan Ahmed—all of which head up growth initiatives at GrowthHackers.com, Nexmo and Thomson Reuters.

The Importance of Good Data Hygiene  —  Data Lakes, Warehouses and Hygiene

Data hygiene is just like personal hygiene; everybody wants it, but not everyone has the easiest time building or maintaining it.

In this guest blog post, Ben Perlmutter, Solutions Architect at Xplenty explains the importance of good data hygiene and highlight key methodologies that will help you build and maintain it.

Advice from Growth Hacking Experts on Reaching Sustainable Growth

There's no silver bullet to growth. However, there are steps that companies can take to reach sustainable growth. Sustainable growth isn’t a new problem, but it’s still one of the biggest challenges anyone in the business of startups faces.

Sean Ellis, Jack Mardack and Riaan Ahmed have spent their careers solving the incredibly complex problem of achieving sustainable growth for various companies. 

I recently rounded up Sean, Jack and Riaan together for a Growth Hackers Data Coffee Hour and picked their brains on the secret to sustainable growth as they shared their growth stories. Continue reading as their dish out advice on how to reach sustainable growth. 

3 Steps to Prioritizing Data Requests

Last Saturday, a few of us from the Customer Success and Marketing teams spent our Saturday at San Francisco’s Measurecamp, a free data analytics unconference. We spent the day talking to a diverse group of data analysts, scientists and enthusiasts about all things data. 

As we spoke with attendees and sat in on round table discussions, we collected insights on how this community of data enthusiasts approach and solve the perpetual problem of prioritizing data requests. In this blog post, we share what we learned from the data community and how they prioritize data requests at their organizations.

Serving Up Data to Get Real-Time Sales Insights

With increasing competition and daily operations at stake, Good Food Guys is leveraging data to learn about their customers and make informed business decisions. Watch the video case study to learn how the company is serving up data to get real-time insights across 12 restuarant locations.

Finding Marketing ROI Through Cohort Analysis

Cohort analysis is useful, for every department across your organization, because it examines the cohort over a period of time and delivers unique insights. In this blog post, learn how marketers can apply cohort analysis as part of their analytics strategy.

Introducing The Six Dashboards Every Startup Needs White Paper

Dashboards have the ability to reach every aspect of the business because they’re powered with your company’s data, and help surface insights that help you answer questions and set goals. In our latest white paper, get the six dashboards that every startup needs to fuel growth. 

How Prezi and Udemy Organize Their Data Teams

The demand for data and data-driven decision makers is here to stay. In this blog post, learn from Data Analysts from Prezi and Udemy as they share heir best practices, their opinion on centralized versus decentralized data teams and their professional experience in working in the data world.