SQL SERVER ANALYSIS SERVICES TRAINING COURSES WYTHENSHAWE
About Enable Technology Wythenshawe SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain 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.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft 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 SQL Server Analysis Services course at an alternative training site in Wythenshawe. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Queen's Medical Centre Nottingham, Nationwide Building Society Limited, National Power PLC, South Staffordshire Water PLC, Cadbury PLC, EDF Energy PLC, Countrywide Homes Limited and Lloyds TSB Bank PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wythenshawe
- 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 ... Define partitions in DirectQuery models
- See Training Course Details...
Add a table Delete a Table
Create and Manage Partitions in the Workspace
Delete a Column
Enable DirectQuery mode in SSDT
Data types supported
Create and Manage Tabular Model Partitions
Understanding DAX in Tabular Models Measures
Create a New Tabular Model Project
Rename a Table or Column
Create and Manage Perspectives Translations Roles
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power Pivot
Restore from Power Pivot
Process Database, Table, or Partition
Sort Data in a Table
Delete Relationships
Create and Manage Hierarchies Partitions
Enable DirectQuery mode in SSMS
Create and Manage KPIs Hierarchies
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wythenshawe
- 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 ... Using SQL Server Data Tools (SSDT)
- See Training Course Details...
Overview of SSAS Multidimensional Modelling
KPIs Actions
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Deployment Requirements and Considerations for Analysis Services Deployment
Supported Data Sources
Partition Writeback Calculations
Define Logical Relationships in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Use Aggregate Functions
Designing Aggregations
Deploy Model Solutions Using XMLA
Delete a Data Source
Create a Dimension by Generating a Non-Time Table in the Data Source
Add or Remove Tables or Views in a Data Source View
Document and Script an Analysis Services Database
Create a Data Source
Data Source object permissions
Tools and Approaches for Processing
Define Named Queries in a Data Source View
Create Calculated Members
Email us about this courses
Other Wythenshawe Enable Technology Training Courses
Excel Power Pivot Wythenshawe Training Courses
JQuery Mobile Wythenshawe Training Courses
SSIS - Wythenshawe SQL Server Integration Services Training Courses
Access VBA - Wythenshawe Access Training Courses
Excel 365 Intermediate - Wythenshawe Excel Training Courses
SQL Wythenshawe Training Courses