Enable Technology

SQL SERVER ANALYSIS SERVICES ACCRINGTON TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES ACCRINGTON




About Enable Technology Accrington SQL Server Analysis Services Training Courses

Enable Technology has twenty year track record of providing short intensive SQL Server Analysis Services skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We provide every candidate with SQL Server Analysis Services training materials which they keep 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.

We provide instructor led training coupled with hands on training. 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. We also offer the option of scheduling of SQL Server Analysis Services course at a venue near you in Accrington. We are happy to discuss customising the course content should you have particular SQL Server Analysis Services training requirements.

We can also deliver SQL Server Analysis Services courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.

In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Norwich Union PLC, Unipart Group, EDF Energy PLC, National Power PLC, Barclays Bank PLC, Cadbury PLC, Birmingham City Council and Yell Group PLC.




Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Accrington
  • 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 ...
  • Calculations using the Business Intelligence Wizard
    Data Source Views
    Define Logical Relationships in a Data Source View
    Processing Options and Settings
    Multidimensional models
    Create a Data Source
    Defined Linked Measure Groups Partitions
    Define a Fact Relationship and Fact Relationship Properties
    Configure Measure Group Properties
    Delete a Data Source View Dimensions
    Overview of SSAS Multidimensional Modelling
    Define Named Calculations in a Data Source View
    Partition Writeback Calculations
    Set Partition Storage
    Create Calculated Members
    Processing Databases, Dimensions and Partitions
    Create a Dimension by Using an Existing Table
    Read Definition permissions
    Define Assignments and Other Script Commands
    View the XML for an Analysis Services Project Data Sources
    Define Semiadditive Behavior

  • See Training Course Details...


Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Accrington
  • 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
    Enable DirectQuery mode in SSMS
    Create and Manage Tabular Model Partitions
    DAX formula compatibility in DirectQuery mode Tables and Columns
    Analyze a tabular model in Excel Deploy tabular model solutions
    Create and Manage Partitions in the Workspace
    Process Database, Table, or Partition
    Manage Roles by using SSMS
    Add a table Delete a Table
    Data sources supported in SSAS tabular 2017
    Add columns to a table
    Sort Data in a Table
    Set the Data Type of a Column
    Version comparison
    Import from Analysis Services
    Row filter mappings
    Object-level security
    DirectQuery Mode
    Import from Power View
    Hide or freeze columns

  • See Training Course Details...



Email us about this courses



Other Accrington Enable Technology Training Courses

Data Warehouse - Accrington SQL Training Courses
Access Accrington Training Courses
JQuery Accrington Training Courses
Excel 365 Basic - Accrington Excel Training Courses
Excel 365 Advanced - Accrington Excel Training Courses
DAX - Accrington Excel Training Courses