DSI Developed Course:
SQL Server Integration Services (SSIS)
This course is intended for a broad audience ranging from strong business users through to IT professionals
No specific prerequisite
Students require a computer with access to the internet
This course introduces participants to SQL Server Analysis Services tabular data models. Participants learn how to create and deploy the models with particular emphasis on DAX (Data Analysis Expressions).
The course is delivered by an instructor that is making use of PowerPoint slides and interactive demonstrations. The learning is reinforced by providing hands-on workshops where the participants have the opportunity to practice the techniques being taught. Access to a computer with connectivity to the internet is mandatory to access the training portal.
Topics covered include:
- BI Semantic Models
- What Is an Analysis Services Tabular Data Model
- Options for Creating an Analysis Services Tabular Data Model Project
- DirectQuery Mode
- Deployment Options
- Time Intelligence
Copyright © 2017 Dimensional Strategies Inc. All rights reserved.