SQL SERVER ANALYSIS SERVICES TRAINING COURSES BEDWORTH
About Enable Technology Bedworth SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Bedworth. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training 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 been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham Heartlands Hospital, Yell Group PLC, Loughborough University, DHL Express, GKN PLC, Lloyds TSB Bank PLC, Aston University and Total Telecommunications Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bedworth
- 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 Attribute Relationships
- See Training Course Details...
Define Logical Primary Keys in a Data Source View
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Cube or model permissions Process permissions
Set Partition Storage
Defined Linked Measure Groups Partitions
Define Time Intelligence
Add a Standard Action
Define a Referenced Relationship and Referenced Relationship Properties
Processing Databases, Dimensions and Partitions
Define a Data Source View
Change a Partition Source
Delete a Data Source View Dimensions
Multidimensional models
Partition Writeback Calculations
Calculations using the Business Intelligence Wizard
Deploy Model Solutions Using the Deployment Wizard
Deploy Analysis Services Projects
Replace a Table or a Named Query in a Data Source View
Deploy Model Solutions with the Deployment Utility
Define Semiadditive Behavior
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bedworth
- 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 Partitions in the Workspace
- See Training Course Details...
Define partitions in DirectQuery models
Delete a Column
Create a Calculated Column
DAX formula compatibility in DirectQuery mode Tables and Columns
Add sample data to DirectQuery models
Create a Calculated Table
Test a model in DirectQuery mode
Create and Manage KPIs Hierarchies
Database Process Partitions in the Workspace Database Perspectives
Specify Mark as Date Table for use with Time Intelligence
Data sources supported in SSAS tabular 2017
Process Tabular Model Partitions
Create a Relationship Between Two Tables
Create and Manage Measures KPIs
Rename a Table or Column
Create and Manage Hierarchies Partitions
Import from Power Pivot
Add columns to a table
Enable DirectQuery mode in SSDT
Tabular model designer
Email us about this courses
Other Bedworth Enable Technology Training Courses
SSRS - Bedworth SQL Server Reporting Services Training Courses
DAX Bedworth Training Courses
TSQL Bedworth Training Courses
VBA - Bedworth Excel Training Courses
Report Builder - Bedworth SQL Server Reporting Services Training Courses
Excel 365 Basic - Bedworth Excel Training Courses