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 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.
See our other BI recipes:
- How to create a self-service report from SQL data
- How to create a BI dashboard (coming soon)
Ingredients
Preparation
Install MySQL and the sample Examplegear Database, including defining the "examplegeardb" data source profile.
Steps
More recipes
View all our Recipes for Business Intelligence & Automation. Here are some of our latest updates:
