SQL SERVER ANALYSIS SERVICES TRAINING COURSES BARNSLEY
About Enable Technology Barnsley SQL Server Analysis Services Training Courses
Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. 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. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of SQL Server Analysis Services course at a socially distanced venue near you in Barnsley. 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. Our clients include: Yell Group PLC, Norwich Union PLC, Barclays Bank PLC, Canadian High Commission, Nationwide Building Society Limited, Total Telecommunications Limited, Aston University and Shell UK Oil Products Ltd.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Barnsley
- 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 ... Change a Partition Source
- See Training Course Details...
Data Source Views
Modify or Delete in Solution Explorer Database Dimensions
Define a Data Source View
Create Named Sets
Define Attribute Relationships
Partition Writeback Calculations
Create Measures and Measure Groups
Tools and Approaches for Processing
Document and Script an Analysis Services Database
Error Configuration Roles and Permissions
Define Logical Primary Keys in a Data Source View
Use Aggregate Functions
Create a Dimension by Using an Existing Table
Backup and Restore of Analysis Services Databases
View the XML for an Analysis Services Project Data Sources
Use a Template to Create an Action Deployment
Define Named Queries in a Data Source View
Add a Standard Action
Deploy Analysis Services Projects
Rename a Multidimensional Database Processing a multidimensional model
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Barnsley
- 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 ... Sort Data in a Table
- See Training Course Details...
Import from Power View
Add columns to a table
Set the Data Type of a Column
Add sample data to DirectQuery models
Process Database, Table, or Partition
DAX formula compatibility in DirectQuery mode Tables and Columns
Import data by using a native query
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Object-level security
Enable DirectQuery mode in SSDT
Understanding DAX in Tabular Models Measures
Create a Calculated Table
Bi-directional cross filters Calculations
Create and Manage Hierarchies Partitions
Data sources supported in tabular 1200 models
Import from Power Pivot
Process Tabular Model Partitions
Data types supported
Data sources supported in tabular 1400 models
Email us about this courses
Other Barnsley Enable Technology Training Courses
Power Query Barnsley Training Courses
Excel 365 Advanced - Barnsley Excel Training Courses
VBA Barnsley Training Courses
Access Barnsley Training Courses
Oracle SQL Barnsley Training Courses
Access VBA Barnsley Training Courses