SQL SERVER ANALYSIS SERVICES TRAINING COURSES DERBY
About Enable Technology Derby SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Derby. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Vodafone Group Services, Norwich Union PLC, Yell Group PLC, Carillion PLC, Wolverhampton City Council, Nuclear Engineering Services, TalkTalk Direct Limited and Fujistu PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Derby
- 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 ... Processing Databases, Dimensions and Partitions
- See Training Course Details...
Define Logical Relationships in a Data Source View
Create a Dimension by Generating a Non-Time Table in the Data Source
Multidimensional models
Configure Measure Group Properties
Create an Analysis Services Project
Define Time Intelligence
Create a Dimension by Using an Existing Table
Define Attribute Relationships
Add or Remove Tables or Views in a Data Source View
Database permissions
Delete a Data Source
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Delete a Data Source View Dimensions
Defined Linked Measure Groups Partitions
Create a Time Dimension by Generating a Time Table
Dimension permissions
Add a Standard Action
Read Definition permissions
Define a Referenced Relationship and Referenced Relationship Properties
Tools and Approaches for Processing
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Derby
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Data types supported
Import Data
Create and Manage Perspectives Translations Roles
Create a Relationship Between Two Tables
Import from Power View
Process Database, Table, or Partition
Process Tabular Model Partitions
Set the Data Type of a Column
Create a Calculated Table
DAX formula compatibility in DirectQuery mode Tables and Columns
Change table, column
Analyze in Excel
Import from Analysis Services
Rename a Table or Column
Create and Manage Hierarchies Partitions
Create a New Tabular Model Project
Data sources supported in SSAS tabular 2017
Test a model in DirectQuery mode
Email us about this courses
Other Derby Enable Technology Training Courses
PL/SQL - Derby SQL Training Courses
Access Derby Training Courses
SSIS - Derby SQL Server Integration Services Training Courses
Excel 365 Basic - Derby Excel Training Courses
JQuery Mobile - Derby JavaScript Training Courses
Power BI - Derby Microsoft Power BI Training Courses