MEASUREMATCH SERVICE PACKAGE

Data-warehouse Architecture, Design & Implementation

Data-warehouse Architecture, Design & Implementation

Michael O

DataEngineer and Datawarehouse Architect

Cost: 
€20,000
Duration: 
30 days
Create a Free Account

Description

Why a Datawarehouse? Data-warehouses are the centre of the modern data set up. It allows the reconciliation of different data sources. As a company grows and the need for data increases. Differences appear from data source to data source. eg Google Analytics (event tracking) and Marketing data fails to align with backend or CRM data (Salesforce, Mail-chimp, Hubspot etc). Without a Datawarehouse (or a correctly organised one) a number of problems arise for companies - Data is spread across Spreadsheets (Excel, google Sheets): theses are increasingly difficult to maintain and debug - Numbers change historically - Departments disagree about the source of truth and the definition of KPIs - Data quality issues go unnoticed or are hard to track down - Building reports is slow and labour intensive My Motivation I believe in there being one reconcilable truth, and that using this knowledge is the best way to move forward for any company. A correctly functioning Data-warehouse is the best way to reach this truth and transparency. I specialise in designing or repairing data-warehouse solutions as well as training the Analytics or BI to be more effective at their job moving forward. Data-warehousing is typically an expensive project with a high risk of project failure. With modern technology and my approach this risk and cost can be reduced. Outputs - Datawarehouse set up: AWS Redshift, BigQuery, Snowflake, Postgres (not recommend) - Data imported from core data sources: -- Production Databases -- CRM systems: Salesforce etc -- Call Systems: New Voice Media etc -- Marketing Platforms: Google Ads, Criteo, Facebook etc -- GSheets -- Event and Product Data: Snowplow, Google Analytics etc - Data Modelling according to Kimball Method -- In SQL Modeling layer -- Core Fact & Dims tables - Transformation and Cleaning of Raw data -- Business Logic applied -- Data reconciliation -- Data quality control -- Data quality testing - Training and Upskilling -- Training regarding best practices for inhouse BI Analysts or Engineers -- Assistance in hiring as required - Budget control and Prioritisation Planning -- Choosing the best products and the correct scale point for businesses -- Suggesting and implementing bespoke in-house implementations where appropriate - Demo Dashboards as required Timeline - 1.5 to 6months depending on company size and desired scope -- example: Company starting fresh Datawarehouse for marketing purposes with a gross revenue of less than €2million per month, (or Marketing spend less than €4million per month) seeking initial design and 1 core fact table = 1.5months Example Downstream Value Adds from improved Datawarehouse - Correct data across the company - Improved Marketing spend (ROI) - In-house Multitouch attribution - Improved Customer lifetime value and cohort analysis - Allows Datascience (data-science performed before a functioning datawarehouse is ineffective and often flawed) - Product Feeds - Providing Data as a product to end customers

Deliverables

Data-warehouse Choice and Setup (Redshift, BigQuery, Snowflake)

Extract & Loading of Raw data into Data-warehouse

Modelling of Core business Dims and Facts Tables

Frequently Asked Questions

Does MeasureMatch quality control new service providers?

Every one of the MeasureMatch network of service providers has been through a stringent application process, including an interview to ensure relevance of Service providers and quality of delivery. And each is fully aware of the how the platform works, including the commercial framework.

Who should sign up to MeasureMatch?

On one side, MeasureMatch is for independent consultancies, agencies, systems integrators and independent consultants with outstanding technology, data or analytics skills and experience to provide services. On the other, the platform is for companies that need to solve, address and advance marketing, commerce, customer experience technology & data challenges, and they are open to embracing service providers located anywhere across the globe via the MeasureMatch marketplace platform.

Why book consultants or consultancies via MeasureMatch?

It's easy and incredibly fast to find and book a pro via the MeasureMatch marketplace platform. And, because we interview all service providers, we're at a 100% contract success rate. Clients are happy and many are re-booking or extending contracts.

Whether it's Salesforce, Microsoft Dynamics, HubSpot, Intercom or Freshsales skills you're after - to name a few in our hottest category of services - MeasureMatch has pros you need. That just the very beginning of 1,000s of skills and services on-demand.

Our end-to-end platform provides clients with direct, seamless and flexible access to a highly-skilled, verified workforce of independent consultants and consultants armed with the skills to advance data collection, marketing analytics, business performance insight, personalization, programmatic media targeting and much more.

It's never been easier to find and book a consultant or consultancy to get important systems or data work done.

Which services can clients contract via the MeasureMatch marketplace platform?

The consultants, consultancies, agencies & SIs in our global network, approaching 4,000 in 60+ countries (as of early July 2020), execute important systems and data project work including, but not limited to: CRM systems deployments and revamps, CRO, data cleaning, marketing performance reporting, identity resolution setup, machine learning for predicting and optimizing customer behaviors, marketing automation systems implementations, social media analytics, CX analytics, web analytics and much much more.


The MeasureMatch global network of professionals is highly skilled, many are certified service providers with proficiencies across more than 3,000+ tools and products including the Adobe Experience Cloud stack, the Google Marketing Platform and Google Cloud suite of tools, Segment, Mixpanel, Intercom, Hubspot, DOMO, Power BI, Tableau and 1,000s more.

What are MeasureMatch Service Packages?

1
A Service Package describes a service on offer from a consultant or consultancy participating in the MeasureMatch professional services marketplace.
2
Service Packages compliment MeasureMatch Experts' profiles with services that can be booked "off the shelf".
3
Service Packages are the only way a prospective client can directly strike up a discovery, scoping, pricing negotiation with any MeasureMatch Expert - otherwise, a project brief needs to be submitted.
Get Started Free