SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOUTH GLAMORGAN
About Enable Technology South Glamorgan SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. 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 courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Alternatively we could schedule a course at a local socially distanced venue in South Glamorgan. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Queen's Medical Centre Nottingham, Birmingham City Council, Barclays Bank PLC, Dollond & Aitchison Limited, GKN PLC, Boots UK Limited, South Staffordshire Water PLC and Yell Group PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: South Glamorgan
- 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 ... Test a model in DirectQuery mode
- See Training Course Details...
Row filter mappings
Import from Power Pivot
Impersonation
Create and Manage Measures KPIs
Set the Data Type of a Column
Import from Analysis Services
Create and Manage Perspectives Translations Roles
Analyze in Excel
Manage Roles by using SSMS
Define partitions in DirectQuery models
Rename a Table or Column
Topics include- Overview of SSAS Tabular models
Data types supported
DirectQuery Mode
Restore from Power Pivot
Data sources supported in tabular 1400 models
Import from Power View
Create and Manage Tabular Model Partitions
Create and Manage Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: South Glamorgan
- 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 Partition Storage
- See Training Course Details...
Database permissions
Deploy Analysis Services Projects
Add or Remove Tables or Views in a Data Source View
Defined Linked Measure Groups Partitions
Use Aggregate Functions
BI Wizard
Designing Aggregations
Using SQL Server Data Tools (SSDT)
Multidimensional models
Deploy Model Solutions Using the Deployment Wizard
Supported Data Sources
Data Source object permissions
Define Named Calculations in a Data Source View
Define Attribute Relationships
Configure Measure Group Properties
Batch Processing Remote Processing
Define Semiadditive Behavior
Read Definition permissions
Overview of SSAS Multidimensional Modelling
Define Logical Primary Keys in a Data Source View
Email us about this courses
Other South Glamorgan Enable Technology Training Courses
TSQL - South Glamorgan SQL Training Courses
Excel 365 Intermediate - South Glamorgan Excel Training Courses
Access South Glamorgan Training Courses
SSRS - South Glamorgan SQL Server Reporting Services Training Courses
Excel Power Pivot South Glamorgan Training Courses
JavaScript South Glamorgan Training Courses