BI Data Model Partitions

SQL Server 2014    |    Expert
  • 6 Videos | 39m 2s
  • Includes Assessment
  • Earns a Badge
Likes 19 Likes 19
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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE T-SQL Queries
Likes 173 Likes 173  
Likes 250 Likes 250