SQL SERVER ANALYSIS SERVICES TRAINING COURSES ROWLEY
About Enable Technology Rowley SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the SQL Server Analysis Services course at a local training venue in Rowley. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Canadian High Commission, Capita Group PLC, Boots UK Limited, Total Telecommunications Limited, Fujistu PLC, Lloyds TSB Bank PLC, Barclays Bank PLC and National Power PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rowley
- 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 ... Delete a Data Source
- See Training Course Details...
Create User-Defined Hierarchies
Authorizing access to objects and operations
Read Definition permissions
Create an Analysis Services Project
Database permissions
Error Configuration Roles and Permissions
Test an Action
View the XML for an Analysis Services Project Data Sources
Set Impersonation Options for a Data Source Connection
Edit or Delete Partitions Merge Partitions
Add a Standard Action
Overview of SSAS Multidimensional Modelling
Create Remote Partitions
Define Time Intelligence
Processing Databases, Dimensions and Partitions
Deploy Model Solutions Using XMLA
Add or Remove Tables or Views in a Data Source View
Replace a Table or a Named Query in a Data Source View
Defined Linked Measure Groups Partitions
Backup and Restore of Analysis Services Databases
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rowley
- 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 ... Import Data
- See Training Course Details...
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Version comparison
Create and Manage KPIs Hierarchies
Create a Calculated Table
Create a New Tabular Model Project
Analyze in Excel
Hide or freeze columns
Create and Manage Perspectives Translations Roles
Import from Analysis Services
Data sources supported in tabular 1200 models
Rename a Table or Column
Delete a Column
Analyze a tabular model in Excel Deploy tabular model solutions
Process Tabular Model Partitions
Enable DirectQuery mode in SSMS
Manage Roles by using SSMS
Filter Data in a Table Relationships
Create and Manage Measures KPIs
Email us about this courses
Other Rowley Enable Technology Training Courses
Excel 365 Basic Rowley Training Courses
SQL Rowley Training Courses
Excel 365 Intermediate Rowley Training Courses
Access - Rowley Access Training Courses
Excel Power Pivot - Rowley Excel Training Courses
SSIS - Rowley SQL Server Integration Services Training Courses