SQL SERVER ANALYSIS SERVICES TRAINING COURSES POWYS
About Enable Technology Powys SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Powys. 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 Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Lloyds TSB Bank PLC, Dollond & Aitchison Limited, Wolverhampton City Council, Norwich Union PLC, University of Birmingham, Aston University, Birmingham Heartlands Hospital and Unipart Group.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Powys
- 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 Calculated Members
- See Training Course Details...
Create Named Sets
Data Source Views
Cube or model permissions Process permissions
Database permissions
Dimension permissions
Authorizing access to objects and operations
Supported Data Sources
Using SQL Server Data Tools (SSDT)
Deploy Model Solutions Using the Deployment Wizard
Tools and Approaches for Processing
Set Impersonation Options for a Data Source Connection
Read Definition permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Error Configuration Roles and Permissions
Create a Dimension Using the Dimension Wizard
Use a Template to Create an Action Deployment
Change a Partition Source
Backup and Restore of Analysis Services Databases
Define a Regular Relationship and Regular Relationship Properties
Define Logical Primary Keys in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Powys
- 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 ... DirectQuery Mode
- See Training Course Details...
Set the Data Type of a Column
Process Tabular Model Partitions
Row filter mappings
Change table, column
Create and Manage Perspectives Translations Roles
Import from Analysis Services
Import from Power View
Object-level security
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Process Database, Table, or Partition
Add sample data to DirectQuery models
Sort Data in a Table
Analyze in Excel
Version comparison
Create and Manage Tabular Model Partitions
Enable DirectQuery mode in SSDT
Connect to a tabular model database
Create and Manage Roles
Delete a Column
Database Process Partitions in the Workspace Database Perspectives
Email us about this courses
Other Powys Enable Technology Training Courses
Power Query Powys Training Courses
TSQL - Powys SQL Training Courses
PL/SQL - Powys SQL Training Courses
Excel 365 Intermediate - Powys Excel Training Courses
Report Builder - Powys SQL Server Reporting Services Training Courses
Oracle SQL - Powys SQL Training Courses