Welcome to MSDN Blogs Sign in | Join | Help

William Li's Enterprise Reporting

Discussions of Enterprise Reporting with SQL Server 2005 and Beyond
Different Types of Enterprise Reporting Needs

Most of organizations might be using different type of data reporting for these business needs but there are a lot of similarities too. Here are the various types of Enterprise Reporting I have collected so far:


  •  List Reporting – The most common usage of Enterprise Reporting is the formatted displays or presentations of organizational data lists through list, text, graphics or other rendering formats for periodic business operation. Various levels of itemized rows and aggregated summaries are typically used in List Reporting. Data rows and summaries might be assembled from one or more than one functional discipline areas within the enterprises.

 

  • Interactive AnalysisEnterprise users needs to perform analysis upon large set of data to understand or find presentation of the data. These analysis typically are interactive and allow users to directly select dimensions (location, department, time, etc) to compare measurements (sales growth, cost distributions, amount etc). The interactive analysis requires data readily available when different dimentions, measurement are chosen so typically data are pre-calculated or aggregated using specific data model like OLAP.


  • Ad-hoc Querying - Ability to allow advanced business users for ad-hoc data needs and play "what-if" scenarios to determine what are the best use of enterprise data. Most of time it involves Excel or other front-end easy tools for those users to analysis or querying data.

  • Metric Management - In many organizations, business performance is managed and measured through outcome-oriented metrics. These metrics are agreed measurement to track and compare the business performance over a period of time. Within the organization, these are mostly called Key Performance Indicators (KPIs). For external organizations, they are Service Level Agreement (SLAs).

 

  • Dashboard - Another way for enterprise to consume their reporting data is publishing them into customized dashboard views, mostly hosted within enterprises’ internet portal. These dashboards might use graphic to mimic color-coded auto dashboard indicator for easy but grand overview of enterprise’s key performance.

 

  • Balance Scorecards - A method attempts to present an integrated view of success in an organization. In addition to financial performance, they also include customer, business process and learning and growth perspectives.

  • Data Mining - When enterprise holds large amount of data, many of them started to analysis using Data Mining technique neural networks and machine learning to study and find potential common patterns in the data. Most of the data mining takes time and dimensions into account to try to predict or forecast the learning.

Published Thursday, September 21, 2006 1:07 AM by williaml

Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# William Li s Enterprise Reporting Different Types of Enterprise | Paid Surveys @ Friday, May 29, 2009 8:12 PM

PingBack from http://paidsurveyshub.info/story.php?title=william-li-s-enterprise-reporting-different-types-of-enterprise

William Li s Enterprise Reporting Different Types of Enterprise | Paid Surveys

Leave a Comment

(required) 
required 
(required) 
Page view tracker