“ERP System with Power BI analytics to measure the performance of Abu Zahra Electronic Co.”
No Thumbnail Available
Date
2026-12-28
Authors
Osaid Barahmeh
Adam Fattouh
Journal Title
Journal ISSN
Volume Title
Publisher
Abstract
This project aims to improve sales and inventory management at Abu Zahra Electronics by
developing an integrated solution based on Enterprise Resource Planning (ERP) systems
and business intelligence tools to support decision-making. The company faces operational
challenges due to its multiple branches and each branch's reliance on separate inventory,
which limits the ability to accurately and real-time product availability and negatively
impacts customer service efficiency and inventory management. Furthermore, management
lacks a comprehensive analytical view of sales performance and inventory movement
between branches.
In this project, an Enterprise Resource Planning (ERP) system was built using the Odoo
platform to manage core processes such as sales and inventory. Several operational
processes were automated, and data was integrated using the n8n tool to minimize manual
intervention and ensure a smooth and accurate data flow. Subsequently, data was extracted,
cleaned, and transformed, and appropriate data modeling was developed to support
analysis and decision-making. In the final phase, interactive analytical dashboards were
designed, providing key performance indicators (KPIs) that enable management to monitor
branch performance, analyze sales, identify best-selling products, and centrally monitor
inventory levels.
The project results showed that integrating ERP systems with automation and business
intelligence tools contributes to improving analytical visibility, raising the efficiency of
operational processes, and supporting data-driven decisions, thereby enhancing
administrative and operational performance in Palestinian multi-branch companies.