SQL SERVER ANALYSIS SERVICES TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given SQL Server Analysis Services courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the SQL Server Analysis Services onsite. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Uttoxeter. We will work with you prior to the course to tailor the SQL Server Analysis Services syllabus to match your 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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Homeserve PLC, Nuclear Engineering Services, Canadian High Commission, Yell Group PLC, University of Birmingham, Boots UK Limited, Barclays Bank PLC and Birmingham City Council.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Uttoxeter
- 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 ... Set Data Source Properties
- See Training Course Details...
Authorizing access to objects and operations
Work with Diagrams in Data Source View Designer
Replace a Table or a Named Query in a Data Source View
Calculations using the Business Intelligence Wizard
Define Logical Relationships in a Data Source View
Rename a Multidimensional Database Processing a multidimensional model
Set Partition Storage
Modify or Delete an Analysis Services Database
Change a Partition Source
Overview of SSAS Multidimensional Modelling
Create Remote Partitions
Set Impersonation Options for a Data Source Connection
Define Logical Primary Keys in a Data Source View
Create a Time Dimension by Generating a Time Table
Error Configuration Roles and Permissions
Create Calculated Members
Database permissions
Processing Databases, Dimensions and Partitions
Add a Standard Action
Define Semiadditive Behavior
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Uttoxeter
- 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 ... Hide or freeze columns
- See Training Course Details...
Create and Manage Tabular Model Partitions
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Filter Data in a Table Relationships
Create a Calculated Column
Enable DirectQuery mode in SSMS
Delete Relationships
Create and Manage KPIs Hierarchies
Topics include- Overview of SSAS Tabular models
Sort Data in a Table
Database Process Partitions in the Workspace Database Perspectives
Import from Power View
Data sources supported in SSAS tabular 2016 Create Tabular Models
Process Database, Table, or Partition
Add columns to a table
Analyze in Excel
Create and Manage Hierarchies Partitions
Create and Manage Measures KPIs
Import from Analysis Services
Create and Manage Partitions in the Workspace
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
JavaScript - Uttoxeter JavaScript Training Courses
Power BI Uttoxeter Training Courses
DAX - Uttoxeter Excel Training Courses
Data Warehouse Uttoxeter Training Courses
SSIS Uttoxeter Training Courses
SQL Uttoxeter Training Courses