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

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.
;