Magento Help Center Magento Help Center
Magento.com
Sign in
  1. Magento Help Center
  2. Magento Business Intelligence (MBI)

Magento Business Intelligence (MBI)

  • MBI Essentials

    • Magento BI Essentials: Onboarding Questions
  • Understanding Your Magento Data: Getting to Know Magento

    • Common Magento Misconceptions
    • The Magento Customer Journey
  • Understanding Your Magento Data: Core Documentation

    • Magento Entity Relationship Diagrams
    • Common Magento Tables
    • The Customer_Entity Table
    • The Sales_Flat_Order Table
    • The Sales_Flat_Order_Item Table
  • Understanding Your Magento Data: Magento Carts

    • The Sales_Flat_Quote Table
    • The Sales_Flat_Quote_Item Table
  • Understanding Your Magento Data: Magento Returns

    • The Enterprise_Rma Table
    • The Enterprise_Rma_Item_Entity Table
  • Training Videos: Data Warehouse Manager

    • Training Video: Filter Sets
  • Training Videos: Report Builders

    • Training Video: SQL Report Builder
    • Training Video: Cohort Report Builder
    • Training Video: Show Top/Bottom and Independent Group By Features
    • Training Video: Time Options in the Visual Report Builder
  • Webinars

    • Webinar Archives
  • Getting Started Guide

    • Getting Started Guide
    • Sign up for your MBI Essentials account: Magento Cloud and On-Premise
    • How to setup MBI Essentials for Magento Commerce Starter
  • Getting Started Videos Series

    • Connect Your MySQL Database to Magento BI
    • Pro Getting Started Video Series
    • Essentials Quick Start Video Series
  • Getting Started Demos

    • Magento Business Intelligence: Essentials Demo
    • Magento Business Intelligence: Pro Demo
  • Accounts and Billing

    • Adding/managing users and user permissions
    • eCommerce and SaaS Starter Packages
  • Account: CloudBI best practices

    • Decluttering your Magento BI account
    • Best practices for naming reports and elements in Magento BI
  • Account FAQ

    • Managing your account settings
    • What is Magento BI?
    • Displaying your dashboards on screens around the office
    • New Architecture FAQ
    • Magento BI Essentials vs. Pro
    • How many people can be on one Magento BI account?
    See all 12 articles
  • Troubleshooting: Contacting Support

    • MBI documentation got moved
  • Troubleshooting: Integrations

    • MBI documentation got moved
  • Troubleshooting: Data discrepancies

    • Using Data Exports to pinpoint discrepancies
    • Auditing Metrics Using the SQL Report Builder
    • Diagnosing a data discrepancy
    • Diagnosing Google eCommerce revenue discrepancies
    • Auditing Google Adwords data
    • Auditing Shopify data
    See all 7 articles
  • Troubleshooting: SQL Report Builder

    • Resolving EXPLAIN cost errors for unsuccessful SQL queries
  • Magento Services and Analyses

    • New website for Magento Services - Analytics
    • Data migration services
  • Magento Services: Webinars, Videos and Blog Posts

    • Webinar: Untap the Full Potential of Your Customer Data
  • Integration FAQ

    • What's an integration?
    • Understanding the "Last successful update began" field
    • How do I suggest an integration?
    • What do I do if I get a connection error message?
  • Connecting SaaS Integrations

    • Connecting Magento
    • Connecting Quickbooks
    • Connecting NetSuite
    • Connecting Segment
    • Connecting Zuora
    • Connecting Google Analytics Warehoused
    See all 25 articles
  • Integrations: Expected SaaS Data

    • Expected Magento data
    • Expected Facebook Ads data
    • Expected Salesforce data
    • Expected Google ECommerce data
    • Expected Mixpanel data
    • Expected Quickbooks data
    See all 18 articles
  • Connecting Database Integrations

    • Connecting Amazon RDS
    • Connecting databases via a VPN
    • Connecting Microsoft SQL Server
    • Connecting MongoDB via SSH tunnel
    • Connecting MySQL via a direct connection
    • Connecting MySQL via cPanel
    See all 8 articles
  • Managing Database Integrations

    • Consolidating your tables
    • MongoDB data modeling guide
    • Restricting access to your database
  • Integrations: Pushing and uploading data

    • Using the File Uploader
    • Using the Magento BI Import API
    • Formatting and importing financial data
    • Formatting and importing eCommerce data
    • Importing Bing Ad Spend data
    • Importing CJ Affiliate (Commission Junction) Marketing Data
    See all 9 articles
  • Getting Started with Data Warehouse Manager

    • Data and Updates FAQ
    • Does your store accept guest orders?
    • Creating and Using Data Warehouse Views
    • Getting started with your data warehouse
    • What's a database?
    • Understanding and evaluating table relationships
    See all 10 articles
  • Data Warehouse Manager: Creating and Managing Metrics

    • Creating metrics
    • Restricting metric access
    • Changing a metric's operational table
    • Creating filter sets for metrics
    • Managing data dimensions in metrics
  • Data Warehouse Manager: Creating and managing calculated columns

    • Creating calculated columns
    • Using the Event Number Calculated Column
    • Using the Sequential Comparison Calculated Column
    • Calculated Column Types
    • Creating paths for calculated columns
    • Deleting calculated column paths
    See all 8 articles
  • Data Warehouse Manager: Creating advanced calculated columns

    • Advanced Calculated Column Types
    • Using the Date Difference Calculated Column
    • Creating and Using a SQL Calculated Column
    • Replicating Google Analytics channels using acquisition sources
  • Data Warehouse Manager: Optimizing your update cycle and database

    • Modifying your database to support Incremental Replication
    • Optimizing your database for analysis
    • Reducing your update cycle time
    • Checking the update cycle status
  • Using the Report Builder

    • Using the Visual Report Builder
    • From question to answer in Magento BI
    • Visualization Options in the Visual Report Builder
    • Ordering data using the Show Top/Bottom feature
    • Using Time Options in the Visual Report Builder
    • Using formulas in the Report Builder
    See all 11 articles
  • Using the Cohort Report Builder

    • Using the Cohort Report Builder for Non-Date Based Cohorts
    • Using the Cohort Report Builder
    • Creating a qualitative cohort analysis
  • Using the SQL Report Builder

    • Using the SQL Report Builder
    • Which Report Builder should I use?
    • Creating visualizations from SQL queries
    • Optimizing your SQL queries
  • SQL Report Builder FAQ

    • What's the SQL Report Builder?
    • What's SQL?
    • Who can use the SQL Report Builder?
    • What's the difference between the Report Builder and the SQL Report Builder?
    • Are columns created differently in SQL and the Data Warehouse Manager?
    • Does deleting a SQL report/query also delete the underlying columns from my Data Warehouse?
    See all 13 articles
  • SQL Report Builder: Handy resources

    • SQL tutorials and resources
    • PostgreSQL resources
  • Dashboard Basics

    • Creating a dashboard
    • Using Dashboard Wide Filtering for Date Ranges
    • Using Dashboard Groups
    • Managing Dashboards
    • Deleting Dashboards
    • Renaming Dashboards
    See all 13 articles
  • Sharing Dashboards

    • Dashboard sharing best practices
    • Sharing dashboards with other users
    • Sharing dashboards organization-wide
    • Accessing shared dashboards
    • Changing access to shared dashboards
    • Leaving (unsharing) a dashboard
  • Charts and Dashboards FAQ

    • How can I tell what a chart is analyzing?
    • How do I create a chart image?
    • How do I export a chart's data?
    • How do I export a dashboard?
  • Analyses Library: Analyses for Essentials

    • Essentials: Coupon Code Analysis
    • Essentials: Expected Lifetime Value (LTV) Analysis
  • Analyses Library: Analyses for Pro

    • Commerce Churn
    • Defining customer concentration
    • Reporting on a retail calendar
    • Category Analysis [an Expert Analysis]
    • Affinity Analysis [an Expert Analysis]
    • Coupon code analysis
    See all 17 articles
  • Analyses Library: Analyses How-to

    • Analyzing customer repurchasing behavior
    • Analyzing coupon impact on acquiring and retaining customers
    • Analyzing coupon usage
    • Analyzing holiday season performance
    • Analyzing repeat probability decay and churn
    • Understanding and building basic analytics
    See all 9 articles
  • Analyses Library: Analyses, Explained

    • Understanding the Repeat Order Probability Report
    • Why does the time to first purchase report slope downward?
    • Why is the Lifetime Revenue Cohort Analysis Important?
  • Analyses Library: Marketing Analyses

    • Analyzing Website Activity and Customer Conversion Rates
    • Increasing ROI on your advertising campaigns
    • Identifying your most valuable marketing sources and channels
  • Analyses Library: Reference

    • Best-Practices for UTM tagging in Google Analytics
    • US Regions Based on Zip Code
    • How does Google Analytics UTM attribution work?
  • Exports and Emails

    • Creating graphical email summaries
    • Creating legacy email summaries
    • Exporting raw data
    • Automating data retrieval with the Data Export API
Ready to try Magento Commerce? Sign up for a DEMO
© 2018 Magento, Inc. All rights reserved.
  • Privacy Policy
  • Ad Choices
  • Terms of Service
  • License/Trademark FAQ