SQL SERVER ANALYSIS SERVICES TRAINING COURSES LANCASHIRE
About Enable Technology Lancashire SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a course at a local venue in Lancashire. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham City University, West Bromwich Building Society, DHL Express, Halfords Group PLC, South Staffordshire Water PLC, Cadbury PLC, Capita Group PLC and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Lancashire
- 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 ... Create a Dimension Using the Dimension Wizard
- See Training Course Details...
Batch Processing Remote Processing
KPIs Actions
Data Source Views
Modify or Delete an Analysis Services Database
Create Named Sets
Ragged Hierarchies
Define Logical Primary Keys in a Data Source View
Read Definition permissions
Define a Referenced Relationship and Referenced Relationship Properties
Processing Databases, Dimensions and Partitions
Use a Template to Create an Action Deployment
Defined Linked Measure Groups Partitions
Dimension permissions
Create Measures and Measure Groups
Create an Analysis Services Project
Add or Remove Tables or Views in a Data Source View
Define Attribute Relationships
Configure Analysis Services Project Properties
Edit or Delete Partitions Merge Partitions
Cube or model permissions Process permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Lancashire
- 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 ... Create a Relationship Between Two Tables
- See Training Course Details...
Manage Roles by using SSMS
Understanding DAX in Tabular Models Measures
Delete Relationships
Set the Data Type of a Column
Process Database, Table, or Partition
Add sample data to DirectQuery models
Tabular model designer
Create a New Tabular Model Project
Analyze a tabular model in Excel Deploy tabular model solutions
Data sources supported in SSAS tabular 2017
Create and Manage Measures KPIs
Create and Manage Hierarchies Partitions
Test a model in DirectQuery mode
Create and Manage Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Data sources supported in SSAS tabular 2016 Create Tabular Models
Filter Data in a Table Relationships
Impersonation
Analyze in Excel
Email us about this courses
Other Lancashire Enable Technology Training Courses
VBA - Lancashire Excel Training Courses
SSIS Lancashire Training Courses
JavaScript - Lancashire JavaScript Training Courses
Power Query Lancashire Training Courses
Excel 365 Advanced - Lancashire Excel Training Courses
JQuery Mobile - Lancashire JavaScript Training Courses