SSAS 2014, Part 01 of 10: Basics and Tools

In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data warehousing and decision support system solutions.

Lesson 1:

• Good Requirements Gathering
• Questions You Might Hear
• Requirements Documentation
• Attribute/Measure Matrix.

Lesson 2:

• Why Use a Data Warehouse?
• Dimensional Modeling
• Needed Entities
• Dimensional Model
• Demo: Build Dimensional Model
• Demo: Dimensional Model Setup.

Lesson 3:

• Dimensions
• Understanding Dim. Modeling
• Product Dimension
• Sales Territory Dimension
• Understanding Fact Tables
• Understanding Dim. Modeling
• 3 Possible Fact Tables
• Demo: Dimensional Model
• Demo: Add Columns.

Lesson 4:

• Understanding SSDT Interface
• Develop Multidimensional Cube
• Demo: SQL Server Data Tools
• Demo: New Cube
• Demo: New Cube and Database
• Demo: Manual Dimension Creation
• Demo: Generate Schema
• Maintaining Data.

Lesson 5:

• Microsoft BI Stack
• Analysis Services 2014
• Why Use Analysis Services
• Build a SSAS Database
• Model Definitions
• UDM & BISM
• Fact & Dimensions Tables
• Star Schema
• Snowflake Schema
• Product Dimension
• MSBI Future
• Deploy and View a Cube
• Deploy a Cube with SSDT
• Sample Databases
• Viewing Cube in Excel.

Lesson 6:

• Demo: SQL Server Data Tools
• Demo: Data Source Viewer
• Demo: Analyze in Excel.