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 information on Advanced DAX, Time Intelligent KPI, Advanced Degenerate Dimensions and Performance Security.
Lesson 1:
- Using DAX for Measures
- Measures
- Context
- Where Can It Be Used
- Demo: Advanced DAX.
Lesson 2:
- Calculate & Time Intelligence
- Calculate
- Ratios
- Ratios - Excel
- Demo: Calculation
- Demo: Calculation Cont.
- Time Intelligence
- Requirement
- Time Intelligence - To Date
- Time Intelligence - Previous
- Demo: Time Intelligence
- KPI
- Demo: KPI.
Lesson 3:
- Degenerate Dimension
- Demo: Degenerate Dimension
- Role Playing
- New Dimension
- Demo: Role Playing.
Lesson 4:
- Perspectives
- Demo: Perspectives
- Security - Roles
- Roles
- Row Level
- Demo: Roles.