Unlocking the Power of SQL 2012 BI Semantic Model
Discover the innovative features of SQL 2012 Analysis Services Tabular Server, including BI Semantic Modeling, relational data models, and deployment modes. Dive deep into the world of business intelligence with insights from a seasoned expert.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
SQL 2012 Tabular for DBAs By Karan Gulati (SQL BI MCM) http://karanspeaks.com http://blogs.msdn.com/karang http://twitter.com/karangspeaks http://in.linkedin.com/in/karanspeaks Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
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) Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
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 Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
MS Business Intelligence Stack DELIVERY CONTENT MANAGEMENT COLLABORATION SEARCH SharePoint Server Excel Services & Workbook Analytic Views Reports Dashboards Scorecards END USER TOOLS AND PERFORMANCE MANAGEMENT APPS PerformancePoint Excel Power View PowerPivot BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services/SQL PDW SQL Server DBMS & Master Data Services (MDS) SQL Server Integration Services Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
What is BI Semantic Model ? One Model The BI Semantic Model is one model for all end reporting, analytics, scorecards, dashboards, and custom applications user experiences Relational Data Model Embracing the relational data model and bringing it together with the multidimensional model under a single unified BI platform Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
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 Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Whats hype about Tabular In-memory database or xVelocity Based on the relational methodology Column oriented database Data is stored in a compressed format Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
XVelocity Design Principle Velocity (Speed) including update changes without forcing reload Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Tabular Usage principle Simplicity . Lets figure out .. Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Developing a Model Deployment Immediate changes implementation at the SDDT Use small DB for development Open an existing PowerPivot Model using SSDT or Management Studio Use the Visual Studio SQL Server Data Tools to build a BISM Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
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. Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Is it ABCD right? ANYBODY CAN DEVELOP .A MODEL Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Summary If you are new to Analysis Services go with Tabular Model Table like Modeling Very easy to learn Excel like language called DAX Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Q & A Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
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 & larger and we need your support Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
Thank you for suggestions, please email at admin@SQLServerGeeks.com Twitter: @SQLServerGeeks www.FaceBook.com/SQLServerGeeks
