SQL SERVER ANALYSIS SERVICES TRAINING COURSES DEVON
About Enable Technology Devon SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
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. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a local training venue in Devon. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Homeserve PLC, Unipart Group, Barclays Bank PLC, Norfolk Police Constabulary, Boots UK Limited, West Bromwich Building Society, Halfords Group PLC and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Devon
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Impersonation
Enable DirectQuery mode in SSMS
Set the Data Type of a Column
Create and Manage Perspectives Translations Roles
Row filter mappings
Import from Analysis Services
Connect to a tabular model database
Data sources supported in tabular 1200 models
Data sources supported in SSAS tabular 2016 Create Tabular Models
Restore from Power Pivot
Create and Manage Roles
DirectQuery Mode
Create a Calculated Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage KPIs Hierarchies
Import data by using a native query
Analyze in Excel
Enable DirectQuery mode in SSDT
Specify Mark as Date Table for use with Time Intelligence
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Devon
- 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 ... Backup and Restore of Analysis Services Databases
- See Training Course Details...
Create Named Sets
Use Aggregate Functions
Define a Regular Relationship and Regular Relationship Properties
Create an Analysis Services Project
Create Measures and Measure Groups
Test an Action
Set Data Source Properties
Move an Analysis Services Database
Define Time Intelligence
Edit or Delete Partitions Merge Partitions
Add a Standard Action
Create a Data Source
Deploy Model Solutions with the Deployment Utility
Create Local Partitions
Tools and Approaches for Processing
Explore Data in a Data Source View
Dimension permissions
Define Logical Relationships in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Define Named Calculations in a Data Source View
Email us about this courses
Other Devon Enable Technology Training Courses
Data Warehouse - Devon SQL Training Courses
Access VBA Devon Training Courses
TSQL Devon Training Courses
SQL Devon Training Courses
Power BI Devon Training Courses
JavaScript Devon Training Courses