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 related BI recipes:
- How to create a self-service report from SQL data (Intermediate)
- How to Create a Business Intelligence (BI) Dashboard (Advanced)
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:
