SQL SERVER ANALYSIS SERVICES TRAINING COURSES WARWICKSHIRE
About Enable Technology Warwickshire SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Courses are instructor led and groups sizes small. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a training location in Warwickshire. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are South Staffordshire Water PLC, Carillion PLC, Royal Air Force, Keele University, Cadbury PLC, Boots UK Limited, Queen's Medical Centre Nottingham and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Warwickshire
- 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 ... BI Wizard
- See Training Course Details...
Define Named Queries in a Data Source View
Batch Processing Remote Processing
Backup and Restore of Analysis Services Databases
Multidimensional models
Delete a Data Source View Dimensions
Work with Diagrams in Data Source View Designer
Document and Script an Analysis Services Database
Deployment Requirements and Considerations for Analysis Services Deployment
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension Using the Dimension Wizard
Create a Dimension by Using an Existing Table
Cube or model permissions Process permissions
Deploy Model Solutions Using XMLA
Modify or Delete in Solution Explorer Database Dimensions
Dimension permissions
Define a Data Source View
Configure Measure Group Properties
Create Local Partitions
Define a Regular Relationship and Regular Relationship Properties
Create Calculated Members
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Warwickshire
- 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...
Database Process Partitions in the Workspace Database Perspectives
Filter Data in a Table Relationships
Import from Power Pivot
Sort Data in a Table
Create a Calculated Column
Object-level security
Version comparison
Restore from Power Pivot
Tabular model designer
Connect to a tabular model database
Hide or freeze columns
Create and Manage Hierarchies Partitions
DirectQuery Mode
Set the Data Type of a Column
Enable DirectQuery mode in SSMS
Analyze in Excel
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Impersonation
Create a Relationship Between Two Tables
Email us about this courses
Other Warwickshire Enable Technology Training Courses
SSRS Warwickshire Training Courses
JQuery - Warwickshire JavaScript Training Courses
SQL - Warwickshire SQL Training Courses
DAX Warwickshire Training Courses
TSQL - Warwickshire SQL Training Courses
SSIS Warwickshire Training Courses