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
Summary:
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.
- Download “Analysis 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