SQL SERVER ANALYSIS SERVICES TRAINING COURSES YSTRAD MYNACH
About Enable Technology Ystrad Mynach SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. 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 venue in Ystrad Mynach. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Vodafone Group Services, Boots UK Limited, Dollond & Aitchison Limited, Nationwide Building Society Limited, Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, Carillion PLC and Yell Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Ystrad Mynach
- 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 ... Read Definition permissions
- See Training Course Details...
Attach and Detach Analysis Services Databases
Define Named Calculations in a Data Source View
Test an Action
Add or Remove Tables or Views in a Data Source View
Defined Linked Measure Groups Partitions
Define a Fact Relationship and Fact Relationship Properties
Calculations using the Business Intelligence Wizard
BI Wizard
Dimension permissions
Using SQL Server Data Tools (SSDT)
Create User-Defined Hierarchies
Deployment Requirements and Considerations for Analysis Services Deployment
Change a Partition Source
Create Local Partitions
Add a Standard Action
Create a Dimension by Using an Existing Table
Multidimensional models
Create Measures and Measure Groups
Error Configuration Roles and Permissions
Define Attribute Relationships
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Ystrad Mynach
- 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 ... Hide or freeze columns
- See Training Course Details...
Add columns to a table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import from Analysis Services
Impersonation
Create a Calculated Column
Sort Data in a Table
Delete Relationships
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Tabular Model Partitions
Create and Manage Hierarchies Partitions
Create a Calculated Table
DAX formula compatibility in DirectQuery mode Tables and Columns
Restore from Power Pivot
Create and Manage Perspectives Translations Roles
Enable DirectQuery mode in SSDT
Import from Power View
Version comparison
Data sources supported in tabular 1400 models
Email us about this courses
Other Ystrad Mynach Enable Technology Training Courses
Access Ystrad Mynach Training Courses
DAX - Ystrad Mynach Excel Training Courses
Excel Power Pivot - Ystrad Mynach Excel Training Courses
TSQL - Ystrad Mynach SQL Training Courses
JQuery Mobile - Ystrad Mynach JavaScript Training Courses
Excel 365 Basic - Ystrad Mynach Excel Training Courses