introduction to sql server analysis services
DESCRIPTION
Introduction to SQL Server Analysis Services. Devin Knight (@ knight_devin ) www.devinknightsql.com [email protected]. About Me. BI Consultant and Trainer with Pragmatic Works Author of 4 SQL Server books MCP, MCITP Certified - PowerPoint PPT PresentationTRANSCRIPT
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Introduction to SQL Server Analysis Services
Devin Knight (@knight_devin)
www.devinknightsql.com
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
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
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Agenda
Understand the different flavors of SSAS
Developing for Multidimensional
Developing for Tabular
Deciding which Analysis Services is for you
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Favors of Analysis Services
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
PowerPivot Development
• Self service BI
• Cube without a data warehouse
• Mashing of loosely related data
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Demo
• Create a basic PowerPivot workbook
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Tabular Development
• xVelocity Engine
• Similar to PowerPivot but for a Server
• Can Create New or Import from PowerPivot
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Demo
• Import a PowerPivot workbook into Tabular
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Multidimensional Development• OLAP Storage Engine
• Dimensional Model
• Measure Groups
• Dimensions
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Demo
• Date Source
• Data Source View
• Cube Design
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Dimension Design
Customer
City
State
Country
Gender Marital
Country
State
City
Customer
Gender
Customer
Marital
Gender
Customer
Customer
City
State
Country
Gender
Marital
Attributes Hierarchies
Age
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Attribute Relationships
• Storage
• Speed
• Security
• Member Properties
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Demo
Hierarchies
Attribute Relationships
Keys
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Which Analysis Services is for you?
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
BISM Multidimensional
• OLAP (Online Analytical Processing)
• Data Compression X3
• Best with Dimensional Model
• Query Language – MDX
Multidimensional vs Tabular
BISM Tabular
• xVelocity Engine
• Data Compression X10
• Any Data Sources
• Query Language – DAX
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Things to Consider• Scalability• Presentation Options• Security• Model Compatibility• Data Source Flexibility• Ease of Query Language• Time to Develop
16
MAKING BUSINESS INTELLIGENT www.pragmaticworks.com
Decision Matrix
ServicesSpeed development through training, and rapid development services from Pragmatic Works.
ProductsBI products to convert to a Microsoft BI platform and simplify development on the platform.
FoundationHelping those who do not have the means to get into information technology and to achieve their dreams.
Sales : [email protected] Email: [email protected] Twitter: @knight_devin