Build Powerful Dashboards with Luzmo and OpenAI
Table of Contents
- Introduction
- Setting Up the Environment
- Creating API Keys and Tokens
- Cloning the GitHub Repository
- Adding API Keys and Tokens to Configuration
- Running the Script
- Adding a New Data Set in Kumulio
- Creating Dashboards in Kumulio
- Exploring Generated Dashboards
- Customizing and Improving the Script
- Conclusion
Introduction
In this article, we will explore how to Create powerful data visualizations using the AI technology of OpenAI and the embedded analytics platform of Kumulio. We will walk through the process of setting up the environment, creating API keys and tokens, cloning the GitHub repository, running the script, adding new data sets in Kumulio, and generating interactive dashboards. We'll also discuss ways to customize and improve the script for your specific use case. So let's get started!
Setting Up the Environment
Before we can begin, we need to set up our environment. You will need a Kumulio account and an OpenAI account. If you don't have one already, you can create an account on both platforms. Once you have your accounts set up, make sure to create an API key and token for both platforms. These API keys and tokens will be used later in the process.
Creating API Keys and Tokens
To create API keys and tokens, navigate to your profile settings in both Kumulio and OpenAI. Look for the API tokens section and generate the necessary keys and tokens. These API keys and tokens will allow the script to access the required functionality of both platforms.
Cloning the GitHub Repository
Next, we need to clone the GitHub repository that contains the GPT dashboard generation project. Choose a folder on your computer where you want to store all the files associated with this project. Navigate to that folder using the command line and use the git clone
command followed by the repository URL to clone the repository into the folder.
Adding API Keys and Tokens to Configuration
After cloning the repository, you will find a .env
file in the folder. Open this file in a text editor and add the API keys and tokens you created earlier for both Kumulio and OpenAI. Save the file after making the necessary changes.
Running the Script
With the environment set up and the configuration in place, you can now run the script. Navigate to the folder where you have stored the project files and go to the specific subfolder called "GPT dashboard generation." In the command line, run the command npm install
to install the required dependencies. Once the installation is complete, you can run the script by entering the command node .
. The script will start listening for new Kumulio data sets.
Adding a New Data Set in Kumulio
To add a new data set in Kumulio, go to the data sets tab and click on "new data set." Kumulio provides several options for creating a data set, such as connecting to a database using out-of-the-box connectors or uploading local files in CSV or JSON format. Choose the option that suits your needs and import the data set. Once imported, the script will detect the new data set.
Creating Dashboards in Kumulio
While the script is listening for new data sets, navigate to the dashboards tab in Kumulio. Here, you should see a dashboard generated by the script Based on the newly added data set. The generated dashboard will include various data visualizations based on the columns of the data set. Some examples include bar charts for average load capacity by country and total passengers by country. You can explore the dashboard and delete any non-working charts if needed.
Exploring Generated Dashboards
The GPT language model generates different output each time, so the generated dashboards may vary. You can experiment with different data sets and explore the dashboards generated by the script. This process is an excellent way to perform data exploration and discover interesting combinations of data and visualizations.
Customizing and Improving the Script
If you want to customize the script further, you can modify the prompt given to the GPT model to specify the types of data visualizations you want in the generated dashboard. You can also make changes to the code to improve its functionality or add additional features. Feel free to experiment and tailor the script to your specific use case.
Conclusion
In this article, we have learned how to create powerful data visualizations using the AI technology of OpenAI and Kumulio's embedded analytics platform. We have covered the entire process from setting up the environment to running the script, adding new data sets, and exploring the generated dashboards. We have also discussed ways to customize and improve the script. With this knowledge, you can now leverage the power of AI to create interactive data visualizations with ease.
Highlights
- Create powerful data visualizations with OpenAI and Kumulio.
- Set up the environment by creating API keys and tokens.
- Clone the GitHub repository and configure the script.
- Run the script to listen for new data sets in Kumulio.
- Generate interactive dashboards based on the data sets.
- Customize and improve the script for your specific needs.