SQL SERVER ANALYSIS SERVICES TRAINING COURSES MAESTEG
About Enable Technology Maesteg SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. 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.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Maesteg. 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.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Homeserve PLC, Nationwide Building Society Limited, West Bromwich Building Society, Vodafone Group Services, Unipart Group, Keele University, South Staffordshire Water PLC and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Maesteg
- 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 ... Batch Processing Remote Processing
- See Training Course Details...
Deploy Model Solutions with the Deployment Utility
Document and Script an Analysis Services Database
Delete a Data Source
Backup and Restore of Analysis Services Databases
Delete a Data Source View Dimensions
Create Named Sets
Create a Dimension Using the Dimension Wizard
Edit or Delete Partitions Merge Partitions
Define a Regular Relationship and Regular Relationship Properties
Set Partition Storage
Create a Dimension by Generating a Non-Time Table in the Data Source
Replace a Table or a Named Query in a Data Source View
Data Source Views
Add a Standard Action
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Explore Data in a Data Source View
Create User-Defined Hierarchies
Define a Data Source View
Overview of SSAS Multidimensional Modelling
Define Named Calculations in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Maesteg
- 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 ... Hide or freeze columns
- See Training Course Details...
Data sources supported in tabular 1400 models
Connect to a tabular model database
Import from Analysis Services
Create and Manage Perspectives Translations Roles
Analyze in Excel
Create a Calculated Column
Sort Data in a Table
DirectQuery Mode
Enable DirectQuery mode in SSDT
Create and Manage Hierarchies Partitions
Enable DirectQuery mode in SSMS
Bi-directional cross filters Calculations
Row filter mappings
Create and Manage Tabular Model Partitions
Data types supported
Version comparison
Change table, column
Tabular model designer
Email us about this courses
Other Maesteg Enable Technology Training Courses
Report Builder Maesteg Training Courses
SSRS Maesteg Training Courses
Access VBA Maesteg Training Courses
JavaScript - Maesteg JavaScript Training Courses
SQL - Maesteg SQL Training Courses
DAX - Maesteg Excel Training Courses