User Interface

Data Dashboard

The Data Dashboard is the central page where you can ask natural language questions about your data and get the SQL queries generated by PowerBuddy for Data Analysis. You can also write your own SQL queries and get the data for analysis.

Getting started

1. Type a natural language question in the Enter a question text box and either press enter or click Generate. The user query is rewritten by AI and displayed below the text box. You can also start by selecting a question from the list of Sample questions on Data dashboard. The results appear below this chat area.

2. To make updates or further refine your data, ask follow-up questions by entering them into the same text box. The rephrased AI query includes the entire context from your previous questions.

3. Click Download data to save a copy of the results.

4. To ask an entirely new, unrelated question, click Start new question, then enter your new question and click Generate.

An AI-generated summary of the SQL query is also produced when entering your own SQL in the Enter a SQL query text box.

Turn off the Enter a SQL query toggle to view the AI-generated prompt for the entered SQL query.

Save SQL

1. Click Save user query and enter a Question name to add a short name or title to your saved queries.

2. Review the AI-generated user query in the Question field and update it as needed.

3. Review the SQL query in the SQL field. You can edit the SQL query by clicking Review SQL from the Data dashboard, and clicking Edit SQL. If you make any modifications, make sure that the Question name and Question associated with the modified SQL query is still relevant, then click Save question.

This ensures that you can access and retrieve the queries without having to regenerate it every time. When a question closely matches a saved user query in terms of similarity, PowerBuddy retrieves the saved SQL and produces corresponding results. This feature is especially useful for frequently used or complex queries.

Guidelines for writing natural language questions

• PowerBuddy for Data Analysis is designed to work well with questions in a natural, conversational manner. You are encouraged to naturally converse with PowerBuddy using the chat to interact and clarify your questions.

• Asking specific questions ensures more accurate and relevant responses. PowerBuddy for Data Analysis performs well when provided with clear and well-defined input.

• Wherever possible, including timeframes or specific conditions in your questions can help narrow the scope of the response. Providing exact timeframes ensures more accurate responses.

• Break down complex questions into smaller parts for PowerBuddy for Data Analysis to comprehend and respond effectively.

• Separate multiple inquiries into distinct questions. Asking one question at a time ensures clearer responses and avoids confusion.

• If the response contains duplicates, explicitly ask a follow-up question to remove duplicates as needed.

Review analysis

The Analysis page provides options to further analyze the data that has been retrieved. You can explore various analytical functionalities including statistics, chart creation, basic machine learning predictions, chart creation, and more.

The Analysis page automatically loads a basic set of visualizations based on the distribution of attributes from the results produced on the Data dashboard. Additionally, the Analysis page offers you suggestions on the types of analysis that can be performed on the fetched data.

Analyze data using AI-generated suggestions

Choose an AI-generated analysis prompt from Suggestions. You can also click Regenerate suggestions to generate new suggestions to choose from.

Analyze data using descriptive language

1. Enter your own analysis description in the field provided.

2. Click View analysis.

Executive Summary and Insight

The Analysis page also provides the summary and insights into the data, highlighting distribution patterns and important details that help in understanding the overall composition of the dataset behind the visualizations.

Charts cannot be interpreted by PowerBuddy for Data Analysis, and it cannot provide suggestions based on visual representation. The capacity is limited to the underlying data in the tables.

Question vault

The Question vault page displays the list of all sample, recommended and queries saved by the users on the customer account. These are specific to each product.

The Search field can be used to find any saved query based on keywords from the saved Question name or Question. The search results display a list of saved queries that has high similarities with the keyword you entered.

You can review the saved SQL queries by clicking Review SQL, then edit the query, if needed, by clicking Edit run SQL. Click Run button to automatically run the saved SQL query.

The Question name and Question associated with any SQL query saved by the users, can be updated by clicking Update. Click Delete to remove the saved query.