SQL SERVER ANALYSIS SERVICES TRAINING COURSES SCARBOROUGH
About Enable Technology Scarborough SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All Enable Technology tutors are Microsoft certified experts. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. 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. 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. If you prefer we can offer an offsite training location in Scarborough. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
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 Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Loughborough University, Barclays Bank PLC, Shell UK Oil Products Ltd, Norwich Union PLC, Royal & Sun Alliance Group PLC, TalkTalk Direct Limited, National Power PLC and EDF Energy PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Scarborough
- 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 ... Define Assignments and Other Script Commands
- See Training Course Details...
Deploy Model Solutions Using XMLA
Create a Data Source
Create a Time Dimension by Generating a Time Table
Multidimensional models
Database permissions
Batch Processing Remote Processing
Set Impersonation Options for a Data Source Connection
Read Definition permissions
Define Logical Primary Keys in a Data Source View
Create User-Defined Hierarchies
Ragged Hierarchies
Create an Analysis Services Project
Supported Data Sources
Data Source Views
Partition Writeback Calculations
Processing Databases, Dimensions and Partitions
Define a Fact Relationship and Fact Relationship Properties
Authorizing access to objects and operations
Delete a Data Source View Dimensions
Attach and Detach Analysis Services Databases
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Scarborough
- 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 ... Impersonation
- See Training Course Details...
Process Tabular Model Partitions
Import from Analysis Services
Topics include- Overview of SSAS Tabular models
Create and Manage Perspectives Translations Roles
Understanding DAX in Tabular Models Measures
Sort Data in a Table
Row filter mappings
Rename a Table or Column
Restore from Power Pivot
Import from Power View
Define partitions in DirectQuery models
Manage Roles by using SSMS
Tabular model designer
Create and Manage Measures KPIs
Bi-directional cross filters Calculations
DirectQuery Mode
Data types supported
Version comparison
Import Data
Add a table Delete a Table
Email us about this courses
Other Scarborough Enable Technology Training Courses
VBA - Scarborough Excel Training Courses
PL/SQL Scarborough Training Courses
Access VBA Scarborough Training Courses
SSRS Scarborough Training Courses
SSIS - Scarborough SQL Server Integration Services Training Courses
Excel 365 Basic Scarborough Training Courses