Building Complete BI Ecosystem for Traditional Distribution

The Starting Point

"A visionary owner trapped in Excel chaos"

Amser PTE LTD is a Singapore-based distribution company running their entire business within Excel spreadsheets. Despite having a visionary owner who understood the potential of data-driven decisions, they lacked the technical infrastructure to turn their vision into reality.

Key Challenges

• Complete Excel dependency: All business operations managed through scattered spreadsheets
• Undocumented business logic: Sales calculations and processes existed only in people's heads
• Manual data chaos: No structured way to manage, update, or validate business information
• Inconsistent reporting: Ad-hoc reports that varied in format and accuracy
• Process inefficiencies: Internal business processes lacked structure and standardization
• Administrative burden: Heavy manual work with no systematic approach

Our Foundation-First Solution

Phase 1: Foundation Assessment & Architecture

• Investigated existing sales calculations and business logic
• Documented all business processes and calculation methodologies
• Designed complete enterprise-grade business intelligence ecosystem architecture

Phase 2: Enterprise Infrastructure Development

• Built enterprise-grade data warehouse using Google BigQuery for scalable analytics
• Implemented Cloud Functions for automated data processing and validation
• Established Google Cloud Storage for scalable, secure data management
• Created custom VM-based form interface for seamless admin data uploads (replacing Excel chaos)

Phase 3: Business Intelligence Implementation

• Incorporated all business calculations and logic into cloud-based structured system
• Developed comprehensive dashboard for leadership decision-making
• Standardized reporting format and delivery process with real-time capabilities

Phase 4: Process Optimization & Documentation

• Tidied up and validated all existing data within cloud infrastructure
• Created comprehensive documentation of all business logic
• Established seamless data update process through custom interface

Transformation Timeline

Total Duration: 3.5 months

Technology Stack: Google Cloud Platform (BigQuery, Cloud Functions, Cloud Storage) + Custom VM Interface

Future Phase: Automation capability extension to further reduce administrative work

What We Actually Fixed

Business Process Transformation:

1. Internal business process optimization and standardization
2. Sales calculation investigation with accuracy recommendations
3. Data organization from Excel chaos to enterprise cloud infrastructure
4. Business logic documentation for operational consistency
5. Standardized reporting with real-time dashboard capabilities
6. Seamless data updates through custom-built interface (structured but user-friendly)

Quantifiable Results

ROI Impact

• Excel chaos → Enterprise cloud infrastructure supporting unlimited business growth
• Local storage → Scalable Google Cloud Platform with enterprise security
• Manual processes → Automated data processing with Cloud Functions
• Undocumented logic → Comprehensive cloud-based business rules
• Ad-hoc reporting → Real-time dashboard intelligence
• Foundation built for advanced automation expansion

Transformation Approach

• Visionary partnership: Worked directly with owner to realize data-driven vision
• Enterprise-grade architecture: Built scalable cloud infrastructure from day one
• Custom development: Created bespoke solutions tailored to business needs
• Process documentation: Captured and standardized all business logic in cloud systems
• Scalable foundation: Enterprise infrastructure ready for future automation capabilities