SQL SERVER ANALYSIS SERVICES TRAINING COURSES RUGBY
About Enable Technology Rugby SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
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 two decades of delivering technical training predominantly in the West Midlands. Our clients include: Birmingham City University, DHL Express, Capita Group PLC, Nationwide Building Society Limited, Canadian High Commission, Queen's Medical Centre Nottingham, GKN PLC and Cadbury PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rugby
- 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 ... Version comparison
- See Training Course Details...
Import from Power Pivot
Create a Relationship Between Two Tables
Data sources supported in SSAS tabular 2017
Hide or freeze columns
DirectQuery Mode
Database Process Partitions in the Workspace Database Perspectives
Create a Calculated Column
Delete Relationships
Enable DirectQuery mode in SSMS
Object-level security
Rename a Table or Column
Create and Manage Partitions in the Workspace
Restore from Power Pivot
Row filter mappings
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Delete a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in SSAS tabular 2016 Create Tabular Models
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rugby
- 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...
Document and Script an Analysis Services Database
Ragged Hierarchies
Define Logical Primary Keys in a Data Source View
Define Attribute Relationships
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Named Calculations in a Data Source View
Change a Partition Source
Define Assignments and Other Script Commands
Delete a Data Source View Dimensions
Dimension permissions
Define a Data Source View
Define Named Queries in a Data Source View
Cube or model permissions Process permissions
Read Definition permissions
Calculations using the Business Intelligence Wizard
Create Local Partitions
Move an Analysis Services Database
Add or Remove Tables or Views in a Data Source View
Configure Measure Group Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Email us about this courses
Other Rugby Enable Technology Training Courses
SQL Rugby Training Courses
Excel 365 Basic Rugby Training Courses
PL/SQL - Rugby SQL Training Courses
JQuery - Rugby JavaScript Training Courses
TSQL - Rugby SQL Training Courses
JavaScript - Rugby JavaScript Training Courses