cancel
Showing results for 
Search instead for 
Did you mean: 

Organizing your Data Warehouse

Highlighted
Magento Team

Organizing your Data Warehouse

Your Magento Analytics account has different users, each using different metrics, reports and dashboards. What do you do as an organization to make sure that consistent definitions of metrics are being maintained throughout the organization? 

 

For example, do you always maintain a single point of contact for any questions or changes to be made to your account? Or is it more decentralized?

1 REPLY
Magento Team

Re: Organizing your Data Warehouse

Thanks, Akash! 

 

Internally, we manage our data using many of these practices: 

 

  • Everyone in our organization has access to an internal data dictionary, where our own core metrics (revenue, active subscriptions, churn) are defined using queries on the underlying data sources. 
  • The data dictionary has subject matter experts for each data source, and changes to any key metric definitions are confirmed by these team members. Our team also has one member responsible for coordinating and maintaining the proper replication of data into our own data warehouse. That team member has operation control, but everyone in our org has the ability to use these definitions for analysis. 

Curious to see how other businesses are organizing this workflow as well.

 

Sal Calvo, Senior Analyst - Magento Analytics (http://www.rjmetrics.com)

Sal Calvo
Senior Analyst, Magento Analytics
www.rjmetrics.com