Presentation (1)

1.

QATARETAIL – SMART
RETAIL MANAGEMENT
SYSTEM
Prepared by:
Mohammad Noman – 60098291
Nour Hussein – 60099846
Shouq Al-sheeb – 60088665
Yasmin Molazehi – 60101797
Instructor:
Dr. Tewfik Ziadi

2. Agenda

Introduction
Requirements & Architecture
Agenda
ERP / CRM Integration
System Design & BPMN
Business Intelligence
Conclusion & Q&A

3. Introduction 

Introduction
Qatar Retail Business operates ( online and physical store)
The primary objective of the system is to enhance operational
efficiency, improve customer experience
The company needs centralized Information System that
supports its core business functions
The proposed solution is based on Odoo ERP, supported by CRM
features and cloud infrastructure to ensure scalability, security,
and cost efficiency.

4. Requirements & Architecture - Business Requirements

Requirements & Architecture - Business
Requirements
-An omni channel , that
helps analysis for better
decision making

5. Requirements & Architecture - Functional

Requirements & Architecture Functional
Customer account , Customer Loyalty program
Inventory tracking
Purchase orders & supplier management
Reporting & promotions

6. Requirements & Architecture - Non Functional

Requirements & Architecture - Non
Functional
Security
scalability (cloud)
Performance
Availability
web/mobile access

7. Requirements & Architecture - Stakeholder

Requirements & Architecture Stakeholder
Customers
Store
Managers
Warehouse
Staff
Suppliers
System
Admins

8. Technology Choice & Architecture

Technology Choice & Architecture
Core: Odoo ERP +
Salesforce CRM
(integration)
Cloud hosting for
scalability & high
availability
Security:
authentication,
encryption, role-based
access
Diagram placeholder:
simplified cloud + Odoo
+ Salesforce + DB +
web/mobile

9. ERP/CRM Integration - Why Odoo + Salesforce?

ERP/CRM Integration - Why Odoo +
Salesforce?
Odoo strengths: inventory, order management,
ERP integration, cost-effective (open-source)
Salesforce strengths: advanced CRM, marketing
automation, customer insights
Combined: end-to-end operations + enhanced
customer lifecycle management

10. ERP/CRM Integration – Key work

Customer journey: account → browse → order
→ payment → fulfillment → loyalty
Inventory flow: stock monitoring → low-stock
alert → PO → supplier delivery → update
Loyalty flow: purchase → points calculation →
tiering → redemption

11. System Design - Data Model (ER essentials)

System Design - Data Model (ER
essentials)
01
02
03
04
05
Customer : ID,
name, email,
prefs,
purchase_history,
loyalty_points
Product : ID,
name, category,
price, supplier_id
Inventory
:inventory_id,
product_id,
quantity, location
Order : order_id,
customer_id, date,
total_cost, status
Supplier
: supplier_id,
name, phone,
lead_time

12. System Design -  Customer Purchase Process BPMN Diagram

System Design - Customer Purchase Process BPMN Diagram

13. System Design -  Inventory Restocking Process BPMN Diagram

System Design - Inventory Restocking Process BPMN Diagram

14. System Design -  Loyalty Program Process BPMN Diagram

System Design - Loyalty Program Process BPMN Diagram

15. System Design -  CustomerManagement Process 

System Design - CustomerManagement Process

16. Business Intelligence – Sales KPI

KPI Name
Target
Data Source
Strategic Relevance
Total Revenue (QAR)
>QAR
1.5M/month
sales_transactions.csv
Primary indicator of business health; tracks
monthly and quarterly revenue growth across all
channels
Average Order Value
(AOV)
>QAR 550
sales_transactions.csv
Measures per-transaction spend; helps evaluate
upselling and pricing strategy effectiveness
Gross Profit Margin (%)
>38%
sales_transactions.csv
Indicates pricing efficiency and cost control across
product categories
Channel Revenue Split
Online >45%
sales_transactions.csv
Tracks the proportion of revenue from online vs instore; supports e-commerce investment decisions
Return Rate (%)
<6%
sales_transactions.csv
High returns signal product quality or mismatch
issues; directly impacts net revenue

