Applied BI Semantic Model (Tabular and Multidimensional)

Applied BI Semantic Model (Tabular and Multidimensional)

The Microsoft BI Semantic Model (BISM) is an umbrella name for the two Analysis Services implementation paths: Multidimensional and Tabular. Multidimensional excels in maturity and scalability. Tabular delivers flexibility, rapid development, and a continuum from self-service BI.

Targeting BI developers, this intensive 5-day onsite class is designed to help you become proficient with Analysis Services and acquire the necessary skills to implement Tabular and Multidimensional semantic models. Use the opportunity to ask questions and study best practices that will help you achieve a single version of the truth by implementing scalable and secure organizational models. Bring your organizational BI to the next level by learning these two powerful BI technologies in one class!

Attend this class and get a free paper copy of the book Applied Microsoft SQL Server 2012 Analysis Services (Tabular Modeling)! This book is designed as an easy-to-follow guide where each chapter builds upon the previous to implement self-service models with Power Pivot and organizational Tabular models.

Audience

  • Business Intelligence developers
  • Database administrators (DBA)

Prerequisites

  • Experience with designing database schemas
  • Experience with Microsoft SQL Server, including authoring T-SQL queries
  • Experience with Visual Studio IDE is preferable

Hardware and software requirements

  • A machine sufficient to comfortably run SQL Server
  • SQL Server installed and functional
  • AdventureWorksDW database installed
  • Adventure Works Multidimensional and Tabular models deployed
  • Microsoft Excel 2007 or above for selected lab practices