SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATLEY
About Enable Technology Batley SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with SQL Server Analysis Services training materials which they keep 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.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We are also more than happy to organise a local course at a training location in Batley. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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 team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Dollond & Aitchison Limited, Keele University, Lloyds TSB Bank PLC, Wolverhampton City Council, Birmingham Heartlands Hospital, Queen's Medical Centre Nottingham, Vodafone Group Services and Birmingham City University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Batley
- 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 ... Designing Aggregations
- See Training Course Details...
Create an Analysis Services Project
Create a Dimension Using the Dimension Wizard
Use a Template to Create an Action Deployment
Configure Measure Group Properties
Create Measures and Measure Groups
Data Source Views
Create a Time Dimension by Generating a Time Table
Delete a Data Source View Dimensions
Move an Analysis Services Database
Define Assignments and Other Script Commands
Supported Data Sources
Add a Standard Action
Data Source object permissions
Add or Remove Tables or Views in a Data Source View
Define a Data Source View
Define Attribute Relationships
Define a Referenced Relationship and Referenced Relationship Properties
Configure Analysis Services Project Properties
Deploy Analysis Services Projects
Define Named Queries in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Batley
- 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 ... Analyze a tabular model in Excel Deploy tabular model solutions
- See Training Course Details...
Enable DirectQuery mode in SSMS
Impersonation
Create and Manage Perspectives Translations Roles
Data sources supported in tabular 1200 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Tabular model designer
Understanding DAX in Tabular Models Measures
DirectQuery Mode
Analyze in Excel
Create a Relationship Between Two Tables
Define partitions in DirectQuery models
Rename a Table or Column
Import from Power Pivot
Connect to a tabular model database
Row filter mappings
Data sources supported in SSAS tabular 2017
Sort Data in a Table
Create and Manage Hierarchies Partitions
Specify Mark as Date Table for use with Time Intelligence
Email us about this courses
Other Batley Enable Technology Training Courses
Excel Power Pivot - Batley Excel Training Courses
TSQL - Batley SQL Training Courses
Data Warehouse Batley Training Courses
SQL Batley Training Courses
JavaScript Batley Training Courses
JQuery Mobile Batley Training Courses