SQL SERVER ANALYSIS SERVICES TRAINING COURSES HYDE
About Enable Technology Hyde SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Professionals. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We are also more than happy to organise a local course at a training location in Hyde. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Lloyds TSB Bank PLC, Queen's Medical Centre Nottingham, Norfolk Police Constabulary, Royal & Sun Alliance Group PLC, Loughborough University, Fujistu PLC, Homeserve PLC and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Hyde
- 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...
Topics include- Overview of SSAS Tabular models
Set the Data Type of a Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Bi-directional cross filters Calculations
Restore from Power Pivot
Data sources supported in tabular 1200 models
Data types supported
Analyze in Excel
Import from Power Pivot
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1400 models
Analyze a tabular model in Excel Deploy tabular model solutions
Filter Data in a Table Relationships
Delete a Column
Delete Relationships
Add a table Delete a Table
Test a model in DirectQuery mode
Impersonation
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Hyde
- 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 ... Deploy Model Solutions Using the Deployment Wizard
- See Training Course Details...
Set Partition Storage
Define Logical Relationships in a Data Source View
Modify or Delete an Analysis Services Database
Change a Partition Source
Data Source Views
Partition Writeback Calculations
Tools and Approaches for Processing
Deploy Model Solutions Using XMLA
Overview of SSAS Multidimensional Modelling
Define a Data Source View
Define Assignments and Other Script Commands
Move an Analysis Services Database
Ragged Hierarchies
Explore Data in a Data Source View
BI Wizard
Read Definition permissions
Deployment Requirements and Considerations for Analysis Services Deployment
Error Configuration Roles and Permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Measures and Measure Groups
Email us about this courses
Other Hyde Enable Technology Training Courses
SQL Hyde Training Courses
Excel 365 Advanced - Hyde Excel Training Courses
Oracle SQL - Hyde SQL Training Courses
PL/SQL - Hyde SQL Training Courses
JQuery Hyde Training Courses
Excel 365 Basic - Hyde Excel Training Courses