Skip to end of banner
Go to start of banner

How to Create a Self-Service Report From SQL Data

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 20 Current »

On this page

Recipe overview

This Business Intelligence (BI) recipe provides step-by-step instructions on building a pie chart based on a SQL data source – one of nearly limitless use cases for transforming raw data into meaningful and useful information for business analysis purposes. This recipe utilizes the following items:

  • The Run Self-Service Reports for Confluence add-on to provide a form through which the user can choose selection criteria for the data to be presented in the chart.
  • The Chart macro, which comes natively with Confluence, to produce the pie chart.
  • The SQL for Confluence add-on, which comes in both Express and Pro editions, to query a SQL database to retrieve the data to be presented in the chart.
  • The Macro Security for Confluence add-on to safeguard the page and the database it uses by ensuring that only Administrators can use the SQL Query macro.

(info) It will take you approximately 13-16 minutes to complete this recipe. Jump to Step 6 to see a preview of the final result!

See our other related BI recipes:

Recipe level

Ingredients

Preparation

Steps

More recipes

View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:

Find more recipes ...


Find answers from the community.

Ask a question to the community.

Log a request with our support team.

  • No labels