Alert - In Chartio, an alert is essentially a Single Value chart with a threshold. Chartio will run your query at the scheduled interval, and if the value returned meets the threshold you’ve specified, we’ll send an email with a customized message.
Cache duration - The Cache Duration tells Chartio how long to keep chart data before querying your database for fresh data. If you would like fresh data very often, you can set the cache duration to a lower time interval.
Concurrency - Concurrency refers to the ability of a database to support multiple processes simultaneously. Every data warehouse has concurrency limitations or the maximum number of queries you can run simultaneously without leading to slowness in generating interactive reports.
Controls - Also known as Dashboard Variables, controls are interactive variables you can set on your dashboard and connect to multiple charts as filters. Controls include Dropdowns, Calendars, and Date Buckets.
Custom column - Custom Columns are a way to increase your organization’s ability to control the definition of these key metrics and prevent different members from redefining them. You can create Custom Columns in the Schema tab of your Data Source.
Custom schema - The ability to store and query manipulated columns, called custom columns, or views, custom tables, that only live inside your Chartio instance. Both objects; custom columns and custom tables must be written in the data sources native SQL syntax and can only be used in interactive mode(cannot reference in SQL mode).
Custom table - A table in Chartio that is made up from the columns of tables that were joined, or just a subset of a specific table. This gives the user the ability to query these results, conceptually similar to a database view except this only lives inside Chartio. When a user pulls from this column, Chartio injects the SQL code used to create the custom table as a subquery. Custom tables function similar to any table in your schema(schema brought into Chartio), you can set foreign keys going from a custom table to a table that exists in your data source, or another custom table. You cannot reference custom tables by name in SQL mode, so you’ll need to use interactive mode to query custom tables.
Dashboard - Dashboards in Chartio can be built with multiple charts, texts, controls. Dashboards are built to trigger insights that help you take action by arranging multiple data visualizations.
Dashboard id - Dashboard IDs are used as a unique identifier for a dashboard. This ID is used to keep track of a dashboard in Chartio’s backend. To find the dashboard ID you can hover over a dashboard’s title.
Data modeling - Modeling is the process of translating data into an easily consumable form to support the business. More specifically for BI, there are two distinct aspects to modeling:
- Business users’ ability to understand the data and build the charts they need (presentation of data)
- Ongoing management between the database and Chartio by Data Engineers, Data Analysts (transformation of data)
Data pipeline - The data pipeline is Chartio’s flexible interface that allows users to continue to manipulate the data returned from the original queries. Our Data Pipeline allows you to perform a number of transformations on your query results in a series of steps. These steps include a variety of operations such as joining data from multiple sources, aggregating data, column sorting, pivoting data, and adding calculated columns. The flexibility of adding any steps in any order allows you to get your data exactly how you want it for your final presentation.
Data Source - An external collection of data that is connected to Chartio for purposes of analysis. This could be a database, CSV, or google sheet.
Data Store - A stored table from one or more data sources connected to Chartio. Advantages: We can use our Visual SQL interface. It can pull from various sources, which can’t be done with custom views alone. Data Stores can be scheduled to run at certain times for performance optimization.
Data Warehouse - A Data Warehouse (also commonly called a single source of truth) is a clean, organized, single representation of your data. Data warehouses make your data:
- Easier to understand and query - simplified single model
- Faster for the data team to use
- Approachable to work with for Business Users
- Trusted, consistent source of answers
- Easier and less time to maintain
Database - A data source that is typically organized in a format that allows for efficient storage and retrieval of information. There are many types of databases, but some of the most common include Relational, Document Oriented, Graph, and Key-Value.
Dataset - A Dataset is one query from a data source. In Chartio, you can merge your Datasets using a join.
DPA - A data processing agreement (DPA) is a legally binding document to be entered into between the controller and the processor in writing or in electronic form. It regulates the particularities of data processing – such as its scope and purpose – as well as the relationship between the controller and the processor.
Drill Down - Chartio’s Drilldown functionality allows you to click an area on a chart to update a Dashboard Variable value. The Dashboard Variable can then be used to update any charts on the same dashboard or on another dashboard.
ELT - ELT is the modern approach to managing cloud data, where the transformation step is saved until after the data is loaded into a data lake. The transformations really happen when moving from the Data Lake to the Data Warehouse.
ETL - ETL is the legacy way to manage cloud data, where data extracted is first transformed before being loaded into a data lake.
Foreign key - Foreign keys tell a database on how to join two or more tables together in the same query. In Chartio, foreign keys allow users to join data from different tables together in Interactive Mode. Foreign keys can either be imported from your data source or manually set from the Chartio schema page.
Hidden Variable - A hidden variable is a control on your dashboard that is not visible from the dashboard. Common use cases for hidden variables are for drilldowns and embedding.
HIPAA - HIPAA is the acronym for the Health Insurance Portability and Accountability Act that was passed by Congress in 1996.
The Standards for Privacy of Individually Identifiable Health Information (Privacy Rule) sets forth, for the first time, a set of national standards for the protection of certain health information. The U.S. Department of Health and Human Services (HHS) issued the HIPAA Privacy Rule to implement the requirement of the Health Insurance Portability and Accountability Act of 1996 (HIPAA).
The HIPAA Privacy Rule addresses the use and disclosure of individuals’ health information called “Protected Health Information (PHI)”. These types of organizations are called “covered entities”. The Privacy Rule HIPAA requirements outline for covered entities individuals’ privacy rights to understand and control how their health information is used. HHS and the Office for Civil Rights (OCR) have the responsibility for implementing and enforcing the HIPAA Privacy Rule with respect to compliance activities and civil money penalties. The HIPAA Privacy Rule is to assure that an individual’s health information is properly protected while allowing the individual’s necessary health information that is needed to provide and promote quality health care, is protected. The HIPAA Privacy Rule permits important uses of information while protecting the privacy of people who seek healthcare.
Interactive Embedding - AKA Embedding, for short; Interactive Embedding is a Premium feature that allows users to embed Chartio dashboards to their own applications, viewing them just as they appear in Chartio (i.e., with applied dashboard themes and titles). Users can also enable viewers to filter those dashboards with Chartio’s native UI elements (e.g., Dashboard Variables, Drilldowns, etc.).
Interactive Mode - Interactive Mode is Chartio’s drag and drop interface. It’s a quick way for anyone to explore their data or create a chart. No SQL knowledge is required, as Chartio is generating the SQL for you behind the scenes.
JSON web token - JSON Web Token (JWT) is an open standard (RFC 7519) that defines a compact and self-contained way for securely transmitting information between parties as a JSON object. This information can be verified and trusted because it is digitally signed.
Link sharing - Link sharing is a way to provide user access to a resource without granting permission for a specific person. In Chartio you can enable link sharing for a dashboard and anyone with access to your Chartio instance and a copy of the link can access the dashboard.
Monitor license - Monitor licenses are user types available on certain plan types allowing you to create a separate view-only Chartio user. This user can then be granted Viewer access to dashboards and used to display dashboards on TVs or Monitors around your workspace.
Primary admin - The Primary Admin is a designated admin on a dashboard or data source. The Primary Admin is considered the owner of the dashboard and they should be the go-to contact with any questions about the dashboard or data source. The Primary Admin can be an individual user or a Team.
Protected Health Information (PHI) - Any Customer Data from a customer that has signed a Business Associates Agreement (BAA) with Chartio, enforcing HIPAA legal requirements on Chartio.
Query log - A query log is used to track queries to a data source. It includes the date and time the query was sent, the amount of time it took the query to complete, the query that was sent to the data source, and any accompanying errors that were generated.
Rate limit - Rate limits are used to control the rate at which a host can send or receive network traffic. In Chartio rate limits are used to specify the number of queries that can be sent at one time to your data source.
Refresh rate - Refresh rates in Chartio refers to when the dashboards automatically refresh their charts on a regular basis. You can read about the refresh rate settings in detail here.
Relational database - A database that stores related information in tables (defined below), also known as relations, which are 2-dimensional structures comprised of columns and rows. Examples include Postgres, MySQL, and Redshift.
Row limits - The maximum number of rows that can be included in a dataset even if more rows match the criteria to be included.
Schema - In Chartio, it is a collection of objects within a database, consisting of tables(and columns within those tables) and the relationship between those tables(foreign keys set on your data source or the ones you set in Chartio).
Slug - Slug is a unique part of the URL to identify your organization in Chartio. Example - (URL after chartio.com/)
Table - A materialized (stored physically) table on the database. These tables on the database are reflected virtually in Chartio and can be manipulated to be more usable by editing metadata.
View - In Chartio, a view is a table stored virtually (created at run-time), created by a SQL query. Views help simplify the underlying physical data without having to copy/create multiple new physical tables.