SQL SERVER ANALYSIS SERVICES TRAINING COURSES CASTLEFORD
About Enable Technology Castleford SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another option is we can organise a local socially distanced training site in Castleford. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training 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 Capita Group PLC, Canadian High Commission, Birmingham City University, Dollond & Aitchison Limited, Unipart Group, Aston University, Birmingham Heartlands Hospital and Barclays Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Castleford
- 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 ... Import from Power Pivot
- See Training Course Details...
Process Database, Table, or Partition
Enable DirectQuery mode in SSMS
Impersonation
Rename a Table or Column
Create and Manage Roles
Filter Data in a Table Relationships
Create a Calculated Column
Sort Data in a Table
Create a Calculated Table
Data types supported
Create and Manage Perspectives Translations Roles
Create and Manage Measures KPIs
Data sources supported in tabular 1200 models
Add sample data to DirectQuery models
Import from Power View
DAX formula compatibility in DirectQuery mode Tables and Columns
Topics include- Overview of SSAS Tabular models
Change table, column
Create and Manage Hierarchies Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Castleford
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Dimension permissions
Processing Databases, Dimensions and Partitions
Configure Measure Group Properties
Using SQL Server Data Tools (SSDT)
Create Local Partitions
Create a Data Source
Define Named Calculations in a Data Source View
Designing Aggregations
BI Wizard
Define a Data Source View
Create a Dimension Using the Dimension Wizard
Create Measures and Measure Groups
Define Logical Relationships in a Data Source View
Use a Template to Create an Action Deployment
Change a Partition Source
Set Impersonation Options for a Data Source Connection
Deploy Model Solutions with the Deployment Utility
Batch Processing Remote Processing
Rename a Multidimensional Database Processing a multidimensional model
Email us about this courses
Other Castleford Enable Technology Training Courses
Oracle SQL Castleford Training Courses
JQuery Mobile Castleford Training Courses
SSRS - Castleford SQL Server Reporting Services Training Courses
JavaScript Castleford Training Courses
Access - Castleford Access Training Courses
SQL - Castleford SQL Training Courses