Enable Technology

SQL SERVER ANALYSIS SERVICES MORECAMBE TRAINING COURSES 

SQL SERVER ANALYSIS SERVICES TRAINING COURSES MORECAMBE




About Enable Technology Morecambe SQL Server Analysis Services Training Courses

Enable Technology offer short intensive skills based SQL Server Analysis Services training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We provide every candidate with SQL Server Analysis Services training materials which they keep after the course. We also provide an ongoing support service to people attending our SQL Server Analysis Services courses. Delegates can contact the course tutor with specific SQL Server Analysis Services questions for as long as they need following the course.

Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. Another option is we can organise a local training site in Morecambe. The SQL Server Analysis Services syllabus can be adjusted and additional topics incorporated if helpful.

SQL Server Analysis Services courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.

The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: National Power PLC, Birmingham City University, Shell UK Oil Products Ltd, Norwich Union PLC, South Staffordshire Water PLC, Capita Group PLC, Carillion PLC and Barclays Bank PLC.




Microsoft SQL Server Analysis Services Tabular Modelling

  • 2 day course
  • Location: Morecambe
  • 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 ...
  • Process Database, Table, or Partition
    Understanding DAX in Tabular Models Measures
    Import data by using a native query
    Add sample data to DirectQuery models
    Data sources supported in tabular 1400 models
    Create and Manage Partitions in the Workspace
    Create a New Tabular Model Project
    Database Process Partitions in the Workspace Database Perspectives
    Create and Manage Roles
    Change table, column
    Enable DirectQuery mode in SSDT
    Topics include- Overview of SSAS Tabular models
    Import Data
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Import from Power Pivot
    Create a Calculated Column
    Analyze a tabular model in Excel Deploy tabular model solutions
    Enable DirectQuery mode in SSMS
    Hide or freeze columns

  • See Training Course Details...


Microsoft SQL Server Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Morecambe
  • 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 ...
  • Ragged Hierarchies
    Multidimensional models
    Data Source object permissions
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    BI Wizard
    Processing Databases, Dimensions and Partitions
    Define Attribute Relationships
    Create an Analysis Services Project
    Edit or Delete Partitions Merge Partitions
    Define Assignments and Other Script Commands
    Explore Data in a Data Source View
    Add or Remove Tables or Views in a Data Source View
    Create a Dimension by Using an Existing Table
    Create a Data Source
    Read Definition permissions
    Replace a Table or a Named Query in a Data Source View
    Processing Options and Settings
    Authorizing access to objects and operations
    Batch Processing Remote Processing
    Attach and Detach Analysis Services Databases
    Delete a Data Source

  • See Training Course Details...



Email us about this courses



Other Morecambe Enable Technology Training Courses

Access - Morecambe Access Training Courses
SSRS - Morecambe SQL Server Reporting Services Training Courses
SSIS Morecambe Training Courses
Excel Power Pivot Morecambe Training Courses
PL/SQL - Morecambe SQL Training Courses
Power Query Morecambe Training Courses