SQL SERVER ANALYSIS SERVICES TRAINING COURSES WARWICKSHIRE
About Enable Technology Warwickshire SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued SQL Server Analysis Services training manuals they can refer to 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. We are also more than happy to organise a local course at a training location in Warwickshire. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are University of Birmingham, Royal & Sun Alliance Group PLC, TalkTalk Direct Limited, Norwich Union PLC, Unipart Group, Norfolk Police Constabulary, DHL Express and Boots UK Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Warwickshire
- 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 Aggregate Functions
- See Training Course Details...
Configure Measure Group Properties
Create a Dimension Using the Dimension Wizard
Data Source Views
Create a Data Source
Set Partition Storage
Modify or Delete in Solution Explorer Database Dimensions
Using SQL Server Data Tools (SSDT)
Change a Partition Source
Ragged Hierarchies
Define a Referenced Relationship and Referenced Relationship Properties
BI Wizard
Create an Analysis Services Project
Create a Dimension by Generating a Non-Time Table in the Data Source
Add or Remove Tables or Views in a Data Source View
Cube or model permissions Process permissions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Calculated Members
Set Impersonation Options for a Data Source Connection
Batch Processing Remote Processing
Replace a Table or a Named Query in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Warwickshire
- 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 ... Data sources supported in SSAS tabular 2016 Create Tabular Models
- See Training Course Details...
Define partitions in DirectQuery models
DirectQuery Mode
Delete a Column
Rename a Table or Column
Create a Calculated Table
Bi-directional cross filters Calculations
Create a New Tabular Model Project
Create and Manage Measures KPIs
Manage Roles by using SSMS
Create and Manage Perspectives Translations Roles
Tabular model designer
Process Database, Table, or Partition
Sort Data in a Table
Understanding DAX in Tabular Models Measures
Topics include- Overview of SSAS Tabular models
Impersonation
Hide or freeze columns
Analyze a tabular model in Excel Deploy tabular model solutions
Row filter mappings
Create and Manage Hierarchies Partitions
Email us about this courses
Other Warwickshire Enable Technology Training Courses
Excel 365 Advanced Warwickshire Training Courses
DAX - Warwickshire Excel Training Courses
Access VBA Warwickshire Training Courses
Power Query Warwickshire Training Courses
VBA Warwickshire Training Courses
PL/SQL - Warwickshire SQL Training Courses