Enable Technology

SQL SERVER ANALYSIS SERVICES NORMANTON TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES NORMANTON




About Enable Technology Normanton SQL Server Analysis Services Training Courses

Enable Technology provides practical SQL Server Analysis Services skills based technology training. The training will be delivered by a Microsoft professional with development experience. 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.

Courses are instructor led and groups sizes small. Enable Technology SQL Server Analysis Services training courses can be delivered at your offices. We can supply the necessary software and computers. We are also more than happy to organise a local course at a socially distanced training location in Normanton. 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.

The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Loughborough University, Carillion PLC, Lloyds TSB Bank PLC, University of Birmingham, Royal & Sun Alliance Group PLC, National Power PLC, Countrywide Homes Limited and Unipart Group.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Normanton
  • 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 ...
  • Replace a Table or a Named Query in a Data Source View
    Create Local Partitions
    Define Assignments and Other Script Commands
    Backup Options Restore Options
    Batch Processing Remote Processing
    Create Named Sets
    Ragged Hierarchies
    Define Named Calculations in a Data Source View
    Define Attribute Relationships
    Document and Script an Analysis Services Database
    Define a Regular Relationship and Regular Relationship Properties
    Delete a Data Source
    Backup and Restore of Analysis Services Databases
    Rename a Multidimensional Database Processing a multidimensional model
    Create a Dimension by Using an Existing Table
    Deploy Model Solutions Using XMLA
    Partition Writeback Calculations
    Define Time Intelligence
    Delete a Data Source View Dimensions
    View the XML for an Analysis Services Project Data Sources
    Configure Measure Group Properties

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Normanton
  • 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 ...
  • Rename a Table or Column
    Create and Manage Perspectives Translations Roles
    Understanding DAX in Tabular Models Measures
    Create and Manage Hierarchies Partitions
    Import data by using a native query
    Delete Relationships
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Import from Analysis Services
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Add sample data to DirectQuery models
    Row filter mappings
    Define partitions in DirectQuery models
    Create a Relationship Between Two Tables
    Impersonation
    Analyze in Excel
    Create and Manage KPIs Hierarchies
    Create and Manage Measures KPIs
    Object-level security
    Connect to a tabular model database
    DirectQuery Mode
    Add columns to a table

  • See Training Course Details...



Email us about this courses



Other Normanton Enable Technology Training Courses

VBA Normanton Training Courses
Power BI - Normanton Microsoft Power BI Training Courses
Report Builder Normanton Training Courses
Access VBA Normanton Training Courses
SSIS Normanton Training Courses
Access - Normanton Access Training Courses