SQL SERVER ANALYSIS SERVICES TRAINING COURSES NEWTOWN
About Enable Technology Newtown SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Our primary method of delivery is instructor led training coupled with practical hands on activities. 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. We are also more than happy to organise a local course at a socially distanced training location in Newtown. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Homeserve PLC, Keele University, Birmingham City University, Dollond & Aitchison Limited, GKN PLC, Birmingham City Council, EDF Energy PLC and University of Birmingham.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Newtown
- 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 ... Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
- See Training Course Details...
Create a Time Dimension by Generating a Time Table
Set Impersonation Options for a Data Source Connection
Create a Dimension by Generating a Non-Time Table in the Data Source
Set Data Source Properties
Processing Databases, Dimensions and Partitions
Deploy Model Solutions Using the Deployment Wizard
Add a Standard Action
Deploy Model Solutions Using XMLA
Backup Options Restore Options
Create User-Defined Hierarchies
Deployment Requirements and Considerations for Analysis Services Deployment
Add or Remove Tables or Views in a Data Source View
Deploy Analysis Services Projects
Change a Partition Source
Create Calculated Members
Replace a Table or a Named Query in a Data Source View
Delete a Data Source
Deploy Model Solutions with the Deployment Utility
Authorizing access to objects and operations
Using SQL Server Data Tools (SSDT)
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Newtown
- 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 ... DAX formula compatibility in DirectQuery mode Tables and Columns
- See Training Course Details...
Create and Manage Measures KPIs
Process Database, Table, or Partition
Object-level security
Create and Manage Tabular Model Partitions
Add columns to a table
Analyze a tabular model in Excel Deploy tabular model solutions
Enable DirectQuery mode in SSMS
Import data by using a native query
Create a Relationship Between Two Tables
Delete Relationships
Rename a Table or Column
Enable DirectQuery mode in SSDT
Row filter mappings
Create and Manage Partitions in the Workspace
Set the Data Type of a Column
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Restore from Power Pivot
Tabular model designer
Impersonation
Connect to a tabular model database
Email us about this courses
Other Newtown Enable Technology Training Courses
Access Newtown Training Courses
Excel 365 Advanced - Newtown Excel Training Courses
TSQL Newtown Training Courses
Access VBA - Newtown Access Training Courses
SSRS - Newtown SQL Server Reporting Services Training Courses
Excel 365 Basic - Newtown Excel Training Courses