You are here: Home / data warehouse / Data warehouse reporting tools

Data warehouse reporting tools

November 21, 2011 By Leave a Comment

Without proper reporting tools a data warehouse contains data which cannot be used. But what are the features of good data warehouse reporting tools?

Passionned Group, a research and consultancy firm, examined 16 data warehouse reporting tools on 103 features. Below are the features. If you want to know all the strenghts and weaknesses of all the tools, consider buying the BI Tool Survey.

  • connect to one or multiple databases in a single report
  • defining queries on the data warehouse database
  • loading millions of records for aggregation and analysis (big data)
  • creating simple and complex filters and sortings
  • create a pixel perfect report including a variety of formatting options
  • conditional formatting
  • automatic summarization of the measures: average, median, count, sum and so forth.
  • display pivot tables, simple lists or summarized tables
  • creating sections guided by a dimension
  • presenting data in many type of graphs

Analysis tools

  • clicking on data items to drill-down into the details
  • one click graphs
  • slicing and dicing - switching easily dimensions
  • nesting dimensions
  • sorting and filtering
  • conditional formatting
  • extreme performance getting answers instantly
  • automatic summarization of the measures

    • Dashboarding tools

    • display measures visualized as meters
    • letting you to create a cockpit with one or more meters
    • defining targets and norms on measures
    • alerts and notifications when target values are reached
    • drilling directly into more details by clicking on a meter or graph

    Performance management

  • design a framework with indicators, performance indicators (PI), key performance indicators (KPI) and key result indicators (KRI)
  • setting the most likely impact of one indicator on another
  • defining norms, targets and short and long term objectives
  • support for Strategy Maps and the Balanced Scorecard methodology
  • support for consolidation & planning
  • adjusting targets and norms on the fly
  • visualization of all type of indicators in dashboards, analysis and reports

    • Social collaboration tools

    • creating comments and notes regarding a specific value in a time-period, indicator or graph
    • distribute & discuss the notes with your collegues
    • shared analysis letting your collegues see what you see (real-time)
    • chat functionality: talking about the figures, analysis and reports

    Order now a thorough comparison of all BI tools and discover all their features & secrets.

    Filed Under: data warehouse, reporting tools Tagged With: ,

    Speak Your Mind

    *