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.

How to do Nth-name Selections in Hubspot Mailing lists using Chartio

Hubspot does a good job of managing marketing lists. It's extraordinarily flexible in defining email lists for your promotions and nurturing campaigns. But if you want to test a list or a promotion, there's no way inside of Hubspot to select a portion of your list (say, 10%) and either send the remainder your standard email or reserve it for other promotions in the future

Data quality dimensions and business intelligence

To be successful at running a business you need to use data to make important decisions. You go through a continual process of collecting, updating, and creating data in order to have the insights that help you grow and succeed. The quality of the data your company uses is essential to the reliability of your business analytics and business intelligence. 

Producing and Analyzing Rich Data with PostgreSQL

Over the past five years or so,  I’ve noticed the  perception that relational databases are only good at descriptive statistics (count, sum, avg, etc.) on medium sized structured data sets. In other words, SQL just doesn’t work for inferential, predictive or causal analysis on larger or unstructured data sets. Although this may have been true five years ago, it’s a lot less true today.

Sales Metrics: Why You Should Care

Though analytics and reporting have always been a central part of sales, this increased access to data doesn’t always result in an increase in sales performance. Even with data readily available, strategy and tactical knowledge can be a challenge for sales managers.

Of all the things one could do to ensure the success of a sales organization, identifying, tracking, understanding, and incentivizing reps with sales metrics is perhaps one of the most important.

Four Secrets of Successful BI Implementations

Business intelligence exists to make people better at their jobs. Although the value of being data driven is indisputable, business intelligence is not an end in itself. Making decisions based on data – facts, trends, and likely outcomes – is a much better approach than intuition, gut feeling or emotion. Better decisions lead to better performance, results, and achievement. Business intelligence is a means to that end.

How to Use Smart Discounting in SaaS Sales

Discounts can be a necessary evil. You will probably have to give something to compel customer to act, so you should expect to have to deal with it at some point in your negotiation. So, you should have a consistent process for addressing discounts before you begin selling your product.

How to evolve your outbound email campaigns

The key to outbound marketing is keeping it simple and testing continually, according to Ryan Buckley the founder of content marketplace and email address locator Toofr. Ryan joined us recently to host a webinar titled Sales Outbounding: The Secret to Getting It Right.

What's the True Cost of Business Intelligence?

It's not easy to estimate the long-term costs of a business intelligence project. Even when you know the numbers, it’s difficult to estimate which options you’re going to need. Sometimes, it seems that the more time you spend talking to vendors about your BI project, the less you know about the total cost of getting it done. We can’t do all your homework for you, but we're written a white paper to introduce you to the unanticipated costs of implementing business intelligence, how to ask about them, estimate them, and mitigate their risks.

Data Munging Crowdsourced Information without SQL, Using Chartio's Data Stores

Chartio's great for analyzing and reporting on data on your company's systems, but what if you don't have all the data you need to complete your analysis?  

We recently held a joint demo with CrowdFlower to show how to crowdsource the information you need and analyze it in Chartio. 

In this post, I'm going to explain how we collected the data, and show you the analysis we performed that night.

Understanding Interleaved Sort Keys in Amazon Redshift, Part 2

Previously, we discussed the role of Amazon Redshift's sort keys and compared how both compound and interleaved keys work in theory. Throughout that post we used some dummy data and a set of Postgres queries in order to explore the Z-order curve and interleaved sorting without getting bogged down in implementation details. In this post, we will explore some of these implementation details, discuss a common tactic that can benefit from using compound and interleaved sort keys together, and run some benchmark queries against a data set with billions of rows. Throughout this post we will link to code that can be used to recreate our results.