SQL SERVER ANALYSIS SERVICES TRAINING COURSES TAMWORTH
About Enable Technology Tamworth SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. We can also deliver the SQL Server Analysis Services course at a local training venue in Tamworth. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Countrywide Homes Limited, Dollond & Aitchison Limited, Keele University, National Power PLC, Total Telecommunications Limited, TalkTalk Direct Limited, Lloyds TSB Bank PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tamworth
- 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 ... Backup Options Restore Options
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Define Named Calculations in a Data Source View
Create Measures and Measure Groups
Change a Partition Source
KPIs Actions
Create Remote Partitions
Create User-Defined Hierarchies
Use Aggregate Functions
Data Source Views
Processing Options and Settings
Configure Analysis Services Project Properties
Modify or Delete an Analysis Services Database
Ragged Hierarchies
Define a Referenced Relationship and Referenced Relationship Properties
Edit or Delete Partitions Merge Partitions
Create Local Partitions
Replace a Table or a Named Query in a Data Source View
Define Logical Relationships in a Data Source View
Set Impersonation Options for a Data Source Connection
Create a Data Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tamworth
- 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...
Row filter mappings
Filter Data in a Table Relationships
Impersonation
Process Database, Table, or Partition
Bi-directional cross filters Calculations
Enable DirectQuery mode in SSDT
Data types supported
Analyze a tabular model in Excel Deploy tabular model solutions
Change table, column
Create and Manage Hierarchies Partitions
Define partitions in DirectQuery models
Manage Roles by using SSMS
Create and Manage Partitions in the Workspace
Create and Manage Measures KPIs
Test a model in DirectQuery mode
Version comparison
Create and Manage Perspectives Translations Roles
Import from Analysis Services
Email us about this courses
Other Tamworth Enable Technology Training Courses
JQuery Mobile - Tamworth JavaScript Training Courses
Access VBA - Tamworth Access Training Courses
Excel 365 Basic - Tamworth Excel Training Courses
VBA - Tamworth Excel Training Courses
PL/SQL - Tamworth SQL Training Courses
Data Warehouse Tamworth Training Courses