Building a Cube in Analysis Services Step by Step （建立一个多维数据集的分析服务一步一步）.pdf

Building a Cube in Analysis Services Step by Step and Best Practices Rhode Island Business Intelligence Group November 15, 2012 Sunil Kadimdiwan In foTr ov e Business Intelligence Agenda  Data Warehousing  Introduction  Star/Snowflake Schemas  SQL Server Analysis Services ◦Overview ◦Components  Questions? Sunil Kadimdiwan: InfoTrove Inc.  Working with SQL Server since 1993  Focusing on Business Intelligence solutions ◦ PowerPivot Power View, Analysis Services, Reporting Services, Integration Services and SQL Server  Frequent speaker: User Groups Code Camps  sunilk AT infotrove DOT com or 508-532- 1180  Find me in LinkedIn: Sunil Kadimdiwan What does a cube mean?  Excel Demo  CrossTab report ◦a sophisticated one perhaps! A simple example Order Date Product City Qty Unit Price Total Sales 10/22/09 Lock Washer Seattle 200 $3.00 $600.00 4 01/14/10 Touring Rim Boston 5 $4000 $20000 Order Date = Date, Month/Week, Quarter,Year Product = Product, Subcategory, Category City = City, County, State, Region, Country, Territory Metrics/Measures = Qty, Unit Price, Sales Total Another example  A line item on a bill received from a doctor  What are the dimensions to derive? ◦ Date (of treatment) ◦ Doctor (maybe called provider) ◦ Patient ◦ Procedure ◦ Primary Diagnosis ◦ Location (doctors office/hospital) ◦ Billing Organization (an organization the doctor belongs to) ◦ Responsible Party (patient or patients legal guardian) ◦ Primary Payer (often an insurance plan) ◦ Secondary Payer (partys spouses insurance plan) ◦ Etc. Business Int