Welcome to Nick Portfolio

Hi, I’m Nick — a Data Analyst & Analytics Engineer
with a strong background in investment and operations data.

I design reliable data pipelines, build analytics-ready datasets,
and deliver insights that support real business and financial decisions.

This portfolio showcases how I apply data analytics and engineering
to solve real-world business problems across finance, investment,
operations, and logistics.

My work focuses on transforming raw, fragmented data into structured, trustworthy insights that decision-makers can act on with confidence.

Data Projects

Investment & M&A Analytics Platform

Business Problem

Financial, operational, and legal data were stored across Excel files, PDF reports, and ad-hoc spreadsheets, making investment analysis slow, error-prone, and difficult to audit.

    Data Solution

    I designed structured financial datasets and automated reporting workflows to support valuation, forecasting, and investment decision-making.

    Key Responsibilities

    • Cleaned and validated financial and operational data
    • Designed analytics-ready data structures for valuation models
    • Built automated Excel and Power BI reports for stakeholders
    • Translated complex financial data into decision-ready dashboards

    Tech Stack:

    SQL • Excel Automation • Power BI • Financial Modeling

    Outcome:

    • Reduced reporting turnaround time
    • Improved data consistency and accuracy
    • Supported a successful ~AUD 10m M&A transaction

    Data Visualisation

    I design dashboards on top of structured, analytics-ready datasets, with a strong focus on accuracy, performance tracking, and insight delivery.

    Focused on trends, KPIs, and decision support — not just visuals

    Built Power BI dashboards using SQL-based datasets

    Applied data modeling principles to ensure consistency and scalability

    Delivered insights for finance, operations, and management teams

    Real Estate & Infrastructure Analytics

    Business Problem

    Investment decisions across warehouse, residential, and commercial projects required consistent evaluation, forecasting, and risk analysis.

    Data Solution

    I built financial models and evaluation frameworks to support data-driven investment decisions across multiple asset classes.

    Key Responsibilities

    • Designed financial and forecasting models
    • Evaluated project performance and ROI scenarios
    • Presented insights to senior stakeholders and investment committees

    Tech Stack

    Excel Modeling • Financial Analysis • Scenario Forecasting

    Outcome

    • Supported investment decisions across 10 warehouse projects
    • Enabled data-backed evaluations for residential and commercial assets

      I combine a strong background in investment and financial analysis
      with modern data analytics and engineering skills.

      My strength lies in understanding business problems, designing reliable
      data structures, and transforming raw data into insights that leaders trust.

      With a Master’s degree in Information Technology and hands-on experience across finance, operations, and analytics, I bring both technical depth and business context to data-driven decision-making.

      Nick Ho

      SQL • Python • Power BI • Data Modeling • ETL Automation

      Let’s work together to

      achieve the company’s goals

      AddMe

      Email: hominhnguyendas@gmail.com