SQL SERVER ANALYSIS SERVICES TRAINING COURSES SOMERSET
About Enable Technology Somerset SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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.
We provide instructor led training coupled with hands on training. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Somerset. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Loughborough University, Vodafone Group Services, Wolverhampton City Council, Shell UK Oil Products Ltd, Nuclear Engineering Services, Royal Air Force, Yell Group PLC and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Somerset
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Define Time Intelligence
Create Remote Partitions
Define Named Calculations in a Data Source View
Create Measures and Measure Groups
Define Assignments and Other Script Commands
Add a Standard Action
Define Attribute Relationships
Use a Template to Create an Action Deployment
Data Source Views
Data Source object permissions
Deploy Model Solutions with the Deployment Utility
Multidimensional models
Authorizing access to objects and operations
Designing Aggregations
View the XML for an Analysis Services Project Data Sources
Set Partition Storage
Modify or Delete in Solution Explorer Database Dimensions
Edit or Delete Partitions Merge Partitions
Add or Remove Tables or Views in a Data Source View
Define a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Somerset
- 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 ... Import from Analysis Services
- See Training Course Details...
Change table, column
Import data by using a native query
Understanding DAX in Tabular Models Measures
Data sources supported in SSAS tabular 2017
Connect to a tabular model database
Create and Manage Hierarchies Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Define partitions in DirectQuery models
Object-level security
Test a model in DirectQuery mode
Filter Data in a Table Relationships
Create and Manage Perspectives Translations Roles
Hide or freeze columns
Sort Data in a Table
Bi-directional cross filters Calculations
Impersonation
Add a table Delete a Table
Enable DirectQuery mode in SSMS
Process Tabular Model Partitions
Specify Mark as Date Table for use with Time Intelligence
Email us about this courses
Other Somerset Enable Technology Training Courses
Excel 365 Intermediate - Somerset Excel Training Courses
Excel Power Pivot - Somerset Excel Training Courses
Excel 365 Advanced Somerset Training Courses
Excel 365 Basic - Somerset Excel Training Courses
DAX Somerset Training Courses
JQuery Somerset Training Courses