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.

data analytics

Is Silicon Valley Losing Its Lead? How VC Investment of $102 Billion Is Spread Among 18,000 Companies and all 50 States

The fact that California, and especially the Bay Area, leads the U.S. in Venture Capital (VC) funding in all rounds isn’t new news.  But is this changing?  We took a look at all early VC funding rounds (Seed, Series A, and Series B) were also staying mostly in California or if other areas in the U.S. were starting to pull some of that funding away from the Golden State.

Off the Charts: An Interview with Kostas Pardalis of Blendo

In this Off the Charts, we spoke with Kostas Pardalis, CEO and co-founder of Blendo on the adventures of starting a company in Athens, Greece, finding the right talent to grow and building an ETL product for a global market.

The Importance of Usability for Business Intelligence Platforms

Usability is paramount to user adoption and can signal the difference between invaluable insights and zero visibility. Learn what the data from G2 Crowd’s Usability Index says about Business Intelligence platforms.

Off the Charts: An Interview with Daniil Bratchenko of DataRobot

In this Off the Charts, we spoke with Daniil Bratchenko of DataRobot on the future of analytics, dashboard management, his career in data analytics and managing data governance across a growing company.

Panoply, Stitch and Chartio Partner to Offer the World’s First Automatic Cloud Data Stack

Panoply, Stitch and Chartio announces the world’s first Automatic Cloud Data Stack. The combined offering enables everyone to connect their cloud applications and databases to gain business insight by visualizing their data.

How Analytics Drives the Golden State Warriors

The Golden State Warriors are pioneers in using technology in basketball. Kirk Lacob pulls the curtain behind the team’s use of technology, analytics and data science to win. Continue reading as we recap Kirk's session from Ops-Stars.

Grouping with a Case Statement

Using GROUP BY allows you to group columns to run specific SQL queries like aggregating data into a SUM, AVG or COUNT. Read this data tutorial to learn how to use a CASE STATEMENT to GROUP a column with an alias or new string.

Pivoting a Table with Amazon Redshift or PostgreSQL

Changing the makeup of a relational table and summarizing it is the definition of a pivot table. Commonly known as an operation in Excel, pivot tables can be done with SQL. Learn how to pivot a table with Amazon Redshift or PostgreSQL.

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

If you have yet invest in an end-to-end cloud-based 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.

How to Track Your Sales Opportunities in a Dashboard

A Sales Opportunities dashboard visualizes your CRM and marketing data as opportunities as they move through the sales pipeline and funnel. In this blog post, learn how to create a dashboard to track sales opportunities.

Data Wars Episode I: The Democratization of Data

Centralized or Decentralized Analytics, it's entirely up to you to implement the right one for your company. This blog post will provide examples and best practices on how either can work for your organization.

The Four Stages of Data Analytics

There are four stages of data analytics for every company. From KPI pulls to Data Heroes to Centralized to Decentralized, there's a flavor of analytics for every company to drive actions and insights from their data. Read more.

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

Not everyone has the easiest time building or maintaining it great data hygiene. Ben Perlmutter explains the importance of good data hygiene and highlight key methodologies that will help you build and maintain it.

3 Steps to Prioritizing Data Requests

In this blog post, we'll share insights on how Data Scientists approach and solve the perpetual problem of prioritizing data requests from their organization. Continue to learn how to effectively prioritize your data requests.

How Prezi and Udemy Organize Their Data Teams

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.

How Data Analysts at Prezi and Udemy Drive Growth

We hosted a panel with Data Analysts from Prezi and Udemy on marketing analytics best practices. Learn how the companies built out their data infrastructure and governance, perform analyses and leverage insights to drive growth.

Get More Value Out of Your Data with the Right Recipe

Leverage the power of Astronomer’s Activities and Recipes within Chartio to get the most value out of your data. Astronomer is a data engineering platform that collects, processes and unifies your data, so you can get insights.

How to Leverage Data to Create an Organized Marketing Dashboard

Marketers use 17 different tools, which amounts to a lot of disparate data. Marketers need to create dashboards that leverage marketing data. In this post, learn how to leverage data to create an insightful marketing dashboard.

You Need More Than Excel to Get Insights

Last week, Tomasz Tunguz wrote “Excel became the tool for nearly everyone to get stuff done at work.” In this blog post, we examine the future of spreadsheets in today's world of data visualization and robust analytics tools.

Dashboards Explained: Operational, Strategic and Analytical

While data has been seen as an overly complicated entity, dashboards don’t have to be. In this blog post learn the differences between operational, strategic and analytical dashboards. Learn how to pick the right dashboard.