SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACKWOOD
About Enable Technology Blackwood SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Blackwood. 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 group of companies has been operating continuously providing IT training since 1998. Our clients include: Barclays Bank PLC, Yell Group PLC, Fujistu PLC, West Bromwich Building Society, EDF Energy PLC, Norfolk Police Constabulary, Birmingham City Council and Royal Air Force.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Blackwood
- 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 ... Connect to a tabular model database
- See Training Course Details...
Create a Relationship Between Two Tables
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create a Calculated Column
Add sample data to DirectQuery models
Row filter mappings
Process Tabular Model Partitions
Version comparison
Create and Manage KPIs Hierarchies
Import from Power View
Data types supported
Import data by using a native query
Define partitions in DirectQuery models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Manage Roles by using SSMS
Add columns to a table
Data sources supported in tabular 1200 models
Restore from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Blackwood
- 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 ... Data Source object permissions
- See Training Course Details...
Add a Standard Action
Create a Time Dimension by Generating a Time Table
Deploy Model Solutions Using XMLA
BI Wizard
Use a Template to Create an Action Deployment
Create a Dimension by Generating a Non-Time Table in the Data Source
Partition Writeback Calculations
Create Measures and Measure Groups
Define Assignments and Other Script Commands
Work with Diagrams in Data Source View Designer
Move an Analysis Services Database
Batch Processing Remote Processing
Delete a Data Source View Dimensions
Add or Remove Tables or Views in a Data Source View
Create Local Partitions
Create an Analysis Services Project
Defined Linked Measure Groups Partitions
Backup and Restore of Analysis Services Databases
Processing Databases, Dimensions and Partitions
Attach and Detach Analysis Services Databases
Email us about this courses
Other Blackwood Enable Technology Training Courses
JQuery Mobile Blackwood Training Courses
Access - Blackwood Access Training Courses
Excel Power Pivot Blackwood Training Courses
JavaScript Blackwood Training Courses
Power BI Blackwood Training Courses
TSQL - Blackwood SQL Training Courses