With the new release of InfoCaptor, we are introducing a data-warehouse that is packaged with the software.
What is meant by packaged Datawarehouse?
We have built a framework for collecting data into a mysql database. This means you can upload any CSV file and convert into a database table. Along with this release we are also releasing two builtin connectors for Google Analytics and Salesforce.
Automate all your Google Analytics data and get quick insights
- Complete Business Intelligence platform with Google Analytics integration
- ETL to bring Google Analytics profile data into MySQL tables
- Consolidate data from multiple profiles – Pull metrics from multiple GA accounts
- Define multiple jobs to extract different set of metrics into separate tables for analysis
Salesforce connector allows you pick and choose all or some of the salesforce tables and bring them into MySQL tables.
With both of these connectors, you get the ability to perform initial load and then schedule the jobs to do daily incremental export of data from Google Analytics and Salesforce.
This is best of the both worlds. On one hand you have an Analytics tool that does dataviz and dashboards but now you can bring data from various web services into your local datawarehouse for further analysis. The benefits are tremendous because now you can correlate your Google Analytics data with finance data sitting in your internal system.
Correlation is the king of Analytics
When you view different data points along the same dimension, it enables you to correlate data and see the ups and downs, identify patterns and get powerful insights.
Here is a high level view of our complete solution
On the left is the Analytics + Visualization and Dashboard solution with live SQL database connections. And on the right, it shows the new connectors that are integrated with the ETL framework into the Social Data Warehouse. Although it is called a Social Data warehouse it is not just meant for social data. In the upcoming releases we will be integrating Adwords, Stripe and many such web services to make your data collection easy.
Please take this quick survey