SQL SERVER ANALYSIS SERVICES TRAINING COURSES BROMSGROVE
About Enable Technology Bromsgrove SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. The tutor delivering the course will be a Microsoft certified expert. We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. We can also deliver the SQL Server Analysis Services course at a local training venue in Bromsgrove. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: TalkTalk Direct Limited, Total Telecommunications Limited, Lloyds TSB Bank PLC, Norfolk Police Constabulary, Keele University, Royal & Sun Alliance Group PLC, Norwich Union PLC and EDF Energy PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bromsgrove
- 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 ... Analyze a tabular model in Excel Deploy tabular model solutions
- See Training Course Details...
DirectQuery Mode
Test a model in DirectQuery mode
Sort Data in a Table
Define partitions in DirectQuery models
Rename a Table or Column
Version comparison
Filter Data in a Table Relationships
Create a Calculated Table
Enable DirectQuery mode in SSDT
Data sources supported in SSAS tabular 2017
Data types supported
Hide or freeze columns
Import data by using a native query
Create and Manage Measures KPIs
Import from Power View
Data sources supported in tabular 1200 models
Row filter mappings
Import from Power Pivot
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bromsgrove
- 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 ... Delete a Data Source
- See Training Course Details...
Create Calculated Members
Define Named Calculations in a Data Source View
View the XML for an Analysis Services Project Data Sources
Create User-Defined Hierarchies
Define Named Queries in a Data Source View
Defined Linked Measure Groups Partitions
Define a Fact Relationship and Fact Relationship Properties
Create a Dimension by Using an Existing Table
Set Impersonation Options for a Data Source Connection
Use a Template to Create an Action Deployment
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Data Source Views
Modify or Delete in Solution Explorer Database Dimensions
Create a Dimension Using the Dimension Wizard
Define a Regular Relationship and Regular Relationship Properties
Overview of SSAS Multidimensional Modelling
Tools and Approaches for Processing
Add a Standard Action
BI Wizard
Define Logical Relationships in a Data Source View
Email us about this courses
Other Bromsgrove Enable Technology Training Courses
Data Warehouse Bromsgrove Training Courses
SQL Bromsgrove Training Courses
Excel 365 Advanced - Bromsgrove Excel Training Courses
Excel 365 Basic Bromsgrove Training Courses
TSQL - Bromsgrove SQL Training Courses
Report Builder - Bromsgrove SQL Server Reporting Services Training Courses