SQL SERVER ANALYSIS SERVICES TRAINING COURSES WIGAN
About Enable Technology Wigan SQL Server Analysis Services Training Courses
We are company which specialises in short, two and three day intensive SQL Server Analysis Services technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each SQL Server Analysis Services training participant with learning resources which they can refer to post training. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Wigan. All SQL Server Analysis Services courses can be customised to meet your particular requirements.
SQL Server Analysis Services courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Birmingham City University, Royal Air Force, West Bromwich Building Society, Shell UK Oil Products Ltd, Barclays Bank PLC, University of Birmingham, Fujistu PLC and TalkTalk Direct Limited.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Wigan
- 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 ... Understanding DAX in Tabular Models Measures
- See Training Course Details...
Topics include- Overview of SSAS Tabular models
Bi-directional cross filters Calculations
Database Process Partitions in the Workspace Database Perspectives
Filter Data in a Table Relationships
Restore from Power Pivot
Create a Relationship Between Two Tables
Enable DirectQuery mode in SSDT
Sort Data in a Table
Create and Manage Partitions in the Workspace
Create and Manage KPIs Hierarchies
Create and Manage Tabular Model Partitions
Define partitions in DirectQuery models
Process Database, Table, or Partition
Create a New Tabular Model Project
Create a Calculated Table
Specify Mark as Date Table for use with Time Intelligence
Tabular model designer
Import Data
Create and Manage Measures KPIs
Import from Power Pivot
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Wigan
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Create a Time Dimension by Generating a Time Table
Configure Analysis Services Project Properties
Designing Aggregations
Work with Diagrams in Data Source View Designer
Define Logical Relationships in a Data Source View
Create Remote Partitions
Document and Script an Analysis Services Database
BI Wizard
Create a Dimension by Using an Existing Table
Partition Writeback Calculations
Create User-Defined Hierarchies
Rename a Multidimensional Database Processing a multidimensional model
Create Local Partitions
Create Calculated Members
Define a Data Source View
Using SQL Server Data Tools (SSDT)
Define Logical Primary Keys in a Data Source View
Define Named Calculations in a Data Source View
Set Data Source Properties
Deploy Model Solutions with the Deployment Utility
Email us about this courses
Other Wigan Enable Technology Training Courses
Excel 365 Basic - Wigan Excel Training Courses
Excel 365 Advanced Wigan Training Courses
VBA - Wigan Excel Training Courses
JQuery Wigan Training Courses
Access VBA Wigan Training Courses
Power Query Wigan Training Courses