SQL SERVER ANALYSIS SERVICES TRAINING COURSES LANCASTER
About Enable Technology Lancaster SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All Enable Technology tutors are Microsoft certified experts. 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.
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. Alternatively we could schedule a course at a local venue in Lancaster. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Loughborough University, South Staffordshire Water PLC, Aston University, Countrywide Homes Limited, Unipart Group, Boots UK Limited and West Bromwich Building Society.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Lancaster
- 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...
Modify or Delete an Analysis Services Database
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Backup Options Restore Options
View the XML for an Analysis Services Project Data Sources
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Attribute Relationships
Replace a Table or a Named Query in a Data Source View
Create a Dimension by Using an Existing Table
Ragged Hierarchies
Create Calculated Members
Delete a Data Source View Dimensions
Authorizing access to objects and operations
Deploy Model Solutions Using the Deployment Wizard
Batch Processing Remote Processing
Add or Remove Tables or Views in a Data Source View
Explore Data in a Data Source View
Set Impersonation Options for a Data Source Connection
Tools and Approaches for Processing
Create a Time Dimension by Generating a Time Table
Dimension permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Lancaster
- 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...
Object-level security
Import Data
Row filter mappings
Tabular model designer
Import data by using a native query
Sort Data in a Table
Set the Data Type of a Column
Create and Manage Measures KPIs
Add a table Delete a Table
Version comparison
Bi-directional cross filters Calculations
Create and Manage Perspectives Translations Roles
Manage Roles by using SSMS
Understanding DAX in Tabular Models Measures
DirectQuery Mode
Add columns to a table
Create a Relationship Between Two Tables
Impersonation
Data sources supported in tabular 1400 models
Email us about this courses
Other Lancaster Enable Technology Training Courses
VBA - Lancaster Excel Training Courses
Report Builder - Lancaster SQL Server Reporting Services Training Courses
Excel 365 Intermediate Lancaster Training Courses
JavaScript - Lancaster JavaScript Training Courses
Excel 365 Basic Lancaster Training Courses
PL/SQL - Lancaster SQL Training Courses