SQL SERVER ANALYSIS SERVICES TRAINING COURSES PLYMOUTH
About Enable Technology Plymouth SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The training will be delivered by a Microsoft professional with development experience. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. Alternatively we could schedule a course at a local venue in Plymouth. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Halfords Group PLC, Total Telecommunications Limited, South Staffordshire Water PLC, Keele University, Barclays Bank PLC, Loughborough University, National Power PLC and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Plymouth
- 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 ... Create Named Sets
- See Training Course Details...
Create User-Defined Hierarchies
Use a Template to Create an Action Deployment
Rename a Multidimensional Database Processing a multidimensional model
KPIs Actions
Define a Regular Relationship and Regular Relationship Properties
Set Data Source Properties
Overview of SSAS Multidimensional Modelling
Test an Action
Define a Fact Relationship and Fact Relationship Properties
Database permissions
Define Semiadditive Behavior
Error Configuration Roles and Permissions
Create Remote Partitions
Processing Databases, Dimensions and Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Add a Standard Action
Partition Writeback Calculations
Create an Analysis Services Project
Define Time Intelligence
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Plymouth
- 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 ... Manage Roles by using SSMS
- See Training Course Details...
Sort Data in a Table
Data sources supported in SSAS tabular 2017
Create and Manage KPIs Hierarchies
Object-level security
Create and Manage Roles
Data types supported
Create and Manage Tabular Model Partitions
Bi-directional cross filters Calculations
Create a New Tabular Model Project
Data sources supported in tabular 1400 models
Add a table Delete a Table
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Hierarchies Partitions
Row filter mappings
Import from Power Pivot
Import from Power View
DAX formula compatibility in DirectQuery mode Tables and Columns
Connect to a tabular model database
Add sample data to DirectQuery models
Version comparison
Email us about this courses
Other Plymouth Enable Technology Training Courses
VBA - Plymouth Excel Training Courses
SQL - Plymouth SQL Training Courses
JQuery - Plymouth JavaScript Training Courses
JavaScript Plymouth Training Courses
Report Builder Plymouth Training Courses
Excel 365 Intermediate - Plymouth Excel Training Courses