Intoduction to sql 2012 Tabular Modeling

Intoduction to sql 2012 Tabular Modeling

• 1.
  Introduction to SQL2012 Tabular Modeling By Karan Gulati (SSAS Maestro)
• 2.
  Support Escalation Engineerin Microsoft for last 6 years Currently focusing more on SQL BI, SQL PDW & Big Data. Active blogger; contributed to multiple whitepapers which are published on MSDN or TechNet site Wrote tools available on CodePlex - ASTrace, Trace Scheduler, etc. Achieved highest certification in SQL BI World SQL Server Analysis Services Maestro (MCM)  About the Speaker @karangspeaks http://karanspeaks.com http://blogs.msdn.com/karang http://twitter.com/karangspeaks http://in.linkedin.com/in/karanspeaks
• 3.
  Agenda New modeling optionin SQL 2012 Analysis Services – Tabular Server • BISM Vision • Table-like modeling • Finding Remote of James Bond Car • ABCD – Anybody Can Dance 
• 4.
  END USER TOOLSAND PERFORMANCE MANAGEMENT APPS Excel PerformancePoi nt BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services/SQL PDW SQL Server DBMS & Master Data Services (MDS) SQL Server Integration Services SharePoint Server DELIVERY Reports Dashboards Excel Services & Workbook Analytic Views Scorecards MS Business Intelligence Stack PowerPivot Power View
• 5.
  Third-party applications Reporting Services Excel Databases FilesCloud Services BI Semantic Model Third party Applications Reporting Services Excel PowerPivot Sharepoint Insights Database Line of Business applications Files OdataFeeds Cloud Services
• 6.
  OneModel The BI SemanticModel is one model for all end-user experiences – reporting, analytics, scorecards, dashboards, and custom applications RelationalDataModel Embracing the relational data model and bringing it together with the multidimensional model under a single unified BI platform Why BI Semantic Model?
• 7.
  Three Ways toModel PersonaI BI Power Pivot for excel Team BI Power Pivot for Sharepoint Organizational BI Analysis Services Tabular or MOLAP
• 8.
  What’s the TabularHype All About? • In-memory database or xVelocity  Based on the relational methodology  Column-oriented database  Data is stored in a compressed format
• 9.
  Tabular Principle #1 Speed.Let user make changes without forcing reload.
• 10.
  Tabular Principle #2 Sowhat does that mean?
• 11.
  Developing a Model Usethe Visual Studio SQL Server Data Tools to build a BISM Open an existing PowerPivot Model using SSDT or Management Studio Deployment • Immediate changes implementation • at the SDDT • Use small DB for development
• 12.
  Tabular Principle #3 Anybodycan develop a model
• 13.
  • What arethe modeling options in SQL 2012 SSAS? • What is the new query language for tabular models? • What tools can you use for modeling? • What is xVelocity? • What tools can you use for reporting on tabular models? Trivia Questions
• 14.
  Summary If you arenew to Analysis Services – go with Tabular Model Table-like modeling is easy to learn New Excel-like language called DAX
• 15.
  http://karanspeaks.com http://blogs.msdn.com/karang http://twitter.com/karangspeaks (@karangspeaks) http://in.linkedin.com/in/karanspeaks