What do you like best?
I love how versatile Chartio is, that often the limitations of my knowledge of the software hold my work back more than the capabilities of the product itself. I love that I can use it to produce such a wide variety of graphs, tables, and visualizations. I love that it updates automatically so I can build charts once and then let them take care of themselves, but the absolute best thing about Chartio is their support.
I have found Chartio support to be incredibly useful and attentive. Their team has helped me solve the smallest, silliest problems and incredibly complex issues I'm having while building and tweaking charts usually within a day or two of my original query and in as few emails as is reasonable.
I lean on Chartio's support team frequently. As their product is so flexible and the data I work with can be particularly challenging at times, I frequently end up learning new techniques from their support team that I can later incorporate into my general workflow.
Chartio allows you to build charts using SQL or their own interactive mode and I frequently switch between the two when I need capabilities one or the other mode is better in. Likewise, Chartio's support team us equally helpful whichever mode I am using. When I need it, they sometimes go beyond helping me tweak what I've already produced to get it to work and will write custom queries or make large adjustments to charts for me.
I love Chartio as a product, but their support team is why I've recommended them to several colleagues and friends.
What do you dislike?
Occasionally I'll run into small problems that are frustrating, but that I can work around. I think perhaps the thing that is most frustrating is that there are a few data sources my team wants to see in Chartio that there isn't an easy integration for.
Primarily, we use SalesForce and Mixpanel as a team, but these can only be connected to Chartio with workarounds that have been less than adequate for my team. If all of your data or your primary data are stored in sources that Chartio can natively connect to you'll have much better outcomes than if you're tied to workarounds.
Recommendations to others considering the product
Look at your data and the problems you're having with them, if your data is stored in places that Chartio has native integrations with and you want to automate charts in daily, weekly, or monthly reports, Chartio is probably a great option for you.
Be realistic about whether you have at least one employee who is willing to learn the ins and outs of Chartio. I probably spend 60% or more of my time in Chartio, which is by far more than any other employee on our plan, and it shows in my work. I've been using Chartio heavily for a year now and the charts I build are increasingly complex in the back end and simple on the surface. Other users within our company who haven't devoted the same time to learning Chartio are less comfortable using it and don't build as much in it.
Oh and if you're trialling or using Chartio, lean on support as much as you need. In general I try to live by the adage that it's o.k. to ask any question once but I should try not to ask the same things twice. This has served me incredibly well with Chartio. Most of the advanced and complex charts I build apply techniques I learned from question I asked support while building smaller, less complex charts. The more you're using Chartio, the more valuable you'll find it.
What business problems are you solving with the product? What benefits have you realized?
One of the biggest business problems we're solving with Chartio is one I think about the least, because Chartio makes it so I don't have to. That is the problem of having the most up to date data whenever we need to look.
Before Chartio I had to run and re-run queries and update executive summary spreadsheets by hand. It was tedious, dull, and time consuming.
I wanted to be analyzing data, asking new queries and finding new answers, instead I spent probably 25% of my time running the same things just so they would be up to date.
Chartio allowed me to build things and then let them update themselves. I get to spend my time pruning the data, looking for new answers, and building ever more specific data sets for specific needs instead of updating the same data by hand over and over and over.
Chartio has also allowed me to combine data from multiple sources in single charts and tables. Some of my most complex charts are pulling data from 3 or more sources, then performing complex calculations on some of it, then producing a simple graph or a single number that belies the complexity beneath.
Our company uses a lot of cloud sources for our data storage and collection and Chartio seamlessly integrates with most of them, while also allowing for manual .csv data uploads when necessary.