SQL SERVER ANALYSIS SERVICES TRAINING COURSES HALESOWEN
About Enable Technology Halesowen SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. We guarantee the training will be delivered by a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Halesowen. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Canadian High Commission, Yell Group PLC, DHL Express, Barclays Bank PLC, Shell UK Oil Products Ltd, Unipart Group, Royal & Sun Alliance Group PLC and Birmingham City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Halesowen
- 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 ... Data sources supported in tabular 1200 models
- See Training Course Details...
Impersonation
Create and Manage KPIs Hierarchies
Rename a Table or Column
Change table, column
Version comparison
Manage Roles by using SSMS
Object-level security
Add a table Delete a Table
Enable DirectQuery mode in SSDT
Process Tabular Model Partitions
Analyze in Excel
Define partitions in DirectQuery models
Import from Power View
Restore from Power Pivot
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1400 models
Enable DirectQuery mode in SSMS
Create a Calculated Column
DirectQuery Mode
Import data by using a native query
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Halesowen
- 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 ... Deploy Model Solutions with the Deployment Utility
- See Training Course Details...
Processing Options and Settings
Backup and Restore of Analysis Services Databases
Create Local Partitions
Create a Dimension Using the Dimension Wizard
Create Named Sets
Overview of SSAS Multidimensional Modelling
Create an Analysis Services Project
Define Logical Relationships in a Data Source View
Dimension permissions
Error Configuration Roles and Permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Deploy Analysis Services Projects
Define Logical Primary Keys in a Data Source View
Defined Linked Measure Groups Partitions
Calculations using the Business Intelligence Wizard
Replace a Table or a Named Query in a Data Source View
Add or Remove Tables or Views in a Data Source View
Authorizing access to objects and operations
Create a Dimension by Using an Existing Table
Deploy Model Solutions Using the Deployment Wizard
Email us about this courses
Other Halesowen Enable Technology Training Courses
VBA Halesowen Training Courses
SSRS - Halesowen SQL Server Reporting Services Training Courses
PL/SQL Halesowen Training Courses
DAX - Halesowen Excel Training Courses
Power BI - Halesowen Microsoft Power BI Training Courses
Oracle SQL Halesowen Training Courses