SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARROW-IN-FURNESS
About Enable Technology Barrow-in-furness SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. We guarantee the training will be delivered by a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Barrow-in-furness. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: EDF Energy PLC, Total Telecommunications Limited, Lloyds TSB Bank PLC, Canadian High Commission, Shell UK Oil Products Ltd, Royal Air Force, West Bromwich Building Society and Keele University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barrow-in-furness
- 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 ... Import data by using a native query
- See Training Course Details...
Rename a Table or Column
Analyze in Excel
Test a model in DirectQuery mode
Impersonation
Add a table Delete a Table
Process Database, Table, or Partition
Object-level security
Process Tabular Model Partitions
Tabular model designer
Create and Manage Measures KPIs
Import Data
Create and Manage Roles
Data sources supported in tabular 1400 models
Restore from Power Pivot
Hide or freeze columns
DAX formula compatibility in DirectQuery mode Tables and Columns
Add columns to a table
Change table, column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barrow-in-furness
- 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...
Define Time Intelligence
Data Source object permissions
Error Configuration Roles and Permissions
Overview of SSAS Multidimensional Modelling
Define a Regular Relationship and Regular Relationship Properties
Multidimensional models
Using SQL Server Data Tools (SSDT)
Edit or Delete Partitions Merge Partitions
Document and Script an Analysis Services Database
Defined Linked Measure Groups Partitions
Deploy Analysis Services Projects
Deployment Requirements and Considerations for Analysis Services Deployment
Move an Analysis Services Database
Authorizing access to objects and operations
Use Aggregate Functions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Backup and Restore of Analysis Services Databases
Define a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
BI Wizard
Email us about this courses
Other Barrow-in-furness Enable Technology Training Courses
VBA - Barrow-in-furness Excel Training Courses
PL/SQL Barrow-in-furness Training Courses
SSIS - Barrow-in-furness SQL Server Integration Services Training Courses
SQL - Barrow-in-furness SQL Training Courses
DAX Barrow-in-furness Training Courses
Excel Power Pivot - Barrow-in-furness Excel Training Courses