Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Summary


SSAS Tabular provides another analytical modeling tool that has a high performance using the xVelocity In-Memory column store engine. This tool is very easy to use rather than multidimensional. However, tabular is in its early stages in comparison with multidimensional that was released in 2000 for the first time. This tool still has room for improvement, but it is good for real-world projects; it will provide higher performance and faster development in BI projects. To be a professional with this tool, your first step is to be a professional in DAX, which is the query language for tabular modeling.

Chapter 2, SQL Server Analysis Services Multidimensional Cube Development and this chapter was about data modeling. The next chapter will explore data transformation and ETL with SSIS. Irrespective of whether you do the data modeling using SSAS Multidimensional or SSAS Tabular, you will definitely need to do ETL and data transformation from the source database to the data warehouse or...