Skip to main content
Version: 1.2

Data Model Overview

The CCBI WxC data model contains all data that was integrated from Webex Contact Center and Webex Calling APIs. Every API feed is stored within a corresponding table, and everything is linked to an extensive star schema within Power BI, called the semantic model.

Fact tables contain the data of the data model. Call Detail Records (CDR) are used to measure incoming and outgoing calls from users and system elements like voicemail, hunt groups, gateways, etc..

Data model

Dimensions are used to filter data within the fact tables and to group this data for any field of the dimension table. Dimensions about configuration objects are loaded from the "List Configuration"-APIs and are kept all time, even if they get deleted within the source system (they get the suffix "deleted" within the name in this case).

Some dimensions are on top of other dimensions and do not directly filter data from the fact tables. USER LOCATION and USER GROUP are used to filter the users in a first step and the USER dimension then filters the data within the facts. This has an impact on the data that is filtered within facts, if the assignment of a user changes (what is not the case for dimensions directly connected with the facts).

Number mapping dimensions are duplicated from a PhoneNumber mapping import file and filters the facts based on calling and called numbers. This allows to configure a name and location parameter to known numbers.

There are two out of the box Security Roles available within the Power BI workspace to be assigned to the Power BI users:

  • "MY OWN" filters the USER dimension with the current user that is logged in to Power BI and the USER dimension then filters the data within the Calling CDR table.
  • "USER DEPARTMENT" uses the Department of the current user that is logged in to Power BI and the DEPARTMENT dimension then filters the data within the Calling CDR table.