Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

In today's data-driven world, businesses rely heavily on advanced analytics solutions to gain valuable insights. One such powerful combination is the integration of Jedox, an enterprise planning and business intelligence platform, with ChatGPT, an AI language model developed by OpenAI. This integration opens up new possibilities for organizations, allowing them to leverage the capabilities of both technologies to achieve enhanced analytics and decision-making. Recently Jedox realised the model which showcases this bond. It can be found on the public marketplace and it is available for everyone. In order to work with the model users will need to have their own API key. Documentation of the model explains in detail how to obtain one and how to set it up in Jedox. The model contains 3 parts: 1st part is where you can send the numeric values to the model and ask it for interpretation of values. The goal is to receive a summary of values and it is good for the people who...
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