SQL SERVER ANALYSIS SERVICES TRAINING COURSES HUDDERSFIELD
About Enable Technology Huddersfield SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If you prefer we can offer an offsite training location in Huddersfield. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Royal & Sun Alliance Group PLC, Fujistu PLC, Keele University, Homeserve PLC, Nationwide Building Society Limited, South Staffordshire Water PLC, Canadian High Commission and Loughborough University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Huddersfield
- 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 ... Delete a Data Source
- See Training Course Details...
Create Measures and Measure Groups
Set Impersonation Options for a Data Source Connection
Add or Remove Tables or Views in a Data Source View
Configure Measure Group Properties
Create a Dimension Using the Dimension Wizard
Deploy Model Solutions Using XMLA
Deploy Model Solutions with the Deployment Utility
Define a Regular Relationship and Regular Relationship Properties
Modify or Delete an Analysis Services Database
Use Aggregate Functions
Create Calculated Members
Create a Dimension by Using an Existing Table
KPIs Actions
Deployment Requirements and Considerations for Analysis Services Deployment
Define Semiadditive Behavior
Deploy Model Solutions Using the Deployment Wizard
Use a Template to Create an Action Deployment
Define Logical Primary Keys in a Data Source View
Create a Time Dimension by Generating a Time Table
Create User-Defined Hierarchies
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Huddersfield
- 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 ... Filter Data in a Table Relationships
- See Training Course Details...
Create and Manage Measures KPIs
DAX formula compatibility in DirectQuery mode Tables and Columns
Topics include- Overview of SSAS Tabular models
Create and Manage Tabular Model Partitions
Create and Manage Hierarchies Partitions
Object-level security
Database Process Partitions in the Workspace Database Perspectives
Bi-directional cross filters Calculations
Create a Calculated Column
Process Tabular Model Partitions
Sort Data in a Table
Create and Manage Roles
Change table, column
Create a Relationship Between Two Tables
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Add columns to a table
Data sources supported in tabular 1200 models
Import from Power View
Data sources supported in SSAS tabular 2016 Create Tabular Models
Define partitions in DirectQuery models
Email us about this courses
Other Huddersfield Enable Technology Training Courses
Access VBA Huddersfield Training Courses
Oracle SQL Huddersfield Training Courses
JQuery Huddersfield Training Courses
Access - Huddersfield Access Training Courses
Excel Power Pivot Huddersfield Training Courses
SSIS - Huddersfield SQL Server Integration Services Training Courses