Asset Management

Expand all | Collapse all

Power BI asset management dashboards

  • 1.  Power BI asset management dashboards

    Posted 19-04-2021 16:34
    We are in the process of developing a Power BI dashboard for asset management and wondering if anyone has something already developed and inplace?

    We are a TechnologyOne Council and already have an asset owner report card and technical report card in place to maintain the integrity of the register and drive the improvement plan and associated behaviours.

    If anyone is on the same journey or has an asset management Power BI dashboard inplace I would be keen to hear from you.

    Regards

    Gary Willocks
    Principal Asset Management
    Finance and Business Strategy
     Toowoomba Regional Council
    PO Box 3021 Toowoomba QLD 4350
    07 4688 4517  0499 092 012
    gary.willocks@tr.qld.gov.au
    www.tr.qld.gov.au



    ------------------------------
    gary willocks
    Toowoomba Regional Council
    TOOWOOMBA VILLAGE FAIR
    Australia
    ------------------------------
    BlogPageSpacerBlank


  • 2.  RE: Power BI asset management dashboards

    Posted 20-04-2021 15:51
    Hi Gary

    I am on a similar journey to you and am creating a Power BI dashboard. I would be happy to connect and discuss my thoughts on what information I want to capture and display with you if you're interested.
    Feel free to reach out and we can set up a time to discuss - my email is megan.finnie@northernbeaches.nsw.gov.au

    Thanks
    Megan Finnie

    ------------------------------
    Megan Finnie
    Northern Beaches Council
    (Warringah)
    Manager Asset Strategy Planning & Performance
    DEE WHY
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 3.  RE: Power BI asset management dashboards

    Posted 20-04-2021 15:51
    Hi Gary, I would take an agile approach to this - what are the business needs?  i.e. what's the purpose of the dashboard.

    Process map the steps to get data to the dashboard, and if the data is to be actionable, any steps that occur after the presentation of the data.
    Identify your user stories for each step, rank them by priority and effort, identify data sources and model the data, create reports in power BI with answers to your business questions and once correct, determine how to display them (UI)

    E.g.  Inform staff about our asset portfolio - might have some user stories such as:
      As a [General Manager] I need to [see the replacement value of the asset portfolio by service group and location] so that [I know the scale of current asset investment]
      As a [Asset Manager] I need to [see the risk profile of the asset portfolio by service group] so that [I can see where interventions need to be prioritised]

    Regards
    Shane

    ------------------------------
    Shane Allen
    Palmerston North City Council
    Asset Manager Advisor (3 Waters)
    Palmerston North
    New Zealand
    ------------------------------

    BlogPageSpacerBlank


  • 4.  RE: Power BI asset management dashboards

    Posted 22-04-2021 09:49
    Hi Shane thankyou for the advise and do agree..


    ------------------------------
    gary willocks
    Toowoomba Regional Council
    TOOWOOMBA VILLAGE FAIR
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 5.  RE: Power BI asset management dashboards

    Posted 20-04-2021 15:51
    Hi Gary,

    I have nothing to offer as an answer, but would be keen to see what you have created for your current report cards given we are a T1 site also.

    Regards

    ------------------------------
    Mark Matthew
    City of Charles Sturt
    Asset Systems Officer

    Email: mmatthew@charlessturt.sa.gov.au
    ------------------------------

    BlogPageSpacerBlank


  • 6.  RE: Power BI asset management dashboards

    Posted 21-04-2021 13:44
    Hi Mark thanks for the contact and have sent information to your email FYI regarding the Asset Owner and Technical report cards we have developed etc...

    ------------------------------
    gary willocks
    Toowoomba Regional Council
    TOOWOOMBA VILLAGE FAIR
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 7.  RE: Power BI asset management dashboards

    Posted 21-04-2021 13:44
      |   view attached
    Hi Gary & Mark
    We are also a Tech One site and would be interested to see what you come up with as I am always working around the sides of strategic asset management and asset  information systems in leiu of an organisation asset management strategy. I did watch a webinar on 'Asset Information Strategy and Development of an Asset Monitoring Information Platform' hosted by Trasgird via the Asset Management Council Website which showed the integration of multiple data sources into a BI Dashboard just this morning which was quite informative if you are interested. It is free for AMC members (I have attached the slides).

    ------------------------------
    Samantha Gartland
    Northern Territory Airports
    Operations Systems Coordinator
    Eaton
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 8.  RE: Power BI asset management dashboards

    Posted 21-04-2021 10:14
    Hi Gary
    not sure if your organisation has the IPWEA e-IIMM (2020), but if you do, go into it and search 'dashboard' and there's a range of case study material and guidance in there.  if any specific case study organisations in there that are of interest I could try and put you in touch with that organisation.
    Lisa Roberts

    ------------------------------
    Lisa Roberts
    Infrastructure Decisions Ltd
    Auckland NZ
    New Zealand
    ------------------------------

    BlogPageSpacerBlank


  • 9.  RE: Power BI asset management dashboards

    Posted 21-04-2021 13:44
    Hi Lisa, thankyou I do have a hard copy IIMM and have found the reference...Having said this I will be organising the e-version to make references so much easier to search and find...Thankyou again


    Regards

    Gary Willocks
    Principal Asset Management
    Finance and Business Strategy
     Toowoomba Regional Council
    PO Box 3021 Toowoomba QLD 4350
    07 4688 4517  0499 092 012
    gary.willocks@tr.qld.gov.au
    www.tr.qld.gov.au



    ------------------------------
    gary willocks
    Toowoomba Regional Council
    TOOWOOMBA VILLAGE FAIR
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 10.  RE: Power BI asset management dashboards

    Posted 26-04-2021 13:29
    Hi Gary
    we recently won the Asset Management Information Management Award for our Asset Data Workflow Dashboard. we have some great dashboards developed for various stages of the asset data records and management. feel free to reach out and connect.

    ------------------------------
    Bhavin Mehta
    Melton City Council
    Principal Planning Engineer
    Melton
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 11.  RE: Power BI asset management dashboards

    Posted 28-04-2021 12:05

    Hi Bhavin,

    I'm wondering if it would be alright for me to connect with you as well as I'm keen to see the dashboards your team have developed. I can use it as a guide for me to create our own asset management dashboards as well. 

    Thank you.



    ------------------------------
    Joemar Cacnio
    Wellington Water Limited
    Wastewater Process Analyst
    Lower Hutt
    New Zealand
    ------------------------------

    BlogPageSpacerBlank


  • 12.  RE: Power BI asset management dashboards

    Posted 29-04-2021 15:25
    Hi Bhavin

    Me too, I'm keen to see and understand the asset data workflow dashboard.

    Cheers, Pete

    ------------------------------
    Pete Hebden
    Dunedin City Council
    Asset & Facilities Mgr
    Dunedin
    New Zealand
    ------------------------------

    BlogPageSpacerBlank


  • 13.  RE: Power BI asset management dashboards

    Posted 29-04-2021 15:26
    Hi there Bhavin,

    We have a similar need here at Singleton Council and we would be keen to review your Power BI dashboards. Could we meet up further to discuss?

    jgrech@singleton.nsw.gov.au

    Kind regards

    ------------------------------
    Jason Grech
    Asset Engineer
    Singleton Council
    Australia
    ------------------------------

    BlogPageSpacerBlank


  • 14.  RE: Power BI asset management dashboards

    Posted 30-04-2021 10:54
    Hi guys, I'll be interested in further information about digital fleet asset management and dashboards, thanks.

    ------------------------------
    Tauseef Waraich
    City of Burnaby
    Manager Green Fleet and Equipment
    Burnaby BC
    Canada
    ------------------------------

    BlogPageSpacerBlank


  • 15.  RE: Power BI asset management dashboards

    Posted 29-04-2021 15:26
    Hi Gary,
    Have you had a look at the NSW IPWEA Webpage (Publications & Resources - Asset Management Panel).  There are some report cards and a dashboard users guide that may assist in data to be displayed.

    https://www.ipweansw.org/sites/default/files/uploaded-content/field_f_content_file/dashboard_user_guide.pdf

    ------------------------------
    Andrew Grant
    Assets Specialist

    Queanbeyan-Palerang Regional Council
    Tel: 02 6285 6221
    Mol: 0429 130 039
    Web: www.qprc.nsw.gov.au
    Mail: PO Box 90 Queanbeyan NSW 2620
    ------------------------------

    BlogPageSpacerBlank


  • 16.  RE: Power BI asset management dashboards

    Posted 17 days ago
    Hi Gary

    We are currently in the process of transitioning onto Tech1 Works & Assets, as part of this transition we are also implementing Power BI Dashboards. I was just wondering how you are progressing and if you could share your experience with me.

    It would be great if you could contact me at the email address below:
    kylieh@trc.qld.gov.au

    Thanks

    ------------------------------
    Tony Hughes
    Tablelands Regional Council
    Asset Management Advisor
    ATHERTON
    Australia
    ------------------------------

    BlogPageSpacerBlank