SQL Server Analysis Services (SSAS)

The training content has been developed by Ensight Academy.

All content related to Microsoft SQL Server Analysis Services (SSAS) has been comprehensively prepared by considering Microsoft documentation, best practice approaches, and real project experience.

Introduction and Core Concepts
• What is SSAS?
• SSAS Architecture and Components
• Tabular vs Multidimensional Model
• VertiPaq Engine Overview
• Visual Studio Installation and Analysis Services Configuration

Tabular Modeling Fundamentals
• Cube and Semantic Model Concepts
• Table Types (Fact, Dimension) and Data Model Types (Star, Snowflake)
• Measures, Calculated Columns, and Hierarchies

SSAS Interface Features
• Creating New Projects and Working with Existing Projects
• Solution Explorer: Project Structure and Files
• Tabular Model Explorer: Managing Tables, Measures, Columns, and Relationships
• Properties Panel: Editing Object Properties
• Diagram View and Data View: Visual Modeling and Data Row View
• Output and Error Windows: Monitoring Errors and Warnings

Connecting to Data Sources
• Data Processing Operations
• Importing Data from SQL Server
• Importing Data from External Sources (Excel, CSV, SharePoint)
• Creating Partitions When Working with Large Data Sets

Data Cleansing and Transformation
• Using the Power Query (M) Editor and Data Cleansing Steps
• Applying Query Folding to Minimize Queries Sent to the Source

Data Types and Proper Configuration
• Understanding Data Types
• Editing and Managing Data Types
• Working with Decimal and Percentage Values
• Working with Date and Time (Datetime) Types
• Other Data Types (String, Boolean, Binary)

Relationships in Tabular Models
• Relationship Concepts
• Primary Key and Foreign Key Concepts
• Relationship Types (One-to-One, One-to-Many, Many-to-Many)
• Managing Relationships in SSAS

Improving Tabular Model Usability
• Organizing Measures Using Calculation Groups
• Working with Display Folders
• Enhancing User Experience with Hierarchies
• Creating Translations
• Creating Perspectives
• Column Sorting Options

Tabular Row-Level Security (RLS)
• What is RLS and Why It Is Used
• Implementing Static RLS and Creating Roles
• Implementing Dynamic RLS (User-Based Filter Context)

Connecting to Tabular Models
• Connecting to the Model with Excel, Power BI, and Report Server (SSRS)
• Live Connection Capabilities with Power BI

Notes (SSAS Training Program)

The training content is regularly updated in line with Microsoft’s latest releases.
For maximum training efficiency, groups of 10–12 participants are recommended.
Technical instruction and hands-on practical exercises will be conducted throughout the training.
The training will be supported with sample datasets, and active participation is expected from all attendees.
By the end of the training, participants are expected to be able to build end-to-end tabular models and use SSAS professionally.
Participants who score 70 or above in the final evaluation exam will receive a certificate of achievement issued by Microsoft Solutions Partner EnSight Bilgi Teknolojileri.

Why Ensight Academy?

Powerful Content

All our training programs are developed using the knowledge and experience Ensight has gained from real customer projects.

Expert Instructor Staff

An opportunity to learn from Microsoft Certified experts.

Applied & Practical Training

In addition to theory, you’ll improve your manual skills through real-world use scenarios.

Online Education Options

Learn with our flexible structure and online learning opportunities.

Physical Education Options

Learn through our flexible structure and in-person learning opportunities.

Certificate-Career

We offer our participants certifications and career guidance that will make a difference in the industry.

Personal Training, Corporate Training

Training Information Request Form

Our training solutions enhance your team’s competencies, provide new skills, and offer a business-oriented learning experience with practical content and expert guidance.