Connect to Google Looker Studio (Looker Studio): https://datastudio.google.com/
From the configuration page
of your data export on Cadulis, you can directly click on Create a DataStudio/LookerStudio data source
This link will open the LookerStudio data source creation page, already pre-filled with your Cadulis download code.
If you used this method, you can skip directly to report creation
Click on Cadulis activities data source
Enter your Cadulis code, obtained from the export configuration page.
To create a data source for tracking your Cadulis licenses: Cadulis licenses data source
Proceed to report creation: your data source is configured!
Log in to your previously configured Cadulis data source: click on Create
, then Data source
You will then need to choose the connector
Search for Cadulis
and select the partner connector provided by “Cadulis SAS” Cadulis activities
.
You can also use the link Cadulis activities data source
Enter your connection code (previously obtained in your Cadulis export configuration) and confirm.
Remember to rename your data source so you can easily find it later!
If you have configured the source in Google Sheet, select the Google Sheet
connector
Select your Sheet file, as well as the sheet where you imported your data
At the top of the page, change the data source title: it will help you find it more easily!
Click on Connect
This method is not efficient for ingesting large volumes of data:
If you have more than a few thousand rows, you will probably need to use a faster or even sequenced ingestion method. Below is ingestion via bucket, but you could also use BigQuery or another big data engine ;)
If you have set up the .csv export to a Google bucket, choose Google Cloud Storage
Select your file from the bucket
At the top of the page, change the data source title: it will help you find it more easily!
Click on Connect
On this page you can refine the data type of the fields.
On this page you can pre-calculate fields, such as a
lat_lon
field, required for map visualization
Don’t worry: you can always come back later to modify the field types.
Your data source is configured!
You can always come back to edit it: refresh frequency, field types, etc.
Click on Create report
For this example, we want to display a map with the positioned interventions.
DataStudio requires a field of type lat_lon
but Cadulis only exposes latitude
and longitude
separately.
Add a field
lat_lon
CONCAT(location.latitude,",",location.longitude)
Geographic data
> Latitude,Longitude