SQL SERVER ANALYSIS SERVICES TRAINING COURSES UK
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Uk
- 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 ... Hide or freeze columns
- See Training Course Details...
Import from Power Pivot
Create and Manage KPIs Hierarchies
Analyze in Excel
Create a Calculated Table
Data sources supported in SSAS tabular 2017
Create and Manage Tabular Model Partitions
Understanding DAX in Tabular Models Measures
Create and Manage Measures KPIs
Rename a Table or Column
Delete Relationships
Set the Data Type of a Column
Create a New Tabular Model Project
Version comparison
DAX formula compatibility in DirectQuery mode Tables and Columns
Data sources supported in tabular 1400 models
Tabular model designer
Enable DirectQuery mode in SSMS
Create a Relationship Between Two Tables
Add a table Delete a Table
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Uk
- 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 ... Defined Linked Measure Groups Partitions
- See Training Course Details...
Work with Diagrams in Data Source View Designer
Explore Data in a Data Source View
Change a Partition Source
Set Data Source Properties
Read Definition permissions
Ragged Hierarchies
Using SQL Server Data Tools (SSDT)
Create an Analysis Services Project
Calculations using the Business Intelligence Wizard
Configure Analysis Services Project Properties
Define a Regular Relationship and Regular Relationship Properties
Attach and Detach Analysis Services Databases
Document and Script an Analysis Services Database
Define a Fact Relationship and Fact Relationship Properties
Processing Options and Settings
Delete a Data Source
Deploy Model Solutions Using the Deployment Wizard
Database permissions
Create Calculated Members
Backup Options Restore Options
Email us about this courses
Other Uk Enable Technology Training Courses
Data Warehouse - Uk SQL Training Courses
Excel 365 Advanced - Uk Excel Training Courses
JQuery Mobile - Uk JavaScript Training Courses
JQuery Uk Training Courses
Power Query Uk Training Courses
SQL Uk Training Courses