SQL Query Reports

SQL query reports in Infoveave are a powerful tool for analyzing data insights from diverse Infoveave sources. These reports enable you to retrieve specific insights using SQL queries written over Infoveave sources. You can tailor your SQL queries to extract specific data fields, apply filters to narrow down the dataset, and perform calculations or aggregations to derive meaningful insights. This allows you to create query reports to showcase insights, whether it is analyzing sales data, tracking customer trends, or monitoring business performance.

Guide to Creating a Query Reports: A Step-by-Step Process

SQL query reports in Infoveave provide a powerful means to access and analyze data from various data sources through customized SQL queries.

1. To create a SQL query report, navigate to Queries under Studio module.
2. To create a new query, to be converted to a report, click on New Query.
   • You will be redirected to the SQL query editor.
3. Select the required Datasource from the pre-configured list. Let us select the ‘Sales’ Datasource.
4. Click on Continue and you will be redirected to the SQL query editor.

5. In the SQL query editor, write your SQL query for the required insights.
   • Let us write the below query into the editor to identify the country wise profit.
   • The SQL query calculates the total profit for each country listed in the [Sales.sales] table. It retrieves the country names and their corresponding total profits, grouping the results by country.

     •  SELECT
       [sales].[Country] AS "Country",
       SUM([sales].[Profit]) AS "Profit"
       FROM [Sales.sales]
       GROUP BY
       [sales].[Country];

6. Click on the Execute Query icon to start executing the query.
7. The query result will be displayed in the Data tab, under the query editor.
8. Click on the Save icon to save the query with a name. Let us name it as “Country Profit”.

9. To convert the query to a report, navigate back to Queries under Studio module.
10. Click on the Show as Report icon associated with the query.
    • You will get a notification on the successful conversion of the query into a data report.

11. To view the report generated, navigate to Reports under Studio module.
12. You can download, email, share with team or even the edit the report directly from here.

Conclusion

SQL query reports in Infoveave offer a robust solution for analyzing insights from diverse Infoveave Datasources. By leveraging SQL queries, you can extract specific data fields, apply filters, and perform calculations to derive meaningful insights for informed decision-making.