SQL SERVER ANALYSIS SERVICES TRAINING COURSES CWMBRAN
About Enable Technology Cwmbran 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. 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.
We provide instructor led training coupled with hands on training. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. If delivery onsite is an issue we will organise a venue near you in Cwmbran. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Royal & Sun Alliance Group PLC, Loughborough University, Canadian High Commission, Keele University, TalkTalk Direct Limited, Nationwide Building Society Limited, GKN PLC and Fujistu PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Cwmbran
- 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
- See Training Course Details...
Manage Roles by using SSMS
Import from Analysis Services
Process Database, Table, or Partition
Data sources supported in SSAS tabular 2016 Create Tabular Models
Define partitions in DirectQuery models
Test a model in DirectQuery mode
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Filter Data in a Table Relationships
Change table, column
Create and Manage Hierarchies Partitions
Create a Relationship Between Two Tables
Create and Manage KPIs Hierarchies
Add columns to a table
Process Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Sort Data in a Table
Add sample data to DirectQuery models
Create and Manage Roles
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Cwmbran
- 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 ... Configure Measure Group Properties
- See Training Course Details...
Backup Options Restore Options
Overview of SSAS Multidimensional Modelling
Multidimensional models
Deploy Model Solutions Using XMLA
Create a Dimension by Using an Existing Table
Supported Data Sources
Set Partition Storage
Define Assignments and Other Script Commands
Add a Standard Action
Rename a Multidimensional Database Processing a multidimensional model
Delete a Data Source View Dimensions
Define a Data Source View
Use Aggregate Functions
Configure Analysis Services Project Properties
Define a Regular Relationship and Regular Relationship Properties
Edit or Delete Partitions Merge Partitions
Calculations using the Business Intelligence Wizard
Explore Data in a Data Source View
Create Local Partitions
Partition Writeback Calculations
Email us about this courses
Other Cwmbran Enable Technology Training Courses
Report Builder Cwmbran Training Courses
TSQL - Cwmbran SQL Training Courses
Excel Power Pivot - Cwmbran Excel Training Courses
SQL - Cwmbran SQL Training Courses
VBA Cwmbran Training Courses
PL/SQL - Cwmbran SQL Training Courses