Downloaded 47 times
Uploaded bySlava Kokaev
Introduction BI Semantic Model with Sql Server Data Tools copy
This document provides an introduction to Business Intelligence Semantic Model (BISM) architecture. It discusses BISM as a single model for various end user experiences, including PowerPivot for Excel, PowerPivot for SharePoint, and organizational BI. It also outlines the BISM architecture, including data access and storage options like VertiPaq, MOLAP, and DirectQuery. Finally, it briefly discusses tools for tabular model development like SQL Server Data Tools and the tabular model development process.
Introduction BI Semantic Model with Sql Server Data Tools copy
- 1. Introduction To BusinessIntelligence Semantic Model (BISM)
- 2. Agenda BISM Architecture Tabular vs.Multi-dimensional Models How to build Tabular Model
- 3. About Me Slava Kokaev– Lead Business Intelligence Architect at Industrial Defender Boston Microsoft BI User Group Leader email: vkokaev@bostonbi.org web: www.bostonbi.org/blogs twitter: @SlavaKokaev
- 4. BISM One Model forall End User Experiences Team BI PowerPivot for SharePoint Personal BI PowerPivot for Excel Organizational BIAnalysis Services
- 5. BISM in Enterprise ExcelServices PowerPivot for SharePoint (Analysis Services) Excel Internet Explorer Analysis Services BI Semantic Model SharePoint Reporting Services Third Party Apps PowerPivot for Excel xlsx xlsx BI Development Studio Project Juneau
- 6. BI Semantic Model:Architecture Third-party Reporting Services Excel PowerPivot Databases LOB Files OData Feeds Cloud Services SharePoint
- 7. Data Access andStorage VertiPaq In-memory column store… typical 10x compression Brute force memory scans… high performance by default… no tuning required Basic paging support… data volume mostly limited to physical memory MOLAP Disk based store… typical 3x compression Disk scans with in-memory sub-cube caching… aggregation tuning required Extensive paging support… data volumes can scale to multiple terabytes DirectQuery Passes through DAX queries & calculations… fully exploits backend database capabilities No support for MDX queries… no support for data sources other than SQL Server (in Denali) ROLAP Passes through fact table requests… not recommended for large dimension tables Supports most relational data sources… no support for aggregations except SQL Server indexed views
- 8. Logical Cube Representation Australia UnitedStates Canada France Country Accessories Mountain Road Touring ProductLine
- 9.
- 10. SQL Server DataTools SSDTSSMS SQL Server provides three environments for the development and management of Analysis Services Models EXCEL
- 11. Tabular Model DevelopmentProcess Create Calculations and KPI Deploy Database to development server Create Measures Create Connections
- 12. OLAP Model OLEDB Oracle Provider SQLServer ProviderSource DB Source DBData Sources Data Source View Cube
- 13. Tabular Model OLEDB Oracle Provider SQLServer Provider Source DB Source DBConnections Tabular Model
Editor's Notes
- #12 SQL Server provides two environments, SQL Server Data Tools and SQL Server Management Studio, for the development and management of Integration Services packages.•SQL Server Data Tools supports the development of Integration Services packages. •SQL Server Management Studio uses the Integration Services service to supports the management of Integration Services packages in test and production environments. Both environments use the concept of projects within solutions to organize and manage the items that you use when you build business intelligence solutions.