SQL SERVER ANALYSIS SERVICES TRAINING COURSES WEST MIDLANDS
About Enable Technology West Midlands SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in West Midlands. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Countrywide Homes Limited, Homeserve PLC, Queen's Medical Centre Nottingham, EDF Energy PLC, Halfords Group PLC, West Bromwich Building Society, Norfolk Police Constabulary and Barclays Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: West Midlands
- 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 Partitions in the Workspace
- See Training Course Details...
Filter Data in a Table Relationships
Delete a Column
DirectQuery Mode
Create and Manage Roles
Process Tabular Model Partitions
Hide or freeze columns
Connect to a tabular model database
Add a table Delete a Table
Create and Manage KPIs Hierarchies
Object-level security
Import from Power View
Create and Manage Tabular Model Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create a Calculated Column
Change table, column
Manage Roles by using SSMS
Tabular model designer
Import Data
Topics include- Overview of SSAS Tabular models
Set the Data Type of a Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: West Midlands
- 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 by Using an Existing Table
- See Training Course Details...
Define a Data Source View
Test an Action
Define a Regular Relationship and Regular Relationship Properties
Create Calculated Members
Configure Analysis Services Project Properties
Rename a Multidimensional Database Processing a multidimensional model
Modify or Delete in Solution Explorer Database Dimensions
Add or Remove Tables or Views in a Data Source View
Deploy Analysis Services Projects
Delete a Data Source
Explore Data in a Data Source View
Deployment Requirements and Considerations for Analysis Services Deployment
Use a Template to Create an Action Deployment
Backup and Restore of Analysis Services Databases
Create Named Sets
Define Named Calculations in a Data Source View
Create Remote Partitions
Define a Fact Relationship and Fact Relationship Properties
Processing Databases, Dimensions and Partitions
Designing Aggregations
Email us about this courses
Other West Midlands Enable Technology Training Courses
JQuery Mobile West Midlands Training Courses
JavaScript West Midlands Training Courses
Access West Midlands Training Courses
VBA - West Midlands Excel Training Courses
Oracle SQL West Midlands Training Courses
DAX - West Midlands Excel Training Courses