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 of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Stockport. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Norwich Union PLC, Norfolk Police Constabulary, Loughborough University, DHL Express, Birmingham City Council, Capita Group PLC, Canadian High Commission and Unipart Group.
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 ... Object-level security
- See Training Course Details...
Test a model in DirectQuery mode
Import from Analysis Services
Delete Relationships
Hide or freeze columns
Version comparison
Restore from Power Pivot
Analyze in Excel
Row filter mappings
Manage Roles by using SSMS
Data sources supported in tabular 1200 models
Specify Mark as Date Table for use with Time Intelligence
Data sources supported in tabular 1400 models
Connect to a tabular model database
Create a Relationship Between Two Tables
Create and Manage Perspectives Translations Roles
Sort Data in a Table
Topics include- Overview of SSAS Tabular models
Delete a Column
Enable DirectQuery mode in SSMS
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 ... Define a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Dimension permissions
Deployment Requirements and Considerations for Analysis Services Deployment
Data Source Views
Define Named Queries in a Data Source View
Edit or Delete Partitions Merge Partitions
Work with Diagrams in Data Source View Designer
Create Measures and Measure Groups
Designing Aggregations
Authorizing access to objects and operations
Data Source object permissions
Create Named Sets
Set Impersonation Options for a Data Source Connection
Cube or model permissions Process permissions
Create an Analysis Services Project
Define Logical Relationships in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Attach and Detach Analysis Services Databases
Add a Standard Action
Ragged Hierarchies
Supported Data Sources
Email us about this courses
Other Stockport Enable Technology Training Courses
Excel 365 Advanced - Stockport Excel Training Courses
Data Warehouse Stockport Training Courses
VBA - Stockport Excel Training Courses
Power Query - Stockport Excel Training Courses
DAX - Stockport Excel Training Courses
Power BI - Stockport Microsoft Power BI Training Courses