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. ...