SQL SERVER ANALYSIS SERVICES TRAINING COURSES TREDEGAR
About Enable Technology Tredegar SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We can also deliver the SQL Server Analysis Services course at a local training venue in Tredegar. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham Heartlands Hospital, Queen's Medical Centre Nottingham, Barclays Bank PLC, Norfolk Police Constabulary, Lloyds TSB Bank PLC, Norwich Union PLC, Loughborough University and Canadian High Commission.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tredegar
- 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 ... Data sources supported in SSAS tabular 2017
- See Training Course Details...
DAX formula compatibility in DirectQuery mode Tables and Columns
Change table, column
Import data by using a native query
Create and Manage Perspectives Translations Roles
Create a Calculated Table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Sort Data in a Table
Process Tabular Model Partitions
Restore from Power Pivot
Hide or freeze columns
Import from Analysis Services
Data sources supported in tabular 1400 models
Object-level security
Filter Data in a Table Relationships
Impersonation
Bi-directional cross filters Calculations
Database Process Partitions in the Workspace Database Perspectives
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tredegar
- 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 ... Backup and Restore of Analysis Services Databases
- See Training Course Details...
Work with Diagrams in Data Source View Designer
Define a Fact Relationship and Fact Relationship Properties
Move an Analysis Services Database
Deploy Model Solutions Using the Deployment Wizard
Deploy Analysis Services Projects
Cube or model permissions Process permissions
Create Calculated Members
Backup Options Restore Options
Batch Processing Remote Processing
Configure Measure Group Properties
Processing Databases, Dimensions and Partitions
Define Logical Primary Keys in a Data Source View
Add a Standard Action
Define Time Intelligence
Create a Data Source
Test an Action
Create User-Defined Hierarchies
Define Named Calculations in a Data Source View
Data Source Views
Dimension permissions
Email us about this courses
Other Tredegar Enable Technology Training Courses
SSIS - Tredegar SQL Server Integration Services Training Courses
Excel 365 Intermediate Tredegar Training Courses
Data Warehouse - Tredegar SQL Training Courses
SQL Tredegar Training Courses
Access VBA - Tredegar Access Training Courses
JQuery Tredegar Training Courses