We want to build a DWH that unifies our main business data in one database. We will need the following tool (this is always subject to changes and adding info might be required as we go) to push data to the DWH:
1.1) Magento (Orders, Customers, Carts/Quotes, Products, Categories) - MySQL DB
1.2) (Magento) Browsing Data
2) Mailchimp (Mailing Lists, Deliveries, Opens, Bounces, Subscribes/Unsubscribes)
3) Zendesk (Tickets, Tags, Satisfaction, Solution Time, Response Time, Tickets by Status)
4) Google Analytics (Users, Sessions, Pageviews, Events, etc.)
5) Google Adwords
7) WMS - Standalone Warehouse Management System we have built
8) Delivery Database (our 3rd party agent for deliveries)
8) Twitter/Facebook/Social Media
9) Accounting - SAGE
10) Euphoria - Telephony Software
On top of the Data Warehouse we want to build a reporting interface that lets us gather insights into what drives business over several platforms.
We are happy with a Database that we can address via SQL queries but
for a V2:
Might also interested in visualizing data so that we can create graphs and dashboards that combine data from several sources within or on top of the DWH via a web interface.