SQL SERVER ANALYSIS SERVICES TRAINING COURSES WEYMOUTH
About Enable Technology Weymouth SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If you prefer we can offer an offsite training location in Weymouth. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Halfords Group PLC, Royal Air Force, Nationwide Building Society Limited, Norfolk Police Constabulary, Carillion PLC, Total Telecommunications Limited, DHL Express and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Weymouth
- 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 ... Modify or Delete in Solution Explorer Database Dimensions
- See Training Course Details...
Rename a Multidimensional Database Processing a multidimensional model
Move an Analysis Services Database
Define a Regular Relationship and Regular Relationship Properties
Use Aggregate Functions
Define Logical Relationships in a Data Source View
Document and Script an Analysis Services Database
Backup and Restore of Analysis Services Databases
Read Definition permissions
Calculations using the Business Intelligence Wizard
Create Remote Partitions
Deployment Requirements and Considerations for Analysis Services Deployment
Edit or Delete Partitions Merge Partitions
Define Named Queries in a Data Source View
Add or Remove Tables or Views in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Assignments and Other Script Commands
Define a Referenced Relationship and Referenced Relationship Properties
Deploy Model Solutions Using XMLA
Defined Linked Measure Groups Partitions
Replace a Table or a Named Query in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Weymouth
- 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 ... Import from Analysis Services
- See Training Course Details...
Tabular model designer
Object-level security
Create and Manage Tabular Model Partitions
Create and Manage Roles
Hide or freeze columns
Connect to a tabular model database
Add sample data to DirectQuery models
Import from Power Pivot
Test a model in DirectQuery mode
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Create and Manage KPIs Hierarchies
Enable DirectQuery mode in SSDT
Filter Data in a Table Relationships
Import Data
Database Process Partitions in the Workspace Database Perspectives
Define partitions in DirectQuery models
Restore from Power Pivot
Process Database, Table, or Partition
Create a Calculated Table
Email us about this courses
Other Weymouth Enable Technology Training Courses
JQuery Mobile - Weymouth JavaScript Training Courses
Excel 365 Advanced Weymouth Training Courses
Data Warehouse Weymouth Training Courses
TSQL Weymouth Training Courses
PL/SQL - Weymouth SQL Training Courses
SSIS - Weymouth SQL Server Integration Services Training Courses