API Integration, ETL and Azure Implementation for Data Analytics
Services Covered:

Industry
Information Technology
Duration
3 months
Budget
Confidential
Start Date
1 March 2023
Team Size
1-5
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
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
5
5 out of 5 stars
Timeliness
Cost Rating
Willing to Refer
Quality of Deliverables
Because of Bakson Ltd, we won a new end client and now have a system we can upgrade. They delivered on time and met our requirements. They communicated well and gave us practical solutions. We were happy with the engagement.
Note: This endorsement is based on publicly available client feedback from external review sources.
More Projects by Bakson Ltd
Endorsed
Ongoing
Engineering & Manufacturing
E-commerce development and Odoo.sh migration for beverage can printing company
Services Covered:
+3 more
