SQL SERVER ANALYSIS SERVICES TRAINING COURSES DROITWICH
About Enable Technology Droitwich 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. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. If you prefer we can offer an offsite training location in Droitwich. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
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 have operated primarily in the West Midlands for twenty years. Our clients include: Norwich Union PLC, Capita Group PLC, Countrywide Homes Limited, GKN PLC, Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Wolverhampton City Council and EDF Energy PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Droitwich
- 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 ... Tools and Approaches for Processing
- See Training Course Details...
Data Source Views
Define Named Calculations in a Data Source View
Create Calculated Members
Document and Script an Analysis Services Database
Multidimensional models
Ragged Hierarchies
Database permissions
Calculations using the Business Intelligence Wizard
Define Time Intelligence
Configure Measure Group Properties
Create an Analysis Services Project
Create a Dimension by Using an Existing Table
BI Wizard
Defined Linked Measure Groups Partitions
Define Named Queries in a Data Source View
Create Named Sets
Create Local Partitions
Designing Aggregations
Data Source object permissions
Modify or Delete in Solution Explorer Database Dimensions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Droitwich
- 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 ... Import data by using a native query
- See Training Course Details...
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Partitions in the Workspace
Create and Manage Hierarchies Partitions
Object-level security
Topics include- Overview of SSAS Tabular models
DirectQuery Mode
Create and Manage Roles
Add columns to a table
Understanding DAX in Tabular Models Measures
DAX formula compatibility in DirectQuery mode Tables and Columns
Delete a Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Restore from Power Pivot
Delete Relationships
Bi-directional cross filters Calculations
Create a New Tabular Model Project
Create and Manage Tabular Model Partitions
Impersonation
Enable DirectQuery mode in SSDT
Create a Calculated Table
Email us about this courses
Other Droitwich Enable Technology Training Courses
SSRS - Droitwich SQL Server Reporting Services Training Courses
SSIS - Droitwich SQL Server Integration Services Training Courses
Access - Droitwich Access Training Courses
Oracle SQL - Droitwich SQL Training Courses
Access VBA - Droitwich Access Training Courses
JavaScript - Droitwich JavaScript Training Courses