4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

No More "Are Where There Yet?" With Tabular Model

SQL Server Analysis Services Tabular Model allows rapid and simplified data modeling of Business Intelligence solutions. However, an important aspect that is often overlooked when building a tabular model, is meeting real-time requirements. In this session you will learn how to tackle low latency (or close to real time requirements) using the different types of Data Access and Query Modes of Tabular Model and how your choice impacts your reporting options in the Microsoft BI stack.

Using live demo, this session will outline advantages and disadvantages between DirectQuery and In-Memory modes. We will also highlight impersonation and partitioning differences between the two modes. Finally, we will also cover the definition of a Hybrid Tabular Model solution 
Presented by Julie Koesmarno at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Julie Koesmarno, SQL Server MVP, MCSE Data Platform and Business Intelligence, is a SQL Server and BI consultant at LobsterPot Solutions, with a bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her recent projects include delivering a SQL Server 2012 data warehouse and BI solutions for a leading finance company in the US and Australia.
    http://www.mssqlgirl.com http://www.mssqlgirl.com/feed
  • Video
    The video is not available to view online.