SQL SERVER ANALYSIS SERVICES TRAINING COURSES WEYMOUTH
About Enable Technology Weymouth SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
We provide instructor led training coupled with hands on training. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. We are also more than happy to organise a local course at a training location in Weymouth. 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 instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: South Staffordshire Water PLC, Royal Air Force, Loughborough University, Wolverhampton City Council, Boots UK Limited, EDF Energy PLC, Homeserve PLC and Fujistu PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Weymouth
- 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 ... Change table, column
- See Training Course Details...
Import Data
DirectQuery Mode
Add columns to a table
Analyze in Excel
Version comparison
Create a Calculated Column
Import from Power View
Delete Relationships
Import from Analysis Services
Tabular model designer
Data types supported
Set the Data Type of a Column
Create and Manage Roles
Test a model in DirectQuery mode
Create a Calculated Table
Hide or freeze columns
Create and Manage Hierarchies Partitions
Bi-directional cross filters Calculations
Process Tabular Model Partitions
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Weymouth
- 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 ... Add a Standard Action
- See Training Course Details...
Define Logical Relationships in a Data Source View
Deploy Analysis Services Projects
Read Definition permissions
Multidimensional models
Define Named Calculations in a Data Source View
View the XML for an Analysis Services Project Data Sources
Set Data Source Properties
Processing Options and Settings
Deploy Model Solutions Using the Deployment Wizard
Work with Diagrams in Data Source View Designer
Configure Measure Group Properties
Use a Template to Create an Action Deployment
Modify or Delete in Solution Explorer Database Dimensions
Data Source object permissions
Define Time Intelligence
Create a Dimension by Generating a Non-Time Table in the Data Source
Delete a Data Source
Error Configuration Roles and Permissions
Add or Remove Tables or Views in a Data Source View
Create a Time Dimension by Generating a Time Table
Email us about this courses
Other Weymouth Enable Technology Training Courses
PL/SQL - Weymouth SQL Training Courses
Power BI - Weymouth Microsoft Power BI Training Courses
Excel 365 Intermediate Weymouth Training Courses
Data Warehouse - Weymouth SQL Training Courses
Power Query - Weymouth Excel Training Courses
Access VBA - Weymouth Access Training Courses