SQL SERVER ANALYSIS SERVICES TRAINING COURSES GORSEINON
About Enable Technology Gorseinon 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 Solutions Experts with development backgrounds. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a course at a local venue in Gorseinon. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Aston University, Barclays Bank PLC, GKN PLC, Norwich Union PLC, Norfolk Police Constabulary, Capita Group PLC, Vodafone Group Services and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Define Attribute Relationships
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Define Logical Primary Keys in a Data Source View
Define a Referenced Relationship and Referenced Relationship Properties
Delete a Data Source View Dimensions
Calculations using the Business Intelligence Wizard
Define Named Queries in a Data Source View
Cube or model permissions Process permissions
Change a Partition Source
Backup Options Restore Options
Modify or Delete in Solution Explorer Database Dimensions
Create Local Partitions
Deploy Model Solutions with the Deployment Utility
Define Assignments and Other Script Commands
Rename a Multidimensional Database Processing a multidimensional model
Define Time Intelligence
Batch Processing Remote Processing
Define Semiadditive Behavior
Error Configuration Roles and Permissions
Replace a Table or a Named Query in a Data Source View
Read Definition permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Gorseinon
- 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 ... Database Process Partitions in the Workspace Database Perspectives
- See Training Course Details...
Create and Manage Roles
Version comparison
Bi-directional cross filters Calculations
Create a Calculated Table
Topics include- Overview of SSAS Tabular models
Rename a Table or Column
Add sample data to DirectQuery models
Create a Calculated Column
Create and Manage KPIs Hierarchies
Specify Mark as Date Table for use with Time Intelligence
Process Tabular Model Partitions
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSDT
Sort Data in a Table
Object-level security
Restore from Power Pivot
Impersonation
Filter Data in a Table Relationships
Add columns to a table
Email us about this courses
Other Gorseinon Enable Technology Training Courses
SSIS - Gorseinon SQL Server Integration Services Training Courses
Power BI - Gorseinon Microsoft Power BI Training Courses
JQuery Mobile Gorseinon Training Courses
SSRS Gorseinon Training Courses
Power Query Gorseinon Training Courses
VBA - Gorseinon Excel Training Courses