1 / 18

Introduction to SQL Server Analysis Services

Introduction to SQL Server Analysis Services. Devin Knight (@ knight_devin ) www.devinknightsql.com dknight@pragmaticworks.com. About Me. BI Consultant and Trainer with Pragmatic Works Author of 4 SQL Server books MCP, MCITP Certified

shel
Download Presentation

Introduction to SQL Server Analysis Services

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. Introduction to SQL Server Analysis Services Devin Knight (@knight_devin) www.devinknightsql.com dknight@pragmaticworks.com

  2. About Me BI Consultant and Trainer with Pragmatic Works Author of 4 SQL Server books MCP, MCITP Certified Has spoke at past events like PASS, Code Camps, User Groups and SQL Saturdays

  3. Agenda Understand the different flavors of SSAS Developing for Multidimensional Developing for Tabular Deciding which Analysis Services is for you

  4. Favors of Analysis Services

  5. PowerPivot Development • Self service BI • Cube without a data warehouse • Mashing of loosely related data

  6. Demo • Create a basic PowerPivot workbook

  7. Tabular Development • xVelocity Engine • Similar to PowerPivot but for a Server • Can Create New or Import from PowerPivot

  8. Demo • Import a PowerPivot workbook into Tabular

  9. Multidimensional Development • OLAP Storage Engine • Dimensional Model • Measure Groups • Dimensions

  10. Demo • Date Source • Data Source View • Cube Design

  11. Dimension Design Country Country State Marital City Gender Gender State Customer Customer Customer City Age Gender Marital Customer State Gender Customer City Country Marital Attributes Hierarchies

  12. Attribute Relationships • Storage • Speed • Security • Member Properties

  13. Demo Hierarchies Attribute Relationships Keys

  14. Which Analysis Services is for you?

  15. Multidimensional vs Tabular BISM Multidimensional • OLAP (Online Analytical Processing) • Data Compression X3 • Best with Dimensional Model • Query Language – MDX BISM Tabular • xVelocity Engine • Data Compression X10 • Any Data Sources • Query Language – DAX

  16. Things to Consider • Scalability • Presentation Options • Security • Model Compatibility • Data Source Flexibility • Ease of Query Language • Time to Develop

  17. Decision Matrix

More Related