slide1
Download
Skip this Video
Download Presentation
SQL 2012 – Tabular for DBA’s By Karan Gulati (SQL BI – MCM)

Loading in 2 Seconds...

play fullscreen
1 / 16

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


  • 112 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL 2012 – Tabular for DBA’s By Karan Gulati (SQL BI – MCM)' - val


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
slide1
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 
slide4
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……..

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.

slide12
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

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”
slide16
Thank you 

for suggestions, please email at [email protected]

ad