SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDGNORTH
About Enable Technology Bridgnorth SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Bridgnorth. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led SQL Server Analysis Services training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Canadian High Commission, Homeserve PLC, Loughborough University, Boots UK Limited, Lloyds TSB Bank PLC, Fujistu PLC, Barclays Bank PLC and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... Edit or Delete Partitions Merge Partitions
- See Training Course Details...
Explore Data in a Data Source View
Add a Standard Action
Create a Dimension by Generating a Non-Time Table in the Data Source
Delete a Data Source
Data Source Views
Create Remote Partitions
Create Named Sets
Configure Measure Group Properties
Define a Fact Relationship and Fact Relationship Properties
Create User-Defined Hierarchies
Dimension permissions
Set Partition Storage
Define Logical Primary Keys in a Data Source View
Define a Data Source View
Define Attribute Relationships
Test an Action
Move an Analysis Services Database
KPIs Actions
Error Configuration Roles and Permissions
Deploy Model Solutions Using XMLA
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bridgnorth
- 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 ... Import data by using a native query
- See Training Course Details...
Connect to a tabular model database
Analyze in Excel
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Enable DirectQuery mode in SSDT
Create a Relationship Between Two Tables
Hide or freeze columns
Import from Power Pivot
Create a Calculated Table
Specify Mark as Date Table for use with Time Intelligence
Rename a Table or Column
Set the Data Type of a Column
Create and Manage Hierarchies Partitions
Change table, column
Import Data
Create and Manage Tabular Model Partitions
Add a table Delete a Table
Create and Manage Measures KPIs
Topics include- Overview of SSAS Tabular models
Email us about this courses
Other Bridgnorth Enable Technology Training Courses
Power Query Bridgnorth Training Courses
Excel 365 Advanced Bridgnorth Training Courses
Oracle SQL Bridgnorth Training Courses
Access VBA Bridgnorth Training Courses
Excel 365 Intermediate - Bridgnorth Excel Training Courses
JQuery Mobile - Bridgnorth JavaScript Training Courses