SQL SERVER ANALYSIS SERVICES TRAINING COURSES SWANSEA
About Enable Technology Swansea SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. 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. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. 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. Another option is we can organise a local socially distanced training site in Swansea. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Lloyds TSB Bank PLC, DHL Express, Fujistu PLC, Loughborough University, Shell UK Oil Products Ltd, Yell Group PLC, National Power PLC and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Swansea
- 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 ... Ragged Hierarchies
- See Training Course Details...
Delete a Data Source View Dimensions
Deploy Model Solutions Using the Deployment Wizard
Configure Analysis Services Project Properties
Configure Measure Group Properties
Define a Fact Relationship and Fact Relationship Properties
Overview of SSAS Multidimensional Modelling
Deployment Requirements and Considerations for Analysis Services Deployment
Authorizing access to objects and operations
KPIs Actions
Database permissions
Set Data Source Properties
Using SQL Server Data Tools (SSDT)
Define a Referenced Relationship and Referenced Relationship Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Defined Linked Measure Groups Partitions
Processing Options and Settings
Add a Standard Action
BI Wizard
Define a Data Source View
Error Configuration Roles and Permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Swansea
- 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...
Create and Manage Perspectives Translations Roles
Manage Roles by using SSMS
Enable DirectQuery mode in SSDT
Add columns to a table
Hide or freeze columns
Define partitions in DirectQuery models
Topics include- Overview of SSAS Tabular models
Filter Data in a Table Relationships
Create and Manage Tabular Model Partitions
Create a Relationship Between Two Tables
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in SSAS tabular 2016 Create Tabular Models
Import data by using a native query
Import from Power View
Create a Calculated Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Specify Mark as Date Table for use with Time Intelligence
Sort Data in a Table
Enable DirectQuery mode in SSMS
Version comparison
Email us about this courses
Other Swansea Enable Technology Training Courses
SSRS - Swansea SQL Server Reporting Services Training Courses
JQuery Mobile Swansea Training Courses
PL/SQL Swansea Training Courses
VBA Swansea Training Courses
Oracle SQL - Swansea SQL Training Courses
SSIS - Swansea SQL Server Integration Services Training Courses