slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
BI Semantic Model PowerPoint Presentation
Download Presentation
BI Semantic Model

play fullscreen
1 / 27
Download Presentation

BI Semantic Model - PowerPoint PPT Presentation

howard
198 Views
Download Presentation

BI Semantic Model

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. BI Semantic Model Presented by: Jose Chinchilla, MCTS, MCITP SQL Server “Denali” Business Intelligence Semantic Model

  2. Agenda • SQL Server Denali BI Semantic Model CTP3: • Overview& Demo • Self-service Reporting and Analytics • BI Semantic Model • PowerPivot • Crescent SQL Server “Denali” Business Intelligence Semantic Model

  3. Jose Chinchilla MCITP: Database Administrator, SQL Server 2008 MCITP: Business Intelligence SQL Server 2008 MCTS: SQL Server 2005 & 2008 Current Positions: Sr. Business Intelligence Consultant & Data Architect, Pragmatic Works President, Tampa Bay Business Intelligence User Group & PASS Official Chapter “DBA by accident, BI Developer by chance, Geek by Choice” Blog: http://www.sqljoe.com http://www.bidn.com Twitter: http://www.twitter.com/sqljoe Linked-in: http://www.linkedin.com/in/josechinchilla Email: jchinchilla@pragmaticworks.com jchinchilla@sqljoe.com BI Savvy NOT BI Curious SQL Server “Denali” Business Intelligence Semantic Model

  4. Upcoming Events • SQL Saturday #86 BI Edition Tampa, FL (November 5th)http://www.sqlsaturday.com/86/eventhome.aspx • Pre-con: BI BootCamp – Tampa, FL (November 4th)http://sqlsat86precon.eventbrite.com • 24 hours of PASS Live! (September 7 & 8) • http://www.sqlpass.org/24hours/fall2011/SessionsbySchedule.aspx • SQL Summit 2011 (October 11-13) • http://www.sqlpass.org/summit/2011/ • SQL PASS BI Virtual Chapter • http://bi.sqlpass.org/ • Pragmatic Works free webinars • http://pragmaticworks.com/Resources/webinars/Default.aspx $99 thru Sep-30th

  5. SQL Server Denali BI Semantic Model SQL Server “Denali” Business Intelligence Semantic Model

  6. Enterprise OLAP Background • Analysis Services (UDM) • I need a promotion • Fast • I need vacation! • MDX! • Secure • Scalable • I.T. Takes too long • Dimensional • Lingo Learning Curve • I need • data! Performance SQL Server “Denali” Business Intelligence Semantic Model

  7. I.T. vs. Business Great. Now I have to open a ticket so that he can fix the report he just broke! Can’t she understand she needs to open a ticket! SQL Server “Denali” Business Intelligence Semantic Model

  8. The Business Intelligence Continuum Empowered Aligned Organizational BI Team BI Personal BI Our Context BI Solution created by power user. Context is for a small team & it’s managed on a server. My Context BI solution created by user. Context is only for user & exists as document. The Org’s Context BI Solution created by IT, Established corporate context & is reusable, scalable and backed up. PowerPivot for Excel Report BuilderCrescent PowerPivot for SharePoint BI Development Studio SQL Server “Denali” Business Intelligence Semantic Model

  9. SQL Server Denali BI Semantic Model BISM 3-Layer Model Data Model Business Logic Data Access • Relational model with BI artifacts such as hierarchies and KPIs • Unifies SMDL (report models) + BI semantics from SSAS/UDM (OLAP models) • Does not replace the Unified Dimensional Model (SSAS/UDM) SQL Server “Denali” Business Intelligence Semantic Model

  10. SQL Server Denali BI Semantic Model Your Choice The “Magic” Your Data SQL Server “Denali” Business Intelligence Semantic Model

  11. SQL Server Denali BI Semantic Model vs. UDM SQL Server “Denali” Business Intelligence Semantic Model

  12. SQL Server “Denali” Business Intelligence Semantic Model

  13. SQL Server “Denali” Business Intelligence Semantic Model

  14. SQL Server Denali PowerPivot for Excel Two flavors: • Free add-in for Excel 2010 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e081c894-e4ab-42df-8c87-4b99c1f3c49b&displaylang=en • SQL Server PowerPivot for SharePoint • Integrate data from a multitude of sources • Support extremely large datasets • Integrate data from a multitude of sources • Unmatched computational power • Efficient data compression • Powerful data manipulations & calculations with DAX language SQL Server “Denali” Business Intelligence Semantic Model

  15. SQL Server Denali Analysis Services Three flavors: • UDM – (Legacy) • SQL Server PowerPivot for SharePoint • Tabular Wait! I saw this one before SQL Server “Denali” Business Intelligence Semantic Model

  16. SQL Server Denali Analysis Services Modes Verify the Server Mode (Analysis Services) http://msdn.microsoft.com/en-us/library/gg471594(v=SQL.110).aspx Mode 0 Mode 2 Mode 1 SQL Server “Denali” Business Intelligence Semantic Model

  17. Demo:PowerPivot for Excel& SQL Server Denali BI Semantic Model SQL Server “Denali” Business Intelligence Semantic Model

  18. Demo: PowerPivotfor Excel • Importing data from multiple sources • Creating relationships • Analyzing data with Pivot tables • Slicing data with Slicers • Visualizing data with Pivot Charts SQL Server “Denali” Business Intelligence Semantic Model

  19. Demo: SQL Server Denali BI Semantic Model • Designing a Business Intelligence Semantic Model with Visual Studio 2010 • Adding Data from relational sources (Access) • Adding Calculated Columns • Creating and Managing Measures • Adding Data from non-relational sources (Excel) • Creating and Managing Relationships • Deploying Business Intelligence Semantic Models • Creating a Business Intelligence Semantic Model from existing SSAS Database or Excel PowerPivot file.

  20. SQL Server Denali Codename "Crescent" SQL Server “Denali” Business Intelligence Semantic Model

  21. Introducing SQL Server Denali Codename "Crescent" Crescent is an interactive data exploration and visual presentation experience for authoring and viewing reports. SQL Server “Denali” Business Intelligence Semantic Model

  22. Introducing SQL Server Denali Codename "Crescent" Rich metadata-driven interactive visualizations Highly visual design experience Presentation and collaboration ready • Interactive PowerPoint presentations • Deliver and collaborate through SharePoint • Turn data into persuasive information • Fully integrated with PowerPivot • Animated trending and comparisons • Drive greater insight through smart and powerful reporting • Interactive web-based authoring • Familiar MS Office design patterns • Powerful data layout with banding SQL Server “Denali” Business Intelligence Semantic Model

  23. Introducing SQL Server Denali Codename "Crescent" SQL Server “Denali” Business Intelligence Semantic Model

  24. Demo: A First Look at SQL Server Denali Codename "Crescent" SQL Server “Denali” Business Intelligence Semantic Model

  25. Project “Crescent”Demo: A First Look at SQL Server Denali Codename "Crescent" • Designing Crescent Reports from BISM models • Displaying data using Tables & Charts • Filtering with slicers • Interactive filtering & contribution with Charts • Timeline replay SQL Server “Denali” Business Intelligence Semantic Model

  26. Thank you for attending! Blog: http://www.sqljoe.com Twitter: http://www.twitter.com/sqljoe Linked-in: http://www.linkedin.com/in/josechinchilla Email: jchinchilla@sqljoe.com jchinchilla@pragmaticworks.com Rate my presentationhttp://www.speakerrate.com/speakers/8064-jchinchilla Q&A SQL Server “Denali” Business Intelligence Semantic Model