SQL SERVER ANALYSIS SERVICES TRAINING COURSES GRIMSBY
About Enable Technology Grimsby SQL Server Analysis Services Training Courses
We are a company that provides short intensive SQL Server Analysis Services training 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. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.
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. Enable Technology can provide SQL Server Analysis Services courses onsite at your location. We will bring the necessary laptops with the required software installed. Another option is we can organise a local training site in Grimsby. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services 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.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Queen's Medical Centre Nottingham, South Staffordshire Water PLC, Canadian High Commission, Wolverhampton City Council, Vodafone Group Services, University of Birmingham, Loughborough University and National Power PLC.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Grimsby
- 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 ... Topics include- Overview of SSAS Tabular models
- See Training Course Details...
Process Database, Table, or Partition
Create a Calculated Column
Impersonation
Object-level security
Row filter mappings
Tabular model designer
Create and Manage Perspectives Translations Roles
Understanding DAX in Tabular Models Measures
Data sources supported in tabular 1400 models
Data types supported
Rename a Table or Column
DirectQuery Mode
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Connect to a tabular model database
Data sources supported in SSAS tabular 2017
Manage Roles by using SSMS
Create and Manage Measures KPIs
Create a Calculated Table
Import from Power View
Hide or freeze columns
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Grimsby
- 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 Attribute Relationships
- See Training Course Details...
Error Configuration Roles and Permissions
Ragged Hierarchies
Define Logical Primary Keys in a Data Source View
Create Measures and Measure Groups
Edit or Delete Partitions Merge Partitions
Calculations using the Business Intelligence Wizard
Create Remote Partitions
Partition Writeback Calculations
Modify or Delete in Solution Explorer Database Dimensions
Rename a Multidimensional Database Processing a multidimensional model
Add a Standard Action
Designing Aggregations
Processing Options and Settings
Create a Data Source
Replace a Table or a Named Query in a Data Source View
Database permissions
Define a Regular Relationship and Regular Relationship Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Define Assignments and Other Script Commands
Test an Action
Email us about this courses
Other Grimsby Enable Technology Training Courses
Excel Power Pivot - Grimsby Excel Training Courses
Excel 365 Intermediate - Grimsby Excel Training Courses
Report Builder - Grimsby SQL Server Reporting Services Training Courses
SSIS - Grimsby SQL Server Integration Services Training Courses
Data Warehouse Grimsby Training Courses
JQuery Grimsby Training Courses