SQL SERVER ANALYSIS SERVICES TRAINING COURSES WALSALL
About Enable Technology Walsall SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. 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.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. If you prefer we can offer an offsite training location in Walsall. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, Norwich Union PLC, Norfolk Police Constabulary, Barclays Bank PLC, Birmingham City Council, Royal Air Force and Dollond & Aitchison Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Walsall
- 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 ... Create and Manage Measures KPIs
- See Training Course Details...
Version comparison
DAX formula compatibility in DirectQuery mode Tables and Columns
Import from Power View
Process Tabular Model Partitions
Analyze a tabular model in Excel Deploy tabular model solutions
Add a table Delete a Table
Restore from Power Pivot
Add columns to a table
Row filter mappings
Connect to a tabular model database
Delete Relationships
Enable DirectQuery mode in SSDT
Create and Manage Roles
Understanding DAX in Tabular Models Measures
Set the Data Type of a Column
Hide or freeze columns
Create and Manage Hierarchies Partitions
Define partitions in DirectQuery models
Manage Roles by using SSMS
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Walsall
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Define Named Queries in a Data Source View
BI Wizard
Create a Data Source
Move an Analysis Services Database
Data Source object permissions
Read Definition permissions
Define a Fact Relationship and Fact Relationship Properties
Define a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Set Impersonation Options for a Data Source Connection
Define Named Calculations in a Data Source View
Deploy Model Solutions with the Deployment Utility
Defined Linked Measure Groups Partitions
Create a Dimension by Using an Existing Table
Add or Remove Tables or Views in a Data Source View
Define Logical Primary Keys in a Data Source View
Delete a Data Source
Explore Data in a Data Source View
Use Aggregate Functions
Define Logical Relationships in a Data Source View
Email us about this courses
Other Walsall Enable Technology Training Courses
Excel 365 Advanced Walsall Training Courses
TSQL - Walsall SQL Training Courses
Access Walsall Training Courses
Oracle SQL - Walsall SQL Training Courses
JQuery - Walsall JavaScript Training Courses
Access VBA Walsall Training Courses