BI Data Model Partitions
SQL Server 2014
| Expert
- 6 videos | 36m 2s
- Includes Assessment
- Earns a Badge
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 10sFind out how to choose the appropriate partitioning strategy for a cube. FREE ACCESS
-
4m 51sIn this video, learn how to design aggregation strategies for separate partitions. FREE ACCESS
-
3. Creating Partitions for a Cube5m 41sIn this video, you will learn how to create partitions for a cube, including specifying the aggregations and storage. FREE ACCESS
-
4. Configuring Binding Options for Partitions6m 54sIn this video, you will configure binding options for partitions. FREE ACCESS
-
5. Configuring Data Compression on Fact Table Partitions8m 27sIn this video, learn how to configure data compression options on partitions of a fact table. FREE ACCESS
-
6. Designing and Configuring Write Back for a Cube4m 59sIn 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.
