SQL SERVER ANALYSIS SERVICES TRAINING COURSES STAFFORD
About Enable Technology Stafford SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. If delegates have have questions about SQL Server Analysis Services after the course they are welcome to contact the course Tutor. This post training support is ongoing.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. Another way we could deliver the SQL Server Analysis Services course is at a local training site. Every SQL Server Analysis Services course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time 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, EDF Energy PLC, Loughborough University, Total Telecommunications Limited, Homeserve PLC, Carillion PLC, Boots UK Limited and Keele University.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stafford
- 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 ... Enable DirectQuery mode in SSDT
- See Training Course Details...
Rename a Table or Column
Bi-directional cross filters Calculations
Data types supported
Create and Manage Hierarchies Partitions
Connect to a tabular model database
Data sources supported in SSAS tabular 2017
Tabular model designer
Create and Manage Measures KPIs
Data sources supported in SSAS tabular 2016 Create Tabular Models
Impersonation
Topics include- Overview of SSAS Tabular models
Create and Manage KPIs Hierarchies
Understanding DAX in Tabular Models Measures
Sort Data in a Table
Import from Power View
Set the Data Type of a Column
Create and Manage Tabular Model Partitions
Process Tabular Model Partitions
Create a New Tabular Model Project
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stafford
- 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 ... Use a Template to Create an Action Deployment
- See Training Course Details...
Modify or Delete an Analysis Services Database
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
BI Wizard
Batch Processing Remote Processing
Create Remote Partitions
Defined Linked Measure Groups Partitions
Create a Data Source
Define Named Queries in a Data Source View
Add a Standard Action
Attach and Detach Analysis Services Databases
Explore Data in a Data Source View
Define a Fact Relationship and Fact Relationship Properties
Create a Dimension Using the Dimension Wizard
Data Source Views
Define a Data Source View
Set Impersonation Options for a Data Source Connection
Overview of SSAS Multidimensional Modelling
Error Configuration Roles and Permissions
Tools and Approaches for Processing
Create Measures and Measure Groups
Email us about this courses
Other Stafford Enable Technology Training Courses
VBA - Stafford Excel Training Courses
Excel Power Pivot Stafford Training Courses
SSIS Stafford Training Courses
Access VBA - Stafford Access Training Courses
Excel 365 Intermediate Stafford Training Courses
Report Builder Stafford Training Courses