Who is this article for?
Coruson administrators or data scientists.
Access keys for Galileo are required.
Galileo is a Coruson data warehouse. It has been designed to surface the data in ways that help to provide good performance on complex queries and expose related data in an efficient manner.
Galileo uses database view to present the data to users. Some of these views may be able to provide all the data required by a user for their reports, while others will allow complex data to be pulled from multiple locations with what appears to be a simple query.
Loading data into the warehouse is designed to allow the process to run frequently, allowing the warehouse to be kept as close to changes within Coruson as possible – usually with under an hour between updates.
The analysis can be performed by connecting to Galileo and performing your queries or you can load the data into a larger database system for more extensive querying or for integration with data collated from other systems.
The links below provide further information on using Galileo:
- Galileo Technical Overview
- Galileo Responses & Usage Limits
- Galileo Structure & Entity Relationship Diagrams (ERDs)
- How to Request Galileo Access
- How to Connect to Galileo Using Microsoft Power BI
- How to Set-up the Galileo Base Reporting Pack
- 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
- Galileo: Glossary of Terms
Important Note: The above articles outline the purpose, capability and requirements of the Galileo system only and do not provide any steps on how to perform your analysis or how to use your business intelligence tools.