SQL SERVER ANALYSIS SERVICES TRAINING COURSES GRIMSBY
About Enable Technology Grimsby SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. If delivery onsite is an issue we will organise a venue near you in Grimsby. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Shell UK Oil Products Ltd, Aston University, Barclays Bank PLC, Countrywide Homes Limited, Queen's Medical Centre Nottingham, Birmingham Heartlands Hospital, GKN PLC and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Grimsby
- 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 a Time Dimension by Generating a Time Table
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Create a Dimension Using the Dimension Wizard
Create Calculated Members
Create an Analysis Services Project
Define a Referenced Relationship and Referenced Relationship Properties
View the XML for an Analysis Services Project Data Sources
BI Wizard
Partition Writeback Calculations
Error Configuration Roles and Permissions
Processing Options and Settings
Change a Partition Source
Use a Template to Create an Action Deployment
Configure Analysis Services Project Properties
Delete a Data Source
Database permissions
Define Time Intelligence
Rename a Multidimensional Database Processing a multidimensional model
Create a Dimension by Generating a Non-Time Table in the Data Source
Set Impersonation Options for a Data Source Connection
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Grimsby
- 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 ... Create a Relationship Between Two Tables
- See Training Course Details...
Sort Data in a Table
Data sources supported in tabular 1200 models
Hide or freeze columns
Connect to a tabular model database
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Roles
Import data by using a native query
Object-level security
Filter Data in a Table Relationships
Create a Calculated Column
Delete a Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Process Database, Table, or Partition
Delete Relationships
DirectQuery Mode
DAX formula compatibility in DirectQuery mode Tables and Columns
Manage Roles by using SSMS
Change table, column
Create and Manage Perspectives Translations Roles
Set the Data Type of a Column
Email us about this courses
Other Grimsby Enable Technology Training Courses
SSIS - Grimsby SQL Server Integration Services Training Courses
TSQL Grimsby Training Courses
SQL Grimsby Training Courses
Power BI Grimsby Training Courses
DAX Grimsby Training Courses
JQuery Mobile - Grimsby JavaScript Training Courses