SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDGNORTH
About Enable Technology Bridgnorth 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 Professionals. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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 deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Bridgnorth. 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 SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Norwich Union PLC, Cadbury PLC, EDF Energy PLC, Aston University, University of Birmingham, Queen's Medical Centre Nottingham, Dollond & Aitchison Limited and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... Set Partition Storage
- See Training Course Details...
Create a Dimension by Using an Existing Table
Backup Options Restore Options
Ragged Hierarchies
Processing Options and Settings
Create User-Defined Hierarchies
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Database permissions
Configure Analysis Services Project Properties
View the XML for an Analysis Services Project Data Sources
Designing Aggregations
Using SQL Server Data Tools (SSDT)
Define Time Intelligence
Configure Measure Group Properties
Delete a Data Source
Authorizing access to objects and operations
Define a Fact Relationship and Fact Relationship Properties
Deploy Model Solutions Using XMLA
Data Source Views
Set Impersonation Options for a Data Source Connection
Create a Dimension by Generating a Non-Time Table in the Data Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... DirectQuery Mode
- See Training Course Details...
Add columns to a table
Create a Calculated Column
Set the Data Type of a Column
Create a Relationship Between Two Tables
Object-level security
Import Data
Create a Calculated Table
Enable DirectQuery mode in SSDT
Create and Manage Hierarchies Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Hide or freeze columns
Data types supported
Data sources supported in SSAS tabular 2017
Import from Analysis Services
Add a table Delete a Table
Topics include- Overview of SSAS Tabular models
Create and Manage Perspectives Translations Roles
Specify Mark as Date Table for use with Time Intelligence
Email us about this courses
Other Bridgnorth Enable Technology Training Courses
TSQL Bridgnorth Training Courses
SQL Bridgnorth Training Courses
Data Warehouse Bridgnorth Training Courses
Excel 365 Advanced - Bridgnorth Excel Training Courses
Access Bridgnorth Training Courses
JavaScript - Bridgnorth JavaScript Training Courses