SQL SERVER ANALYSIS SERVICES TRAINING COURSES SHREWSBURY
About Enable Technology Shrewsbury SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
We provide instructor led training coupled with hands on training. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a socially distanced training location in Shrewsbury. We offer the option of working with you to develop a bespoke SQL Server Analysis Services programme which precisely matches your organisations training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: University of Birmingham, GKN PLC, TalkTalk Direct Limited, DHL Express, Cadbury PLC, Yell Group PLC, Royal Air Force and Nuclear Engineering Services.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Shrewsbury
- 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 Table
- See Training Course Details...
Process Tabular Model Partitions
Analyze in Excel
Create and Manage Measures KPIs
Create and Manage Roles
Create a New Tabular Model Project
Data sources supported in SSAS tabular 2016 Create Tabular Models
Delete a Column
Add a table Delete a Table
Create and Manage KPIs Hierarchies
Create and Manage Tabular Model Partitions
Define partitions in DirectQuery models
Understanding DAX in Tabular Models Measures
Create and Manage Hierarchies Partitions
Tabular model designer
Test a model in DirectQuery mode
Add sample data to DirectQuery models
Data sources supported in tabular 1400 models
Rename a Table or Column
Hide or freeze columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Shrewsbury
- 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 ... Delete a Data Source
- See Training Course Details...
Authorizing access to objects and operations
Create Local Partitions
Defined Linked Measure Groups Partitions
Rename a Multidimensional Database Processing a multidimensional model
Create a Dimension Using the Dimension Wizard
Backup Options Restore Options
Add or Remove Tables or Views in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Define Named Calculations in a Data Source View
Create a Dimension by Using an Existing Table
Use Aggregate Functions
Set Data Source Properties
Move an Analysis Services Database
Replace a Table or a Named Query in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Multidimensional models
Designing Aggregations
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Attach and Detach Analysis Services Databases
Create Measures and Measure Groups
Email us about this courses
Other Shrewsbury Enable Technology Training Courses
SQL - Shrewsbury SQL Training Courses
TSQL Shrewsbury Training Courses
Access - Shrewsbury Access Training Courses
Excel 365 Basic Shrewsbury Training Courses
Data Warehouse Shrewsbury Training Courses
Oracle SQL Shrewsbury Training Courses