SQL SERVER ANALYSIS SERVICES TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology offers instructor led training taught by technology specialists. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We are also more than happy to organise a local course at a socially distanced training location in Mid Glamorgan. 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 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Capita Group PLC, Norwich Union PLC, Yell Group PLC, Unipart Group, Barclays Bank PLC, Countrywide Homes Limited, Norfolk Police Constabulary and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Mid Glamorgan
- 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 and Manage Roles
- See Training Course Details...
Create a New Tabular Model Project
Filter Data in a Table Relationships
Sort Data in a Table
Restore from Power Pivot
Manage Roles by using SSMS
Create and Manage Tabular Model Partitions
Import from Power Pivot
Delete a Column
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Set the Data Type of a Column
Create and Manage Perspectives Translations Roles
Database Process Partitions in the Workspace Database Perspectives
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Define partitions in DirectQuery models
Add columns to a table
Enable DirectQuery mode in SSMS
Topics include- Overview of SSAS Tabular models
Analyze in Excel
Data types supported
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Mid Glamorgan
- 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 ... Explore Data in a Data Source View
- See Training Course Details...
Delete a Data Source
Configure Analysis Services Project Properties
Deploy Model Solutions with the Deployment Utility
Set Partition Storage
Batch Processing Remote Processing
Create an Analysis Services Project
Create Measures and Measure Groups
Database permissions
Partition Writeback Calculations
Deploy Model Solutions Using the Deployment Wizard
Create a Dimension Using the Dimension Wizard
Define Logical Primary Keys in a Data Source View
Test an Action
Delete a Data Source View Dimensions
Use a Template to Create an Action Deployment
Edit or Delete Partitions Merge Partitions
Create User-Defined Hierarchies
Data Source Views
Set Impersonation Options for a Data Source Connection
Ragged Hierarchies
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
SQL Mid Glamorgan Training Courses
Excel Power Pivot Mid Glamorgan Training Courses
Excel 365 Advanced - Mid Glamorgan Excel Training Courses
PL/SQL - Mid Glamorgan SQL Training Courses
Oracle SQL Mid Glamorgan Training Courses
TSQL Mid Glamorgan Training Courses