Magento BI Essentials vs. Pro
The following table describes what is included with Essentials and Pro.
MBI Essentials | MBI Pro | |
Pre-Defined Reports | Up to 100 | Custom |
Pre-Defined Dashboards | 5-6 | Custom |
New Custom Report Creation | Yes | Yes |
Magento Commerce Tables | 4-6* | Unlimited |
Log-ins/User Accounts | 10 | 20 |
User Permissions | Yes | Yes |
Data Warehouse Manager | Unavailable | Available |
Email Reports | Yes | Yes |
Cohort Report Builder | Yes | Yes |
Google Analytics Live Integration | Yes | Unlimited |
3rd Party Integrations | Unavailable | Available |
Full API Access | No | Yes |
Access to CS, AM, or Analysts | No | Yes |
Professional Services | Available | Available |
*Number of tables depends on guest checkout.
Included tables
sales\_order
sales\_order\_item
sales\_order\_address
customer\_entity
customer\_group
store
Columns Included in Essentials
Items in italics are calculated fields.
sales_order
table- entity_id
- base_grand_total
- customer_id
- status
- customer_email
- store_id
- base_currency_code
- billing_address_id
- shipping_address_id
- base_shipping_amount
- base_tax_amount
- coupon_code
- created_at
- updated_at
- base_subtotal
- customer_group_id
- base_discount_amount
- base_discount_invoiced
- increment_id
- Customer’s order number
- Customer’s first order date
- Customer’s lifetime number of orders
- Is customer’s last order?
- Billing address region
- Shipping address country
- Customer’s lifetime revenue
- Seconds between customer’s first order date and this order
- Seconds since previous order
- _Store name*
- Customer’s lifetime number of coupons
- Customer’s order number (previous-current)
- Shipping address region
- _Number of items in order
- Billing address city
- Shipping address city
- Customer’s group code
- Customer’s first order’s billing region
- Customer’s first order’s coupon_code
- Customer’s creation date
- Billing address country
sales_order_item
table- item_id
- qty_ordered
- base_price
- name
- order_id
- sku
- product_type
- product_id
- created_at
- updated_at
- parent_item_id
- store_id
- base_discount_amount
- base_discount_invoiced
- Order’s coupon_code
- Order item total value (quantity * price)
- Order’s increment_id
- Customer’s email
- Customer’s lifetime number of orders
- Store name
- Customer’s order number
- Order’s status
- Customer’s lifetime revenue
sales_order_address
table- entity_id
- city
- region
- country_id
customer_entity
table- entity_id
- group_id
- created_at
- updated_at
- store_id
- Customer’s lifetime revenue
- Customer’s lifetime number of coupons
- Customer’s first order date
- Customer’s lifetime number of orders
- Seconds since customer’s first order date
- Customer’s first 30 day revenue
- Customer’s first order’s billing region
- Customer’s first order’s coupon_code
- Customer’s group code
- Store name
customer_group
table- customer_group_id
- customer_group_code
store
table- store_id
- name
Refer to the following video series to learn more about the differences between Magento BI Essentials and Magento BI Pro.