SQL SERVER ANALYSIS SERVICES TRAINING COURSES PRESTON
About Enable Technology Preston SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Each course participant will be issued with training SQL Server Analysis Services resources which they can continue to use after the training. Anyone attending the course can contact the Tutor for as long as they like after the SQL Server Analysis Services course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. We are also more than happy to organise a local course at a socially distanced training location in Preston. We are happy to modify the SQL Server Analysis Services syllabus to match your teams 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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Canadian High Commission, National Power PLC, Keele University, Countrywide Homes Limited, Royal Air Force, EDF Energy PLC, Nuclear Engineering Services and Norwich Union PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Preston
- 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 ... Data sources supported in SSAS tabular 2017
- See Training Course Details...
Test a model in DirectQuery mode
Data types supported
Import from Power View
Hide or freeze columns
Enable DirectQuery mode in SSDT
DirectQuery Mode
Sort Data in a Table
Impersonation
Enable DirectQuery mode in SSMS
Create a Calculated Table
Rename a Table or Column
Import Data
Create and Manage KPIs Hierarchies
Create and Manage Roles
Topics include- Overview of SSAS Tabular models
Version comparison
Restore from Power Pivot
Create a New Tabular Model Project
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Preston
- 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 ... Defined Linked Measure Groups Partitions
- See Training Course Details...
Define Attribute Relationships
Backup and Restore of Analysis Services Databases
Test an Action
Define Logical Primary Keys in a Data Source View
Move an Analysis Services Database
Multidimensional models
Define Logical Relationships in a Data Source View
Delete a Data Source
Tools and Approaches for Processing
View the XML for an Analysis Services Project Data Sources
Use a Template to Create an Action Deployment
Calculations using the Business Intelligence Wizard
Create a Time Dimension by Generating a Time Table
Define Semiadditive Behavior
Create a Data Source
Modify or Delete in Solution Explorer Database Dimensions
KPIs Actions
Add a Standard Action
Deployment Requirements and Considerations for Analysis Services Deployment
Rename a Multidimensional Database Processing a multidimensional model
Email us about this courses
Other Preston Enable Technology Training Courses
Access VBA - Preston Access Training Courses
JQuery - Preston JavaScript Training Courses
PL/SQL - Preston SQL Training Courses
JQuery Mobile - Preston JavaScript Training Courses
Power Query - Preston Excel Training Courses
TSQL Preston Training Courses