How to Set-up the Galileo Base Reporting Pack
Who is this article for?Coruson administrators or data scientists.
Access keys for Galileo are required.
The Base Reporting Pack has been designed as a starting point to begin analysing your Coruson data using Galileo. The Base Reporting Pack is a Microsoft PowerBI file which will pull in the key data from each module.
Once implemented, you can modify the PBIX file to focus on other information or build entirely new widgets.
This article outlines the steps required to begin using the Base Reporting Pack. This does not provide details on specific steps on how to perform the data analysis as these steps vary depending on the tools you use.
To make setup easier to follow, this article is split into 4 sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are doing with Galileo:
Important: Before proceeding, you will need to have Galileo activated for your Coruson tenant and you will need your security access keys. If you do not have the connection information or access keys then please visit Getting Started with Galileo for more information.
1. Download the PBIX
The template PBIX can be downloaded here.
Once downloaded, this file can be opened in PowerBI and then connected to your Galileo system.
Note: Galileo does not provide real time data from Coruson. However, the day refreshes frequently throughout the day so that the data will feel "fresh" when performing an analysis.
2. Connect to Your Galileo
Reminder: Before proceeding, you will need to have Galileo activated for your Coruson tenant and you will need your security access keys. If you do not have the connection information or access keys then please visit Getting Started with Galileo for more information.
To connect to your Galileo system:
- Open the Galileo Base Reporting Pack.pbix.
- Click Transform Data, then Transform Data.
- There are eight queries displayed in the PowerQuery editor. You will need to edit each query.
- Select the first query and click Advanced Editor.
- Update the query with:
-
- The URL to your Galileo database.
- The access key to your Galileo database.
- Click Done.
- Select the second query and make the same changes.
- Repeat this process for the remaining queries.
- Return to the BI Reporting Pack and click Apply.
Need to update the relationships? Please visit How to Build Table Relationships in Galileo using Power BI for details on the relationships configured in the Base Reporting Pack and also for details on how to build a new relationship.
3. Further Reading
4. Attachments