Geocharts visualisation in Jedox

Geocharts visualisation in Jedox

In today's post, we'll explore the world of geocharts and how they can enhance your data visualization capabilities in Jedox. Specifically, we'll dive into using geocharts from Google and discuss how to leverage the Google API key to unlock their potential. What are Geocharts? Geocharts are powerful visual representations of data that allow you to display information on a geographic map. With just a few lines of code, you can transform your data into an interactive map. This helps you identify patterns, trends, and correlations across different regions. Why Use Geocharts in Jedox? Jedox, a BI and EPM platform, provides a wealth of features for data analysis and visualization. Geocharts offer a layer of insight, enabling you to explore data geographically and gain a deeper understanding of regional variations. Getting Started with Geocharts and Google API Key: To utilize Geocharts in Jedox, we'll need to integrate the Google Charts API, which powers these visualizations. Before we proceed, you'll need a Google API key,...
Read More
Connect Jedox Cloud and Power BI

Connect Jedox Cloud and Power BI

To connect Jedox to Power BI, you will need to follow these steps: Make sure that the oData Hub service is running. (check Cloud Console) Obtain the Jedox OData API URL: usually, add odata before the cloud name. Example https://odata.test-jedox4begginers.cloud.jedox.com/DATABASENAME. It is also essential to add a database name at the end. In our case, we will put Biker as a database. Connect to Jedox from Power BI: Here, click on the "Get Data" button in the Home tab, and select "OData Feed" from the list of available data sources. Paste the Jedox OData API URL into the "URL" field, and click "OK" to connect to the Jedox server. Add the username and password. Depending if your team is using SSO choose Windows or Basic for standard Jedox credentials. Import data into Power BI: Once connected to the Jedox server, you can select the Jedox cubes or views you want to import into Power BI. Select the cube or view from the list of available tables,...
Read More