SQL SERVER ANALYSIS SERVICES TRAINING COURSES STROUD
About Enable Technology Stroud SQL Server Analysis Services Training Courses
We offer intensive two and three days SQL Server Analysis Services courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a SQL Server Analysis Services course receives learning resources which also serves as a reference source after the course. We offer a post training support service and delegates will have access to a Microsoft expert on SQL Server Analysis Services for as long as they need.
Enable Technology SQL Server Analysis Services courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver SQL Server Analysis Services courses at your site. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Stroud. Every SQL Server Analysis Services course can be modified to meet your bespoke 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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: DHL Express, TalkTalk Direct Limited, University of Birmingham, Wolverhampton City Council, EDF Energy PLC, Barclays Bank PLC, Cadbury PLC and Yell Group PLC.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Stroud
- 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 ... Authorizing access to objects and operations
- See Training Course Details...
BI Wizard
Create Calculated Members
Delete a Data Source View Dimensions
Create a Data Source
Processing Databases, Dimensions and Partitions
Create a Dimension by Generating a Non-Time Table in the Data Source
Deployment Requirements and Considerations for Analysis Services Deployment
Create a Time Dimension by Generating a Time Table
Define Semiadditive Behavior
Define Logical Primary Keys in a Data Source View
Dimension permissions
Calculations using the Business Intelligence Wizard
Define a Fact Relationship and Fact Relationship Properties
Rename a Multidimensional Database Processing a multidimensional model
Set Impersonation Options for a Data Source Connection
Tools and Approaches for Processing
Delete a Data Source
Define Named Calculations in a Data Source View
Define Named Queries in a Data Source View
Define Time Intelligence
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Stroud
- 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 ... DAX formula compatibility in DirectQuery mode Tables and Columns
- See Training Course Details...
Restore from Power Pivot
Delete a Column
Enable DirectQuery mode in SSDT
Database Process Partitions in the Workspace Database Perspectives
Create and Manage Tabular Model Partitions
Import from Power Pivot
Create a Calculated Column
Tabular model designer
Create and Manage Hierarchies Partitions
Add columns to a table
DirectQuery Mode
Manage Roles by using SSMS
Add a table Delete a Table
Deploy from SQL Server Data Tools Manage Tabular Model Databases
Import data by using a native query
Filter Data in a Table Relationships
Process Database, Table, or Partition
Create and Manage Partitions in the Workspace
Email us about this courses
Other Stroud Enable Technology Training Courses
JQuery Mobile - Stroud JavaScript Training Courses
TSQL Stroud Training Courses
Data Warehouse - Stroud SQL Training Courses
Access - Stroud Access Training Courses
JQuery Stroud Training Courses
Excel 365 Advanced Stroud Training Courses