SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATH
About Enable Technology Bath SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.
We provide instructor led training coupled with hands on training. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. We are also more than happy to organise a local course at a training location in Bath. All SQL Server Analysis Services courses can be customised to meet your particular 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. Some of our clients are EDF Energy PLC, Lloyds TSB Bank PLC, Barclays Bank PLC, Birmingham Heartlands Hospital, South Staffordshire Water PLC, Shell UK Oil Products Ltd, National Power PLC and Aston University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bath
- 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 ... Enable DirectQuery mode in SSMS
- See Training Course Details...
Understanding DAX in Tabular Models Measures
Add a table Delete a Table
Process Database, Table, or Partition
Create a Calculated Table
Add sample data to DirectQuery models
Create and Manage Perspectives Translations Roles
Set the Data Type of a Column
DirectQuery Mode
Import from Power View
Filter Data in a Table Relationships
Import data by using a native query
Enable DirectQuery mode in SSDT
Create a Calculated Column
Create and Manage Hierarchies Partitions
Row filter mappings
Create and Manage Measures KPIs
Process Tabular Model Partitions
Data sources supported in tabular 1400 models
Change table, column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bath
- 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 ... Define a Fact Relationship and Fact Relationship Properties
- See Training Course Details...
Dimension permissions
Create an Analysis Services Project
Data Source object permissions
Using SQL Server Data Tools (SSDT)
BI Wizard
Multidimensional models
Backup and Restore of Analysis Services Databases
Read Definition permissions
Configure Analysis Services Project Properties
Add a Standard Action
Backup Options Restore Options
Create a Time Dimension by Generating a Time Table
Set Data Source Properties
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Named Calculations in a Data Source View
Database permissions
Create Remote Partitions
Create a Data Source
Change a Partition Source
Work with Diagrams in Data Source View Designer
Email us about this courses
Other Bath Enable Technology Training Courses
JQuery Bath Training Courses
PL/SQL - Bath SQL Training Courses
TSQL Bath Training Courses
DAX Bath Training Courses
Oracle SQL - Bath SQL Training Courses
Power Query - Bath Excel Training Courses