SQL SERVER ANALYSIS SERVICES TRAINING COURSES DONCASTER
About Enable Technology Doncaster SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Doncaster. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your 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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Birmingham City University, Aston University, GKN PLC, Shell UK Oil Products Ltd, Cadbury PLC, DHL Express, Keele University and Nationwide Building Society Limited.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Doncaster
- 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 ... Create an Analysis Services Project
- See Training Course Details...
Create a Dimension Using the Dimension Wizard
Rename a Multidimensional Database Processing a multidimensional model
Create Remote Partitions
Define a Fact Relationship and Fact Relationship Properties
Define Named Calculations in a Data Source View
Test an Action
Work with Diagrams in Data Source View Designer
Create Calculated Members
Define a Referenced Relationship and Referenced Relationship Properties
Partition Writeback Calculations
Processing Databases, Dimensions and Partitions
Tools and Approaches for Processing
Backup Options Restore Options
Supported Data Sources
Defined Linked Measure Groups Partitions
Backup and Restore of Analysis Services Databases
Use a Template to Create an Action Deployment
Create a Dimension by Generating a Non-Time Table in the Data Source
Add or Remove Tables or Views in a Data Source View
Create a Data Source
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Doncaster
- 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 Tabular Model Partitions
- See Training Course Details...
Add sample data to DirectQuery models
Manage Roles by using SSMS
Topics include- Overview of SSAS Tabular models
Create and Manage Hierarchies Partitions
Hide or freeze columns
Enable DirectQuery mode in SSMS
Rename a Table or Column
Create a Calculated Column
Version comparison
Import Data
Import data by using a native query
Analyze in Excel
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Tabular model designer
Impersonation
Create a Relationship Between Two Tables
Specify Mark as Date Table for use with Time Intelligence
Create a New Tabular Model Project
Data types supported
Email us about this courses
Other Doncaster Enable Technology Training Courses
JQuery - Doncaster JavaScript Training Courses
Excel 365 Basic Doncaster Training Courses
Data Warehouse - Doncaster SQL Training Courses
Access - Doncaster Access Training Courses
Report Builder - Doncaster SQL Server Reporting Services Training Courses
SQL - Doncaster SQL Training Courses