SQL SERVER ANALYSIS SERVICES TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
We provide instructor led training coupled with hands on training. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Stratford Upon Avon. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Capita Group PLC, Norfolk Police Constabulary, Nationwide Building Society Limited, Aston University, Homeserve PLC, Yell Group PLC, Norwich Union PLC and Unipart Group.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Create Named Sets
- See Training Course Details...
Deploy Model Solutions with the Deployment Utility
Define a Fact Relationship and Fact Relationship Properties
Test an Action
Processing Databases, Dimensions and Partitions
Use a Template to Create an Action Deployment
Define Time Intelligence
Create a Dimension Using the Dimension Wizard
Read Definition permissions
View the XML for an Analysis Services Project Data Sources
Batch Processing Remote Processing
Create User-Defined Hierarchies
Designing Aggregations
Define Semiadditive Behavior
Define a Referenced Relationship and Referenced Relationship Properties
Create a Data Source
Processing Options and Settings
Configure Measure Group Properties
Dimension permissions
Using SQL Server Data Tools (SSDT)
Define Logical Primary Keys in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Create a Relationship Between Two Tables
- See Training Course Details...
Import from Analysis Services
Analyze a tabular model in Excel Deploy tabular model solutions
Import Data
Tabular model designer
Create and Manage Tabular Model Partitions
Manage Roles by using SSMS
Impersonation
Import from Power Pivot
Specify Mark as Date Table for use with Time Intelligence
Add sample data to DirectQuery models
Enable DirectQuery mode in SSMS
Process Tabular Model Partitions
Object-level security
DAX formula compatibility in DirectQuery mode Tables and Columns
Data types supported
Change table, column
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
TSQL Stratford Upon Avon Training Courses
Excel Power Pivot Stratford Upon Avon Training Courses
SSRS - Stratford Upon Avon SQL Server Reporting Services Training Courses
Access VBA - Stratford Upon Avon Access Training Courses
Access Stratford Upon Avon Training Courses
Power Query - Stratford Upon Avon Excel Training Courses