Daniel Mellish is the Senior Consultant (Data Specialist) at SPP

Connect on email

Daniel Mellish is the Senior Consultant and Data Specialist at SPP, with over 20 years of experience in key finance and data analysis positions in ASX Top 50, Big Four consulting and other large organisations. He brings expertise in data visualisation, financial analysis and performance and management reporting. Daniel is a Chartered Accountant (CA), a Financial Modelling Valuation Analyst (FMVA) and has completed a Graduate Diploma of Applied Finance and Investment.

Industry Focus
  • Asset Intensive Industries
  • Consumer
  • Education & Research
  • Financial Services
Services Focus
  • Capital Planning & Precincts
  • Customer Driven Growth
  • Data & Digital
High Impact Work

Education – Victorian U-Pass Program economic model: designed a hypothesis driven model to highlight the intersection of sustainability and financial outcomes, and indicating the potential range of program features:

  • Quantitative and qualitative assumptions, goals and outputs
  • Scenarios and sensitivity analysis including elasticities
  • Allows multi-factor based analysis of pilot data to recommend final program

Australian Resort Operator– Data Analysis: comprehensive performance improvement project for a major Australian operator:

  • Data analysis and visualisation of 5 years revenue streams across all key products, to identify trends and opportunities
  • Build and delivery of a full working dashboard covering revenue streams and all detailed P&L reporting – fully customisable

Education – Course demand and opportunity model: built a dynamic, detailed and PowerBI based model for evaluating course offerings, highlighting opportunities at the intersection of market attractiveness and Uni capabilities:

  • Wide range of external (market, economic) and internal (University) data inputs – all can be switched on/off or refreshed
  • Visualisation of all outputs, with flexibility for users to isolate, compare or drill into areas and reasons being the outcomes

Education – Fund and investor economic model for University early-stage venture funding proposal: designed a specialised financial model for two funds and their key investors as part of a significant investment opportunity:

  • Identified, researched and incorporated all start-up assumptions and inputs, including international comparisons and sensitivity analysis
  • Model outputs included in all Investor pitches/presentations

Australian Import/Export Air Freight Analysis –  PowerBI visualisation: developed a model to analyse full history of any type of goods (imports and exports by category) travelling through every Australian air or sea port:

  • Using detailed monthly data sources, allows selection by region, port, good and other categories (in both value and weight)
  • Tens of millions of rows of data, 100+ million data combos

Major Australian Customer Owned Bank– Financial Analytics Managerfull time position responsible for all financial analysis and forecasting/budgeting:

    • Designed and rolled out a complete “Monthly Business Review” Corporate dashboard, changing 10+ year old reports into insightful, trend-based info
    • Built the bank’s first ever cost allocation financial model, identifying and allocating all direct and indirect costs to retail products, channels and branches – assisting the bank identify and target it strategic goals