Summary
Harcourts International operates approximately 550 offices worldwide, utilizing Adobe Analytics (AA) to gather crucial data on their operations. The company aims to centralize its AA account data into Domo to create comprehensive reports and dashboards that will enhance decision-making and operational efficiency. Continuum Software Solutions Inc. has been engaged to develop a robust solution for this integration. This case study outlines the approach, tasks, and expected outcomes of the project.
Project Overview
Objectives
Centralize data from multiple Adobe Analytics accounts into Domo.
Create actionable reports and dashboards for stakeholders.
Improve data accessibility and decision-making across global offices.
Proposed Solution
Continuum Digital proposes a structured approach to achieve seamless integration and effective data visualization. The solution consists of three main tasks:
Data Connections
Data Modeling and Conformance
Additional Services
Task Breakdown
1. Data Connections
Options Explored
Existing Adobe Connector in Domo: This method leverages Domo’s native integration capabilities, allowing for streamlined data imports directly from Adobe Analytics.
SFTP (Using Adobe Data Warehouse): A secure file transfer protocol will be utilized to extract data from Adobe’s data warehouse, ensuring data security and integrity.
Email (Using Adobe Data Warehouse): Data can also be sent as reports via email, providing an alternative route for importing data into Domo.
2. Data Modeling and Conformance
Key Activities
Data Definition: Establishing clear definitions for the data fields and metrics from Adobe Analytics.
Pattern/Schema Application: Implementing a standardized schema to ensure consistency across all data sets.
Transformations: Applying necessary data transformations to align data formats and enhance usability.
Metrics Definitions: Collaborating with Harcourts’ business stakeholders to define key performance indicators (KPIs) and metrics.
Reporting Data Mart(s):Creating structured data marts that facilitate efficient reporting and analytics.
3. Additional Services
Deliverables
Dashboard Build:
High-Level Website Metrics: A monthly report summarizing key website performance metrics.
Listings Report: A detailed report that provides insights into property listings, replicating an existing report for consistency.
Design Documentation: Collaborating with Harcourts to document design choices and dashboard layouts.
Technical Documentation: Creating comprehensive technical documents outlining the integration process and data models.
Knowledge Transfer: Facilitating knowledge transfer sessions to ensure Harcourts’ team can maintain and adapt the system post-implementation.
Resource Experience
Continuum Digital brings extensive expertise to this project:
Data Engineering: Over 15 years of experience in data engineering, ensuring robust and scalable data integration solutions.
MajorDomo: More than 4 years of experience working with Domo, ensuring best practices are followed in dashboard design and data handling.
Expected Outcomes
Enhanced Data Insights: By centralizing data in Domo, Harcourts International will have a unified view of performance metrics across all offices.
Improved Decision-Making: The intuitive dashboards and reports will empower stakeholders to make informed decisions based on real-time data.
Streamlined Reporting: Automated data connections will reduce manual reporting efforts and increase operational efficiency.
Conclusion
This integration project is designed to provide Harcourts International with powerful insights and streamlined operations through effective use of Adobe Analytics and Domo. By leveraging Continuum Software Solutions’ expertise, Harcourts will enhance its data capabilities and drive better business outcomes across its global offices.