SQL SERVER ANALYSIS SERVICES TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Professionals. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. If you prefer we can offer an offsite training location in Stratford Upon Avon. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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 team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Vodafone Group Services, GKN PLC, Canadian High Commission, Capita Group PLC, South Staffordshire Water PLC, Cadbury PLC, Aston University and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stratford Upon Avon
- 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 Measures KPIs
- See Training Course Details...
Add sample data to DirectQuery models
Add columns to a table
Bi-directional cross filters Calculations
Restore from Power Pivot
Import data by using a native query
Deploy from SQL Server Data Tools Manage Tabular Model Databases
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in tabular 1200 models
Object-level security
Add a table Delete a Table
Set the Data Type of a Column
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSDT
Import from Analysis Services
Create and Manage Hierarchies Partitions
Sort Data in a Table
Data sources supported in SSAS tabular 2017
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Error Configuration Roles and Permissions
- See Training Course Details...
Define Named Calculations in a Data Source View
Read Definition permissions
Define Named Queries in a Data Source View
Define Assignments and Other Script Commands
Create an Analysis Services Project
Designing Aggregations
Data Source object permissions
Delete a Data Source
Add or Remove Tables or Views in a Data Source View
Authorizing access to objects and operations
Replace a Table or a Named Query in a Data Source View
Attach and Detach Analysis Services Databases
Test an Action
Create Measures and Measure Groups
Define Logical Primary Keys in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using XMLA
Deployment Requirements and Considerations for Analysis Services Deployment
Processing Options and Settings
Supported Data Sources
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
Access VBA Stratford Upon Avon Training Courses
JavaScript - Stratford Upon Avon JavaScript Training Courses
VBA Stratford Upon Avon Training Courses
Report Builder - Stratford Upon Avon SQL Server Reporting Services Training Courses
SSRS - Stratford Upon Avon SQL Server Reporting Services Training Courses
Excel 365 Basic Stratford Upon Avon Training Courses