BIO and In-Memory Analytics

Post date:
Post views: 2,594

“In-memory data stores will be the biggest trend to revolutionize the business intelligence (BI) industry this year.” Dr. Barry Devlin, ITWeb Business Intelligence 2013 Summit, February 2013

In-memory analytics is being touted as one of the year’s biggest BI developments by no less than CIO, Information Week, TDWI, and Gartner. In-memory solutions provide fast access to data and easier programming, making them less expensive to use in terms of time, resources, and skills required.

BIO business intelligence software for Microsoft Dynamics gives you the option of taking advantage of in-memory analytics using the Microsoft SQL 2012 Tabular Data Model. Here are some other benefits of using Tabular:

  • Using Tabular allows you to use of Microsoft Power View, Microsoft’s leading edge tool for
    visualizing data.
  • Tabular provides extreme speed and consistently fast query time.
  • It allows you to use existing relational databases without re-modeling.
  • It enables you to extend the solution without reprocessing the entire database.

However, Tabular does not supersede multidimensional and the two formats are not interchangeable. So there are instances when you will still want to use multidimensional data cubes with Microsoft Dynamics data. If your solution uses very large databases, multidimensional may be the way to go. Also, if you need writeback support, complex calculations, many-to-many relationships, or complex modeling, you may choose to employ multidimensional cubes.

So the best solution is going to allow for both options—Tabular and multidimensional. BIO business intelligence for Microsoft Dynamics delivers Tabular as well as multidimensional so you can choose which option will work best for you.

Join BIO for a free business intelligence webinar to get to see how BIO business intelligence software can help you meet your business intelligence and reporting needs. And please contact me at 203.705.4648 or by email at if you have any questions about BIO or business intelligence in general.

By Sandi Richards Forman of BIO Analytics Corp., Microsoft Dynamics Business Intelligence (BI) Solution Provider

Leave a Reply