SQL SERVER ANALYSIS SERVICES TRAINING COURSES NORMANTON
About Enable Technology Normanton SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If delivery onsite is an issue we will organise a venue near you in Normanton. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Nationwide Building Society Limited, Canadian High Commission, TalkTalk Direct Limited, Nuclear Engineering Services, Keele University, West Bromwich Building Society, Yell Group PLC and Loughborough University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Normanton
- 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 Calculated Table
- See Training Course Details...
Data sources supported in tabular 1200 models
Row filter mappings
Create and Manage Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Delete Relationships
Add a table Delete a Table
Topics include- Overview of SSAS Tabular models
Data types supported
Create and Manage Roles
Object-level security
Import from Power View
Create and Manage Partitions in the Workspace
Change table, column
Manage Roles by using SSMS
Import from Analysis Services
Hide or freeze columns
Data sources supported in SSAS tabular 2016 Create Tabular Models
Database Process Partitions in the Workspace Database Perspectives
Import data by using a native query
Connect to a tabular model database
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Normanton
- 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 ... Use Aggregate Functions
- See Training Course Details...
Processing Options and Settings
Create Local Partitions
BI Wizard
Data Source Views
Deploy Analysis Services Projects
Set Partition Storage
Define Logical Primary Keys in a Data Source View
Calculations using the Business Intelligence Wizard
Define a Data Source View
Define Assignments and Other Script Commands
Deploy Model Solutions Using XMLA
Using SQL Server Data Tools (SSDT)
Create Named Sets
Ragged Hierarchies
Data Source object permissions
Define Time Intelligence
Create Calculated Members
Create a Time Dimension by Generating a Time Table
Test an Action
Define a Regular Relationship and Regular Relationship Properties
Email us about this courses
Other Normanton Enable Technology Training Courses
JQuery Mobile - Normanton JavaScript Training Courses
Excel 365 Intermediate - Normanton Excel Training Courses
Excel Power Pivot - Normanton Excel Training Courses
JQuery - Normanton JavaScript Training Courses
Data Warehouse - Normanton SQL Training Courses
Oracle SQL - Normanton SQL Training Courses