The Design and Implementation of the Google BigQuery Warehouse from multiple sources.
Source Data Pipeline options include:
- Cloud Storage
- Cloud Functions
- Cloud DataFlow
- Pub/Sub Messaging
- Cloud-based ETL (eg Talend/Stitch, FiveTran, Skyva, Hevo, etc.)
- Onsite ETL (eg Talend Studio, InfoSphere, etc.)
- Custom Development (Python, C#, Shell Script and more supported)
- Legacy Integrations (AS400, DB/2, etc.)
- More options can be accommodated on request
Optimisation of the Warehouse via Query Analysis/Metrics, Table Partitioning, etc.
Analysis/Reporting options include:
- Google Data Studio / Looker Studio
- PowerBI
- Kliq
- Google Workspace
- Jupyter Notebooks
- More options can be accommodated on request