SQL SERVER ANALYSIS SERVICES TRAINING COURSES RISCA
About Enable Technology Risca SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Professionals. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Risca. 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. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Fujistu PLC, Homeserve PLC, West Bromwich Building Society, Wolverhampton City Council, Halfords Group PLC, South Staffordshire Water PLC and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Risca
- 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 ... View the XML for an Analysis Services Project Data Sources
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Modify or Delete in Solution Explorer Database Dimensions
Create User-Defined Hierarchies
Deploy Analysis Services Projects
Defined Linked Measure Groups Partitions
Supported Data Sources
Create Calculated Members
Set Partition Storage
Define a Data Source View
Define Named Calculations in a Data Source View
Edit or Delete Partitions Merge Partitions
Create Remote Partitions
Create a Dimension by Generating a Non-Time Table in the Data Source
Use a Template to Create an Action Deployment
Dimension permissions
Create an Analysis Services Project
Ragged Hierarchies
Create Named Sets
Overview of SSAS Multidimensional Modelling
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Risca
- 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 ... Analyze a tabular model in Excel Deploy tabular model solutions
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Filter Data in a Table Relationships
Database Process Partitions in the Workspace Database Perspectives
Rename a Table or Column
Connect to a tabular model database
Import from Analysis Services
DAX formula compatibility in DirectQuery mode Tables and Columns
Object-level security
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Create a Calculated Table
Create a Calculated Column
Add columns to a table
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Change table, column
Manage Roles by using SSMS
Create a Relationship Between Two Tables
Impersonation
Email us about this courses
Other Risca Enable Technology Training Courses
SSRS Risca Training Courses
PL/SQL Risca Training Courses
SSIS - Risca SQL Server Integration Services Training Courses
DAX - Risca Excel Training Courses
Access - Risca Access Training Courses
Oracle SQL Risca Training Courses