SQL SERVER ANALYSIS SERVICES TRAINING COURSES TREDEGAR
About Enable Technology Tredegar SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We are also more than happy to organise a local course at a training location in Tredegar. 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 team have been providing IT training primarily in the Midlands for two decades. Our clients include: Wolverhampton City Council, Carillion PLC, Total Telecommunications Limited, Nuclear Engineering Services, Capita Group PLC, Birmingham City Council, Royal & Sun Alliance Group PLC and National Power PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Tredegar
- 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 ... Cube or model permissions Process permissions
- See Training Course Details...
Deploy Model Solutions with the Deployment Utility
Define a Fact Relationship and Fact Relationship Properties
Define a Data Source View
Define Named Calculations in a Data Source View
Define Logical Primary Keys in a Data Source View
Set Data Source Properties
Configure Measure Group Properties
Edit or Delete Partitions Merge Partitions
Create Calculated Members
Move an Analysis Services Database
Create User-Defined Hierarchies
Authorizing access to objects and operations
View the XML for an Analysis Services Project Data Sources
Deploy Model Solutions Using the Deployment Wizard
Overview of SSAS Multidimensional Modelling
Rename a Multidimensional Database Processing a multidimensional model
Error Configuration Roles and Permissions
Designing Aggregations
Define Time Intelligence
Deploy Analysis Services Projects
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Tredegar
- 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...
Enable DirectQuery mode in SSDT
Define partitions in DirectQuery models
DirectQuery Mode
Manage Roles by using SSMS
Data sources supported in tabular 1400 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Row filter mappings
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in SSAS tabular 2017
Delete Relationships
Change table, column
Import from Power Pivot
Data sources supported in tabular 1200 models
Restore from Power Pivot
Understanding DAX in Tabular Models Measures
Analyze in Excel
DAX formula compatibility in DirectQuery mode Tables and Columns
Create and Manage Partitions in the Workspace
Sort Data in a Table
Email us about this courses
Other Tredegar Enable Technology Training Courses
SQL Tredegar Training Courses
Power Query Tredegar Training Courses
Excel 365 Advanced Tredegar Training Courses
Excel 365 Basic - Tredegar Excel Training Courses
VBA Tredegar Training Courses
PL/SQL - Tredegar SQL Training Courses