Opportunity star schema grouping

The Opportunity star schema grouping consists of the Opportunity measures and the following dimensions:

Dimensions

Sales person
Address region
Calendar
Enterprise
Buyer
Customer
Sales team

Measures

The following table provides a list of the Opportunity measures:

Measure: Description
Is Opportunity Won: Indicates if an opportunity is won and converted into an order.
Opportunity Value: Indicates the budget allocated for an opportunity.
Opportunity Revenue: Indicates the total revenue generated by an opportunity after being converted into an order.
Opportunity Count: Indicates the count of an opportunity for a specific criteria.

Grouped measures

The Opportunity grouped measure is Opportunity Conversion Percentage. It indicates the percentage of the opportunities that were successfully converted into orders.