SQL SERVER ANALYSIS SERVICES TRAINING COURSES BRIDLINGTON
About Enable Technology Bridlington SQL Server Analysis Services Training Courses
Enable Technology provides practical SQL Server Analysis Services skills based technology training. The tutor teaching the course will be an experienced developer and Microsoft certified professional. 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 offers instructor led training taught by technology specialists. Enable Technology SQL Server Analysis Services courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If you prefer we can offer an offsite training location in Bridlington. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.
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. Some of our clients are Yell Group PLC, Birmingham City Council, Total Telecommunications Limited, DHL Express, Barclays Bank PLC, Unipart Group, Countrywide Homes Limited and Norfolk Police Constabulary.
Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling
- 2 day course
- Location: Bridlington
- 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 ... Deploy Analysis Services Projects
- See Training Course Details...
Configure Measure Group Properties
Delete a Data Source View Dimensions
Create an Analysis Services Project
Work with Diagrams in Data Source View Designer
Explore Data in a Data Source View
BI Wizard
Define a Fact Relationship and Fact Relationship Properties
Database permissions
Move an Analysis Services Database
Set Partition Storage
Create a Dimension Using the Dimension Wizard
Calculations using the Business Intelligence Wizard
Modify or Delete an Analysis Services Database
Delete a Data Source
Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
Define Named Calculations in a Data Source View
Create Local Partitions
Dimension permissions
Use Aggregate Functions
Read Definition permissions
Microsoft SQL Server Analysis Services Tabular Modelling
- 2 day course
- Location: Bridlington
- 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 Perspectives Translations Roles
- See Training Course Details...
DAX formula compatibility in DirectQuery mode Tables and Columns
Change table, column
Version comparison
Delete a Column
Create and Manage KPIs Hierarchies
Connect to a tabular model database
Impersonation
Create a Calculated Column
Create a New Tabular Model Project
Topics include- Overview of SSAS Tabular models
Create and Manage Partitions in the Workspace
Create and Manage Tabular Model Partitions
Analyze a tabular model in Excel Deploy tabular model solutions
Specify Mark as Date Table for use with Time Intelligence
Create a Calculated Table
Import from Power View
DirectQuery Mode
Database Process Partitions in the Workspace Database Perspectives
Understanding DAX in Tabular Models Measures
Email us about this courses
Other Bridlington Enable Technology Training Courses
JQuery Bridlington Training Courses
VBA - Bridlington Excel Training Courses
JavaScript - Bridlington JavaScript Training Courses
Oracle SQL - Bridlington SQL Training Courses
Access VBA Bridlington Training Courses
Power BI Bridlington Training Courses