Forum Replies Created

Viewing 15 posts - 1 through 15 (of 73 total)
1 2 3 4 5 Next
  • Author
    Posts
  • cmcarthur
    Keymaster
    March 20, 2026 at 9:31 am
    Post count: 107
    in reply to: Power BI for Data Exploration #5075

    Hi Rich, I was surprised how many requests were submitted by our own department! To create the bar visual from a spreadsheet view, I did the following:

    1. Using Archibus Smart Client, I exported the work request(wr) table data into an excel spreadsheet,
    2. Imported the data into Power BI,
    3. Applied a date filter to view data from the last 2 years,
    4. Selected the spreadsheet visual and selected the Requested by and Count of Work request code, then selected the bar chart visual.

    Here’s a 35 second video that illustrates the last few steps in the process. https://ocas.sharepoint.com/:v:/r/sites/co-ocappa/Shared%20Documents/Resources/Recordings/35%20seconds%20of%20Power%20BI.mp4?csf=1&web=1&e=mfG9cW&nav=eyJyZWZlcnJhbEluZm8iOnsicmVmZXJyYWxBcHAiOiJTdHJlYW1XZWJBcHAiLCJyZWZlcnJhbE1vZGUiOiJtaXMiLCJyZWZlcnJhbFZpZXciOiJwb3N0cm9sbC1jb3B5bGluayIsInJlZmVycmFsUGxheWJhY2tTZXNzaW9uSWQiOiI4MjlmYmYyZC1mZjhjLTRmYTMtOTIwYy00M2FmZDczOWJkOGUifX0%3D

    • This reply was modified 7 months, 3 weeks ago by cmcarthur.
    • This reply was modified 7 months, 3 weeks ago by cmcarthur.
    cmcarthur
    Keymaster
    March 10, 2026 at 2:21 pm
    Post count: 107
    in reply to: Power BI for Data Exploration #5065

    Thanks for sharing Colleen.  Any surprises with the results?  I’ve always related to the term ‘data discovery’.

    Perhaps you can share the steps on how you extracted the raw data and turned it into the cool bar chart.

    cmcarthur
    Keymaster
    June 16, 2025 at 8:04 am
    Post count: 107
    in reply to: Dip into AI with Google’s NotebookLM #4861

    Hey Phil,

    Thanks for this great post!

    I also think the audio interview was very fascinating. I fed it a spreadsheet of information for my mom’s upcoming appointments, and it converted it into a conversation between 2 “people” talking about what is upcoming, when and where. It was such a unique way of consuming the information and much more interesting than viewing columns and rows of static data.

    cmcarthur
    Keymaster
    June 5, 2025 at 2:48 pm
    Post count: 107
    in reply to: Unlock Effective Time Management – An Infographic #4847

    Very impressive use of AI and the graphical summary is very appealing.  The steps you shared to generate your infographic are also appreciated and I hope will be the beginning of more shared uses of this cool tech!

    cmcarthur
    Keymaster
    May 13, 2025 at 8:14 am
    Post count: 107
    in reply to: Lockdown – Fire Door- Automatically close? #4820

    Hi Chris,

    At Algonquin, our magnetic hold opens do not disengage and close if a lockdown alarm is activated.

    Regards,

    Colleen

    cmcarthur
    Keymaster
    April 30, 2025 at 2:14 pm
    Post count: 107
    in reply to: Smudging :) #4801

    Hi Nadeen,

    You may remember our Indigenous ‘Kalihwiyo’ Circle in our Library Learning Commons during your visit to Fanshawe last year.  It’s a designated smudging area with specialized HVAC as well.  I’ve attached our Standard Operating Procedure document which may provide some perspective on this and other designated areas in the College.

     

    Attachments:
    You must be logged in to view attached files.
    cmcarthur
    Keymaster
    February 3, 2025 at 12:52 pm
    Post count: 107
    in reply to: Microsoft Power Bi – Analytic Data Visualization #4713

    bump @r_mcevoy

     

    cmcarthur
    Keymaster
    November 11, 2024 at 11:08 am
    Post count: 107
    in reply to: Classroom design – power to desk or flexible configuration? #4619

    Thanks for the insightful feedback.  I believe we are leaning towards the approach Melissa described above  but, there are a few conversations pending before we decide on a go-forward standard.   …Rich

    cmcarthur
    Keymaster
    October 10, 2024 at 5:38 pm
    Post count: 107
    in reply to: Campus Signage and Building Flow Enhancement #4549

    Hi Robin,

    Fanshawe engaged Entro (https://entro.com/) a few years ago.  It was a lengthy process but they came up with an impressive design for our exterior and interior wayfinding signage.  We learned a lot during the process – in many cases we had overlooked simple things that seem obvious (ugly garbage bins at nice entrances).

    COVID interrupted our deployment but since then, signs are now up at our main campus and are due to be installed at our regional campuses this Fall.

    It was an expensive and time consuming initiative but has made a big improvement.

    We chose not to pursue a wayfinding app – when you boil it down, it’s typically used for a only few days at the beginning of a semester.   Users tend to stick with the apps they are used to (Google maps) and rarely use yet another app.   However, we have been interested in having digital wayfinding as a component of a platform.  We’ve been experimenting with ESRI’s ArcGIS Indoors.  We don’t have a dedicated resource/ expertise but early signs are promising.  This tool can connect with existing sources like AutoCAD, Revit, Archibus and even SLAM.

    Hope this helps.

    …Rich

    cmcarthur
    Keymaster
    October 7, 2024 at 5:08 pm
    Post count: 107
    in reply to: Mind Mapping – The Swiss Army Knife for Critical Thinking! #4540

    I found XMind to be particularly helpful, recently, in discussing a project with a new staff member.  We needed to create a project plan but had to sort out a number of elements to know where to begin.

    The tool allow me to easily assemble my thoughts and goals.  What seemed overwhelming at first was quickly brought under control using the tool.   The new staff member was very appreciative of the approach and was able to grasp the problem and is working towards an effective plan.

     

    cmcarthur
    Keymaster
    September 27, 2024 at 9:17 am
    Post count: 107
    in reply to: Very Cool Ways to Manipulate, Sort and Filter Lists and Tables – Dynamic Arrays #4532

    This is super helpful Phil.  I have lots of ideas to try this out on.  Thank you for sharing the video link, it was good!

    cmcarthur
    Keymaster
    September 6, 2024 at 4:54 pm
    Post count: 107
    in reply to: Benchmarking Report Q&A #4441
    How to retrieve Greenhouse Gas Data from Energy Star Portfolio Manager
    It seems we cannot re-retrieve the BPS Submission Reports from Portfolio Manager once they’ve been generated.
    If you cannot find a copy of your submission file, I’ve found a work-around and have attached a template that may help.​
    You’ll need to go into Energy Star Portfolio Manager and generate a report template (takes about 10-minutes) – this should help future submissions.
    Create Custom Report
    1. Log into your Energy Star Portfolio Manager
    2. Select Reporting tab
    3. Click Create a New Template
      1. Name Template= BPS Energy Report Ontario Colleges
      2. Timeframe = Current Year
      3. For = Energy
      4. Select Properties = All (or preferred subset)
      5. Select Metrics =
        1. Property Information
          1. Property Name
          2. Parent Property Name (default)
          3. Property GFA Self-Reported (m²) *ft2
          4. Primary Property Type-Self Selected
        • Property ID Numbers
          1. Portfolio Manager Property I.D
          2. Portfolio Manager Parent Property I.D (default)
        • Energy Performance Metrics
          1. Site Energy Use        Total (Location Based)*kBtu
        • Greenhouse Gas Emissions
          1. GHG Emissions (Metric Tons CO2e)
      1. Apply & Save Template
    10. You should return to ‘My Reports and Templates’
      1. Select Action: Generate new report
      2. After a few minutes the ‘Status’ will change from ‘Last Modified…’ to ‘Generated’ (you may need to refresh your browser window)
      3. Select Action: Download Report in Excel
    11. The attached template can help you convert 2 fields to the standard units of measure four our report.  I’ve included Fanshawe’s numbers for reference.  Feel free to overwrite and use for your Benchmarking Report data file.
    • This reply was modified 2 years, 2 months ago by cmcarthur.
    • This reply was modified 2 years, 2 months ago by cmcarthur.
    Attachments:
    You must be logged in to view attached files.
    cmcarthur
    Keymaster
    June 28, 2024 at 4:20 pm
    Post count: 107
    in reply to: Snip & Sketch Ruler #4359

    Thanks Colleen – I also had never notice the ruler, very clever.  Thanks for sharing.  I may have to watch the YouTube that Phil referenced!

    cmcarthur
    Keymaster
    May 3, 2024 at 2:50 pm
    Post count: 107
    in reply to: Adding Tool No. 2 – Calendar – Unlocking Effective Time Management #4208

    Wow, Phil – outstanding summary of practical information we can use.  I think I deserve a certificate for reading to the end!

    I’ve been getting better at leveraging the interaction between Task Manager/ Outlook Calendar & EMail but there is always room to improve.  It’s reassuring to tag items for reviewing later without worrying about forgetting them by relying on memory.  I do my ‘reviews’ but not as regularly – scheduling them into my daily routine is a clever idea.

    I agree that a deeper understanding of the functionality built into these tools (especially Calendar) can lead to profound improvements rather quickly (e.g. Scheduling Poll).  I will be checking out your link for additional tips and tricks – there’s always something new!

    Thanks for sharing.

    …Rich

    cmcarthur
    Keymaster
    March 5, 2024 at 11:23 am
    Post count: 107
    in reply to: Student Accommodations and Specialized Furniture #4132

    Hi Karen,

    Do you encounter many issues requiring repair to your electric height adjustable desks?

    Also, would you please let me know your supplier info for purchasing EHADs.

    thank you,

    Colleen

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 73 total)
1 2 3 4 5 Next