SQL SERVER ANALYSIS SERVICES TRAINING COURSES YOEVIL
About Enable Technology Yoevil SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor delivering the course will be a Microsoft certified expert. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Yoevil. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training requirements.
SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: GKN PLC, Norfolk Police Constabulary, TalkTalk Direct Limited, Capita Group PLC, Royal & Sun Alliance Group PLC, Aston University, National Power PLC and Cadbury PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Yoevil
- 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 Perspectives Translations Roles
- See Training Course Details...
Process Database, Table, or Partition
Create and Manage KPIs Hierarchies
Test a model in DirectQuery mode
Version comparison
Import Data
Define partitions in DirectQuery models
Import from Power Pivot
Restore from Power Pivot
Create and Manage Partitions in the Workspace
Object-level security
Create and Manage Tabular Model Partitions
Data sources supported in tabular 1200 models
Process Tabular Model Partitions
Create a Relationship Between Two Tables
DAX formula compatibility in DirectQuery mode Tables and Columns
Add a table Delete a Table
Import from Power View
Add columns to a table
Data types supported
Import from Analysis Services
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Yoevil
- 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 ... Calculations using the Business Intelligence Wizard
- See Training Course Details...
Create Remote Partitions
Define a Fact Relationship and Fact Relationship Properties
Define Semiadditive Behavior
Deploy Model Solutions Using the Deployment Wizard
Use a Template to Create an Action Deployment
Deploy Analysis Services Projects
Create a Data Source
Change a Partition Source
Dimension permissions
Add a Standard Action
Replace a Table or a Named Query in a Data Source View
Configure Measure Group Properties
Data Source object permissions
Create a Dimension by Generating a Non-Time Table in the Data Source
Create a Time Dimension by Generating a Time Table
Define Assignments and Other Script Commands
Set Data Source Properties
Ragged Hierarchies
View the XML for an Analysis Services Project Data Sources
Move an Analysis Services Database
Email us about this courses
Other Yoevil Enable Technology Training Courses
JQuery Yoevil Training Courses
Excel 365 Intermediate - Yoevil Excel Training Courses
Excel 365 Basic Yoevil Training Courses
Power BI Yoevil Training Courses
Excel 365 Advanced Yoevil Training Courses
TSQL Yoevil Training Courses