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.
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.
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.
Earlier this month, Chartio's Sasha Blumenfeld interviewed Moz founder Rand Fishkin. And, although Moz certainly is numbers driven, it's also clear that they seek good content and a great connection with their audience
We've detailed how to document each of our supported databases and how this documentation can be accessed via SQL which allows you to create documentation dashboards inside of Chartio for your end users.
"Customer success is when your customers achieve their desired outcome through their interaction with your company." By focusing on whether your customer is achieving their desired outcome, you have the best chance of keeping them from churning months in the future.
In an organization that depends on sales for its revenue, leads are the key output of marketing, and the key input to sales. Lead scoring is an essential stop in that process, making it possible to allocate leads and evaluate the performance of marketing programs.
Recently, Amazon announced interleaved sort keys for Amazon Redshift. In part one of this two-part series we will use some dummy data and a set of Postgres queries to discuss the role of sort keys and compare how both types of keys work in theory.
This is part two of our post on Amazon Redshift best practices with our panel of experts in using Redshift for business intelligence applications. In this part we discuss schema design, diagnostic utilities, and our favorite Redshift analyses.
Churn is the scourge of the Saas businesses. Unchecked, it can turn a thriving SaaS business into a leaky bucket that’s impossible to fill. It’s essential to measure, monitor, and reduce churn. But, churn terminology in SaaS is often lacking in precision, clarity, or even common definitions.
Chartio's AJ Welch interviewed Craig Kerstiens who runs the Ecosystem group at Heroku, which comprises their add-ons marketplace, core languages and API. He’s a well-known content contributor to the Postgres community.
Since many of our customers store their data on Redshift, we wanted to bring together a panel of people with expertise in using Redshift for business intelligence applications. We assembled a team of panelists from AWS, Clever, and Lumosity who answered our questions on Redshift best practices.
Before you try any BI product write out ten questions that you should be able to answer using your data. Answer each of them using any product you’re evaluating. Then, ask yourself the three questions that really matter.
This post will explore the traditional Customer Lifetime Value model, the variables that go into it, and the assumptions they make about the future.
When products have a long buying cycle, simple tracking can’t be used. Marketers need visibility into the buying process to help them make decisions.
As a key element of modern marketing, a solid content marketing strategy includes increasing search engine rankings to get found by prospective customers.
Best practices aren’t created equal. They are only "best" if the practices are profitable for your company. Don’t assume that great strategies work well in all circumstances.
It’s happening. Machines are taking over. Algorithmic trading took over Wall Street, and now, the same thing is happening in the world of marketing.
Agile Business Intelligence is a new way to think about the process of building and managing BI. In the last five years, technologies and practices have matured, so that it is now possible to deliver business intelligence systems faster, at lower cost, and with greater control by end users.
It’s getting harder to identify and convert prospects with traditional targeting methods. Dark pools of low information web browsers are now navigating under the radar and out of reach of advertisers.