SQL SERVER ANALYSIS SERVICES TRAINING COURSES BATH
About Enable Technology Bath SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services 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. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology offers instructor led training taught by technology specialists. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bath. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Keele University, Halfords Group PLC, Shell UK Oil Products Ltd, Boots UK Limited, Canadian High Commission, Countrywide Homes Limited, Dollond & Aitchison Limited and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bath
- 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 ... Backup Options Restore Options
- See Training Course Details...
Set Impersonation Options for a Data Source Connection
Define Named Calculations in a Data Source View
Overview of SSAS Multidimensional Modelling
Dimension permissions
Define Semiadditive Behavior
Attach and Detach Analysis Services Databases
Define a Referenced Relationship and Referenced Relationship Properties
Data Source object permissions
Create Named Sets
Create a Dimension Using the Dimension Wizard
Define a Regular Relationship and Regular Relationship Properties
Define Time Intelligence
Configure Analysis Services Project Properties
Create a Dimension by Using an Existing Table
Create Measures and Measure Groups
Rename a Multidimensional Database Processing a multidimensional model
BI Wizard
Work with Diagrams in Data Source View Designer
Error Configuration Roles and Permissions
Add a Standard Action
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bath
- 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 and Manage Roles
- See Training Course Details...
Create and Manage Perspectives Translations Roles
Analyze in Excel
Row filter mappings
Import Data
Create and Manage Measures KPIs
Specify Mark as Date Table for use with Time Intelligence
Topics include- Overview of SSAS Tabular models
Create a Calculated Column
Create a Calculated Table
Import from Power Pivot
Connect to a tabular model database
Create a New Tabular Model Project
Add sample data to DirectQuery models
DirectQuery Mode
Object-level security
Enable DirectQuery mode in SSDT
Define partitions in DirectQuery models
Create a Relationship Between Two Tables
Enable DirectQuery mode in SSMS
Email us about this courses
Other Bath Enable Technology Training Courses
PL/SQL - Bath SQL Training Courses
Access Bath Training Courses
JavaScript Bath Training Courses
Power Query Bath Training Courses
TSQL - Bath SQL Training Courses
SSRS Bath Training Courses