SQL SERVER ANALYSIS SERVICES TRAINING COURSES WIGAN
About Enable Technology Wigan SQL Server Analysis Services Training Courses
We have a twenty year history of providing skills based SQL Server Analysis Services industry training. The tutor delivering the course will be a Microsoft certified expert. All candidates receive comprehensive SQL Server Analysis Services training materials and practice files which are theirs to refer to after the course. Enable Technology offer post course help to all delegates. Participants on the SQL Server Analysis Services course can contact the tutor for as long as they like if they encounter SQL Server Analysis Services problems.
Delegates are taught by an experienced Microsoft professional. SQL Server Analysis Services courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Wigan. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual SQL Server Analysis Services class and can both talk to and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: West Bromwich Building Society, Halfords Group PLC, DHL Express, Royal Air Force, EDF Energy PLC, South Staffordshire Water PLC, Aston University and Birmingham City Council.
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 ... Ragged Hierarchies
- See Training Course Details...
Define Time Intelligence
Use Aggregate Functions
Database permissions
Edit or Delete Partitions Merge Partitions
Create a Data Source
Backup and Restore of Analysis Services Databases
Use a Template to Create an Action Deployment
Work with Diagrams in Data Source View Designer
Explore Data in a Data Source View
Create Measures and Measure Groups
Data Source object permissions
Define a Fact Relationship and Fact Relationship Properties
Replace a Table or a Named Query in a Data Source View
Read Definition permissions
Define Named Calculations in a Data Source View
Deploy Model Solutions Using the Deployment Wizard
Add or Remove Tables or Views in a Data Source View
Overview of SSAS Multidimensional Modelling
Supported Data Sources
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
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 ... Analyze a tabular model in Excel Deploy tabular model solutions
- See Training Course Details...
Create and Manage Hierarchies Partitions
Delete Relationships
Sort Data in a Table
Topics include- Overview of SSAS Tabular models
Restore from Power Pivot
Import data by using a native query
Create and Manage Roles
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Data types supported
Delete a Column
Object-level security
Import from Power View
Analyze in Excel
Create a Relationship Between Two Tables
Row filter mappings
Create and Manage Tabular Model Partitions
Enable DirectQuery mode in SSDT
Hide or freeze columns
Email us about this courses
Other Wigan Enable Technology Training Courses
Excel 365 Advanced Wigan Training Courses
TSQL Wigan Training Courses
Access Wigan Training Courses
Excel 365 Intermediate - Wigan Excel Training Courses
Report Builder - Wigan SQL Server Reporting Services Training Courses
JQuery - Wigan JavaScript Training Courses