Process Models & Database Deployment

SQL Server 2014    |    Intermediate
  • 9 videos | 54m 33s
  • Includes Assessment
  • Earns a Badge
Likes 10 Likes 10
After creation, multidimensional models need to be processed and the databases deployed for users to access them. Examine what is involved in processing data models and deploying SSAS databases.

WHAT YOU WILL LEARN

  • describe how processing and reprocessing affects SSAS objects, specifically partitions, databases, cubes, and dimensions
    describe the different processing options available for SSAS objects, specifically full processing and incremental processing
    automate the processing of SSAS objects using AMO
    use XMLA to process SSAS objects
    use PowerShell to process and manage partitions
  • implement remote processing of SSAS objects
    use the deployment wizard to deploy an SSAS database
    test a database deployment
    use the Synchronize Database Wizard to synchronize metadata and data between two SSAS databases

IN THIS COURSE

  • 7m 26s
    Upon completion of this video, you will be able to describe how processing and reprocessing affects SSAS objects, specifically partitions, databases, cubes, and dimensions. FREE ACCESS
  • 5m 48s
    After completing this video, you will be able to describe the different processing options available for SSAS objects, specifically full and incremental processing. FREE ACCESS
  • Locked
    3.  Automating SSAS Objects Processing Using AMO
    7m 47s
    In this video, find out how to automate the processing of SSAS objects using AMO. FREE ACCESS
  • Locked
    4.  Processing SSAS Objects Using XMLA
    5m 57s
    In this video, you will use XMLA to process SSAS objects. FREE ACCESS
  • Locked
    5.  Processing Partitions Using PowerShell
    8m 11s
    In this video, you will learn how to use PowerShell to process and manage partitions. FREE ACCESS
  • Locked
    6.  Implementing Remote Processing of SSAS Objects
    5m 18s
    In this video, you will process SSAS objects remotely. FREE ACCESS
  • Locked
    7.  Using the Deployment Wizard to Deploy Databases
    6m 12s
    In this video, learn how to use the deployment wizard to deploy an SSAS database. FREE ACCESS
  • Locked
    8.  Testing a SSAS Database Deployment
    3m 41s
    In this video, you will test a database deployment. FREE ACCESS
  • Locked
    9.  Using the Synchronize Database Wizard
    4m 14s
    During this video, you will learn how to use the Synchronize Database Wizard to synchronize metadata and data between two SSAS databases. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book Core Data Services for ABAP Second Edition
Course Data Engineering on Microsoft Azure: Data Factory
Likes 93 Likes 93  
Course Database Fundamentals: Getting Started with SQL