Enable Technology

SQL SERVER ANALYSIS SERVICES MERSEYSIDE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES MERSEYSIDE




About Enable Technology Merseyside SQL Server Analysis Services Training Courses

Enable Technology SQL Server Analysis Services courses are short, skill focused and hands on. 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 all delegates open ended post training support. Delegates can contact the Tutor after the course with SQL Server Analysis Services queries.

Enable Technology training courses are delivered as instructor led courses. Our SQL Server Analysis Services training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Alternatively we could schedule a SQL Server Analysis Services course at an alternative training site in Merseyside. We are more than happy to incorporate additional topics to accommodate your organisations SQL Server Analysis Services training needs.

SQL Server Analysis Services courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.

We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Cadbury PLC, Royal Air Force, West Bromwich Building Society, Norwich Union PLC, EDF Energy PLC, Boots UK Limited, South Staffordshire Water PLC and Shell UK Oil Products Ltd.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Merseyside
  • 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 ...
  • Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Create a Calculated Table
    Filter Data in a Table Relationships
    Bi-directional cross filters  Calculations
    Object-level security
    Analyze a tabular model in Excel Deploy tabular model solutions
    Database Process Partitions in the Workspace Database Perspectives
    Topics include- Overview of SSAS Tabular models
    Connect to a tabular model database
    Test a model in DirectQuery mode
    Enable DirectQuery mode in SSDT
    Row filter mappings
    Rename a Table or Column
    Define partitions in DirectQuery models
    Create and Manage Roles
    Specify Mark as Date Table for use with Time Intelligence
    Create a New Tabular Model Project
    Tabular model designer
    Restore from Power Pivot
    Change table, column
    Create a Relationship Between Two Tables

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Merseyside
  • 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 ...
  • Create Local Partitions
    Test an Action
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Define Assignments and Other Script Commands
    Delete a Data Source View Dimensions
    Define Attribute Relationships
    Calculations using the Business Intelligence Wizard
    Deploy Model Solutions with the Deployment Utility
    Explore Data in a Data Source View
    Data Source Views
    Create User-Defined Hierarchies
    Rename a Multidimensional Database Processing a multidimensional model
    Define Logical Relationships in a Data Source View
    Define Logical Primary Keys in a Data Source View
    Ragged Hierarchies
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Processing Databases, Dimensions and Partitions
    Define Time Intelligence
    Modify or Delete an Analysis Services Database
    Cube or model permissions Process permissions
    Using SQL Server Data Tools (SSDT)

  • See Training Course Details...



Email us about this courses



Other Merseyside Enable Technology Training Courses

Access Merseyside Training Courses
Excel Power Pivot - Merseyside Excel Training Courses
Access VBA Merseyside Training Courses
Excel 365 Advanced Merseyside Training Courses
SQL Merseyside Training Courses
Report Builder Merseyside Training Courses