Share via

Analysis and Reporting Services, Design and Implementation

SQL Server Technical Article

Writers: Nicholas Dritsas, Nopparat Leelavanich

Contributors: Artich Asawachaiyawong, Sairung Inlert

TechnicalReviewers: Carl Rabeler, Robert Bruckner

Published: June 2010

Applies to: SQL Server 2008, SQL Server 2008 Analysis Services, and SQL Server 2008 Reporting Services


Providing strong customer service has helped this customer become the largest commercial bank in Thailand. Always looking for new ways to enhance the services it provides, the bank wanted to study its customer data to help it better determine customer needs, but a reporting system based on manual report development in spreadsheets by using mainframe data (provided in text files) proved cumbersome. The company created a business intelligence (BI) data warehouse using the Microsoft Application Platform, including Microsoft SQL Server 2008 Enterprise (64-bit) database software. Reports are now generated automatically using SQL Server 2008 Reporting Services. Multidimensional data cubes for support of BI analytics were created using SQL Server 2008 Analysis Services. The customer has gained a better view into its operations and deeper customer knowledge since deploying its BI solution. 

- DownloadAnalysis and Reporting Services, Design and Implementation A SQL Server 2008 Technical Case Study” from the Microsoft Download Center

 - Ask a question in the SQL Server Forums

 - Send Feedback on the white paper