Building a unified datawarehouse

The client used various softwares and tools for their business, so critical business data was dispersed across various platforms, blocking seamless decision-making. Key data sources included internal recruitment and people management data (greenhouse, lever, hibob), lead generation data (Hubspot , Salesforce) business development information from Jira, customer support data (Freshdesk, Freshchat) and web traffic data from Google Analytics. The focus was on creating a unified data warehouse that would serve as a centralized repository.

Collaborated closely with key stakeholders from different departments to understand specific data requirements and desired outcomes.

Analyzed the data structures and schemas of each source system and developed a comprehensive data mapping plan to understand how data elements from various sources relate to each other.

Conducted a market research for best available tools for ELT processes, datawarehouses, presented the options to key decision makers and made a mutual decision

Implemented BigQuery and Fivetran for the organization

Configured connections between the various source systems and Fivetran to automate the extraction, loading, and transformation processes

Loaded all Google Analytics data into Google BigQuery using Google API-s

Implemented security measures for the data warehouse, ensuring that access is restricted based on roles and responsibilities.

Created the necessary fact and dimension tables, as well as the aggregated reporting layer in BigQuery

With a unified data repository and enhanced analytical capabilities, decision-making processes have been streamlined

Foundations for both dashboard creation and quick data analysis were created

Google BigQuery and Fivetran provides a cost-effective and scalable solution for handling increasing data volumes