SSAS 2014, Part 01 of 10: Basics and Tools
Interactive

SSAS 2014, Part 01 of 10: Basics and Tools

Biz Library
Updated Feb 04, 2020

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.