SQL SERVER ANALYSIS SERVICES TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country SQL Server Analysis Services Training Courses
We are a company that offers short, practical, SQL Server Analysis Services hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). All course participants are issued SQL Server Analysis Services training manuals they can refer to after the course. Course participants are welcome contact the Tutor after the course with specific SQL Server Analysis Services queries. This support is open ended.
SQL Server Analysis Services training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver SQL Server Analysis Services courses onsite at your site. The SQL Server Analysis Services course could also be scheduled at a socially distanced site near you in Black Country. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled SQL Server Analysis Services course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Our clients include: Vodafone Group Services, Boots UK Limited, Nuclear Engineering Services, National Power PLC, Countrywide Homes Limited, Norfolk Police Constabulary, Keele University and Canadian High Commission.
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Black Country
- 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 ... Create and Manage Roles
- See Training Course Details...
Bi-directional cross filters Calculations
Understanding DAX in Tabular Models Measures
Filter Data in a Table Relationships
Specify Mark as Date Table for use with Time Intelligence
Change table, column
Set the Data Type of a Column
Rename a Table or Column
Create and Manage Measures KPIs
Import from Analysis Services
Create and Manage Hierarchies Partitions
Create a Calculated Column
Delete Relationships
Test a model in DirectQuery mode
DirectQuery Mode
Import from Power Pivot
Process Database, Table, or Partition
Analyze a tabular model in Excel Deploy tabular model solutions
Create a Relationship Between Two Tables
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Black Country
- 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 ... Overview of SSAS Multidimensional Modelling
- See Training Course Details...
Set Data Source Properties
Define Attribute Relationships
Define Named Calculations in a Data Source View
Modify or Delete in Solution Explorer Database Dimensions
Configure Analysis Services Project Properties
Create a Dimension by Generating a Non-Time Table in the Data Source
Data Source Views
Add or Remove Tables or Views in a Data Source View
Set Partition Storage
Defined Linked Measure Groups Partitions
Define Logical Primary Keys in a Data Source View
KPIs Actions
Use Aggregate Functions
Define Assignments and Other Script Commands
Edit or Delete Partitions Merge Partitions
Work with Diagrams in Data Source View Designer
Multidimensional models
Database permissions
Processing Databases, Dimensions and Partitions
Backup Options Restore Options
Email us about this courses
Other Black Country Enable Technology Training Courses
Report Builder - Black Country SQL Server Reporting Services Training Courses
PL/SQL - Black Country SQL Training Courses
JQuery - Black Country JavaScript Training Courses
Data Warehouse Black Country Training Courses
SSIS Black Country Training Courses
TSQL Black Country Training Courses