SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Professionals. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We are set up to deliver SQL Server Analysis Services training courses onsite at your premises. Another option is we can organise a local training site in Black Country. The SQL Server Analysis Services syllabus can be modified to accommodate your specific training needs.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Boots UK Limited, National Power PLC, Nationwide Building Society Limited, Wolverhampton City Council, South Staffordshire Water PLC, Aston University, Keele University and Capita Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Black Country
- 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 ... Define a Regular Relationship and Regular Relationship Properties
- See Training Course Details...
Use a Template to Create an Action Deployment
Partition Writeback Calculations
Authorizing access to objects and operations
BI Wizard
Add or Remove Tables or Views in a Data Source View
Cube or model permissions Process permissions
Define Named Queries in a Data Source View
Delete a Data Source
Define Logical Relationships in a Data Source View
Tools and Approaches for Processing
Set Impersonation Options for a Data Source Connection
Create User-Defined Hierarchies
Supported Data Sources
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Local Partitions
Modify or Delete an Analysis Services Database
Deploy Analysis Services Projects
Edit or Delete Partitions Merge Partitions
Define a Data Source View
Create Measures and Measure Groups
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Black Country
- 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 ... Tabular model designer
- See Training Course Details...
Data sources supported in SSAS tabular 2017
Create a Calculated Column
Create and Manage Hierarchies Partitions
Enable DirectQuery mode in SSMS
Add sample data to DirectQuery models
Import from Power Pivot
Define partitions in DirectQuery models
Filter Data in a Table Relationships
Database Process Partitions in the Workspace Database Perspectives
Delete Relationships
Enable DirectQuery mode in SSDT
Test a model in DirectQuery mode
Process Tabular Model Partitions
Create and Manage Perspectives Translations Roles
Impersonation
Connect to a tabular model database
Import Data
Specify Mark as Date Table for use with Time Intelligence
Version comparison
Email us about this courses
Other Black Country Enable Technology Training Courses
VBA - Black Country Excel Training Courses
Access VBA - Black Country Access Training Courses
Report Builder Black Country Training Courses
Power Query Black Country Training Courses
JQuery Black Country Training Courses
SSIS - Black Country SQL Server Integration Services Training Courses