User contributions
26 March 2020
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.
File:Section Planning Input Requirements.pptx
A presentation for discussion of which data elements might form a planning record which would serve PPMG going forward. Breaking the mindset of data model per report to "data we need".
File:Report Modeling2.pptx
A presentation for a discussion about the potential for a local repository of data from and useful to PPMG activities.
File:Publications SOP.pptx
This is a process diagram of the Publications SOP
25 March 2020
File:RBM platform scenarios.docx
The list of scenarios considered for Centralized RBM
File:Auto Import the Attachments of Incoming Emails to Excel.docx
VB for auto import
File:SurveyAssessment.pptx
William.taylor uploaded a new version of File:SurveyAssessment.pptx
File:SurveyAssessment.pptx
William.taylor uploaded a new version of File:SurveyAssessment.pptx
File:PMR BOP Integration savings.xlsx
A comparative study of the possible savings of integration of PMR planning, PMR-BOP data and data gathering methods. A side-by-side comparison of As-Is vs. To-Be scenarios
File:Data Modeling.xlsx
the Lean data modeling of all the local data sources and some quick analysis. There is a companion ppt
File:CCDIC HR Database.xlsx
Suggestion from staff. It needs a nice record viewing form, a centralized collection and a method of sharing data.
File:DP Approval Process.pptx
When PPMG was left out of a step of the Departmental Plan, I gathered process info and created a process chart. The chart clearly demonstrated a disconnect which was corrected with the chart aiding discussion
File:SurveyAssessment.pptx
A quick ppt for a discussion on the merits of surveys vs. spreadsheets and what requirements should be considered for a data gathering system.
File:Decoupling Benefits.pptx
An overview of the concepts, benefits and configuration examples of decoupling data creation from data gathering/reporting.
23 March 2020
CCDIC Refining Strategic Data Management Initiative
it to them
m+2
CCDIC Refining Strategic Data Management Initiative
First Draft
+23,078
19 March 2020
CCDIC Refining Strategic Data Management Initiative
Started the wrap up
-1,776
User:William.taylor
first edit of my page
CCIDC Refining Strategic Data Management Initiative
William.taylor moved page CCIDC Refining Strategic Data Management Initiative to CCDIC Refining Strategic Data Management Initiative: Correct spelling in Centre's acronym
CCDIC Refining Strategic Data Management Initiative
William.taylor moved page CCIDC Refining Strategic Data Management Initiative to CCDIC Refining Strategic Data Management Initiative: Correct spelling in Centre's acronym
m
6 November 2019
5 November 2019
CCDIC Refining Strategic Data Management Initiative
Providing information about the Refining Strategic Data Management Initiative.
m+115
CCDIC Refining Strategic Data Management Initiative
Tracking the results, planning and activities of an initiative to take on the responsibility of improving a reporting system by the staff behind the system, non-IT folks, themselves.