SQL SERVER ANALYSIS SERVICES TRAINING COURSES SALISBURY
About Enable Technology Salisbury SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. 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 provide instructor led training coupled with hands on training. 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. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Salisbury. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Canadian High Commission, Wolverhampton City Council, Royal Air Force, Queen's Medical Centre Nottingham, GKN PLC, TalkTalk Direct Limited, Countrywide Homes Limited and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Salisbury
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Rename a Table or Column
Specify Mark as Date Table for use with Time Intelligence
Row filter mappings
Delete Relationships
Enable DirectQuery mode in SSDT
Create a New Tabular Model Project
Process Tabular Model Partitions
Create a Relationship Between Two Tables
Deploy from SQL Server Data Tools Manage Tabular Model Databases
DAX formula compatibility in DirectQuery mode Tables and Columns
Set the Data Type of a Column
Restore from Power Pivot
Create and Manage Tabular Model Partitions
Import Data
Tabular model designer
Impersonation
Import data by using a native query
Filter Data in a Table Relationships
Create and Manage Partitions in the Workspace
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Salisbury
- 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 ... Add or Remove Tables or Views in a Data Source View
- See Training Course Details...
View the XML for an Analysis Services Project Data Sources
BI Wizard
Create a Dimension by Generating a Non-Time Table in the Data Source
Move an Analysis Services Database
Deploy Model Solutions with the Deployment Utility
Add a Standard Action
Delete a Data Source View Dimensions
Create a Dimension Using the Dimension Wizard
Create a Dimension by Using an Existing Table
Explore Data in a Data Source View
Delete a Data Source
Create Measures and Measure Groups
Overview of SSAS Multidimensional Modelling
Define Attribute Relationships
Designing Aggregations
Rename a Multidimensional Database Processing a multidimensional model
Create an Analysis Services Project
Change a Partition Source
Supported Data Sources
Configure Analysis Services Project Properties
Email us about this courses
Other Salisbury Enable Technology Training Courses
Access VBA - Salisbury Access Training Courses
Excel Power Pivot Salisbury Training Courses
SSIS - Salisbury SQL Server Integration Services Training Courses
SSRS - Salisbury SQL Server Reporting Services Training Courses
SQL Salisbury Training Courses
JQuery Mobile - Salisbury JavaScript Training Courses