SQL SERVER ANALYSIS SERVICES TRAINING COURSES DROITWICH
About Enable Technology Droitwich SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Canadian High Commission, Yell Group PLC, EDF Energy PLC, Fujistu PLC, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Countrywide Homes Limited and University of Birmingham.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Droitwich
- 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 ... DirectQuery Mode
- See Training Course Details...
Add a table Delete a Table
Data types supported
Create and Manage Measures KPIs
Data sources supported in tabular 1400 models
Topics include- Overview of SSAS Tabular models
Import from Power View
Object-level security
Filter Data in a Table Relationships
Add sample data to DirectQuery models
Data sources supported in tabular 1200 models
Create and Manage Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Create and Manage Hierarchies Partitions
Create a Calculated Table
Process Tabular Model Partitions
Create a Calculated Column
Rename a Table or Column
Process Database, Table, or Partition
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Droitwich
- 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 ... Defined Linked Measure Groups Partitions
- See Training Course Details...
Document and Script an Analysis Services Database
Dimension permissions
Define a Regular Relationship and Regular Relationship Properties
Create an Analysis Services Project
Define Attribute Relationships
Backup Options Restore Options
Use Aggregate Functions
Create Measures and Measure Groups
Set Impersonation Options for a Data Source Connection
Delete a Data Source View Dimensions
Define Logical Relationships in a Data Source View
Ragged Hierarchies
Set Partition Storage
Batch Processing Remote Processing
Define Named Queries in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Create Named Sets
Create Remote Partitions
Tools and Approaches for Processing
Configure Analysis Services Project Properties
Email us about this courses
Other Droitwich Enable Technology Training Courses
Excel 365 Advanced Droitwich Training Courses
Excel 365 Basic Droitwich Training Courses
Oracle SQL - Droitwich SQL Training Courses
Excel 365 Intermediate Droitwich Training Courses
TSQL Droitwich Training Courses
Report Builder Droitwich Training Courses