SQL SERVER ANALYSIS SERVICES TRAINING COURSES COVENTRY
About Enable Technology Coventry SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a course at a local venue in Coventry. 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.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are GKN PLC, Countrywide Homes Limited, Cadbury PLC, University of Birmingham, Royal Air Force, DHL Express, Birmingham City Council and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Coventry
- 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 ... Create Remote Partitions
- See Training Course Details...
Create Measures and Measure Groups
Configure Analysis Services Project Properties
Define Named Queries in a Data Source View
BI Wizard
Define Attribute Relationships
Data Source object permissions
Multidimensional models
Define Time Intelligence
Delete a Data Source View Dimensions
Rename a Multidimensional Database Processing a multidimensional model
Calculations using the Business Intelligence Wizard
Define a Referenced Relationship and Referenced Relationship Properties
Use a Template to Create an Action Deployment
Define a Regular Relationship and Regular Relationship Properties
Move an Analysis Services Database
Explore Data in a Data Source View
Define Assignments and Other Script Commands
Create a Dimension by Generating a Non-Time Table in the Data Source
Backup Options Restore Options
Set Partition Storage
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Coventry
- 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 ... Bi-directional cross filters Calculations
- See Training Course Details...
Change table, column
Delete Relationships
Enable DirectQuery mode in SSMS
Process Database, Table, or Partition
Version comparison
Create and Manage Perspectives Translations Roles
Create and Manage Roles
Data types supported
DAX formula compatibility in DirectQuery mode Tables and Columns
Filter Data in a Table Relationships
Manage Roles by using SSMS
Understanding DAX in Tabular Models Measures
Import from Power Pivot
Analyze a tabular model in Excel Deploy tabular model solutions
Analyze in Excel
Create a Relationship Between Two Tables
Test a model in DirectQuery mode
Create a Calculated Table
Set the Data Type of a Column
Topics include- Overview of SSAS Tabular models
Email us about this courses
Other Coventry Enable Technology Training Courses
Report Builder Coventry Training Courses
Excel 365 Advanced Coventry Training Courses
Excel 365 Intermediate - Coventry Excel Training Courses
SQL Coventry Training Courses
Access - Coventry Access Training Courses
Data Warehouse - Coventry SQL Training Courses