SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Newcastle Upon Tyne. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Capita Group PLC, Total Telecommunications Limited, Boots UK Limited, Homeserve PLC, Unipart Group, Barclays Bank PLC, GKN PLC and Queen's Medical Centre Nottingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newcastle Upon Tyne
- 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 ... Define a Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Define Named Calculations in a Data Source View
Use a Template to Create an Action Deployment
Define Named Queries in a Data Source View
Edit or Delete Partitions Merge Partitions
Create Remote Partitions
Deploy Model Solutions with the Deployment Utility
Designing Aggregations
Define Logical Relationships in a Data Source View
Create a Dimension Using the Dimension Wizard
Processing Databases, Dimensions and Partitions
Modify or Delete in Solution Explorer Database Dimensions
Define Semiadditive Behavior
Calculations using the Business Intelligence Wizard
Attach and Detach Analysis Services Databases
Authorizing access to objects and operations
Add a Standard Action
Deploy Analysis Services Projects
Set Data Source Properties
Backup Options Restore Options
Configure Measure Group Properties
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newcastle Upon Tyne
- 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...
Database Process Partitions in the Workspace Database Perspectives
Add sample data to DirectQuery models
Create a Relationship Between Two Tables
Create and Manage Partitions in the Workspace
Row filter mappings
Bi-directional cross filters Calculations
Import from Power View
Import from Power Pivot
Impersonation
Import from Analysis Services
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Perspectives Translations Roles
Create a Calculated Column
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Roles
Data types supported
Add a table Delete a Table
Sort Data in a Table
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
VBA Newcastle Upon Tyne Training Courses
Report Builder - Newcastle Upon Tyne SQL Server Reporting Services Training Courses
Data Warehouse Newcastle Upon Tyne Training Courses
Excel Power Pivot Newcastle Upon Tyne Training Courses
TSQL - Newcastle Upon Tyne SQL Training Courses
Oracle SQL Newcastle Upon Tyne Training Courses