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.