Business Intelligence (BI)

Business Intelligence (BI) systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. Software elements support the use of this information by assisting in the extraction, analysis, and reporting of information. Applications tackle sales, production, financial, and many other sources of business data for purposes that include, notably, business performance management. Information may be gathered on comparable companies to produce benchmarks.

Key Performance Index

The KPI framework provides a rich centralized repository defining key metrics and scorecards. With the KPI framework in Analysis Services, you can easily build balanced scorecards and other types of business performance management applications.

• Translations
  Translations provide a simple and centrally managed mechanism for storing and presenting analytic data to users in their preferred languages.
• MDX Scripts
  Multi dimensional Expressions (MDX) scripts are the new mechanism for defining calculated members, named sets, and cell calculations.
• Business Intelligence Wizards
  A set of easy-to-use wizards can help even the most novice user model some of the more complex business intelligence problems.
• Semiadditive Measures
  This new measure aggregation type for advanced data modeling includes last–nonempty, last–child, first–child, average–of–children, and even by–account–type.
• Data Mining
  Analysis Services provides tools for data mining with which you can identify rules and patterns in your data, so that you can determine why things happen and predict what will happen in the future–giving you powerful insight that will help your company make better business decisions.

EXECUTIVE DASHBOARDS for PERFORMANCE MANAGEMENT

Consolidated graphical view of the organizations performance using specialized visuals. Primarily meant for business users and top management, these tools can also be used at other levels.Executive Dashboards enable management to identify potential problems and bottlenecks in time. Dashboards are built to provide information that is actionable, forward looking and diagnostic.