It's a great way to make SQL pretty, and great for team dashboards and goal tracking on the wall monitors. Also, the …
Customizable dashboards (18)
Pre-built visualization formats (heatmaps, scatter plots etc.) (15)
Publish to PDF (17)
Pixel Perfect reports (14)
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Chartio (discontinued), and make your voice heard!
Contact sales team
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Chartio is a visualization tool designed to enable anyone to explore, transform and visualize data on the fly through a drag-and-drop interface. Chartio was acquired by Atlassian in February 2021 so that it's capabilities could be integrated into the Atlassian product portfolio's capabilities. Chartio is no longer available to new customers, standalone. Existing customers must migrate to alternatives by March 2022, when the service will be retired.
- Supported: Pre-built visualization formats (heatmaps, scatter plots etc.)
- Supported: Location Analytics / Geographic Visualization
- Supported: Predictive Analytics
- Supported: Support for Machine Learning models
- Supported: Customizable dashboards
- Supported: Report Formatting Templates
- Supported: Pixel Perfect reports
- Supported: Drill-down analysis
- Supported: Formatting capabilities
- Supported: Predictive modeling
- Supported: Integration with R or other statistical packages
- Supported: Report sharing and collaboration
- Supported: Publish to Web
- Supported: Publish to PDF
- Supported: Output Raw Supporting Data
- Supported: Report Versioning
- Supported: Report Delivery Scheduling
- Amazon Redshift
- Google Analytics
- Google BigQuery
- Amazon Aurora
- IBM Db2 Warehouse on-premise edition
- Google Cloud SQL
- Heroku Platform
- MariaDB Platform
- Microsoft Azure
- Microsoft SQL Server
- Twilio Segment
- Treasure Data
- Amazon Relational Database Service (RDS)
- a Talend company
|Mobile Application||Mobile Web|
- Downloadable charts
- Combining email domains
- Customizable dashboards
- Loads very slowly
- Not very accurate numbers
- Doesn't always load
- Hooks up to nearly any data source and common services.
- Supports SQL but also has a nice query builder.
- Supports the creation of data stores for fast loading charts for common metrics.
- Offers a data pipeline to ETL the data as needed.
- The sharing is descent but is a bit lacking. You can embed charts but they're not as nice as when displayed on Chartio dashboards.
- The pricing model is very competitive, but just to offer embedding puts you in a very high tier.
- They need a better pricing model for adding users. User licensing is a bit expensive.
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
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.
- Easy to get started
- Great customer support
- Frequent new features
- Better arrangement of charts within a dashboard
- Efficient access
- Multiple options for displaying data
- flexible analytics
- Improved ability to build charts
- Easier search for facts and dimensions
- Formatting of data elements...adding $ or % symbols
- csv export
- sql query
- Display graphs in a comprehensive way
- Easy interface
- Faster loading speed
- More customization with the dashboards
Is your data being updated on an hourly/daily basis?
- 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.
- 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?
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)
- Good visualizations.
- Simple to use and build charts.
- Good and understandable design.
- Might be hard to use for people without SQL knowledge.
- Not very convenient use with custom queries.
- After creating a dashboard it's confusing to edit or correct it.
- 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.
- Very simple to set up charts
- Automatic Updating
- Clear Metrics
- Layout sometimes can be convoluted
- Sometimes there is a learning curve
- 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.
- 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.
- Organizing Graphs
- Custom Queries
- Easy interface
- Email notifications
- Ease of use.
- Ease of integration.
- Simple visual layout.
- More chart options.
- 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
- Direct linkage to our databases. Abstracts away the visualization layer so we can focus on the data and the queries.
- Host of graphs and tools that permits all types of data visualizations.
- Haven't quite used this yet, but there is a new embedding feature that will be very helpful so that we can embed the charts into a company central dash.
- The date slider is hyper annoying to use
- When emails get sent as PDF, the formatting gets messed up if it's a graph dense dash.
- It handles a lot of data, but it'd be great if it could handle and visualize more data.
- 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 data representation. Once built, the charts and dashboards are very pleasing to look at and easy to understand.
- Great customer service. If there is ever something that I realize I need, but the product doesn't have yet, I can contact Chartio directly and they usually implement a solution for my particular need.
- The data transformation steps while writing charts are very useful. You can reorder and rename columns, pivot your data, add extra filters or groups, etc. What is really helpful is that you can preview your data as you're transforming it.
- There is not a last full month date range option. You can still get the range that you need, but the dashboards will have to be manually updated to exclusively display one whole month.
- When building a chart, the area which displays your tables and fields is finite. You can't adjust the size to make it easier to see. They do allow a mouse-over to see the entire name of your table/field, but I would prefer to adjust the width.
- Once you modify a query in the Custom Query tab, there doesn't seem to be a way to go back to using the U.I.
This product is well suited for end users that don't want to get too in depth with reporting. The interface is simple and the default filter options are sufficient for a general report.
Example: Total Sum of Net Sales for all products sold in X State between dates X and X. If the need is for a more complex query, then there is the Custom Query option. This would be something that an administrator would have to police as having users writing their own queries could get really messy really fast.
I suppose the key questions to ask would be:
Do you need a product that will... display all relevant charts/reports in one consistent place? ... be simple for an end user to navigate? ...be web-based and remotely accessed?