SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKWOOD
About Enable Technology Blackwood 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. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. If you prefer we can offer an offsite socially distanced training location in Blackwood. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Keele University, Shell UK Oil Products Ltd, Nuclear Engineering Services, Dollond & Aitchison Limited, Royal & Sun Alliance Group PLC, Cadbury PLC, Birmingham City Council and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Blackwood
- 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 Data Source
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Create a Time Dimension by Generating a Time Table
Set Partition Storage
Data Source Views
BI Wizard
Dimension permissions
Define Named Queries in a Data Source View
Deploy Analysis Services Projects
Define Logical Relationships in a Data Source View
Database permissions
Use a Template to Create an Action Deployment
Use Aggregate Functions
Create a Dimension by Using an Existing Table
Work with Diagrams in Data Source View Designer
Move an Analysis Services Database
Designing Aggregations
Processing Options and Settings
Ragged Hierarchies
Create Calculated Members
Modify or Delete in Solution Explorer Database Dimensions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Blackwood
- 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 ... Import from Power Pivot
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Create a Calculated Column
Import data by using a native query
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Set the Data Type of a Column
Create and Manage Hierarchies Partitions
Import Data
Define partitions in DirectQuery models
Restore from Power Pivot
Delete Relationships
Sort Data in a Table
Data sources supported in tabular 1400 models
Manage Roles by using SSMS
Import from Analysis Services
Add columns to a table
Add sample data to DirectQuery models
Data types supported
Specify Mark as Date Table for use with Time Intelligence
Create and Manage KPIs Hierarchies
Email us about this courses
Other Blackwood Enable Technology Training Courses
Excel 365 Advanced - Blackwood Excel Training Courses
Access VBA Blackwood Training Courses
PL/SQL Blackwood Training Courses
Excel 365 Basic Blackwood Training Courses
Power BI Blackwood Training Courses
Oracle SQL - Blackwood SQL Training Courses