We are excited to announce that we now support Amazon Athena, an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Together, Chartio and Amazon Athena allow users across an organization to quickly analyze large-scale datasets and get insights.
In the past couple of years we’ve hit some very significant milestones along our ever going journey to JOIN people ON data. We envision a future where anyone (not just data analysts or scientists) can explore and understand their data
Read more about the State of Chartion and what customer reviews mean to us.
Some historical trends tend to indicate whether or not there is VC funding money out there to be won, we took a dive into the data available to determine whether or not the S&P and other market indicators are correlated to funding availability.
Three days, over ten thousand attendees and at least five things all happening at once.
Welcome to SaaStr Annual! We've scoured the official schedule for the best SaaStr events and dedicated many nights and mornings taste testing food and sipping coffee nearby the conference venue - all in the name of saving you time. Check out our picks for sessions, restaurants, cafes and events during SaaStr.
Usability is one of the most important features of any platform. 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 BI platforms.
Have you ever spent January in Buffalo? I have. A Lot. Eighteen times actually, I grew up there. In fairness, I left there as soon as I could, and moved a little farther west and south, and then 15 years later decided to leave because (among MANY other reasons) I had had my fill of winter.
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.
Housing Prices are skyrocketing! Heard that one before? Yeah, me too.
So I went to the internet to find data on the cost of housing in the United States broken down by state and then found a source that gave me information on the average cost of a home in those states as well.
On May 25th, 2018, The EU GDPR (General Data Protection Regulation) will go into effect. This regulation enhances the data privacy protections for European Union citizens and is a mandatory requirement for any company with access to personal data of EU citizens. Chartio is both a controller and processor in the context of GPDR with many customers in the EU - meaning we are actively working on GDPR preparations.
Taking a closer look at the NYC and Boston Marathons you will see a trend that is very interesting. These two races gather the most elite of elite marathon runners in the world on both sides of this gender gap, whereas the smaller races like in Casper, or Albuquerque, or Marshall do not necessarily gain the attention of the world’s elite. It looks like the gap between men and women is narrowing.
Business Intelligence is an incredibly jargon filled industry. After seven years of being in this industry, I believe I've heard most of them. Now I'm sharing a curated version of my list and definitions with you to help modern data team understand traditional concepts and help traditional BI users understand the modern take on these concepts.
In September, we ran 10 different Ads that lined the entire Montgomery BART platform. Now, read about how all that data came together and how it helped one tourist couple plan out their entire day visiting San Francisco.
Panoply, Stitch and Chartio today announced the availability of the world’s first Automatic Cloud Data Stack. The combined offering enables data analysts and business users to connect to disparate cloud applications and databases and gain business insight by visualizing their data.
The 2017 Fire Season in Northern California was one of the most costly and deadly on record. When ranked against the yearly totals for the last 14 years, 2017 ranks as the most deadly, and is among the most costly in terms of Structures and Acreage Destroyed. We've visualized the data.
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.