Data Migration and Integration

Organizing and executing data migration from multiple data sources into an integrated and secure serverless warehouse.

Client:

E-commerce enterprise

Service type:

Data engineering, data migration

Core technologies:

Microsoft .NET

Project Scope

Prior to the project, our client used many disintegrated data management tools, including databases, PIM systems, ERP systems, Google Analytics, Google AdWords, tracking systems, performance testing systems, Excel (Google Spreadsheets), etc. The problem with disintegrated data management was that the client could view data on each store separately, without seeing the whole picture for their 140+ stores, business systems, plus back-office tools.

The company wanted to enable consistent data collection in one place and get role-based access to different datasets. The task was complicated by the fact that each dataset was managed and controlled by a different stakeholder within the enterprise. Our goal was to bring it all together and set an effective mechanism for data storage and collection.

Firstly, our team migrated data from the main sources to BigQuery. Both historical and real-time data are now available to the client. Secondly, we securely exposed the data to powerful BI and analytics tools. Depending on the client’s purpose, the team can access different datasets, manipulate them, use them in custom reports, and drive valuable business insights.

Projects Results

Goal

Solve the problem of fragmented data that is hard to store and manage.

Result

Forbytes migrated data from all sources used by the client to a data warehouse where it can be securely stored, managed, used in reports, and streamed in real time.

Goal

Help the client not only store data but also get practical value from it.

Result

We designed a role-based data management space where managers can use data for AI-powered analysis, trend forecasting, gap detection, and more.

Goal

Prevent data loss because of the changes in Google Analytics and preserve all historical data.

Result

Our team preserved all historical data by moving it from Google Analytics to BigQuery, which is a more effective solution for working with big datasets.

Goal

Make the data management solution easy to scale.

Result

We enabled the solution to integrate with an unlimited number of tools and systems to extract the growing volumes of data as the client’s business scales.

Technology Stack

Backend: .NET Core, ASP.NET Core MVC
Frontend: ASP.NET Core MVC
Database: MSSQL
Cloud storage: Google BigQuery, Google Storage
Cloud platform: Google Cloud
Cloud orchestration: Google Kubernetes Engine (GKE)
Virtualization: Docker
Logs/Monitoring tools: Seri log, custom logging
Continuous integration: Bitbucket
Other tools: Quartz

About the client

Bygghemma Group is a leading Nordic online retailer specializing in home improvement and garden products. The company offers a wide range of products through multiple e-commerce platforms. Bygghemma Group has expanded its presence across 25 countries, becoming a significant player in the European home improvement market.

  • Leading Nordic online retailer
  • More than 12 years on the market
  • 100+ online destinations under the BHG umbrella
  • 25 countries with the BHG presence
  • 411 million site visits in 2021
  • 39% annual CAGR last 6 years

Let’s Get in Touch

    The Forbytes team was very professional and demonstrated a great understanding of the business aspects. All tasks were completed above expectations. Their experts were always available, and we never needed to wait for a response or a suggested solution.

    Valentin Berg CTO at GardenStore

    Valentin Berg

    CTO, GardenStore

    Forbytes has a strong process-oriented way of leading the company, with good respect for themselves and their managers. They made a choice not to become too big but build slowly on more qualified people, which is paying off.

    Niklas Hammar COO & Business Development at Offerta.se

    Niklas Hammar

    COO & Business
    Development at Offerta.se

    Forbytes’ engineers and team leads worked as part of our RnD group and were directly managed by our company directors. They were both proactive and adaptable, qualities that perfectly match our needs in our fast-growing and constantly evolving environment.

    Nazar Lytvynenko Group Manager in Guesty

    Nazar Lytvynenko

    Group Manager, Guesty

    The Forbytes team has been loyal and dedicated in their partnership. The team provides management as needed but allows flexibility for direct work with developers.

    Thomas Andersson Ecommerce Manager & CTO Trademax

    Thomas Andersson

    E-commerce Manager & CTO, Trademax

    Forbytes has established strong project management. Their entire team is knowledgeable about appropriate processes and project expectations.

    Julia Noack eCommerce Manager Motorsweden & Swebike

    Julia Noack

    E-commerce Manager Motorsweden & Swebike

    Scroll Up

    This website is using cookies to give you the best experience.
    Continue using this site you agree with our Privacy and Cookies Policy.