O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Let's Get Analytical!

Seeing that the reports developed by John Kirkland are greatly helping the company understand its performance, the management decided to explore the use of SQL Server Analysis Services (SSAS). The company has accumulated huge amount of data from various sources, and SSAS is the perfect tool to implement the company's analytics initiative.

The company's senior BI Developer designed an Online Analytical Processing (OLAP) database and it is ready for deployment on the Analysis Services server.

John was tasked to develop reports based on the cubes in the OLAP.

There is a big advantage in using an analytic engine in handling Big Data. The SQL Server database engine is of great use in storing and retrieving relational data. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required