SQL SERVER ANALYSIS SERVICES TRAINING COURSES SMETHWICK
About Enable Technology Smethwick SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology 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. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Courses are instructor led and groups sizes small. 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 Smethwick. 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 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are National Power PLC, Birmingham Heartlands Hospital, Homeserve PLC, Yell Group PLC, Queen's Medical Centre Nottingham, Shell UK Oil Products Ltd, Capita Group PLC and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Smethwick
- 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 ... Create a Calculated Column
- See Training Course Details...
Sort Data in a Table
Tabular model designer
Test a model in DirectQuery mode
Create a New Tabular Model Project
Create and Manage KPIs Hierarchies
Process Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
DirectQuery Mode
Add a table Delete a Table
Enable DirectQuery mode in SSDT
Create and Manage Hierarchies Partitions
Create and Manage Perspectives Translations Roles
Data sources supported in tabular 1200 models
Add columns to a table
Enable DirectQuery mode in SSMS
Import data by using a native query
Create and Manage Roles
Filter Data in a Table Relationships
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Smethwick
- 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...
Deployment Requirements and Considerations for Analysis Services Deployment
Dimension permissions
Set Impersonation Options for a Data Source Connection
Add a Standard Action
Rename a Multidimensional Database Processing a multidimensional model
Test an Action
Define a Referenced Relationship and Referenced Relationship Properties
Calculations using the Business Intelligence Wizard
Backup Options Restore Options
Modify or Delete in Solution Explorer Database Dimensions
Partition Writeback Calculations
Multidimensional models
Define Semiadditive Behavior
Define a Data Source View
Set Data Source Properties
Backup and Restore of Analysis Services Databases
Processing Databases, Dimensions and Partitions
Move an Analysis Services Database
Attach and Detach Analysis Services Databases
Create an Analysis Services Project
Email us about this courses
Other Smethwick Enable Technology Training Courses
PL/SQL - Smethwick SQL Training Courses
DAX - Smethwick Excel Training Courses
Data Warehouse Smethwick Training Courses
Excel 365 Intermediate - Smethwick Excel Training Courses
Excel 365 Basic Smethwick Training Courses
SQL - Smethwick SQL Training Courses