SQL SERVER ANALYSIS SERVICES TRAINING COURSES TELFORD
About Enable Technology Telford SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Telford. 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are South Staffordshire Water PLC, Royal & Sun Alliance Group PLC, Royal Air Force, Carillion PLC, Cadbury PLC, GKN PLC, Yell Group PLC and Lloyds TSB Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Telford
- 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 ... KPIs Actions
- See Training Course Details...
Deployment Requirements and Considerations for Analysis Services Deployment
Configure Analysis Services Project Properties
Overview of SSAS Multidimensional Modelling
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Local Partitions
Database permissions
Change a Partition Source
Partition Writeback Calculations
Add or Remove Tables or Views in a Data Source View
Backup and Restore of Analysis Services Databases
Dimension permissions
Create a Dimension Using the Dimension Wizard
Deploy Model Solutions with the Deployment Utility
Batch Processing Remote Processing
Read Definition permissions
Create a Data Source
Document and Script an Analysis Services Database
Define a Regular Relationship and Regular Relationship Properties
Create Calculated Members
Data Source object permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Telford
- 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 ... Create a Calculated Table
- See Training Course Details...
Hide or freeze columns
Specify Mark as Date Table for use with Time Intelligence
Data types supported
Restore from Power Pivot
Change table, column
Manage Roles by using SSMS
Delete a Column
Create and Manage KPIs Hierarchies
Delete Relationships
Tabular model designer
Add sample data to DirectQuery models
Object-level security
Impersonation
Understanding DAX in Tabular Models Measures
Process Database, Table, or Partition
Enable DirectQuery mode in SSDT
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power View
Import from Power Pivot
Email us about this courses
Other Telford Enable Technology Training Courses
Report Builder - Telford SQL Server Reporting Services Training Courses
TSQL Telford Training Courses
JQuery Mobile Telford Training Courses
JavaScript Telford Training Courses
Access Telford Training Courses
SQL - Telford SQL Training Courses