SQL SERVER ANALYSIS SERVICES TRAINING COURSES BIRKENHEAD
About Enable Technology Birkenhead SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Birkenhead. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions 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 Countrywide Homes Limited, Loughborough University, Fujistu PLC, Halfords Group PLC, EDF Energy PLC, Shell UK Oil Products Ltd, Yell Group PLC and Royal Air Force.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Birkenhead
- 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 ... Define Time Intelligence
- See Training Course Details...
Processing Databases, Dimensions and Partitions
Delete a Data Source View Dimensions
Create a Dimension by Generating a Non-Time Table in the Data Source
Create Measures and Measure Groups
Test an Action
Define Attribute Relationships
Create Named Sets
Create Remote Partitions
Define a Referenced Relationship and Referenced Relationship Properties
Define Semiadditive Behavior
Create Local Partitions
Create Calculated Members
Overview of SSAS Multidimensional Modelling
Define a Fact Relationship and Fact Relationship Properties
Configure Measure Group Properties
Explore Data in a Data Source View
Document and Script an Analysis Services Database
Deploy Model Solutions Using the Deployment Wizard
Error Configuration Roles and Permissions
Deploy Model Solutions Using XMLA
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Birkenhead
- 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 from Power View
- See Training Course Details...
Object-level security
Create a Calculated Table
Import data by using a native query
Manage Roles by using SSMS
Process Database, Table, or Partition
Create and Manage Measures KPIs
Topics include- Overview of SSAS Tabular models
Data sources supported in tabular 1400 models
Bi-directional cross filters Calculations
Analyze in Excel
Import from Power Pivot
Test a model in DirectQuery mode
Sort Data in a Table
Create and Manage Partitions in the Workspace
DirectQuery Mode
Enable DirectQuery mode in SSMS
Create and Manage Roles
Row filter mappings
Restore from Power Pivot
Rename a Table or Column
Email us about this courses
Other Birkenhead Enable Technology Training Courses
SSIS - Birkenhead SQL Server Integration Services Training Courses
SSRS - Birkenhead SQL Server Reporting Services Training Courses
Report Builder - Birkenhead SQL Server Reporting Services Training Courses
Excel 365 Basic Birkenhead Training Courses
PL/SQL - Birkenhead SQL Training Courses
Oracle SQL Birkenhead Training Courses