Confluence Reporting HOWTO

Introduction

Everyone knows that Confluence is a great enterprise wiki. At Atlassian, we also use Confluence as a reporting and business intelligence tool. We've developed some techniques to extract and share our company's information using Confluence, and in this guide we'll share them with you.

When I started at Atlassian I was blown away by how they use Confluence for business intelligence. In previous jobs I had published business data using hacked-together collections of scripts or (under duress) cumbersome reporting packages that seemed designed more to impress in a demo than to serve a useful purpose for the organization. Atlassian seemed to have in Confluence a simple and fast yet fully capable way to publish the business' data to whoever needed it most.

What makes Confluence so great for reporting? By combining Confluence's enterprise features with the ease-of-use and flexibility of a wiki, you can get real-time dynamic data in front of your users quickly, simply and without needing to invest in additional systems. As a bonus you get all of the collaborative features of Confluence for your reports (such as automatic versioning, granular enterprise security, and update notifications). If someone has a good idea for a report, they can make it happen (and if that good idea breaks the report, you can easily roll back to a working version).
Contents

Here are some examples of what you can do (click to enlarge):

In this guide we'll cover:

After you're done, you'll be able to use the same techniques that we use at Atlassian to build your own information dashboards and reports.

Audience

Creating reports and data dashboards in Confluence isn't as hard as, say, calculating the airspeed velocity of an unladen swallow. But we do assume that you:

  • Have Confluence set up and running in your company.
  • Know structured query language (SQL)1.
  • Have the database you want to report on set up as a JDBC datasource available to Confluence.
  • Know where your company's data is kept and how it's organized.

About the Authors

  • Jim Severino is in Atlassian's Internal Systems group. When not mediating on business intelligence, Jim spends his time managing projects, building tools and playing Set. Contact Jim at jseverino@atlassian.com or just tap on the window of our Sydney office.
  • John Rotenstein is Jim's boss. He taught Jim everything he knows, except for the wrong bits and anything that causes mistakes.

Next: Retrieving Data Into Tables

1: SQLzoo is a good place to learn SQL and a great reference for experienced practitioners.

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (1)

 

  1. Dec 21

    roytjie [atlassian] says:

    Related blog post.

    Related blog post.