You’ve learned about first steps for getting into BI field in previous post. In this post I’ll continue with explaining some other components of Microsoft BI and resources to learn it. Previous post was about the overall picture of BI, Data Warehouse Design, Dimensional Modelling, ETL and SSIS. In this post I’ll explore components such as SQL Server Analysis Services (SSAS) Tabular and Multi-Dimensional.
4- BISM: Business Intelligence Symantec Model
Data Warehouse designed to speed up the queries, faster data analysis, and integrated reports. However there are still some problems that cannot be easily solved with Data Warehouse. Speed is one of the issues; Data Warehouse designed to be fast, and with star-schema design it will be much faster rather than transactional databases. However database still has some constraints, it might be stored on disk, there are not enough measures for combinations of values for dimension attributes.
SQL Server Analysis Services is a service of Microsoft SQL Server which can be used for building BISM layer. Business Intelligence Symantec Model is the middle layer between data warehouse and reporting layer. BISM can be created with two different technologies; SSAS Tabular, and SSAS Multi-Dimensional.
This is the mature OLAP technology of Microsoft, and there are heaps of useful resources for it, such as books, videos, and blog posts. I would like to mention couple of books that I highly recommend for learning this technology.
I know you might say this is not on SSAS 2012, but believe me that there are not that much changes between SSAS multi-Dimensional 2008 and 2012. So I strongly recommend starting with this book which gives you an overall understanding of this technology, with many beginner’s wizards. afterwards you can read about new changes in SSAS 2012 multi-dimensional from blob posts like this one from Chris.
This is an advanced level book that I recommend highly for everyone working with SSAS multi-dimensional. There are many tips and tricks, and best practices for implementations. The book written with three professionals in this field with many years experiences: Chris Webb, Alberto Ferrari, and Marco Russo.
It is almost impossible to learn SSAS multi-dimensional without learning MDX. Multi Dimensional eXpression (MDX) is the language to query SSAS cubes, this book has many examples from beginner to advanced level.
Tabular is the new technology introduced in SQL Server 2012, this technology is an In-Memory Tabular technology based on xVelocity engine. This model is super fast compared with SSAS multi-dimensional. Fortunately there are good resources for this new technology. as an example I would like to mention this book which was one of the very first books in the market for it.
Walk-through Steps: I’m New to BI, Where to Start? – Part 0: Prerequisites
Walk-through Steps: I’m New to BI, Where to Start? – Part 1: Fundamentals, Data Warehouse and ETL
Walk-through Steps: I’m New to BI, Where to Start? – Part 2: Modelling with BISM
Walk-through Steps: I’m New to BI, Where to Start? – Part 3: Data Governance
Walk-through Steps: I’m New to BI, Where to Start? – Part 4: Data Visualization