SQL SERVER ANALYSIS SERVICES TRAINING COURSES SHEFFIELD
About Enable Technology Sheffield SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Courses are instructor led and groups sizes small. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the SQL Server Analysis Services course is at a local training site. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Royal Air Force, Vodafone Group Services, University of Birmingham, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC, Homeserve PLC, TalkTalk Direct Limited and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Sheffield
- 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 ... Deploy from SQL Server Data Tools Manage Tabular Model Databases
- See Training Course Details...
Hide or freeze columns
Create and Manage Roles
Tabular model designer
Filter Data in a Table Relationships
Sort Data in a Table
Data sources supported in SSAS tabular 2016 Create Tabular Models
Create and Manage Partitions in the Workspace
Data types supported
Process Database, Table, or Partition
Create a Relationship Between Two Tables
Analyze in Excel
Topics include- Overview of SSAS Tabular models
Create and Manage Perspectives Translations Roles
Create and Manage Tabular Model Partitions
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in SSAS tabular 2017
Understanding DAX in Tabular Models Measures
Define partitions in DirectQuery models
Delete a Column
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Sheffield
- 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 ... Work with Diagrams in Data Source View Designer
- See Training Course Details...
Overview of SSAS Multidimensional Modelling
Calculations using the Business Intelligence Wizard
Define a Referenced Relationship and Referenced Relationship Properties
Document and Script an Analysis Services Database
Database permissions
Edit or Delete Partitions Merge Partitions
Change a Partition Source
Create User-Defined Hierarchies
Define Logical Primary Keys in a Data Source View
Defined Linked Measure Groups Partitions
Test an Action
Create an Analysis Services Project
Define a Data Source View
Replace a Table or a Named Query in a Data Source View
Define a Regular Relationship and Regular Relationship Properties
Define Attribute Relationships
Set Data Source Properties
Create a Dimension by Using an Existing Table
Delete a Data Source View Dimensions
Explore Data in a Data Source View
Email us about this courses
Other Sheffield Enable Technology Training Courses
JQuery Mobile Sheffield Training Courses
SSIS Sheffield Training Courses
Excel Power Pivot Sheffield Training Courses
SQL Sheffield Training Courses
VBA Sheffield Training Courses
Excel 365 Intermediate Sheffield Training Courses