Designing BI Data Models

SQL Server 2014    |    Expert
  • 13 Videos | 1h 27m 39s
  • Includes Assessment
  • Earns a Badge
Likes 37 Likes 37
Data models use performance indicators and aggregation to add extra value to the data being presented. Discover how to design and create multidimensional and tabular data models to achieve this goal.

WHAT YOU WILL LEARN

  • describe how to plan for a multidimensional cube
    design data sources for analytical models, including the types of data source and the considerations
    create data sources and data source views, including relationships, for analytical models
    use the cube wizard to create a cube for a multidimensional model
    configure measures, including identifying the aggregation method
    define measure groups
    design and configure dimensions in a multidimensional model
  • design and configure relationships between tables
    design and create aggregations to improve cube performance
    design and configure cubes for drill-through
    design indexes, index views, and order by statement for SSAS processing
    import tables and configure relationships and measures for a tabular model
    design and configure attributes and dimensions for a tabular model

IN THIS COURSE

  • Playable
    1. 
    Designing  Multidimensional Cubes
    6m 47s
    UP NEXT
  • Playable
    2. 
    Designing Data Sources for Analytical Models
    5m 50s
  • Locked
    3. 
    Creating a Data Source for Analytical Models
    5m 7s
  • Locked
    4. 
    Creating a Cube for a Multidimensional Model
    5m 6s
  • Locked
    5. 
    Defining Measures
    4m 22s
  • Locked
    6. 
    Defining Measure Groups
    6m 16s
  • Locked
    7. 
    Designing and Configuration Dimensions
    7m 35s
  • Locked
    8. 
    Configuring Relationships between Tables
    7m 44s
  • Locked
    9. 
    Designing and Creating Aggregations
    8m 44s
  • Locked
    10. 
    Designing Cubes for Drill-through
    6m 59s
  • Locked
    11. 
    Designing Indexes and Index Views for Processing
    5m 44s
  • Locked
    12. 
    Creating Tables in a Tabular Model (Part 1)
    6m 54s
  • Locked
    13. 
    Creating Tables in a Tabular Model (Part 2)
    5m 31s

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

Likes 67 Likes 67  
Likes 39 Likes 39  
Likes 50 Likes 50