SQL 2012
This presentation is the property of its rightful owner.
Sponsored Links
1 / 16

SQL 2012 – Tabular for DBA’s By Karan Gulati (SQL BI – MCM) PowerPoint PPT Presentation


  • 58 Views
  • Uploaded on
  • Presentation posted in: General

SQL 2012 – Tabular for DBA’s By Karan Gulati (SQL BI – MCM). http ://karanspeaks.com http ://blogs.msdn.com/karang http://twitter.com/karangspeaks http ://in.linkedin.com/in/karanspeaks. Speaker Details. Working as Support Escalation Engineer in Microsoft for last 6 years

Download Presentation

SQL 2012 – Tabular for DBA’s By Karan Gulati (SQL BI – MCM)

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Sql 2012 tabular for dba s by karan gulati sql bi mcm

SQL 2012 – Tabular for DBA’s

By

Karan Gulati (SQL BI – MCM)

  • http://karanspeaks.com

  • http://blogs.msdn.com/karang

  • http://twitter.com/karangspeaks

  • http://in.linkedin.com/in/karanspeaks


  • Speaker details

    Speaker Details

    Working as Support Escalation Engineer in Microsoft for last 6 years

    Currently focusing more on SQL BI and SQL PDW. I am very Active blogger and contributed to multiple whitepapers which are published on MSDN or TechNet site, also written tools ASTrace, Trace Scheduler, etc. which are available on CodePlex.

    Recently achieved highest certification in SQL BI World SQL Server Analysis Services Maestro (MCM) 


    Agenda

    Agenda

    • New Flavor of SQL 2012 Analysis Services – Tabular Server

      • BISM Vision

      • Table like Modeling - Tabular Modeling

      • Finding Remote of James Bond Car

      • ABCD – Anybody Can Dance or something else 


    Sql 2012 tabular for dba s by karan gulati sql bi mcm

    MS Business Intelligence Stack

    DELIVERY

    COLLABORATION

    CONTENT MANAGEMENT

    SharePoint Server

    SEARCH

    Reports

    Dashboards

    Excel Services

    & Workbook

    Analytic

    Views

    Scorecards

    END USER TOOLS AND PERFORMANCE MANAGEMENT APPS

    PerformancePoint

    Excel

    PowerPivot

    Power View

    BI PLATFORM

    SQL Server

    Reporting Services

    SQL Server

    Analysis Services/SQL PDW

    SQL Server DBMS & Master Data Services (MDS)

    SQL Server Integration Services


    What is bi semantic model

    What is BI Semantic Model ?

    One Model

    • The BI Semantic Model is one model for all end user experiences – reporting, analytics, scorecards, dashboards, and custom applications

      Relational Data Model

    • Embracing the relational data model and bringing it together with the multidimensional model under a single unified BI platform


    Sql 2012 ssas flavors

    Choose Server Mode or Flavors of Analysis Services

    DeploymentMode setting in msmdsrv.ini

    0 Multidimensional and Data Mining (default)

    1 PowerPivot with SharePoint

    2 Tabular

    Same code, different behavior

    Choice during setup

    SQL 2012 SSAS Flavors


    What s hype about tabular

    In-memory database or xVelocity

    Based on the relational methodology

    Column oriented database

    Data is stored in a compressed format

    What’s hype about Tabular


    X velocity design principle

    XVelocity Design Principle

    Velocity (Speed) including update changes without forcing reload


    Tabular usage principle

    Tabular Usage principle

    Simplicity…….

    Lets figure out……..


    Developing a model

    Developing a Model


    Tabular mode schema vs data source views

    Tabular Mode Schema vs. Data Source Views

    Much simpler than a Data Source View

    Building the AdventureWorks DB using Tabular Mode is about x4 times faster.


    Sql 2012 tabular for dba s by karan gulati sql bi mcm

    Is it ABCD right?

    Anybody Can Develop….a Model


    Summary

    Summary

    If you are new to Analysis Services – go with Tabular Model

    Table like Modeling

    Very easy to learn

    Excel like language called DAX


    Sql 2012 tabular for dba s by karan gulati sql bi mcm

    Q & A


    Spread the word

    Spread the word…

    • www.FaceBook.com/SQLServerGeeks

    • Be a member – www.SQLServerGeeks.com

    • @SQLServerGeeks

    • Talk about your experience

      • Post photos

      • Blog, Tweet (#SQLServerGeeks)

      • Post your experience on Forums

    • Why do all this?

      • “We want to make the community bigger & largerand we need your support”


    Sql 2012 tabular for dba s by karan gulati sql bi mcm

    Thank you 

    for suggestions, please email at [email protected]


  • Login