SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTWICH
About Enable Technology Prestwich SQL Server Analysis Services Training Courses
Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away SQL Server Analysis Services courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Alternatively we could schedule a course at a local venue in Prestwich. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite SQL Server Analysis Services course to some extent is bespoke and tailored to your needs.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Norwich Union PLC, Cadbury PLC, Barclays Bank PLC, Wolverhampton City Council, GKN PLC, Boots UK Limited, Halfords Group PLC and Homeserve PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Prestwich
- 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 ... Tabular model designer
- See Training Course Details...
Define partitions in DirectQuery models
Create and Manage Measures KPIs
Add a table Delete a Table
Understanding DAX in Tabular Models Measures
DirectQuery Mode
Create and Manage Partitions in the Workspace
Impersonation
Import from Power View
Topics include- Overview of SSAS Tabular models
Hide or freeze columns
Create a Calculated Column
Create and Manage Hierarchies Partitions
Filter Data in a Table Relationships
Database Process Partitions in the Workspace Database Perspectives
Data sources supported in tabular 1200 models
Process Database, Table, or Partition
Analyze a tabular model in Excel Deploy tabular model solutions
Delete Relationships
Change table, column
Bi-directional cross filters Calculations
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Prestwich
- 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 Assignments and Other Script Commands
- See Training Course Details...
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Measures and Measure Groups
Use a Template to Create an Action Deployment
Modify or Delete an Analysis Services Database
Add or Remove Tables or Views in a Data Source View
Test an Action
Change a Partition Source
Ragged Hierarchies
Work with Diagrams in Data Source View Designer
Error Configuration Roles and Permissions
Read Definition permissions
Define Logical Primary Keys in a Data Source View
Deploy Analysis Services Projects
Delete a Data Source
Create a Data Source
Deploy Model Solutions Using the Deployment Wizard
Supported Data Sources
Define Semiadditive Behavior
Define Named Calculations in a Data Source View
Create a Dimension by Generating a Non-Time Table in the Data Source
Email us about this courses
Other Prestwich Enable Technology Training Courses
Power BI - Prestwich Microsoft Power BI Training Courses
TSQL Prestwich Training Courses
Report Builder Prestwich Training Courses
Access - Prestwich Access Training Courses
JavaScript - Prestwich JavaScript Training Courses
Power Query - Prestwich Excel Training Courses