SQL SERVER ANALYSIS SERVICES TRAINING COURSES BIRMINGHAM
About Enable Technology Birmingham SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. All of our tutors are Microsoft Certified Professionals. Every person attending a SQL Server Analysis Services course will be provided with training materials and practice files to retain after the course. It is our company policy to provide SQL Server Analysis Services training participants with ongoing support from the course Tutor. People who attend a SQL Server Analysis Services course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the SQL Server Analysis Services course at a local training venue in Birmingham. 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Nuclear Engineering Services, Dollond & Aitchison Limited, Birmingham Heartlands Hospital, Barclays Bank PLC, Shell UK Oil Products Ltd, Yell Group PLC, Aston University and Lloyds TSB Bank PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Birmingham
- 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 Referenced Relationship and Referenced Relationship Properties
- See Training Course Details...
Create Calculated Members
Overview of SSAS Multidimensional Modelling
Attach and Detach Analysis Services Databases
Create User-Defined Hierarchies
Using SQL Server Data Tools (SSDT)
Deploy Analysis Services Projects
Data Source Views
Define Assignments and Other Script Commands
BI Wizard
Batch Processing Remote Processing
Delete a Data Source View Dimensions
Create Named Sets
Define Named Queries in a Data Source View
Backup Options Restore Options
Calculations using the Business Intelligence Wizard
Create a Time Dimension by Generating a Time Table
Authorizing access to objects and operations
Create a Dimension by Using an Existing Table
Dimension permissions
Backup and Restore of Analysis Services Databases
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Birmingham
- 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 ... Set the Data Type of a Column
- See Training Course Details...
Import from Power Pivot
DAX formula compatibility in DirectQuery mode Tables and Columns
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Roles
Create and Manage Tabular Model Partitions
Specify Mark as Date Table for use with Time Intelligence
Change table, column
Define partitions in DirectQuery models
Analyze in Excel
Data types supported
Hide or freeze columns
Create and Manage KPIs Hierarchies
Topics include- Overview of SSAS Tabular models
Import from Power View
Understanding DAX in Tabular Models Measures
Delete a Column
Bi-directional cross filters Calculations
Delete Relationships
Email us about this courses
Other Birmingham Enable Technology Training Courses
PL/SQL Birmingham Training Courses
Power BI - Birmingham Microsoft Power BI Training Courses
Excel 365 Intermediate Birmingham Training Courses
Report Builder - Birmingham SQL Server Reporting Services Training Courses
TSQL Birmingham Training Courses
JQuery - Birmingham JavaScript Training Courses