Sunday January 21st 2018

Categories

Insider

Archives

Business Intelligence and MS Sql Server 2008

Microsoft Sql Server 2008 Provides tools to support all Aspect of Business Intelligence;

Integration Services – Enables us to create automated processes for data cleansing and import into Data Ware house and Data marts.

Online Analytical processing (OLAP) features i.e Key performance indicators (KPIs),

Multidimensional expressions MDX queries and scripts, and the Unified dimensional model (UDM) enable us to slice, dice and summarize information for meaning full reporting.

Data mining – Allowing finding and presenting patterns and behavior predictors that might not otherwise be found in the data.

Reporting Services and MS office business intelligence accelerators – facilitate the delivery of this information to decision makers.