17. Business Intelligence – Customer KPIs

KPI Name
Target
Data Source
Strategic Relevance
Customer Retention Rate (%)
>75%
customers.csv + sales
Measures the ability to retain existing
customers; lower churn means higher lifetime
value
New Customer Acquisition
>80/month
customers.csv
Tracks growth in customer base; essential for
market share expansion
Customer Satisfaction Score
(CSAT)
>4.2 / 5.0
kpi_summary.csv
Reflects overall service quality and customer
experience across all touchpoints
Net Promoter Score (NPS)
>50
kpi_summary.csv
Gauges customer loyalty and word-of-mouth
potential; critical for brand growth in Qatar's
social market
Loyalty Program Engagement
(%)
>60%
customers.csv
Measures active participation in loyalty
schemes; drives repeat purchases

18. Business Intelligence–Inventory andSupply Chain KPIs

KPI Name
Target
Data Source
Strategic Relevance
Inventory
Turnover Ratio
>5x / year
inventory_log.csv
Measures how quickly stock is sold and
replenished; low turnover signals
overstocking
Stockout Rate
(%)
<4%
inventory_log.csv
Tracks product unavailability events;
stockouts directly reduce revenue and
customer satisfaction
Supplier
Reliability Score
>90%
suppliers.csv
Evaluates vendor on-time delivery and
quality; critical for maintaining supply
continuity
Average Lead
Time (days)
<12 days
suppliers.csv
Shorter lead times improve
responsiveness to demand; impacts
inventory planning

19. Business Intelligence –Marketing and E-commerce KPIs

KPI Name
Target
Data Source
Strategic Relevance
Campaign ROI (%)
>250%
marketing_campaigns.csv
Measures the financial return on marketing
investment; identifies highest-performing channels
Campaign Conversion Rate (%)
>20%
marketing_campaigns.csv
Tracks the percentage of reached customers who make a
purchase; measures campaign effectiveness
Website Conversion Rate (%)
>5%
kpi_summary.csv
Measures the percentage of site visitors that complete a
purchase; key for e-commerce optimization

20. Dashboard - Sales & Channel Analysis

Dashboard - Sales & Channel Analysis
Line Chart — Monthly Revenue
Trend (2023 vs 2024): Displays
month-by-month revenue across two
years, enabling management
to identify seasonal peaks, growth
periods, and year-over-year
performance for strategic forecasting.
Card Visuals — Total Revenue, Total
Orders, AOV, Total Customers:
Provides instant at-a-glance KPI
status for board-level reporting
without requiring deep analysis.
Donut Chart — Revenue by Category:
Visualizes the proportional
contribution of each product category
to total revenue, supporting
procurement and inventory
investment decisions.

21. Dashboard - Sales & Channel Analysis

Dashboard - Sales & Channel Analysis
Bar Chart —
Revenue by Category
Bar Chart —
Campaign ROI (%):
Table — Campaign
Performance Details

22. Dashboard - Customer & Loyalty

Dashboard - Customer & Loyalty
Donut Chart —
Customer Segments
Donut Chart —
Loyalty Tier
Distribution
Bar Chart —
Customers by City
Line Chart —
Online Sales Share
(%)

23. Dashboard - Inventory & Supply Chain 

Dashboard - Inventory & Supply Chain
Bar Chart — Inventory
Turnover by Category:
Donut Chart —
Suppliers by Country
Clustered Bar Chart —
KPI vs Target

24. Conclusion 

Conclusion
The proposed Information System for QataRetail provides an effective solution
for managing retail operations across both physical and online platforms. It
supports key functions such as customer management, inventory tracking, and
order processing while improving overall efficiency.
The use of ERP and CRM functionalities, along with well-defined workflows
and business intelligence tools, enables better decision-making and enhances
customer experience.