fbpx Skip to content

Unlocking New Capabilities with ChatGPT in Logi Symphony

insightsoftware -
September 22, 2023

insightsoftware is a global provider of reporting, analytics, and performance management solutions, empowering organizations to unlock business data and transform the way finance and data teams operate.

23 09 Blog Unlockingnewcapabilitieswithchatgpt Website

In today’s fast-paced market, data has become the lifeblood of decision-making. For application teams and users, having access to insightful and actionable data is not just a luxury; it’s a necessity. And now, the proliferation of AI in embedded analytics, like Logi Symphony’s new ChatGPT integration, is revolutionizing the way application teams and users interact with data, increasing efficiency and reducing the technical skills required to generate valuable insights.

The AI Revolution in Embedded Analytics

The integration of AI, particularly the capabilities of ChatGPT, into embedded analytics platforms like Logi Symphony, marks a significant milestone in the evolution of data-driven decision-making. This union signifies the transformation of traditional analytics dashboards into dynamic, AI-powered data hubs that can fetch, analyze, and provide actionable insights from a wide array of data sources.

AI integration bridges the gap between data and action, making analytics an integral part of the application experience. No longer confined to static reports or complex data exploration, users can now engage in dynamic, meaningful conversations with AI about their data.

With the power of ChatGPT, Logi Symphony offers a glimpse into the future of embedded analytics. And ChatGPT is just one AI integration option. Logi’s flexibility allows you to seamlessly plug in your AI tool of choice.

From contextual analysis of third-party data to single-click data analyses, the possibilities are endless. Whether you’re an application team striving to empower users with actionable insights or an end user seeking to unlock the potential of data, the AI-driven revolution in embedded analytics promises to deliver a brighter, data-driven future.

In this blog, we’ll explore two compelling use cases that demonstrate how ChatGPT enhances Logi Symphony’s capabilities.

Use Case #1 – Using ChatGPT to Analyze Any Data Set with Logi

With the power of ChatGPT, Logi Symphony offers single-click data analysis by extracting insights from visual representations. You can create a button within Logi Symphony that extracts data from charts or visualizations and sends it to ChatGPT for analysis.

This game-changing functionality empowers non-technical users to unravel complex datasets through simple conversations.

Traditional data tools often posed barriers for those lacking technical expertise, but now, ChatGPT’s conversational interface democratizes data insights, making them accessible to all. For data analysts, this integration automates routine or basic reporting tasks from senior stakeholders, freeing up their time for more intricate analyses.

Automated Data Extraction and Analysis

Let’s go through an example. You might have a dataset represented in a chart, and you want ChatGPT to analyze it.

Chatgpt 1

You can create a query like this:

  • “Please analyze this dataset and let me know interesting facts you see:
  • Rows:
  • (All)
  • Quarter 1, 2012
  • Quarter 2, 2012
  • Quarter 3, 2012
  • Cells:
  • 4,117,344.28
  • 38,946.00
  • 81,747.00
  • …”

ChatGPT will provide an analysis that you can display directly on your Logi Symphony dashboard. This enables you to uncover patterns and trends in the data without the need to open external applications.

Chatgpt 2

The analysis might reveal insights such as increasing values over time, seasonality, significant changes between quarters, peaks, troughs, overall trends, and more. These insights, available at the click of a button, can provide oversight and guidance to non-technical users and decision-makers.

Use Case #2 – ChatGPT as a Data Source

In the ever-evolving landscape of data-driven decision-making, access to real-time, context-rich information is the key to staying ahead of the curve. Imagine a world where application teams and end users can seamlessly tap into a wealth of data resources, fetching insightful information effortlessly, and integrating it directly into their workflows.

Now, that dream is a reality. Let’s say you want to integrate publicly available contextual information into your Logi Symphony dashboard. With ChatGPT, this task becomes not just possible but very straightforward. By utilizing Python programming, you can script interactions with the ChatGPT API to fetch data efficiently and integrate it into your reporting at the click of a button.

Fetching Historical Data on US Presidents

For example, let’s say you want to gather information about the last 20 United States presidents to analyze if there’s a trend in their ages when entering office. You can create a prompt for ChatGPT like this:

“Please give me the names and ages of the last 20 presidents in the USA and their age when they entered office. Can you provide this in a JSON format? Do not provide any other text response other than JSON.”

Adding the qualifier “do not provide any text response other than JSON”, will just give us the data, and remove anything else in the response that will make it more difficult to read via Python/Logi Symphony.

Upon testing this query in the web-based interface, you can see that we get a friendly, clean response:

Test Code

Going into Python, we have code that looks like this to get the same response as the web interface.

  • import openai
  • import json
  • import pandas as pd
  • from pandas import json_normalize


  • openai.api_key = “YOUR API CODE HERE”


  • completion = openai.ChatCompletion.create(
  • model=”gpt-3.5-turbo”,
  • messages=[
  • {“role”: “user”, “content”: “please give me the names and ages of the last 20 presidents in the USA and their age when they entered office. Can you provide this in a JSON format? Do not provide any other text response other than JSON.”}
  • ]
  • )
  • data = (completion.choices[0].message.content)


All we need to do is covert this data into a table format and pass it back to Logi Symphony.


  • dict = json.loads(data)
  • df = pd.DataFrame.from_dict(dict[“presidents”])
  • return df

As you can see, we are able to get a response.

Final Working Response

Since ChatGPT is potentially an unstable element in that it’s response might change due to a software update or service outage, we should warehouse the result so that our answer is stored and captured for long-term use. That way, we know it will still be available anytime we want to see the data.

Working Results 5

Now, all we must do is create a dashboard based on the results we generated by ChatGPT.

Working Results 7 Correct Data, New Query

Since we can now look at the results visually, these results are exciting but also seem high (Jimmy Carter wasn’t president at the ripe old age of 98!). Our query to ChatGPT might have needed to be more straightforward, as it’s given the current ages of the presidents. Lesson learned: You get what you ask for.

After a quick modification to the query and some additional clarification on expected data formats and additional information, we are getting the correct results and more data.

“Please give me the names of the last 20 presidents in the USA, their age when they first entered office (as integer), and the date of inauguration (as DateTime datatype). Can you provide this in a JSON format? Do not provide any other text response other than JSON.”

Now that we have data, we can utilize the predictive power of Logi Symphony to take this data to another level by requesting the system perform a forecast.

Working Results 9

Logi Symphony and ChatGPT Will Change the Way you Interact with Data

The integration of ChatGPT into Logi Symphony opens a world of possibilities for data-driven decision-making and analysis. Whether you need to fetch real-time data or extract insights from visual representations, ChatGPT’s capabilities enhance Logi Symphony’s functionality.

By leveraging the power of AI and data integration, you can gain deeper insights into your data and make more informed decisions. With ChatGPT in Logi Symphony, you have a powerful tool at your disposal to unlock the full potential of your data.

Visit our website to schedule a demo and see what Logi Symphony can help your application achieve.

About Logi Symphony

Logi Symphony enables software teams to rapidly design, build, and embed interactive dashboards and data visualizations with fast connectivity and access to modern data infrastructure. Maintain complete control over the analytics experience while empowering end users to explore, analyze, and share data securely.

  • Connect to any data source.
  • Align data with ETL, data performance, data quality, and data structure.
  • Embed dashboards, reporting, what-if analysis, and self-service.
  • Create content with unparalleled visual and interactive flexibility.
  • Augment data with predictive, forecasting, clustering, and outlier analysis.
  • Integrate with fully open APIs and white labeling.


23 08 Bro Logisymphonyfrominsightsoftware 1pg Website

Logi Symphony from insightsoftware

Download Now: