SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERSEYSIDE
About Enable Technology Merseyside SQL Server Analysis Services Training Courses
Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology training courses are delivered as instructor led courses. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Merseyside. 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Royal Air Force, West Bromwich Building Society, Norwich Union PLC, EDF Energy PLC, Boots UK Limited, South Staffordshire Water PLC and Shell UK Oil Products Ltd.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Merseyside
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Create a Calculated Table
Filter Data in a Table Relationships
Bi-directional cross filters Calculations
Object-level security
Analyze a tabular model in Excel Deploy tabular model solutions
Database Process Partitions in the Workspace Database Perspectives
Topics include- Overview of SSAS Tabular models
Connect to a tabular model database
Test a model in DirectQuery mode
Enable DirectQuery mode in SSDT
Row filter mappings
Rename a Table or Column
Define partitions in DirectQuery models
Create and Manage Roles
Specify Mark as Date Table for use with Time Intelligence
Create a New Tabular Model Project
Tabular model designer
Restore from Power Pivot
Change table, column
Create a Relationship Between Two Tables
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Merseyside
- 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 Local Partitions
- See Training Course Details...
Test an Action
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Assignments and Other Script Commands
Delete a Data Source View Dimensions
Define Attribute Relationships
Calculations using the Business Intelligence Wizard
Deploy Model Solutions with the Deployment Utility
Explore Data in a Data Source View
Data Source Views
Create User-Defined Hierarchies
Rename a Multidimensional Database Processing a multidimensional model
Define Logical Relationships in a Data Source View
Define Logical Primary Keys in a Data Source View
Ragged Hierarchies
Create a Dimension by Generating a Non-Time Table in the Data Source
Processing Databases, Dimensions and Partitions
Define Time Intelligence
Modify or Delete an Analysis Services Database
Cube or model permissions Process permissions
Using SQL Server Data Tools (SSDT)
Email us about this courses
Other Merseyside Enable Technology Training Courses
Access Merseyside Training Courses
Excel Power Pivot - Merseyside Excel Training Courses
Access VBA Merseyside Training Courses
Excel 365 Advanced Merseyside Training Courses
SQL Merseyside Training Courses
Report Builder Merseyside Training Courses