SQL SERVER ANALYSIS SERVICES TRAINING COURSES STOCKPORT
About Enable Technology Stockport SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in Stockport. 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. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Keele University, EDF Energy PLC, Cadbury PLC, South Staffordshire Water PLC, Nationwide Building Society Limited, Total Telecommunications Limited, Canadian High Commission and Carillion PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stockport
- 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 ... Dimension permissions
- See Training Course Details...
Define a Fact Relationship and Fact Relationship Properties
View the XML for an Analysis Services Project Data Sources
Calculations using the Business Intelligence Wizard
Add or Remove Tables or Views in a Data Source View
Move an Analysis Services Database
Deployment Requirements and Considerations for Analysis Services Deployment
Deploy Model Solutions with the Deployment Utility
Set Data Source Properties
Data Source Views
Create Calculated Members
Work with Diagrams in Data Source View Designer
Partition Writeback Calculations
Batch Processing Remote Processing
Change a Partition Source
Deploy Model Solutions Using the Deployment Wizard
Create Remote Partitions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Data Source object permissions
Create a Data Source
Configure Analysis Services Project Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stockport
- 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 Database, Table, or Partition
- See Training Course Details...
Data types supported
Bi-directional cross filters Calculations
Create and Manage Roles
Analyze in Excel
Specify Mark as Date Table for use with Time Intelligence
Create a Calculated Table
Import data by using a native query
Restore from Power Pivot
Manage Roles by using SSMS
Version comparison
Create a New Tabular Model Project
Process Tabular Model Partitions
Change table, column
Define partitions in DirectQuery models
Tabular model designer
Impersonation
Add sample data to DirectQuery models
Row filter mappings
Email us about this courses
Other Stockport Enable Technology Training Courses
Excel 365 Basic - Stockport Excel Training Courses
PL/SQL - Stockport SQL Training Courses
Power Query Stockport Training Courses
DAX Stockport Training Courses
Oracle SQL - Stockport SQL Training Courses
SSRS - Stockport SQL Server Reporting Services Training Courses