SQL SERVER ANALYSIS SERVICES TRAINING COURSES OLDHAM
About Enable Technology Oldham 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. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. We can also deliver the SQL Server Analysis Services course at a local training venue in Oldham. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Cadbury PLC, Wolverhampton City Council, National Power PLC, Nuclear Engineering Services, Vodafone Group Services, Countrywide Homes Limited, Lloyds TSB Bank PLC and Dollond & Aitchison Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Oldham
- 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 ... Create a Dimension Using the Dimension Wizard
- See Training Course Details...
Create Remote Partitions
Add or Remove Tables or Views in a Data Source View
Change a Partition Source
Batch Processing Remote Processing
Ragged Hierarchies
Deploy Analysis Services Projects
Read Definition permissions
Add a Standard Action
Processing Databases, Dimensions and Partitions
Document and Script an Analysis Services Database
Define Assignments and Other Script Commands
Deploy Model Solutions Using the Deployment Wizard
Create Named Sets
Defined Linked Measure Groups Partitions
Processing Options and Settings
Define a Referenced Relationship and Referenced Relationship Properties
Set Partition Storage
Backup Options Restore Options
BI Wizard
Create User-Defined Hierarchies
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Oldham
- 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 and Manage KPIs Hierarchies
- See Training Course Details...
Process Tabular Model Partitions
Manage Roles by using SSMS
Create a Calculated Table
Create and Manage Partitions in the Workspace
Data sources supported in tabular 1400 models
Create a New Tabular Model Project
Analyze in Excel
Add a table Delete a Table
Create and Manage Measures KPIs
Hide or freeze columns
Add sample data to DirectQuery models
Import Data
Import from Power View
Define partitions in DirectQuery models
Enable DirectQuery mode in SSMS
Row filter mappings
Data types supported
Set the Data Type of a Column
Delete Relationships
Email us about this courses
Other Oldham Enable Technology Training Courses
JavaScript Oldham Training Courses
Excel 365 Advanced Oldham Training Courses
JQuery Oldham Training Courses
Power Query Oldham Training Courses
Excel Power Pivot - Oldham Excel Training Courses
Report Builder Oldham Training Courses