SQL SERVER ANALYSIS SERVICES TRAINING COURSES BOLTON
About Enable Technology Bolton SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If delivery onsite is an issue we will organise a venue near you in Bolton. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Queen's Medical Centre Nottingham, Canadian High Commission, Loughborough University, Capita Group PLC, Barclays Bank PLC, Halfords Group PLC, Unipart Group and Birmingham City University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bolton
- 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...
Create Remote Partitions
Backup and Restore of Analysis Services Databases
Set Impersonation Options for a Data Source Connection
Define a Referenced Relationship and Referenced Relationship Properties
Define a Regular Relationship and Regular Relationship Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create an Analysis Services Project
Data Source object permissions
Tools and Approaches for Processing
Data Source Views
View the XML for an Analysis Services Project Data Sources
Replace a Table or a Named Query in a Data Source View
Processing Databases, Dimensions and Partitions
Using SQL Server Data Tools (SSDT)
Deploy Model Solutions Using the Deployment Wizard
Use a Template to Create an Action Deployment
Multidimensional models
Cube or model permissions Process permissions
Create Named Sets
Create User-Defined Hierarchies
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bolton
- 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 ... DirectQuery Mode
- See Training Course Details...
Import from Power View
Delete a Column
Create a Calculated Table
Process Database, Table, or Partition
DAX formula compatibility in DirectQuery mode Tables and Columns
Sort Data in a Table
Rename a Table or Column
Create a Calculated Column
Impersonation
Import data by using a native query
Create and Manage Hierarchies Partitions
Define partitions in DirectQuery models
Create and Manage Partitions in the Workspace
Database Process Partitions in the Workspace Database Perspectives
Import from Analysis Services
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Perspectives Translations Roles
Set the Data Type of a Column
Delete Relationships
Create and Manage Roles
Email us about this courses
Other Bolton Enable Technology Training Courses
JQuery Mobile - Bolton JavaScript Training Courses
Excel Power Pivot - Bolton Excel Training Courses
Power BI Bolton Training Courses
VBA - Bolton Excel Training Courses
Access VBA Bolton Training Courses
Report Builder Bolton Training Courses