SQL SERVER ANALYSIS SERVICES TRAINING COURSES RISCA
About Enable Technology Risca SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Enable Technology training courses are delivered as instructor led courses. 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 socially distanced training site. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
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 Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: GKN PLC, Shell UK Oil Products Ltd, Aston University, DHL Express, Dollond & Aitchison Limited, Birmingham City University, Cadbury PLC and Canadian High Commission.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Risca
- 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 ... Bi-directional cross filters Calculations
- See Training Course Details...
Create and Manage Roles
Sort Data in a Table
Create a New Tabular Model Project
Create and Manage Perspectives Translations Roles
Test a model in DirectQuery mode
Data sources supported in tabular 1400 models
Object-level security
DirectQuery Mode
Tabular model designer
Import from Power Pivot
Define partitions in DirectQuery models
Create and Manage Partitions in the Workspace
Manage Roles by using SSMS
Row filter mappings
Topics include- Overview of SSAS Tabular models
Enable DirectQuery mode in SSMS
Analyze a tabular model in Excel Deploy tabular model solutions
Understanding DAX in Tabular Models Measures
Version comparison
Analyze in Excel
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Risca
- 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 ... Define Assignments and Other Script Commands
- See Training Course Details...
Data Source object permissions
Define Time Intelligence
Database permissions
Work with Diagrams in Data Source View Designer
Replace a Table or a Named Query in a Data Source View
Supported Data Sources
Define a Fact Relationship and Fact Relationship Properties
Create Named Sets
Define Semiadditive Behavior
View the XML for an Analysis Services Project Data Sources
Move an Analysis Services Database
Set Data Source Properties
Test an Action
Using SQL Server Data Tools (SSDT)
Rename a Multidimensional Database Processing a multidimensional model
Add a Standard Action
Use Aggregate Functions
Dimension permissions
KPIs Actions
Designing Aggregations
Email us about this courses
Other Risca Enable Technology Training Courses
Power Query - Risca Excel Training Courses
Excel 365 Basic Risca Training Courses
Oracle SQL - Risca SQL Training Courses
JavaScript - Risca JavaScript Training Courses
Excel 365 Advanced - Risca Excel Training Courses
Power BI Risca Training Courses