SQL SERVER ANALYSIS SERVICES TRAINING COURSES WALSALL
About Enable Technology Walsall 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. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. Another way we could deliver the SQL Server Analysis Services course is at a local training site. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, TalkTalk Direct Limited, Norwich Union PLC, Nationwide Building Society Limited, Queen's Medical Centre Nottingham, Birmingham City Council, DHL Express and Carillion PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Walsall
- 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 ... Hide or freeze columns
- See Training Course Details...
Add sample data to DirectQuery models
Row filter mappings
Rename a Table or Column
Impersonation
Data types supported
Import from Analysis Services
Delete Relationships
Process Database, Table, or Partition
Enable DirectQuery mode in SSMS
Data sources supported in tabular 1400 models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Tabular model designer
Create and Manage Roles
Manage Roles by using SSMS
Create and Manage Measures KPIs
Database Process Partitions in the Workspace Database Perspectives
Sort Data in a Table
Bi-directional cross filters Calculations
Topics include- Overview of SSAS Tabular models
Enable DirectQuery mode in SSDT
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Walsall
- 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 Regular Relationship and Regular Relationship Properties
- See Training Course Details...
Move an Analysis Services Database
Create a Dimension by Generating a Non-Time Table in the Data Source
Replace a Table or a Named Query in a Data Source View
Document and Script an Analysis Services Database
Processing Options and Settings
Rename a Multidimensional Database Processing a multidimensional model
Partition Writeback Calculations
Add or Remove Tables or Views in a Data Source View
BI Wizard
Read Definition permissions
Using SQL Server Data Tools (SSDT)
Batch Processing Remote Processing
Modify or Delete in Solution Explorer Database Dimensions
Set Data Source Properties
Create User-Defined Hierarchies
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Logical Relationships in a Data Source View
Define Logical Primary Keys in a Data Source View
Create Calculated Members
Delete a Data Source View Dimensions
Email us about this courses
Other Walsall Enable Technology Training Courses
JQuery Walsall Training Courses
Excel 365 Intermediate - Walsall Excel Training Courses
Oracle SQL - Walsall SQL Training Courses
SSIS Walsall Training Courses
Access - Walsall Access Training Courses
Excel 365 Advanced Walsall Training Courses