Whenever we have a data question which has to be answered multiple times we usually automate it using Chartio.
- It is easy to connect your datasources and it supports over 15 different type of datasources.
- It is easy to create your first dashboards. You can learn the basics just by trying it out. It also has great documentation to find the solution for more difficult problems.
- You can save your data into Chartio's datastores. Using these datastores on your dashboards makes them super fast to refresh without querying your own database. You can set when you would like to refresh your datastores.
- I really miss usage statistics. We don't know who, when and how many times were viewing our dashboards. It is a real pain point when you have created hundreds of dashboards and you need to maintain those too which are not used any more.
- Would be nice to have version control to easily revert changes.
- Data-stores are limited to 1 million lines. Using multiple filters on a dashboards makes hard to fit into this limit.
It is not appropriate for deeper analyses/modeling. Also would not use it for one-time reports.
- Really easy to get going. We tested many solutions - and Chartio is by far, the quickest. Took us a legitimate 30 minutes from nothing to up and running.
- Chartio visually illustrates your database structure. This is phenomenally helpful for users who need to understand how to join tables and get the data they need.
- The UI is pretty typical of other tools, so there's not an additional learning curve if you've used other BI tools. It's actually more simple than most, but still pretty similar.
- Slow - the queries aren't optimized for speed. In order to combat this, you may need to build aggregate tables for date ranges and typical calculations.
- Expensive. We negotiated down to $25k a year. That's pretty typical for BI tools, but the value ended up not being equal to $25k.
- Chart manipulation after an initial query.
- Extensive choices for dropdown menus.
- User interface is very easy on the eyes and intuitive.
- The new drag & drop method for arranging charts is much more efficient than before!
- I'd like to be able to see two dashboards at once.
- Sometimes I do find myself limited by the chart types - not quite as flexible as Excel would be.
- Drag and drop interface
- Comprehensive options for data sources
- Excellent support response
- Beautiful chart designs make At-A-Glance measurement possible
- Minor interface issues on building and arranging dashboards. The Z-index of charts can re-sort without warning, making visual layering of independent charts difficult
- Building visualizations without technical knowledge; I don't know of any other way to do this as easily with anything other than social media stats.
- Good customer support - Chartio has incredible potential, but sometimes it can be hard to know how to get what you want, and their support makes that possible.
- Design - they handle a lot of information and options and it's very easily for that to get complicated and bogged down, but their design is clear and concise and lightweight, allowing you to see things clearly.
- Navigation; there are a lot of repeated process for using the tool and there is a lot of wasted time required to re-organize things or move around properly.
- More shortcuts or docs or smart suggestions to help you achieve the more complicated processes that are possible without having the full technical understanding, the way the drag and drop does for the basic stuff.
- Linking to a particular chart is still not great because you either send someone to edit mode (don't want that) or to a page full of charts, and while it's highlighted, that is not sufficient for the average person.
- Directly connect to the actual data running our site.
- Allow for advanced querying, filtering, and even user based permissions to see and edit the data.
- Provide a great way to layout and communicate the data in visualizations and dashboards.
- Chartio is beginning to add more statistical analysis tools into their platform, but for now this is somewhat lacking.
- Dashboard level filters have come a long way in helping to get to the data that is really important, but there are some challenges we've had with more complex queries where we'd like to filter certain things completely out of our data for every single chart, and that one use case has been a challenge.
Chartio Review: "The tools that solves the BI for the companies that doesn't hate the resources to hire dedicated BI resources but badly need it."
I would say that this is the number one BI tool compared to other BI tools I've used.
- Intuitive for reporting and analysing on the fly.
- Can perform calculations in tables and in the data cells instead of pre-processing the data elsewhere and not only using the Chartio tool as a tool for viewing data. Not passive but active reporting and analysing which makes the tool a good core tool in any corporate BI suite.
- Chartio has a lot of usable diagrams for viewing data from new perspectives which makes our business decisions much wiser than they would be otherwise. With Chartio it's easier to have the right data at the right time for the best possible business outcome.
- If you have connected to a simple MYSQL-database which has a limited amount of requests, perhaps be able to send the database requests in sql instead of all of them at the same time. Especially if you have a dashboard build with a lot of single number KPIs.
- Easy to read and interpret
- Great sets of charts and graphs
- Able to export large amounts of data that can be easily used in different platforms.
- Crashes from time to time with different data pieces (this may not be Chartio's fault)
- Does not directly plug in to other parts of our system (which would be difficult to execute anyways)
- Constantly updating: many of the BI tools we looked at were slow to iterate on their product. This was a main selling point for us.
- Ease of Use: We have many users that are new to BIs tools and database management in general. BI software as a whole has a pretty steep learning curve for most people, but Chartio does a good job of making things easier all around.
- Database Support: It seems as though every department insists on storing their information using different databases. Chartio had support for everyone one we needed which was very helpful.
- Limited in-depth functionality: In speaking with our Data Science team, it seems Chartio is limited when it comes to more in-depth BI features. An example is the lack of ability to have complete control over queries: how often they fire, when they fire, which charts can refresh when, etc. Chartio has been improving on this, however.
- Limited Google Analytics control: In my speaking with the Chartio CSMs, this seems to be more on Google's end. Examples: The API doesn't fully pull in custom dimension names and query limits seem to still be imposed even though we have GA premium. Chartio does attempt to give workarounds like letting you rename the custom dimensions until they roll out a permanent fix.
- Filtering data by vertical - this allows the user to see the effects of different data points.
- The ability to pull the data on to an Excel sheet - this allows further manipulation of the data and by the addition of formula etc.
- Different dashboards allow the user to view the data in different ways different users may be fond of one view over another.
- Inability to immediately act on data from Chartio through Chartio's platform means we have to use other software to implement information gained from Chartio.
- Data gained isn't live this means we can sometimes depending on the quarter be acting on less relevant data and we also cannot be as reactive because we have to wait a day before we know if our changes made based on data from Chartio is successful or not.
- Very easy to integrate
- Simple interface to create charts and reports
- It affects the performance of our DB machine so we had to run it on a replica, I guess this can be solved by running more processing on Chartio's machines instead of our own.
- The query editor needs to be more enhanced, things like autocomplete and other basic features in the regular SQL consoles
- Global filters on dashboards to allow users to dig down into information
- Does not require you to upload your data - instead connects to database on our servers
- "Drag and Drop" style query building for easy queries, but also direct SQL for more complex questions
- Optimisation of timing of SQL queries (e.g. staggering things that run "every day" to not all run at midnight)
- Appearance - ability to customise axes, fonts, sizes, colours etc
- Simplicity for certain team members that do not have experience writing SQL code. Allows them to simply drag and drop for the easiest of queries rather than having an analyst find time to write one.
- Quick visualizations of written queries with a good amount of choices for different charts. It's easy to test a query in terminal and drop it into chartio to get a quick visual.
- Partitioning dashboards so only certain users can view or edit them. I've built upwards of 15 different dashboards in Chartio and some of the information isn't always privy to certain departments.
- Seat licenses for an entire organization which are then limited to a max of 10 users in the product at a certain time. If an 11th person wants to view something, they will get a pop-up that says the max amount of users are currently using Chartio, please wait until one of them exits. Or give a list of who is currently viewing.
- Auto formatting of numbers within a set of space defined by the vertical/horizontal rulers.
- Clean, intuitive interface.
- Good selection of visualization types.
- Easy to use, without a lot of unnecessary features tacked on.
- Limited ability to control when charts update. We've seen issues where loading a single dashboard will cause all charts to update simultaneously, swamping the DB.
- User management controls are a bit crude. Adding/removing users and managing dashboard permissions is not trivial.
- Updates existing business analytics reports automatically.
- Makes it easy to create new reports on the fly.
- It would be nice if the graphical interface could do some things that currently require SQLite code.
- Nice design
- Can create multiple dashboards easily
- Can clone graphs, tables, or dashboards easily for custom reports
- More tools for novice data users or people less familiar with data structure
- Ability to add documentation re: data libraries
Is your data being updated on an hourly/daily basis?
It's a great way to make SQL pretty, and great for team dashboards and goal tracking on the wall monitors. Also, the Chartio support team has been very helpful and new features are frequently rolled out. I use it primarily for productivity tracking of off-site team. For alerting suspicious activity by online customers. And we have an wall display of KPIs across all businesses being managed, and milestones to celebrate.
- SQL to Charts - if you've got data stuck in a database, Chartio makes it sharable.
- Business Intelligence - Want to know how your production is doing? Using drag and drop you can ask your database questions.
- Chartio's PDF reports via email sometimes are incorrectly formatted. This has much improved lately!
Key questions to ask are:
- Is your data consistent enough for analysis?
- Is it in a database?
Chartio Scorecard Summary
Feature Scorecard Summary
Chartio is a business intelligence tool that connects to the world’s most popular data sources in real-time by working with an organization’s database. Some key features include: Drag and Drop UI, Powerful Query Mode and Powerful Filters.
All Chartio customers receive the full version of our product.
Chartio Support Options
|Video Tutorials / Webinar|
Chartio Technical Details
|Mobile Application:||Mobile Web|