Aamir2786/marketing_analytics
Md Aamir Sohel Ansari
Firstly I ingested Salesforce and Marketo data present in Google sheets to Bigquery using Fivetran connectors as well as Destinations.
I used dbt for the transformation, test and documentation required for the analysis. I created this repository to maintain data models for the analysis and also grant Fivetran access so that we can schedule our pipelines.
Finally, I can define upstream Fivetran connectors as source, set up dbt to transform, clean and aggregate this data and schedule pipeline run in Fivetran against our Bigquery destinations.
Later on, we can connect BI tools with Bigquery destinations to visualize our metrics.
Like this project
Posted Nov 15, 2023
Marketing Analytics Solution Using Fivetran and dbt - GitHub - Aamir2786/marketing_analytics: Marketing Analytics Solution Using Fivetran and dbt
Likes
0
Views
1
