The SAPAA received 30 years of site inspection data from the Alberta Government, converted from a Paradox database into an Excel format. This information included 2,973 inspections from 1988 to 2021. The data was subsequently transferred to a Microsoft Access database for further analysis and record-keeping.
Continue readingThe IPOOG session framework outlines event planning and risk management. Participants indicate their interest and possible future involvement based on attendance, ranging from indifference to active participation. Key topics include IPOOG Model complexity, time tracking, and discussion on improving tool effectiveness.
Continue readingAn Excel based tool which matches Who has right of access to What systems and Why this is the right decision.
Continue readingIPOOG onboarding emphasizes the importance of a well-structured process for new employees, focusing on providing abundant information and a clear pathway for understanding. It is based on the IPOOG concept (Input, Process, Output, Outcome, Guide), emphasizing contextualized information delivery. The strategy aims to accelerate productivity and encourage long-term employee involvement.
Continue readingNotes on how to document and manage Oracle Data Integrator (ODI) or similar extract, transform, and load (ETL) tools. A bit of a lengthy memory jog for the author.
Is the system live, is it stable? What are the risk areas of the new system? When will it be working properly? Dreaded questions when managing complex systems. A multi-factor success matrix can help an organization visualize key elements of a system and make informed decisions… or perhaps just answer the question, have we gone live yet?
A Data Dictionary assists in planning, controlling, and evaluating the collection, storage, and use of data. An Excel tool can be downloaded and a brief explanation and set of definitions are provided.
Continue readingWhat is the role of business process mapping to internal controls? The Sheffield model outlines various purposes for mapping, including clarity, compliance, process improvement, and training. The Sheffield University guidance provides a structured approach to process mapping, with different levels and options for each purpose, emphasizing the importance of accurate documentation.
Continue readingThe network file structure is now about 50+ years old but is still the backbone for a lot of corporate and personal data management [1]. At the same time, how often have you heard stories of people losing all of the family pictures because they failed to back up or backed up the wrong directory.
Continue readingHave you ever had the unenviable task of creating a procedure for something? Maybe a high level set of policies or a hands on ‘How-To’ guide. Great – now picture the end result in your mind. Got it pictured? Okay, where is it now?
Continue reading
Organizational Biology 