SQL SERVER ANALYSIS SERVICES TRAINING COURSES REDDITCH
About Enable Technology Redditch SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a training location in Redditch. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Shell UK Oil Products Ltd, Countrywide Homes Limited, Yell Group PLC, EDF Energy PLC, TalkTalk Direct Limited, Homeserve PLC, Loughborough University and Boots UK Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Redditch
- 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 Logical Relationships in a Data Source View
- See Training Course Details...
Set Data Source Properties
View the XML for an Analysis Services Project Data Sources
Define Semiadditive Behavior
Defined Linked Measure Groups Partitions
Deployment Requirements and Considerations for Analysis Services Deployment
Calculations using the Business Intelligence Wizard
Edit or Delete Partitions Merge Partitions
Replace a Table or a Named Query in a Data Source View
Configure Measure Group Properties
Create Measures and Measure Groups
Define Named Calculations in a Data Source View
Move an Analysis Services Database
Overview of SSAS Multidimensional Modelling
Document and Script an Analysis Services Database
Define a Regular Relationship and Regular Relationship Properties
Read Definition permissions
Data Source Views
Processing Databases, Dimensions and Partitions
Test an Action
Batch Processing Remote Processing
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Redditch
- 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 ... Sort Data in a Table
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Define partitions in DirectQuery models
Restore from Power Pivot
Set the Data Type of a Column
Tabular model designer
Create a Relationship Between Two Tables
Import Data
Hide or freeze columns
Create and Manage Tabular Model Partitions
Import from Analysis Services
Analyze in Excel
Row filter mappings
Bi-directional cross filters Calculations
Analyze a tabular model in Excel Deploy tabular model solutions
Manage Roles by using SSMS
Create and Manage Measures KPIs
Change table, column
Email us about this courses
Other Redditch Enable Technology Training Courses
JQuery Mobile Redditch Training Courses
Excel 365 Advanced Redditch Training Courses
SSRS - Redditch SQL Server Reporting Services Training Courses
PL/SQL Redditch Training Courses
Access - Redditch Access Training Courses
JQuery - Redditch JavaScript Training Courses