SQL SERVER ANALYSIS SERVICES TRAINING COURSES SANDWELL
About Enable Technology Sandwell SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology training courses are delivered as instructor led courses. We can deliver at your premises. We can provide the equipment. We can also deliver the SQL Server Analysis Services course at a local training venue in Sandwell. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Boots UK Limited, DHL Express, Halfords Group PLC, University of Birmingham, Royal & Sun Alliance Group PLC, Unipart Group, Homeserve PLC and Fujistu PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Sandwell
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Define Assignments and Other Script Commands
Create a Dimension Using the Dimension Wizard
Create an Analysis Services Project
Define Logical Relationships in a Data Source View
Overview of SSAS Multidimensional Modelling
Error Configuration Roles and Permissions
Create a Data Source
View the XML for an Analysis Services Project Data Sources
Ragged Hierarchies
Set Data Source Properties
Processing Options and Settings
Test an Action
Create Calculated Members
Define Attribute Relationships
Define Logical Primary Keys in a Data Source View
Designing Aggregations
Define a Fact Relationship and Fact Relationship Properties
Multidimensional models
Create a Dimension by Using an Existing Table
Tools and Approaches for Processing
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Sandwell
- 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 ... Change table, column
- See Training Course Details...
Analyze a tabular model in Excel Deploy tabular model solutions
Object-level security
Set the Data Type of a Column
Understanding DAX in Tabular Models Measures
Enable DirectQuery mode in SSMS
Create and Manage Measures KPIs
Connect to a tabular model database
Manage Roles by using SSMS
Create a Relationship Between Two Tables
Import from Analysis Services
Process Tabular Model Partitions
Process Database, Table, or Partition
Add columns to a table
Data sources supported in tabular 1400 models
Import Data
Restore from Power Pivot
Create and Manage Hierarchies Partitions
Data sources supported in SSAS tabular 2016 Create Tabular Models
Test a model in DirectQuery mode
Email us about this courses
Other Sandwell Enable Technology Training Courses
TSQL - Sandwell SQL Training Courses
Access VBA Sandwell Training Courses
JavaScript Sandwell Training Courses
DAX Sandwell Training Courses
Access - Sandwell Access Training Courses
Excel 365 Advanced Sandwell Training Courses