SQL SERVER ANALYSIS SERVICES TRAINING COURSES NOTTINGHAM
About Enable Technology Nottingham SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. 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. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
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 group of companies has been operating continuously providing IT training since 1998. Our clients include: Royal & Sun Alliance Group PLC, Birmingham Heartlands Hospital, EDF Energy PLC, GKN PLC, Carillion PLC, Halfords Group PLC, Countrywide Homes Limited and Barclays Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Nottingham
- 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 Remote Partitions
- See Training Course Details...
Create Measures and Measure Groups
BI Wizard
Set Impersonation Options for a Data Source Connection
Define Logical Relationships in a Data Source View
Change a Partition Source
Define Assignments and Other Script Commands
Tools and Approaches for Processing
Read Definition permissions
Define Named Calculations in a Data Source View
Data Source Views
Defined Linked Measure Groups Partitions
Define a Regular Relationship and Regular Relationship Properties
Create Local Partitions
Create an Analysis Services Project
Processing Options and Settings
Define Time Intelligence
Replace a Table or a Named Query in a Data Source View
Multidimensional models
Deployment Requirements and Considerations for Analysis Services Deployment
Document and Script an Analysis Services Database
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Nottingham
- 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 ... Understanding DAX in Tabular Models Measures
- See Training Course Details...
Hide or freeze columns
Topics include- Overview of SSAS Tabular models
Specify Mark as Date Table for use with Time Intelligence
Tabular model designer
Enable DirectQuery mode in SSDT
Impersonation
DirectQuery Mode
Process Database, Table, or Partition
Data sources supported in tabular 1200 models
Data types supported
Enable DirectQuery mode in SSMS
Create and Manage Hierarchies Partitions
Create and Manage Perspectives Translations Roles
Database Process Partitions in the Workspace Database Perspectives
Add columns to a table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Set the Data Type of a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Delete Relationships
Email us about this courses
Other Nottingham Enable Technology Training Courses
PL/SQL Nottingham Training Courses
VBA - Nottingham Excel Training Courses
TSQL - Nottingham SQL Training Courses
DAX - Nottingham Excel Training Courses
Excel 365 Basic Nottingham Training Courses
Access Nottingham Training Courses