After successfully linking and exporting all data sources, Niologic built a central data lake on Google Cloud Storage for long term archival, a data warehouse running on Google BigQuery, and multiple fully automated data marts and dashboards in Google Data Studio. Instead of relying on multiple platforms, our client is now able to view and analyze all data in a singular dashboard combining both sell and cost side from ERP and marketing. Data marts are exported to Google Sheets for external processes. At the same time, manual import and visualization are no longer necessary, as the dashboards update automatically.
With the data warehouse combining multiple locations, entities, and data sources, this opens up possibilities for continuous machine learning implementations like the implemented pricing engine. Moreover, to secure data from multiple subsystems containing private identifiable information (PII) for each remote third-party hosted, a secure VPN connection was set up.