Public Sector

At Hardes & Associates our primary goal is to achieve better outcomes for the Australian Health System. We do this by providing the best evidence-based market intelligence available.

We believe that providing trustworthy, valid and reliable information to health departments will support equitable access to healthcare for all Australians. In the public sector, every Australian State and Territory either has used or is currently using our demand/supply modelling for both strategic planning and capital works. We provide a full suite of Inpatient and Emergency Department products designed to:

  • Facilitate a comprehensive evaluation of health service delivery over the past 5 years
  • Evaluate historical and projected clinical trends
  • Quantify the type & volume of activity to expect in the future under a “status quo” or “base case” scenario
  • Deliver automated modelling tools that produce alternate scenarios based on a detailed set of end-user inputs

Product Delivery

Delivering the “gold standard” in healthcare data is essential, but it’s not the only thing that is important. At Hardes & Associates, we put just as much effort into the end-user experience.

Microsoft Access

In general, Access is better for managing data. It is an information management tool, or relational database, that helps you store information for reference, reporting and analysis. Access can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.

Microsoft Excel and Pivot Tables

Excel is generally better than Access for analysing data: performing complex calculations, exploring possible outcomes, and producing high quality charts. Pivot Tables provide a comprehensive review of the historical, current, and future acute inpatient and emergency department data. The greatest advantage of using a pivot table is the flexibility to manipulate/cut the information any way you choose and at any level of aggregation. Pivot tables are a rich and valuable source of detailed information.


Summary information is delivered in Tableau, which is a suite of business analytics tools to analyse data and share insights. Its dashboards offer a rich visual representation of Hardes Data. Heat maps provide unparalleled insight into geographic variation and patterns.

Microsoft Excel Acute Inpatient Model (AIM) and Emergency Department AIM

Our automated Excel-based tools enable modelling of alternate inpatient and emergency department scenarios. These programs provide the capacity to model changes across five key dimensions: populations, admission rates, relative utilisation, overnight ALOS and flow patterns.