User contributions
31 March 2020
30 March 2020
File:PublicationPlanning3.xlsm
no edit summary
File:Travel.xlsm
no edit summary
File:UserStoryReport.PNG
William.taylor uploaded a new version of File:UserStoryReport.PNG
File:UserStoryReport.PNG
no edit summary
File:Artifacts.xlsx
no edit summary
File:Form Processing.pptx
no edit summary
File:UXForm2.xlsm
no edit summary
File:Findings.pptx
no edit summary
File:PPMG Repository.pptx
The repository contains a number of data bases created in response to expressed needs, to address gaps in data management, to carryout experiments in time savings, email volume reduction, demonstrate including disparate elements in PMR reporting and a...
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+384
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+26
27 March 2020
CCDIC Refining Strategic Data Management Initiative
more fixes
m+604
CCDIC Refining Strategic Data Management Initiative
small fix
m+5
CCDIC Refining Strategic Data Management Initiative
spellos
-12
CCDIC Refining Strategic Data Management Initiative
typo
m+2
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+681
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+950
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+135
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+755
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+211
26 March 2020
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+353
CCDIC Refining Strategic Data Management Initiative
no edit summary
m+266
File:Report flows.pptx
The data modeling of the reports around us was important from a data point of view. Looking at data flows gives insights to the reporting process and how well it is interfaced. We look for "ping-ponging", "bounces", waiting, existence of a feedback lo...
File:Data Input Method.pptx
The first presentation exploring the options available to PPMG and CCDIC. This theme matured as time went on an those improvements are in later presentations.
File:PPMG CCDIC planning tool.pptx
Common Planning Dbs to demonstrate what the common tool would look like and how it would work in an effort to acquaint folks with relational database strategies which can save significant time and prevent repeating tasks (rated #1 source of pain). My...
File:HL PMRRequirements.pptx
Lean effort to define the high level requirements for the PMR
File:PMRwithForm2.xlsm
The second of a series of forms intended to deliver the missing higher quality User Experience to the spreadsheet environment at PHAC.
File:The PPMG Data Landscape.pptx
This presentation was used to shape the discussion of local data, data repositories and data usage in PPMG.
File:Survey2.jpg
an example of the type of form I was attempting to embed in an email body as a watermark. Sadly, the alignment of the form and the users input can be thrown out of whack by too many uncontrollable influences like the size of the receiver's signature or...
File:PMT Reponses.txt
This is an example we studied in order to determine if it was possible for this group to achieve the technical standing required with this survey system to be able to do the back-office processing for this very demanding PMT reporting. While we do have...
File:New Work Plan.xlsx
A BA operates under a commitment not to impact the time staff requires for operational deliverables. This team was very busy. Just before the new year, I proposed an alternated set of deliverables as an example of goals we could pursue given that it...
File:MVR PMR BoP.pptx
A study of PMR BOP and MVR data models used to deflect attention from any strategy of combining these data to solve MVR aggregation issues. The solution lies in preserving local financial system records not in the data of existing reports. Now, it is...
File:MVRAntG&C.docx
Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders...
File:MVR CCDIC Rollup.docx
Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders...
File:MVR Anticipated Salary.docx
Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders...
File:MVR Anticipated O.docx
Data Modeling for this report. How does local data fit with this aggregated report? Where is the data given by PPMG to the financial reporting system each year as financial commitments?, Surely, preserving that data will be the source data to unders...
File:ImportMail.docx
VBA routine to auto-import the contents of the body of email into excel or access
File:DRRDataModel.docx
The DRR report data model. If the report content were to be treated like a data base record, what would the individual data elements and their labels be? We need these data models in order to assess whether or not these data might be of value in our...
File:PMRwithForm5.xlsm
This is a working example of using an improved UX Form on one tab to gather data and save one record per row to another tab with the traditional spreadsheet entry form. The Form will save all the data entered as a workbook to a network drive automatic...
File:CCDIC Sprints.pptx
Improvement ideas and early discussions from our sprint meetings.
File:PIP model.docx
PIP Data Model
File:PMTerms.pptx
Intended for discussion during the team's deliberations of a data model solution required for adding PMR planning records to the BOP. There was a clash of nomenclature, I felt the standard usage would be an aid to the discussion.
File:PHAC Org Chart.pptx
Made my own org chart while waiting for the official one.
File:Integration.pptx
High Level conceptual view of the data mindset we need to change. This enables change
File:CCDIC publications flow- Pilot.xlsx
Dta from which I built the Publications Planning RBM data input form, the spreadsheet repository and the trial database
File:Setup Workbook Connections.pptx
Results of the Lean experiment: Can we use connects to gather data?
File:SurveyAssessment.pptx
William.taylor uploaded a new version of File:SurveyAssessment.pptx
File:Our First Step.pptx
Presentation intended to help those who were having difficulty "starting" their RBM data gathering and reporting in the RBM Community of Practice.
File:Telephone Data Initiative.pptx
This was our first sprint or Lean experiment.