Business Intelligence, the process of analyzing business data to support better decision making, has become a necessity for most businesses in today’s competitive environment. In order to bring BI to small and mid-sized companies, there needs to be a set of affordable easy to use tools at their disposal. Microsoft has long had a vision and commitment to bringing the power of BI to the masses, and creating a set of tools and technologies to allow for self-service BI.
One of the major hurdles of bringing BI to the masses is the complexity of developing data warehouse models using the OLAP processing engine in SQL Server Analysis Services (SSAS). Add to this the complexity of querying the data with MDX and you have a challenging road block for most small to medium sized organizations. In order to help overcome these hurdles,
Microsoft has introduced the Business Intelligence Semantic Model (BISM). BISM supports two models, the traditional multidimensional model and a new tabular model. The tabular model is based on a relational table model which is familiar to DBA’s, developers, and power users. In addition, Microsoft has created a new query language to query the BISM Tabular model. This language, Data Analysis Expression Language (DAX), is similar to the syntax used in Excel calculations and should be familiar to the Excel power users.
The goal of this white paper is to expose you to the process needed to create a BISM Tabular Model in SQL Server 2012 and deploy it to an Analysis Server where it can be exposed to client applications. This is not an in depth discussion of the process but rather an overview of the methods involved.
See attachment for full whitepaper.