SQL SERVER ANALYSIS SERVICES TRAINING COURSES WARWICK
About Enable Technology Warwick SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If delivery onsite is an issue we will organise a socially distanced venue near you in Warwick. 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. Some of our clients are Birmingham City Council, Canadian High Commission, Shell UK Oil Products Ltd, Capita Group PLC, Carillion PLC, Unipart Group, Royal Air Force and West Bromwich Building Society.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Warwick
- 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 ... Delete a Column
- See Training Course Details...
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Add a table Delete a Table
Create and Manage Partitions in the Workspace
Import from Power View
DirectQuery Mode
Sort Data in a Table
Row filter mappings
Create a Relationship Between Two Tables
Create and Manage Perspectives Translations Roles
Create and Manage Tabular Model Partitions
Version comparison
Hide or freeze columns
Impersonation
Enable DirectQuery mode in SSDT
Data types supported
Create and Manage KPIs Hierarchies
Process Database, Table, or Partition
Import Data
Tabular model designer
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Warwick
- 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 ... Supported Data Sources
- See Training Course Details...
Deploy Model Solutions Using the Deployment Wizard
Database permissions
Partition Writeback Calculations
Change a Partition Source
Using SQL Server Data Tools (SSDT)
Error Configuration Roles and Permissions
Define Logical Relationships in a Data Source View
Test an Action
Data Source Views
Define Named Calculations in a Data Source View
Processing Databases, Dimensions and Partitions
Backup and Restore of Analysis Services Databases
Deploy Model Solutions Using XMLA
Authorizing access to objects and operations
Replace a Table or a Named Query in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Measures and Measure Groups
Add or Remove Tables or Views in a Data Source View
Batch Processing Remote Processing
Create a Dimension by Generating a Non-Time Table in the Data Source
Email us about this courses
Other Warwick Enable Technology Training Courses
SSRS - Warwick SQL Server Reporting Services Training Courses
SSIS - Warwick SQL Server Integration Services Training Courses
Excel 365 Basic Warwick Training Courses
Oracle SQL Warwick Training Courses
Excel Power Pivot Warwick Training Courses
Data Warehouse Warwick Training Courses