Operations has quickly become one of the most sought-after roles for growing companies. Learn the role of Operations plays in building and maintaining SaaS rocket ship companies from delivering metrics, balancing strategy versus tactics and working as a centralized Operations team across a larger organization.
If a collection of data is normally distributed we’ll see the results show very nice and neat on a bell curve, and that bell curve won’t require any manipulation of data. The fact of the matter is, and this might be hard to hear, normal is rare. Almost no randomly arrayed statistic is normally distributed. Shockingly, normal is weird.
Read more to find out how a bell curve and a real curve compare.
In September 2017, Chartio took over the Montgomery BART station with an advertisement campaign. Entering into the world of metro advertising wasn't easy. We couldn't just read a report and know exactly what to do and measure.
We were skeptical, cautious and excited. To say the least, we learned a lot, and now we're sharing those learnings with you.
The Golden State Warriors are pioneers in using technology in basketball. As the keynote discussion during Ops-Stars, Kirk Lacob of the Golden State Warriors pulled the curtain behind the team’s use of technology, analytics and data science to win.
Continue reading as we recap the session with Kirk and Mark Emmons from LeanData.
Using GROUP BY allows you to group columns to run specific SQL queries like aggregating data into a SUM, AVG or COUNT. With that, know which of the columns you want to GROUP BY and how you want to group them is important.
Continue reading our Data Tutorial as we walk you through how to use a CASE STATEMENT to GROUP a column with an alias or new string.
Changing the makeup of a relational table and summarizing it is the basic definition of a pivot table. Most people know pivot tables as an operation in Excel, but you can also create powerful pivot tables just as easily by writing SQL in a data analytics tool.
Continue reading our Data Tutorial on How to Pivot a Table with Amazon Redshift or PostgreSQL.
A Social Media dashboard enables you to measure your company’s social activities from Twitter engagement, Facebook comments to LinkedIn shares. With a dashboard, you can understand what’s working and what isn’t, and proactively work to optimize each social channel.
Continue reading as we walk you through how to create a Social Media dashboard that quantifies ROI.
Annual Recurring Revenue, or ARR, is an insightful metric for B2B SaaS businesses to track the total dollar amount that comes in every year for the duration of a customer’s annual contract. No matter the size of your company or industry, ARR is a universal metric that gives businesses the most insight about the success of their business.
Continue reading to learn how to use your Salesforce data in Chartio to calculate ARR in two simple steps.
Hi, my name is Tim and I am your new Data Evangelist. For the past year and a half I’ve worked as a Customer Success Engineer. It is more than possible that I helped you through one of your tickets, helped you build a dashboard or trained you during one of our customer webinars or on-site visits. If none of that rings true, then you’ll simply know my henceforth as your Data Evangelist.
Marketing attribution continues to be a hot topic of conversation for marketing teams, no matter the industry or size of the organization. As marketers are beginning to leverage data and dive into the analytics of their marketing campaigns, it has become apparent that marketing attribution is still a hurdle for many of us.
In this blog post, we’ll walk you through how to track first touch marketing attribution with Hubspot data in Chartio. In implementing, a first touch attribution model, you’ll be able to iterate on campaigns, content and messaging faster and earlier on.
According to Weather.com, September 2017 was the most active month on record for Atlantic Hurricanes. These hurricanes were large, dangerous and deadly and ran through the United States and the Caribbean Islands, leaving vast destruction and death in their wakes. We've visualized the data to show just how magnitude and destruction of these hurricanes.
Practicing good data hygiene is crucial. Not only for data teams, but for every aspect of the business. Good data hygiene is like washing your hands. I’ll explain it all in this blog post and provide best practices on how to implement good data hygiene at your organization.
Marketing attribution is challenging. However, you can use Google Analytics as a starting point to understanding and measure attribution. In this blog post, we’ll walk you through three ways to use Google Analytics to jumpstart your attribution strategy.
As customers are the livelihood of your business, having a bird’s-eye-view on the revenue activity generated from your customers is crucial for growth. A Customer Success dashboard monitors the health of this growth.
In this blog post, we’ll show you how to create a Customer Success dashboard that optimizes for growth.
A CEO dashboard visualizes your business data and tracks the health of your business by measuring revenue trends, growth and operational cash flow. In this blog post, get a breakdown on which metrics to track and how to create your own dashboard in Chartio.
With more and more content out there, companies are looking for ways to rise above the noise and optimize their content. In this blog post, we’ll uncover five ways to optimize your content while leveraging Google Analytics.
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 Lukas Biewald of CrowdFlower.
Read our interview with Lukas as we discuss the importance of training data and the evolution of Artificial Intelligence.
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.
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.
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.