SQL SERVER ANALYSIS SERVICES TRAINING COURSES CHORLEY
About Enable Technology Chorley SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a training location in Chorley. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: University of Birmingham, Norfolk Police Constabulary, Canadian High Commission, Lloyds TSB Bank PLC, Countrywide Homes Limited, Boots UK Limited, Royal & Sun Alliance Group PLC and Wolverhampton City Council.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Chorley
- 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 ... Process Database, Table, or Partition
- See Training Course Details...
Rename a Table or Column
Add sample data to DirectQuery models
Enable DirectQuery mode in SSMS
Create a Calculated Column
Understanding DAX in Tabular Models Measures
Analyze in Excel
Create and Manage Partitions in the Workspace
Create and Manage Roles
Analyze a tabular model in Excel Deploy tabular model solutions
Restore from Power Pivot
Change table, column
Enable DirectQuery mode in SSDT
Create a Relationship Between Two Tables
Version comparison
Data sources supported in tabular 1200 models
Set the Data Type of a Column
Test a model in DirectQuery mode
Define partitions in DirectQuery models
Create and Manage Perspectives Translations Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Chorley
- 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 ... Processing Databases, Dimensions and Partitions
- See Training Course Details...
Define a Regular Relationship and Regular Relationship Properties
Data Source Views
Use Aggregate Functions
Work with Diagrams in Data Source View Designer
Designing Aggregations
Modify or Delete an Analysis Services Database
Delete a Data Source
Error Configuration Roles and Permissions
BI Wizard
Document and Script an Analysis Services Database
Create Calculated Members
Deploy Model Solutions with the Deployment Utility
Move an Analysis Services Database
Batch Processing Remote Processing
Deployment Requirements and Considerations for Analysis Services Deployment
Using SQL Server Data Tools (SSDT)
Processing Options and Settings
Define Logical Relationships in a Data Source View
Create Named Sets
Set Partition Storage
Email us about this courses
Other Chorley Enable Technology Training Courses
Excel 365 Advanced Chorley Training Courses
Power Query Chorley Training Courses
Excel 365 Basic - Chorley Excel Training Courses
SQL Chorley Training Courses
VBA - Chorley Excel Training Courses
JQuery Mobile Chorley Training Courses