SQL SERVER ANALYSIS SERVICES TRAINING COURSES BURY
About Enable Technology Bury SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. 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. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local socially distanced training site in Bury. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Vodafone Group Services, South Staffordshire Water PLC, Royal Air Force, Queen's Medical Centre Nottingham, West Bromwich Building Society, Unipart Group, Total Telecommunications Limited and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bury
- 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 ... Use a Template to Create an Action Deployment
- See Training Course Details...
Create Remote Partitions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Semiadditive Behavior
Edit or Delete Partitions Merge Partitions
Replace a Table or a Named Query in a Data Source View
Add or Remove Tables or Views in a Data Source View
Create Local Partitions
Define Named Calculations in a Data Source View
Configure Measure Group Properties
Modify or Delete in Solution Explorer Database Dimensions
Designing Aggregations
Calculations using the Business Intelligence Wizard
Attach and Detach Analysis Services Databases
Set Data Source Properties
Create Calculated Members
Create an Analysis Services Project
Define a Data Source View
Move an Analysis Services Database
Read Definition permissions
Add a Standard Action
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bury
- 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...
Add columns to a table
Object-level security
Database Process Partitions in the Workspace Database Perspectives
Create a Calculated Table
Delete Relationships
Analyze in Excel
Import Data
Import from Power View
Data types supported
Data sources supported in tabular 1400 models
Version comparison
DirectQuery Mode
Create a Relationship Between Two Tables
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Define partitions in DirectQuery models
Delete a Column
Row filter mappings
Bi-directional cross filters Calculations
Create and Manage Measures KPIs
Understanding DAX in Tabular Models Measures
Email us about this courses
Other Bury Enable Technology Training Courses
Excel 365 Basic Bury Training Courses
SSRS Bury Training Courses
PL/SQL Bury Training Courses
TSQL - Bury SQL Training Courses
Excel 365 Intermediate - Bury Excel Training Courses
Power BI - Bury Microsoft Power BI Training Courses