SQL Server 2005 Analysis Services (SSAS)
What is Microsoft BI?

• Core concept – BI is the cube or UDM
• Example cube as seen using Excel pivot table
• MS BI is comprehensive – more than Analysis Services on SQL Server
• Demonstration of SQL Reporting Services with cube as data source

• Modeling source schemas—stars and snowflakes
• Understanding dimensional modeling—Dimensions (Type 1, 2, or 3) or rapidly changing
• Understanding fact (measures) and cube modeling
• Other types of modeling—data mining etc.

• Understanding the development environment
• Creating Data Sources and Data Source Views
• Creating cubes – using the UDM and the Cube Build Wizard
• Refining Dimensions and Measures in BIDS

• KPIs
• Perspectives
• Translations – cube metadata and currency localization
• Actions – regular, drillthrough and reporting

• Using multiple fact tables
• Modeling intermediate fact tables
• Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, writeback dimensions
• Modeling changing dimensions – Dimension Intelligence w/ Wizard
• Using the Add Business Intelligence Wizards – writeback, semi-additive measures, time intelligence, account intelligence

• Storage topics – basic aggregations, MOLAP
• Advanced Storage Design – MOLAP, ROLAP, HOLAP
• Partitions – relational and Analysis Services partitions
• Customizing Aggregation Design - Processing Design
• Rapidly changing dimensions / ROLAP dimensions
• Welcome to the Real Time -- Proactive Caching
• Cube processing options

• Basic syntax
• Using the MDX query editor in SQL Server Management Studio
• Most-used Functions & Common tasks
• New MDX functions

• Adding calculated members
• Adding scripts
• Adding named sets
• .NET Assemblies

• Best practices – health monitoring
• XMLA scripting (SQL Mgmt Studio)
• Other Documentation methods
• Security – roles and permissions
• Disaster Recovery – backup / restore
• Clustering – high availability

• What and why?
• Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naive Bayes, MS Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)
• Data Mining dimensions
• Data Mining clients
• Processing mining models

• Excel 2003 and 2007 Pivot Tables
• SQL Server 2005 Reporting Services (SSRS) & Report Builder
• SPS RS web parts & .NET report viewer controls
• Business Scorecards & ProClarity

• SharePoint 2007 and AS
• Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter
• Excel Services 2007 and AS (Web Services)