SQL SERVER ANALYSIS SERVICES TRAINING COURSES WEST GLAMORGAN
About Enable Technology West Glamorgan SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and SQL Server Analysis Services course resources that can be referenced post training. Our policy is to provide open ended SQL Server Analysis Services post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
SQL Server Analysis Services courses are taught by a Microsoft Certified Solutions Expert. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a venue near you in West Glamorgan. We are happy to modify the SQL Server Analysis Services syllabus to match your teams training 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
We have operated primarily in the West Midlands for twenty years. Our clients include: GKN PLC, Boots UK Limited, Birmingham City Council, West Bromwich Building Society, Capita Group PLC, Norfolk Police Constabulary, University of Birmingham and Norwich Union PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: West Glamorgan
- 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 ... Attach and Detach Analysis Services Databases
- See Training Course Details...
Create a Dimension Using the Dimension Wizard
Cube or model permissions Process permissions
Configure Measure Group Properties
Defined Linked Measure Groups Partitions
Using SQL Server Data Tools (SSDT)
View the XML for an Analysis Services Project Data Sources
Data Source Views
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Create Local Partitions
Define a Data Source View
BI Wizard
Create Named Sets
Tools and Approaches for Processing
Change a Partition Source
Calculations using the Business Intelligence Wizard
Document and Script an Analysis Services Database
Set Impersonation Options for a Data Source Connection
Authorizing access to objects and operations
Dimension permissions
Define Logical Primary Keys in a Data Source View
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: West Glamorgan
- 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 ... Bi-directional cross filters Calculations
- See Training Course Details...
Rename a Table or Column
Create and Manage Measures KPIs
Import from Power View
Data sources supported in tabular 1200 models
Impersonation
Understanding DAX in Tabular Models Measures
Create a Calculated Column
Create and Manage KPIs Hierarchies
Create and Manage Tabular Model Partitions
Create and Manage Partitions in the Workspace
Create and Manage Hierarchies Partitions
Create a Relationship Between Two Tables
Delete Relationships
Enable DirectQuery mode in SSDT
Row filter mappings
Analyze in Excel
Process Tabular Model Partitions
Delete a Column
Email us about this courses
Other West Glamorgan Enable Technology Training Courses
Report Builder West Glamorgan Training Courses
Excel 365 Basic West Glamorgan Training Courses
Access West Glamorgan Training Courses
SSRS - West Glamorgan SQL Server Reporting Services Training Courses
Data Warehouse - West Glamorgan SQL Training Courses
Access VBA West Glamorgan Training Courses