SQL SERVER ANALYSIS SERVICES TRAINING COURSES MOLD
About Enable Technology Mold SQL Server Analysis Services Training Courses
Enable Technology specialise in succinct skills based SQL Server Analysis Services training. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post 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. Enable Technology can supply all of the equipment necessary to deliver SQL Server Analysis Services courses onsite at your offices. You simply need to provide a suitable room. We can also deliver the SQL Server Analysis Services course at a local training venue in Mold. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
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 been delivering technical training in the Midlands for twenty years. Some of our clients are Homeserve PLC, Total Telecommunications Limited, Aston University, Royal Air Force, Norfolk Police Constabulary, Barclays Bank PLC, Fujistu PLC and South Staffordshire Water PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Mold
- 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 ... Set the Data Type of a Column
- See Training Course Details...
Connect to a tabular model database
Create and Manage Tabular Model Partitions
Create and Manage Roles
Add a table Delete a Table
Manage Roles by using SSMS
Enable DirectQuery mode in SSMS
Version comparison
Add sample data to DirectQuery models
Change table, column
Analyze a tabular model in Excel Deploy tabular model solutions
Create and Manage Hierarchies Partitions
Object-level security
Analyze in Excel
Rename a Table or Column
Data sources supported in SSAS tabular 2016 Create Tabular Models
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Delete a Column
Topics include- Overview of SSAS Tabular models
Create a Calculated Column
Add columns to a table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Mold
- 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 ... Replace a Table or a Named Query in a Data Source View
- See Training Course Details...
Use Aggregate Functions
Define Logical Primary Keys in a Data Source View
Define Time Intelligence
Deploy Analysis Services Projects
Define Assignments and Other Script Commands
Test an Action
Create Local Partitions
Delete a Data Source
Designing Aggregations
Use a Template to Create an Action Deployment
Error Configuration Roles and Permissions
Configure Analysis Services Project Properties
Multidimensional models
Move an Analysis Services Database
Set Data Source Properties
Create an Analysis Services Project
Define Logical Relationships in a Data Source View
Processing Databases, Dimensions and Partitions
Deploy Model Solutions Using the Deployment Wizard
Read Definition permissions
Email us about this courses
Other Mold Enable Technology Training Courses
SQL Mold Training Courses
Access - Mold Access Training Courses
PL/SQL Mold Training Courses
Report Builder Mold Training Courses
SSRS - Mold SQL Server Reporting Services Training Courses
Excel 365 Basic - Mold Excel Training Courses