Who is this article for?
Coruson administrators or data scientists.
Access keys for Galileo are required.
This article provides definitions for the main terms used in relation to Galileo, the data warehouse platform available as part of your Coruson system.
This article does not include any steps for using Galileo and instead provides a glossary of terms to help explain the concepts and purpose of some of the features. For more details on Galileo please visit Getting Started with Galileo.
Important: In some cases, you may be familiar with the concept but refer to these as something different within your organisation.
- API: Application Programming Interface, a software layer that allows two applications to talk to each other.
- API Call: The message sent to/from the API and another system.
- BI: Business Intelligence, a term used to describe analysis of organisational data from one or many sources.
- CSV: A file format with data delaminated by a comma that can normally be imported into other systems.
- Data Limit: A cap on the amount of data that can be downloaded. This resets every 24-hours.
- Data Refresh: Updating the data so you are looking at the most recent version.
- Data Warehouse: A large collection of business data that can be used for business intelligence. A warehouse can be made up of many databases.
- Database: An organised collection of structured information.
- Header: An extra source of information on an API call holding all of the metadata around the request and response.
- JSON: An open standard file format. Data is stored in a format that is easily importable into other systems.
- Key: A security code that will allow you to access your data. Keys can be enabled and disabled.
- Microsoft Excel: A spreadsheet tool for working with data.
- Microsoft Power BI: An interactive data visualisation software that can provide business intelligence. It connects to a data source and can be used to structure the data in a visual and understandable way (e.g. charts, dashboards, tables).
- Odata: Open Data Protocol, an approved standard that defines best practices for APIs.
- Postman: An API platform for querying data.
- Tableau: An interactive data visualisation software that can provide business intelligence. It connects to a data source and can be used to structure the data in a visual and understandable way (e.g. charts, dashboards, tables).
- Warehouse: See data warehouse.
- Widget: A component on a dashboard (e.g. a chart).
2. Further Reading
- Getting Started with Galileo
- Galileo Technical Overview
- Galileo Responses & Usage Limits
- How to Request Galileo Access
- How to Connect to Galileo Using Microsoft Power BI
- How to Build Table Relationships in Galileo using Power BI
- How to Connect to Galileo Using Postman
- How to Connect to Galileo Using Microsoft Excel