Designing BI Data Models

SQL Server 2014    |    Expert
  • 13 videos | 1h 22m 39s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 29 users Rating 4.6 of 29 users (29)
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

  • 6m 47s
    Upon completion of this video, you will be able to describe how to plan for a cube with multiple dimensions. FREE ACCESS
  • 5m 50s
    Learn how to design data sources for analytical models, including the types of data sources and the considerations. FREE ACCESS
  • Locked
    3.  Creating a Data Source for Analytical Models
    5m 7s
    During this video, you will learn how to create data sources and data source views, including relationships, for analytical models. FREE ACCESS
  • Locked
    4.  Creating a Cube for a Multidimensional Model
    5m 6s
    Learn how to use the cube wizard to create a cube for a multidimensional model. FREE ACCESS
  • Locked
    5.  Defining Measures
    4m 22s
    Find out how to configure measures, including identifying the aggregation method. FREE ACCESS
  • Locked
    6.  Defining Measure Groups
    6m 16s
    In this video, you will learn how to define measure groups. FREE ACCESS
  • Locked
    7.  Designing and Configuration Dimensions
    7m 35s
    In this video, learn how to design and configure dimensions in a multidimensional model. FREE ACCESS
  • Locked
    8.  Configuring Relationships between Tables
    7m 44s
    Find out how to design and configure relationships between tables. FREE ACCESS
  • Locked
    9.  Designing and Creating Aggregations
    8m 44s
    Find out how to design and create aggregations to improve the performance of your cube. FREE ACCESS
  • Locked
    10.  Designing Cubes for Drill-through
    6m 59s
    In this video, you will learn how to design and configure cubes for drill-through. FREE ACCESS
  • Locked
    11.  Designing Indexes and Index Views for Processing
    5m 44s
    In this video, find out how to design indexes, index views, and order by statements for SSAS processing. FREE ACCESS
  • Locked
    12.  Creating Tables in a Tabular Model (Part 1)
    6m 54s
    In this video, you will import tables, configure relationships, and measure for a tabular model. FREE ACCESS
  • Locked
    13.  Creating Tables in a Tabular Model (Part 2)
    5m 31s
    In this video, you will learn how to design and configure attributes and dimensions for a tabular model. 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

Journey Learn Tableau for Data Visualization
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Microsoft Certified: Power BI Data Analyst Associate
Rating 4.0 of 1 users Rating 4.0 of 1 users (1)
Book Pro DAX and Data Modeling in Power BI: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course BI Reporting & Analysis
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course PL-300: An Overview of Data Modeling in Power BI
Rating 4.6 of 227 users Rating 4.6 of 227 users (227)
Course Preparing for BI Data Models
Rating 4.6 of 33 users Rating 4.6 of 33 users (33)