BI Data Model Partitions

SQL Server 2014    |    Expert
  • 6 videos | 36m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)
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

  • 5m 10s
    Find out how to choose the appropriate partitioning strategy for a cube. FREE ACCESS
  • 4m 51s
    In this video, learn how to design aggregation strategies for separate partitions. FREE ACCESS
  • Locked
    3.  Creating Partitions for a Cube
    5m 41s
    In this video, you will learn how to create partitions for a cube, including specifying the aggregations and storage. FREE ACCESS
  • Locked
    4.  Configuring Binding Options for Partitions
    6m 54s
    In this video, you will configure binding options for partitions. FREE ACCESS
  • Locked
    5.  Configuring Data Compression on Fact Table Partitions
    8m 27s
    In this video, learn how to configure data compression options on partitions of a fact table. FREE ACCESS
  • Locked
    6.  Designing and Configuring Write Back for a Cube
    4m 59s
    In this video, you will design and configure write back for a cube. 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

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course Training Machine Learning Models in Power BI
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Book Mastering Power BI: Build Business Intelligence Applications Powered with DAX Calculations, Insightful Visualizations, Advanced BI Techniques, and Loads of Data Sources, 2nd Edition

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Core Commerce
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)
Course Availability & Configuration
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Course Developing Personal Accountability
Rating 4.5 of 6258 users Rating 4.5 of 6258 users (6258)