SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDGNORTH
About Enable Technology Bridgnorth SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a training location in Bridgnorth. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Homeserve PLC, Dollond & Aitchison Limited, Keele University, Norfolk Police Constabulary, South Staffordshire Water PLC, Lloyds TSB Bank PLC, West Bromwich Building Society and Boots UK Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... Add or Remove Tables or Views in a Data Source View
- See Training Course Details...
Set Data Source Properties
Create an Analysis Services Project
Define Time Intelligence
Use a Template to Create an Action Deployment
KPIs Actions
Create a Dimension by Using an Existing Table
Batch Processing Remote Processing
Create Named Sets
Add a Standard Action
Define Attribute Relationships
Backup Options Restore Options
Define Named Calculations in a Data Source View
Set Impersonation Options for a Data Source Connection
Replace a Table or a Named Query in a Data Source View
Define Logical Primary Keys in a Data Source View
Tools and Approaches for Processing
Create Measures and Measure Groups
Create a Time Dimension by Generating a Time Table
Move an Analysis Services Database
Create User-Defined Hierarchies
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... Process Tabular Model Partitions
- See Training Course Details...
Tabular model designer
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in SSAS tabular 2016 Create Tabular Models
DAX formula compatibility in DirectQuery mode Tables and Columns
Enable DirectQuery mode in SSDT
Impersonation
Restore from Power Pivot
DirectQuery Mode
Import data by using a native query
Add columns to a table
Create a Calculated Column
Add a table Delete a Table
Create a New Tabular Model Project
Import from Analysis Services
Test a model in DirectQuery mode
Create and Manage Roles
Analyze a tabular model in Excel Deploy tabular model solutions
Add sample data to DirectQuery models
Specify Mark as Date Table for use with Time Intelligence
Filter Data in a Table Relationships
Email us about this courses
Other Bridgnorth Enable Technology Training Courses
Excel 365 Advanced - Bridgnorth Excel Training Courses
SQL Bridgnorth Training Courses
JQuery Mobile - Bridgnorth JavaScript Training Courses
Power Query - Bridgnorth Excel Training Courses
Excel 365 Basic Bridgnorth Training Courses
Oracle SQL Bridgnorth Training Courses