SQL SERVER ANALYSIS SERVICES TRAINING COURSES WILTSHIRE
About Enable Technology Wiltshire SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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 SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite training location in Wiltshire. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Keele University, Homeserve PLC, Capita Group PLC, Yell Group PLC, Total Telecommunications Limited, Nationwide Building Society Limited, Royal Air Force and Carillion PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wiltshire
- 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 ... Partition Writeback Calculations
- See Training Course Details...
Configure Analysis Services Project Properties
Define a Data Source View
Replace a Table or a Named Query in a Data Source View
Test an Action
Supported Data Sources
View the XML for an Analysis Services Project Data Sources
Add a Standard Action
Database permissions
Error Configuration Roles and Permissions
Batch Processing Remote Processing
Create a Dimension by Using an Existing Table
Define Attribute Relationships
Create Remote Partitions
Create Calculated Members
Define Logical Relationships in a Data Source View
Create a Data Source
Change a Partition Source
Add or Remove Tables or Views in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Configure Measure Group Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wiltshire
- 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 ... Tabular model designer
- See Training Course Details...
Manage Roles by using SSMS
Database Process Partitions in the Workspace Database Perspectives
Hide or freeze columns
Restore from Power Pivot
Sort Data in a Table
Import from Analysis Services
Impersonation
Set the Data Type of a Column
Import data by using a native query
Create a New Tabular Model Project
Create and Manage Measures KPIs
DirectQuery Mode
Enable DirectQuery mode in SSDT
Import from Power Pivot
Row filter mappings
Process Database, Table, or Partition
Add a table Delete a Table
Delete Relationships
Data sources supported in SSAS tabular 2016 Create Tabular Models
Email us about this courses
Other Wiltshire Enable Technology Training Courses
Power Query - Wiltshire Excel Training Courses
Excel 365 Intermediate Wiltshire Training Courses
SSIS Wiltshire Training Courses
VBA Wiltshire Training Courses
SQL Wiltshire Training Courses
Report Builder - Wiltshire SQL Server Reporting Services Training Courses