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 macro.