SQL SERVER ANALYSIS SERVICES TRAINING COURSES RHOSLLANERCHRUGOG
About Enable Technology Rhosllanerchrugog SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to 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 provide instructor led training coupled with hands on training. 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 Rhosllanerchrugog. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Keele University, Countrywide Homes Limited, Birmingham City University, Halfords Group PLC, Shell UK Oil Products Ltd, EDF Energy PLC, West Bromwich Building Society and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Rhosllanerchrugog
- 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 ... Modify or Delete an Analysis Services Database
- See Training Course Details...
Dimension permissions
Define Time Intelligence
Processing Options and Settings
Define Named Calculations in a Data Source View
Attach and Detach Analysis Services Databases
Add a Standard Action
Define Named Queries in a Data Source View
Calculations using the Business Intelligence Wizard
Create Local Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Create User-Defined Hierarchies
Designing Aggregations
Create Measures and Measure Groups
Authorizing access to objects and operations
Configure Analysis Services Project Properties
Create Remote Partitions
Set Impersonation Options for a Data Source Connection
Rename a Multidimensional Database Processing a multidimensional model
Define a Regular Relationship and Regular Relationship Properties
View the XML for an Analysis Services Project Data Sources
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Rhosllanerchrugog
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Import data by using a native query
Manage Roles by using SSMS
Connect to a tabular model database
Hide or freeze columns
Row filter mappings
Enable DirectQuery mode in SSDT
Version comparison
Data sources supported in SSAS tabular 2017
Create and Manage Roles
Create a Relationship Between Two Tables
Database Process Partitions in the Workspace Database Perspectives
Define partitions in DirectQuery models
Create and Manage Perspectives Translations Roles
Create a New Tabular Model Project
Delete a Column
Bi-directional cross filters Calculations
DirectQuery Mode
Create and Manage KPIs Hierarchies
Change table, column
Tabular model designer
Email us about this courses
Other Rhosllanerchrugog Enable Technology Training Courses
Excel 365 Basic Rhosllanerchrugog Training Courses
JQuery Mobile Rhosllanerchrugog Training Courses
Access - Rhosllanerchrugog Access Training Courses
TSQL - Rhosllanerchrugog SQL Training Courses
Oracle SQL - Rhosllanerchrugog SQL Training Courses
Excel 365 Advanced Rhosllanerchrugog Training Courses