Daniel (Viet) Nguyen

Daniel (Viet) Nguyen

he/him

Portfolio 3: End-to-End Business Intelligence & Analytics Dashboard (DataCo Global)

📎For more details, click here

🎯 Objective

Developed an end-to-end Business Intelligence solution for DataCo Global that transformed fragmented sales, logistics, customer, and web traffic data into a unified reporting platform. Built an interactive executive dashboard analysing over 180,000 records, enabling stakeholders to monitor business performance, identify operational inefficiencies, optimise pricing and logistics, and make faster, data-driven decisions across the organisation.

⚙️ Tasks

Data Engineering & ETL

  • Built an end-to-end ETL pipeline using Python to clean, transform, validate, and integrate over 180,000 records from multiple business domains.
  • Designed a Fact Constellation (Galaxy) Schema with 2 Fact and 8 Dimension tables, creating a scalable data model that supports cross-functional reporting and analysis.

Database & Data Modelling

  • Developed a relational MySQL database with primary keys, foreign keys, and data integrity constraints to support efficient analytical queries.
  • Created and validated an Entity Relationship Diagram (ERD) to ensure accurate relationships between sales, customer, product, logistics, and web data.

Business Intelligence & Analytics

  • Built an interactive Power BI dashboard using DAX, Power Query, Deneb, and geospatial visualisations to deliver drill-through analysis, dynamic KPIs, forecasting, and customer segmentation.
  • Analysed sales performance, profitability, discount strategies, web conversion, and shipping operations to identify business challenges and opportunities for improvement.

💡 Results

Operational Insights

  • Identified that 54.8% of orders were delivered late, revealing fulfilment inefficiencies that reduced profitability and customer satisfaction.
  • Showed that delivery performance was driven by operational processes rather than order volume, highlighting opportunities to improve logistics efficiency.

Commercial Performance

  • Discovered that the web channel generated only 3.04% of total revenue, while customer conversion increased to 22.94% on Thursdays (2.5× higher), providing clear opportunities to improve digital marketing and online sales.
  • Identified profit margin erosion caused by excessive discounting, supporting more targeted pricing and promotional strategies.

Decision Support

  • Delivered an executive dashboard with 15+ interactive KPIs, enabling business users to monitor performance, investigate root causes, and explore trends through self-service analytics.
  • Translated complex operational data into practical recommendations across pricing, logistics, customer experience, and digital commerce to support strategic decision-making.