SQL SERVER ANALYSIS SERVICES TRAINING COURSES MACCLESFIELD
About Enable Technology Macclesfield SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local training site in Macclesfield. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Norwich Union PLC, National Power PLC, Shell UK Oil Products Ltd, Total Telecommunications Limited, Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Birmingham City University and West Bromwich Building Society.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Macclesfield
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage Hierarchies Partitions
Data sources supported in SSAS tabular 2017
Add columns to a table
Bi-directional cross filters Calculations
Set the Data Type of a Column
Database Process Partitions in the Workspace Database Perspectives
Delete Relationships
Create a Calculated Column
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Perspectives Translations Roles
Create a Calculated Table
Delete a Column
Process Tabular Model Partitions
Filter Data in a Table Relationships
Change table, column
Data sources supported in tabular 1400 models
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Macclesfield
- 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 Data Source View
- See Training Course Details...
Explore Data in a Data Source View
Defined Linked Measure Groups Partitions
Create Measures and Measure Groups
Define Attribute Relationships
Create a Dimension by Generating a Non-Time Table in the Data Source
Create Remote Partitions
Configure Analysis Services Project Properties
Add a Standard Action
Define a Regular Relationship and Regular Relationship Properties
Modify or Delete an Analysis Services Database
Deploy Analysis Services Projects
Create User-Defined Hierarchies
Set Data Source Properties
Document and Script an Analysis Services Database
Calculations using the Business Intelligence Wizard
Work with Diagrams in Data Source View Designer
Define Semiadditive Behavior
Create an Analysis Services Project
Delete a Data Source
Cube or model permissions Process permissions
Email us about this courses
Other Macclesfield Enable Technology Training Courses
Power Query Macclesfield Training Courses
Data Warehouse Macclesfield Training Courses
DAX - Macclesfield Excel Training Courses
Access VBA - Macclesfield Access Training Courses
SQL Macclesfield Training Courses
SSIS - Macclesfield SQL Server Integration Services Training Courses