SQL SERVER ANALYSIS SERVICES TRAINING COURSES ELLESMERE PORT
About Enable Technology Ellesmere Port SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology 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. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Ellesmere Port. 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Countrywide Homes Limited, Halfords Group PLC, Queen's Medical Centre Nottingham, Canadian High Commission, Wolverhampton City Council, TalkTalk Direct Limited, University of Birmingham and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ellesmere Port
- 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 ... Process Tabular Model Partitions
- See Training Course Details...
Specify Mark as Date Table for use with Time Intelligence
Import Data
Import from Power Pivot
Create and Manage Measures KPIs
Connect to a tabular model database
Topics include- Overview of SSAS Tabular models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a Relationship Between Two Tables
Tabular model designer
Hide or freeze columns
Bi-directional cross filters Calculations
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in tabular 1200 models
Filter Data in a Table Relationships
Delete a Column
Data sources supported in SSAS tabular 2017
Set the Data Type of a Column
Add sample data to DirectQuery models
Create and Manage Perspectives Translations Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ellesmere Port
- 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 ... Define a Fact Relationship and Fact Relationship Properties
- See Training Course Details...
Deployment Requirements and Considerations for Analysis Services Deployment
Define Assignments and Other Script Commands
Overview of SSAS Multidimensional Modelling
Define Named Queries in a Data Source View
Multidimensional models
Define Named Calculations in a Data Source View
Calculations using the Business Intelligence Wizard
Create Named Sets
Create an Analysis Services Project
Modify or Delete in Solution Explorer Database Dimensions
KPIs Actions
Create User-Defined Hierarchies
Configure Analysis Services Project Properties
Define Time Intelligence
Configure Measure Group Properties
Move an Analysis Services Database
Partition Writeback Calculations
Backup Options Restore Options
Modify or Delete an Analysis Services Database
Use Aggregate Functions
Email us about this courses
Other Ellesmere Port Enable Technology Training Courses
JavaScript - Ellesmere Port JavaScript Training Courses
Power Query - Ellesmere Port Excel Training Courses
DAX Ellesmere Port Training Courses
JQuery Mobile - Ellesmere Port JavaScript Training Courses
VBA - Ellesmere Port Excel Training Courses
Excel 365 Intermediate Ellesmere Port Training Courses