SQL SERVER ANALYSIS SERVICES TRAINING COURSES SMETHWICK
About Enable Technology Smethwick SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. We are also more than happy to organise a local course at a socially distanced training location in Smethwick. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your requirements.
Taught SQL Server Analysis Services courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Vodafone Group Services, Nationwide Building Society Limited, Birmingham City University, TalkTalk Direct Limited, National Power PLC, West Bromwich Building Society, Royal Air Force and Loughborough University.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Smethwick
- 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 ... KPIs Actions
- See Training Course Details...
Define a Fact Relationship and Fact Relationship Properties
Edit or Delete Partitions Merge Partitions
Create User-Defined Hierarchies
Work with Diagrams in Data Source View Designer
Define Semiadditive Behavior
Deploy Model Solutions Using XMLA
Create Named Sets
Define Assignments and Other Script Commands
Batch Processing Remote Processing
Configure Measure Group Properties
Configure Analysis Services Project Properties
Designing Aggregations
Authorizing access to objects and operations
Modify or Delete an Analysis Services Database
Use Aggregate Functions
Define a Regular Relationship and Regular Relationship Properties
Create Measures and Measure Groups
Delete a Data Source
Modify or Delete in Solution Explorer Database Dimensions
Set Partition Storage
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Smethwick
- 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 ... Row filter mappings
- See Training Course Details...
Create and Manage Tabular Model Partitions
Sort Data in a Table
DAX formula compatibility in DirectQuery mode Tables and Columns
Enable DirectQuery mode in SSMS
Create and Manage Partitions in the Workspace
Import data by using a native query
Data sources supported in SSAS tabular 2017
Create and Manage Measures KPIs
Add a table Delete a Table
Rename a Table or Column
Create a Calculated Table
Tabular model designer
Enable DirectQuery mode in SSDT
Delete Relationships
Object-level security
Import from Power View
Import Data
Hide or freeze columns
Connect to a tabular model database
Data types supported
Email us about this courses
Other Smethwick Enable Technology Training Courses
TSQL - Smethwick SQL Training Courses
PL/SQL Smethwick Training Courses
Data Warehouse - Smethwick SQL Training Courses
Excel 365 Intermediate Smethwick Training Courses
SSRS - Smethwick SQL Server Reporting Services Training Courses
DAX Smethwick Training Courses