Page 203 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes

Notes You cannot use SQL Server Management Studio to develop, manage, or query
multidimensional data sets that were built by using PowerPivot for Excel.

Self Assessment

Fill in the blanks:
6. OLAP is supported by .................... by letting you design, create, and manage
multidimensional structures.
7. An Analysis Services instance is deployed in a mode that supports a .................... architecture
that is optimized for all kinds of solutions.

Case Study Microsoft SQL Server 2008

lobal aviation fuel companies supplying airlines in the current fragile economic
climate are highly sensitised to potential airline collapses. The liability of unpaid
Ginvoices or even un-invoiced deliveries can significantly harm the profit margins
within an extremely competitive market. Getting this information into the hands of the
people who can make some sound commercial decisions was paramount for one such
company.

Following a successful pilot in 2007 and the rapidly changed economy in Q4 2008, BMN
was engaged to turn around an analysis and reporting tool within a matter of weeks. By
using the right tools and approach, the results have been astonishingly productive with a
solution that puts the power in the hands of the end user.
Solution:
The principal project objective was to enable the creation, management, and delivery of
business intelligence reports for the analysis of customer account open debt and priced
un-invoiced deliveries from all account receivable systems.
This required the consolidation of data feeds from multiple regional accounting systems
into a single data warehouse against which data cubes and their dependent reports could
be developed.
A SQL Server 2005 Business Intelligence solution was implemented to meet the customer
requirements of accuracy, flexibility and performance.
Features:

Centralised credit exposure reporting environment allowing clear identification
and analysis of account information by account holders
A complex data consolidation procedure to ensure data is up-to-date for global
account managers
Contd....

198 LOVELY PROFESSIONAL UNIVERSITY