SQL SERVER ANALYSIS SERVICES TRAINING COURSES MAESTEG
About Enable Technology Maesteg SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local socially distanced training site in Maesteg. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Royal & Sun Alliance Group PLC, Halfords Group PLC, Capita Group PLC, National Power PLC, Nationwide Building Society Limited, Birmingham Heartlands Hospital, Wolverhampton City Council and Birmingham City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Maesteg
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) . The course is aimed at Data Analysts and SQL professionals. No prior knowledge of SSAS is assumed.
- Some of the training topics covered include ... Hide or freeze columns
- See Training Course Details...
Impersonation
Define partitions in DirectQuery models
Version comparison
Create and Manage Measures KPIs
Understanding DAX in Tabular Models Measures
Process Database, Table, or Partition
Enable DirectQuery mode in SSDT
Enable DirectQuery mode in SSMS
Delete Relationships
Create and Manage Tabular Model Partitions
Row filter mappings
Create a New Tabular Model Project
Create a Calculated Table
Import from Power Pivot
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage Roles
Object-level security
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power View
Create and Manage Perspectives Translations Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Maesteg
- Telephone on 01952 938014
- Course Outline
-
This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.
- Some of the training topics covered include ... Define a Fact Relationship and Fact Relationship Properties
- See Training Course Details...
Deploy Model Solutions with the Deployment Utility
Read Definition permissions
Ragged Hierarchies
Create a Dimension by Using an Existing Table
Dimension permissions
Deployment Requirements and Considerations for Analysis Services Deployment
Add or Remove Tables or Views in a Data Source View
Define a Data Source View
Test an Action
Create Calculated Members
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Create Named Sets
Create Remote Partitions
Create User-Defined Hierarchies
Add a Standard Action
Create a Time Dimension by Generating a Time Table
Define Named Queries in a Data Source View
Move an Analysis Services Database
Processing Options and Settings
Email us about this courses
Other Maesteg Enable Technology Training Courses
SSRS - Maesteg SQL Server Reporting Services Training Courses
Power BI - Maesteg Microsoft Power BI Training Courses
Data Warehouse - Maesteg SQL Training Courses
Power Query Maesteg Training Courses
Report Builder Maesteg Training Courses
PL/SQL - Maesteg SQL Training Courses