SQL SERVER ANALYSIS SERVICES TRAINING COURSES WETHERBY
About Enable Technology Wetherby SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Alternatively we could schedule a course at a local venue in Wetherby. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
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 Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Birmingham City University, University of Birmingham, Loughborough University, Vodafone Group Services, Queen's Medical Centre Nottingham, Homeserve PLC, Total Telecommunications Limited and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wetherby
- 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 ... Process Database, Table, or Partition
- See Training Course Details...
Create and Manage Hierarchies Partitions
Add sample data to DirectQuery models
Object-level security
Create and Manage Measures KPIs
DirectQuery Mode
Create and Manage KPIs Hierarchies
Add a table Delete a Table
Define partitions in DirectQuery models
Connect to a tabular model database
Impersonation
Data sources supported in tabular 1400 models
Version comparison
Database Process Partitions in the Workspace Database Perspectives
Test a model in DirectQuery mode
Rename a Table or Column
Create a Relationship Between Two Tables
Understanding DAX in Tabular Models Measures
Delete Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wetherby
- 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 ... BI Wizard
- See Training Course Details...
Using SQL Server Data Tools (SSDT)
Data Source object permissions
Deploy Model Solutions Using the Deployment Wizard
Create an Analysis Services Project
Define a Data Source View
Define Time Intelligence
Define Logical Primary Keys in a Data Source View
Attach and Detach Analysis Services Databases
Define Named Queries in a Data Source View
Create Remote Partitions
Test an Action
Tools and Approaches for Processing
Backup Options Restore Options
Define Named Calculations in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Create Measures and Measure Groups
Add or Remove Tables or Views in a Data Source View
Data Source Views
View the XML for an Analysis Services Project Data Sources
Error Configuration Roles and Permissions
Email us about this courses
Other Wetherby Enable Technology Training Courses
SQL Wetherby Training Courses
Oracle SQL - Wetherby SQL Training Courses
Data Warehouse - Wetherby SQL Training Courses
Access Wetherby Training Courses
Excel 365 Advanced Wetherby Training Courses
DAX Wetherby Training Courses