endorsedCompleted

API Integration, ETL and Azure Implementation for Data Analytics

Services Covered:

Big Data Analytics and Business Intelligence • Cloud Consulting and Services

Industry

Information Technology

Duration

3 months

Budget

Confidential

Start Date

1 March 2023

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

80/100

Strong

Project Capability Score (PCS) estimates how capable Bakson Ltd is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

N Solutions LLC

Cincinnati, United States of America

Project Summary

Bakson Ltd implemented a data-transfer and cloud solution for a data analytics firm, connecting client APIs to partner APIs and building ETL pipelines for PowerBI. The team set user privileges, created scheduling and manual reload mechanisms, and implemented the system on Azure. The project was delivered on time and produced an upgradeable, tested system that enabled the client to win a new end customer.

Key Challenges

Connecting to client APIs within a short deadline
Creating data transfer and loading mechanisms
Building automatic scheduling for periodic data transfer with a manual reload option
Testing the system and ensuring external APIs are responsive and handling potential issues
Setting up user privileges on data
Enabling data structures to be efficiently consumed by PowerBI

Project Deliverables

API integrations to partner systems
ETL/data transfer and loading mechanisms
Automated scheduling for periodic data transfers with manual reload option
User privilege configurations
Data structures prepared for PowerBI
System implemented on Azure and tested

Project Solution

Bakson Ltd connected the client's APIs to multiple partner APIs, built ETL pipelines to load data into agreed data structures for PowerBI, and implemented automatic scheduling with an option for manual reload. They set up user privileges, tested the system against external API conditions, and deployed the solution on Azure such that adding new APIs or clients is a simple configuration task.

Project Outcome

Completion within the deadline
Data transfer tested and working in expected conditions
System is easily upgradeable for new APIs

Platforms

Cloud

Tech Stack

Azure

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Thanks to Bakson Ltd, the client gained a new end client and secured an upgradeable system. Bakson Ltd delivered the project on time and to the client's requirements. They also demonstrated effective communication and offered practical solutions. The client was pleased with the engagement.”
Jennifer Nenadov
Managing Partner
Date: 09/20/2023