Magento Business Intelligence Help Center

Getting started with your data warehouse




Want to segment your revenue data by the customer’s gender, or some other customer-level attribute? Are you interested in linking UTM attributes from a tool like Google eCommerce with the data points in your orders table? You can do all this and more in your Magento BI Data Warehouse.

We know; this is very exciting and you’re itching to get started. We don’t blame you. To set you up for success, we created this tutorial to guide you down the path of Magento BI guru-dom. If you’re unfamiliar with databases, data warehouses, or data anything, this is an excellent place to start.

In this tutorial, you’ll learn:

  1. What a database is. In this section, we go over the very basics: What’s a database? How is it organized? How does Magento BI optimize data for analysis?
  2. How tables are related to each other and how to evaluate these relationships. This is absolutely crucial to accurately modeling your data - don’t skip it!
  3. What you can do in the Data Warehouse Manager. By the end of this tutorial, you'll have a deeper understanding of the update cycle, creating columns, managing dimensions, and more.

If at any point you’re confused and want to talk through a concept or process, don’t hesitate to contact us.

Ready? Lets get started by talking about what databases are.

Was this article helpful?
1 out of 1 found this helpful


Powered by Zendesk