--- title: Home --- [Skip to content](https://robertmair.com#main-content) [![robertmairemailsiglogov3](https://robertmair.com/hs-fs/hubfs/robertmairemailsiglogov3.png?width=321&height=40&name=robertmairemailsiglogov3.png)](https://robertmair.com/?hsLang=en) - [Home](https://robertmair.com) - [About](https://robertmair.com/about) - [Skills and Experience](https://robertmair.com/skills-and-experience) - Projects Show submenu for Projects - [Projects Summary](https://robertmair.com/projects) - [Aged Care Fee Calculator](https://robertmair.com/aged-care-fee-calculator) - [Falls Prevention App](https://robertmair.com/falls-prevention-app) - [Data Visualisation Using R](https://robertmair.com/data-visualisation-using-r) - [Contact](https://robertmair.com/contact) Open main navigation Close main navigation - [Home](https://robertmair.com) - [About](https://robertmair.com/about) - [Skills and Experience](https://robertmair.com/skills-and-experience) - Projects Show submenu for Projects - [Projects Summary](https://robertmair.com/projects) - [Aged Care Fee Calculator](https://robertmair.com/aged-care-fee-calculator) - [Falls Prevention App](https://robertmair.com/falls-prevention-app) - [Data Visualisation Using R](https://robertmair.com/data-visualisation-using-r) - [Contact](https://robertmair.com/contact)   **HOME** # ROBERT MAIR ## Certified Practising Accountant, Tax Agent, and Chartered Tax Advisor. I also design for dynamic data. [Contact](https://robertmair.com/contact?hsLang=en) ### Designing for dynamic data ![home - business advisory](https://robertmair.com/hs-fs/hubfs/home%20-%20business%20advisory.png?width=94&height=100&name=home%20-%20business%20advisory.png "home - business advisory") ##### The Goal What are we solving? First, start with the end goal, then back solve from there. Many projects start with the  request for an executive 'dashboard', this is often driven by lack of transparency. However, this is not where to start. A  dashboard built on poorly defined KPIs, or inaccurate data, isn't helpful, and can result in incorrect decisions. Instead, think about the broader use of the data - how can it benefit the organisation more holistically. When and where is it needed, who needs it, and in what format?  I start with operational, compliance, and risk. Define all required outputs. These can then be used to feed into the high level 'dashboard'. ![business advisory - financial modelling](https://robertmair.com/hs-fs/hubfs/business%20advisory%20-%20financial%20modelling.png?width=76&height=100&name=business%20advisory%20-%20financial%20modelling.png "business advisory - financial modelling") ##### Systems and Data Data sources and access? Secondly, determine how to access the data.  After determining where and when data is needed, and in what format, a difficult process can be accessing the data and assessing its quality. Technology vendors don't always make this easy, sometimes there are API's, but mostly it is .csv exports. Look at all the systems, and the available reporting and export options of each. This will highlight data duplication (and functionality) between systems. Build a map, how systems connect by user, business function, process, API or otherwise (and document the licensing cost and renewal dates!).   ![home - software development](https://robertmair.com/hs-fs/hubfs/home%20-%20software%20development.png?width=112&height=100&name=home%20-%20software%20development.png "home - software development") ##### Extract Transform Load How is the data pipeline managed? Thirdly, ELT is the process of moving data from source to destination. This is where a suitable framework, e.g., Total Data Quality Management (TDQM) ([Wang, 1992](https://robertmair.com/references?hsLang=en)), really needs to be chosen and implemented. The TDQM cycle of define, measure, analyze and improve should then overlay the ELT ([IBM, n.d.](https://robertmair.com/references?hsLang=en)) process. ELT is where data is extracted from a source system, errors corrected and format transformed, and loaded into a suitable destination, such as a data warehouse or information product. Information products convert data into information via aggregation and organisation, and then present, or dashboard, to reveal meaning. ![business advisory - strategic planning](https://robertmair.com/hs-fs/hubfs/business%20advisory%20-%20strategic%20planning.png?width=113&height=100&name=business%20advisory%20-%20strategic%20planning.png "business advisory - strategic planning") ##### Putting This In Context How does all this create value? As a practical example, consider the operations of an aged care facility. Aged care is highly regulated and predominantly government funded, who sets it's pricing policy. A facilities revenue bottleneck is bed numbers. Many facilities operate at a deficit, hence I have designed data led tools to maximise funding outcomes. For example, incorrect charging of means tested care fees, without reconciliation to government charge backs, can equal tens of thousands of dollars of lost revenue. In addition, for every $1 of revenue, a facility can spend $0.85 on direct care labour. Therefore funding data should be used to optimise rosters. ### Drowning in data? ![Help](https://robertmair.com/hs-fs/hubfs/Help.png?width=104&height=100&name=Help.png "Help") Disparate systems? Data quality issues? Inaccurate reporting?  You need help. I can fix your data, systems and processes to reduce risk, improve efficiencies and enhance outcomes. [Contact](https://robertmair.com/contact?hsLang=en) Start a conversation. Interested in working together? I would love to hear from you! [Contact Me Here >](https://robertmair.com/contact?hsLang=en) **Melbourne** PO Box 602 South Melbourne Vic 3205 ![CPA B&W Logo](https://robertmair.com/hs-fs/hubfs/CPA%20B%26W%20Logo.png?width=250&height=111&name=CPA%20B%26W%20Logo.png "CPA B&W Logo") Robert is a Fellow of CPA Australia Robert is currently completing the [Bachelor of Design (Interaction Design](https://www.canberra.edu.au/course/ARB202/3/2025) at University of Canberra [mailto:info@robertmair.com](mailto:info@robertmair.com) [Home](https://robertmair.com) [Privacy](https://robertmair.com/privacy-policy?hsLang=en) [Conduct](https://robertmair.com/code-of-conduct?hsLang=en) [Reference](https://robertmair.com/references?hsLang=en) Copyright © 2026, Robert Mair