SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHESTER
About Enable Technology Chester SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued SQL Server Analysis Services training manuals they can 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Chester. 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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Aston University, Norwich Union PLC, Shell UK Oil Products Ltd, Birmingham City Council, Royal Air Force, EDF Energy PLC, Yell Group PLC and TalkTalk Direct Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Chester
- 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 ... Set Data Source Properties
- See Training Course Details...
Using SQL Server Data Tools (SSDT)
Edit or Delete Partitions Merge Partitions
Define Logical Primary Keys in a Data Source View
Deploy Model Solutions with the Deployment Utility
Data Source Views
BI Wizard
Batch Processing Remote Processing
Backup and Restore of Analysis Services Databases
Backup Options Restore Options
Cube or model permissions Process permissions
Deploy Model Solutions Using XMLA
Document and Script an Analysis Services Database
Modify or Delete an Analysis Services Database
Error Configuration Roles and Permissions
Multidimensional models
Partition Writeback Calculations
Attach and Detach Analysis Services Databases
Define Named Calculations in a Data Source View
Supported Data Sources
Processing Databases, Dimensions and Partitions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Chester
- 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 ... Delete Relationships
- See Training Course Details...
Data sources supported in SSAS tabular 2017
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSDT
Define partitions in DirectQuery models
Process Database, Table, or Partition
Set the Data Type of a Column
Create and Manage Partitions in the Workspace
Restore from Power Pivot
Hide or freeze columns
Data sources supported in tabular 1400 models
Specify Mark as Date Table for use with Time Intelligence
Manage Roles by using SSMS
Create and Manage KPIs Hierarchies
Import Data
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Impersonation
Connect to a tabular model database
DirectQuery Mode
Delete a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Email us about this courses
Other Chester Enable Technology Training Courses
Data Warehouse Chester Training Courses
VBA Chester Training Courses
PL/SQL - Chester SQL Training Courses
DAX - Chester Excel Training Courses
SQL - Chester SQL Training Courses
JQuery Mobile Chester Training Courses