1 / 16

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. Working as Support Escalation Engineer in Microsoft for last 6 years

val
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. 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) 

  3. 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 

  4. 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

  5. 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

  6. 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

  7. 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

  8. XVelocity Design Principle Velocity (Speed) including update changes without forcing reload

  9. Tabular Usage principle Simplicity……. Lets figure out……..

  10. Developing a Model

  11. 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.

  12. Is it ABCD right? Anybody Can Develop….a Model

  13. Summary If you are new to Analysis Services – go with Tabular Model Table like Modeling Very easy to learn Excel like language called DAX

  14. Q & A

  15. 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”

  16. Thank you  for suggestions, please email at admin@SQLServerGeeks.com

More Related