SQL SERVER ANALYSIS SERVICES TRAINING COURSES OLDHAM
About Enable Technology Oldham SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Oldham. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Carillion PLC, Barclays Bank PLC, Royal Air Force, Capita Group PLC, Halfords Group PLC, Aston University, Birmingham City Council and Keele University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Oldham
- 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 ... Delete a Data Source View Dimensions
- See Training Course Details...
Modify or Delete in Solution Explorer Database Dimensions
Create a Time Dimension by Generating a Time Table
Read Definition permissions
Replace a Table or a Named Query in a Data Source View
Partition Writeback Calculations
Create a Dimension by Generating a Non-Time Table in the Data Source
Define a Regular Relationship and Regular Relationship Properties
Tools and Approaches for Processing
Delete a Data Source
Create Calculated Members
Using SQL Server Data Tools (SSDT)
Data Source Views
Define Assignments and Other Script Commands
Define a Data Source View
Cube or model permissions Process permissions
KPIs Actions
Overview of SSAS Multidimensional Modelling
Change a Partition Source
Set Impersonation Options for a Data Source Connection
Define Named Queries in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Oldham
- 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 and Manage Hierarchies Partitions
- See Training Course Details...
Impersonation
Data sources supported in tabular 1200 models
Filter Data in a Table Relationships
Data types supported
Manage Roles by using SSMS
Set the Data Type of a Column
Restore from Power Pivot
Delete Relationships
Understanding DAX in Tabular Models Measures
Create and Manage Perspectives Translations Roles
Object-level security
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage Measures KPIs
Create and Manage Roles
Import data by using a native query
Version comparison
Create a Calculated Column
Bi-directional cross filters Calculations
Email us about this courses
Other Oldham Enable Technology Training Courses
SSIS - Oldham SQL Server Integration Services Training Courses
Excel Power Pivot Oldham Training Courses
Excel 365 Intermediate Oldham Training Courses
SSRS - Oldham SQL Server Reporting Services Training Courses
JQuery Mobile - Oldham JavaScript Training Courses
Excel 365 Advanced - Oldham Excel Training Courses