SQL SERVER ANALYSIS SERVICES TRAINING COURSES HARROGATE
About Enable Technology Harrogate SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Another option is we can organise a local training site in Harrogate. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are South Staffordshire Water PLC, Halfords Group PLC, Barclays Bank PLC, DHL Express, University of Birmingham, Nationwide Building Society Limited, Boots UK Limited and Birmingham Heartlands Hospital.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Harrogate
- 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 ... Document and Script an Analysis Services Database
- See Training Course Details...
Define Named Queries in a Data Source View
Designing Aggregations
Replace a Table or a Named Query in a Data Source View
Create a Dimension by Using an Existing Table
Backup and Restore of Analysis Services Databases
Batch Processing Remote Processing
Data Source Views
Create Calculated Members
Multidimensional models
Ragged Hierarchies
Define Logical Primary Keys in a Data Source View
Define a Data Source View
Create a Dimension Using the Dimension Wizard
Deploy Model Solutions Using XMLA
Using SQL Server Data Tools (SSDT)
Test an Action
Deploy Model Solutions with the Deployment Utility
Define a Fact Relationship and Fact Relationship Properties
Deployment Requirements and Considerations for Analysis Services Deployment
Create a Data Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Harrogate
- 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 ... Create and Manage Tabular Model Partitions
- See Training Course Details...
Process Database, Table, or Partition
Connect to a tabular model database
Data sources supported in tabular 1400 models
Create and Manage Partitions in the Workspace
Specify Mark as Date Table for use with Time Intelligence
Create and Manage Measures KPIs
Create and Manage Roles
Import Data
Tabular model designer
Add a table Delete a Table
Filter Data in a Table Relationships
Create and Manage Hierarchies Partitions
Impersonation
Manage Roles by using SSMS
Deploy from SQL Server Data Tools Manage Tabular Model Databases
DirectQuery Mode
Create a New Tabular Model Project
Import from Analysis Services
Analyze a tabular model in Excel Deploy tabular model solutions
Email us about this courses
Other Harrogate Enable Technology Training Courses
JQuery Mobile - Harrogate JavaScript Training Courses
Access VBA Harrogate Training Courses
DAX - Harrogate Excel Training Courses
JavaScript - Harrogate JavaScript Training Courses
Excel Power Pivot - Harrogate Excel Training Courses
PL/SQL Harrogate Training Courses