BI Data Model Partitions

SQL Server 2014
  • 6 Videos | 39m 2s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
Partitions can improve performance when retrieving data for analysis and reporting. Learn how to design and create partitions for cubes and tables in your BI data warehouse.

WHAT YOU WILL LEARN

  • choose the appropriate partitioning strategy for a cube
    design aggregations strategies for separate partitions
    create partitions for a cube, including specifying the aggregations and storage
  • configure binding options for partitions
    configure data compression options on fact table partitions
    design and configure write back for a cube

IN THIS COURSE

  • Playable
    1. 
    Designing Partition Strategies for a Cube
    5m 10s
    UP NEXT
  • Playable
    2. 
    Designing Aggregations for Partitions
    4m 51s
  • Locked
    3. 
    Creating Partitions for a Cube
    5m 41s
  • Locked
    4. 
    Configuring Binding Options for Partitions
    6m 54s
  • Locked
    5. 
    Configuring Data Compression on Fact Table Partitions
    8m 27s
  • Locked
    6. 
    Designing and Configuring Write Back for a Cube
    4m 59s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 13 Likes 13  
Likes 5 Likes 5  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 25 Likes 25  
Likes 57 Likes 57  
Likes 78 Likes 78