SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a course at a local venue in Newcastle Upon Tyne. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Cadbury PLC, Royal Air Force, Norfolk Police Constabulary, Yell Group PLC, Birmingham Heartlands Hospital, Shell UK Oil Products Ltd, University of Birmingham and Fujistu PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newcastle Upon Tyne
- 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 ... Restore from Power Pivot
- See Training Course Details...
Rename a Table or Column
Create and Manage Partitions in the Workspace
Import from Analysis Services
Tabular model designer
Process Database, Table, or Partition
Create and Manage KPIs Hierarchies
Data types supported
Delete Relationships
Enable DirectQuery mode in SSDT
Create and Manage Roles
Import Data
Sort Data in a Table
Add sample data to DirectQuery models
DirectQuery Mode
Process Tabular Model Partitions
Manage Roles by using SSMS
Impersonation
Create and Manage Measures KPIs
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newcastle Upon Tyne
- 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 ... Explore Data in a Data Source View
- See Training Course Details...
Define Logical Relationships in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Supported Data Sources
Using SQL Server Data Tools (SSDT)
Define a Referenced Relationship and Referenced Relationship Properties
Test an Action
Dimension permissions
Backup and Restore of Analysis Services Databases
Modify or Delete in Solution Explorer Database Dimensions
Processing Databases, Dimensions and Partitions
Define Assignments and Other Script Commands
Replace a Table or a Named Query in a Data Source View
Deploy Model Solutions Using XMLA
Create Remote Partitions
Set Partition Storage
Deploy Model Solutions with the Deployment Utility
Data Source object permissions
Modify or Delete an Analysis Services Database
Deployment Requirements and Considerations for Analysis Services Deployment
KPIs Actions
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
SSIS Newcastle Upon Tyne Training Courses
JQuery Newcastle Upon Tyne Training Courses
Data Warehouse Newcastle Upon Tyne Training Courses
Access VBA - Newcastle Upon Tyne Access Training Courses
Excel Power Pivot - Newcastle Upon Tyne Excel Training Courses
Report Builder - Newcastle Upon Tyne SQL Server Reporting Services Training Courses