SQL SERVER ANALYSIS SERVICES TRAINING COURSES SALISBURY
About Enable Technology Salisbury SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. We guarantee the training will be delivered by 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. 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. If you prefer we can offer an offsite training location in Salisbury. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled SQL Server Analysis Services classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Shell UK Oil Products Ltd, Loughborough University, Cadbury PLC, Dollond & Aitchison Limited, Unipart Group, Fujistu PLC, Capita Group PLC and Canadian High Commission.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Salisbury
- 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 ... BI Wizard
- See Training Course Details...
Create Calculated Members
Set Partition Storage
Processing Options and Settings
Create Local Partitions
Processing Databases, Dimensions and Partitions
Designing Aggregations
Data Source object permissions
Define a Data Source View
Create a Time Dimension by Generating a Time Table
Dimension permissions
Create Measures and Measure Groups
Create a Dimension by Using an Existing Table
Add or Remove Tables or Views in a Data Source View
Calculations using the Business Intelligence Wizard
Work with Diagrams in Data Source View Designer
Cube or model permissions Process permissions
Create a Dimension by Generating a Non-Time Table in the Data Source
Explore Data in a Data Source View
Backup and Restore of Analysis Services Databases
Multidimensional models
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Salisbury
- 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 SSMS
- See Training Course Details...
Define partitions in DirectQuery models
Create and Manage Roles
Create and Manage Measures KPIs
Connect to a tabular model database
Import from Power Pivot
Create a New Tabular Model Project
Create a Relationship Between Two Tables
Delete Relationships
Topics include- Overview of SSAS Tabular models
Hide or freeze columns
Bi-directional cross filters Calculations
Delete a Column
Import Data
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Tabular model designer
Change table, column
Import data by using a native query
Create and Manage Tabular Model Partitions
Email us about this courses
Other Salisbury Enable Technology Training Courses
Power Query - Salisbury Excel Training Courses
SQL - Salisbury SQL Training Courses
VBA Salisbury Training Courses
Excel 365 Intermediate - Salisbury Excel Training Courses
Report Builder - Salisbury SQL Server Reporting Services Training Courses
JQuery Mobile - Salisbury JavaScript Training Courses