Business Intelligence with Analysis Services

For the last few days I’ve been toying around with Microsoft Analysis Services. Most people think that SQL Server is a relational database. It’s much more than that with a uber-performance, proper non-relational model out of the box… “By using SQL Server 2012 Analysis Services to create cubes, every day our MOLAP model can load 350 million rows of new Hive data, analyze 35 billion rows of information, and achieve an average query response time of less than 10 seconds.” — Dave Mariani, VP of Engineering, Klout