Statistician: Difference between revisions

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Statistician"

@@ Line 1: / Line 1: @@
-Our Statistician [[Julie Mojica]] provides data analysis support to the projects that use the [[CCMDB]].
+[[p:Julie Mojica]] is the full time Statistician for the Critical Care and Medicine Database.
-The Statistician has full access to all the data. We use various tools for data analysis, with SAS being the preferred. Some basic analysis can be done by the [[data processor]]s using [[TMSX]], Excel or Access.
+She provides '''[[Statistical Analysis]]''' and '''[[Reporting]]''' using our data.
-{{stub}}
+The Statistician is a member of the [[Steering Committee]] & the [[Task Team]].
+== Indicators w questions ==
+{{#cargo_query:
+tables=Indicators,Discussions,_pageData
+|join on=Indicators._pageName = Discussions._pageName, Indicators._pageName=_pageData._pageName
+|fields=
+CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
+Discussions._pageName=page,
+question, Indicators.Description
+|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
+|order by=Discussions.question
+|limit=1000
+|offset=some number
+|default=No questions found
+|format=dynamic table
+|rows per page=100
+}}
+== Reports w questions ==
+{{#cargo_query:
+tables=Reports,Discussions,_pageData
+|join on=Reports._pageName = Discussions._pageName, Reports._pageName=_pageData._pageName
+|fields=
+CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
+Discussions._pageName=page,
+question
+|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
+|order by=Discussions.question
+|limit=1000
+|offset=some number
+|default=No questions found
+|format=dynamic table
+|rows per page=100
+}}
+==Questions on wiki==
+Here is a list of questions driven by the [[Template:Discuss]] that have been flagged for Julie.
+{{#cargo_query:
+tables=Discussions,_pageData
+|join on=Discussions._pageName=_pageData._pageName
+|fields=
+CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=edit\}\} edit]")=edit,
+Discussions._pageName=page,
+question,
+_modificationDate=ModDate
+|where=Discussions.who="Julie" and Discussions._pageName<>"MediaWiki:Common.js"
+|order by=Discussions.question
+|limit=1000
+|offset=some number
+|default=No questions found
+|format=dynamic table
+|rows per page=100
+}}
+== IT Access used ==
+* [[File share HSC Critical Care]]
+* [[File share HSC Critical Care CRRT]]
+* [[File share Critical Care QIT]]
+* [[Critical Care Sharepoint ExtraNet]]
+* [[File Locations]]
+== Related Articles ==
+{{Related Articles}}
+[[Category:Statistician| *]]
+[[Category:Steering Committee]]
+[[Category:Task Team]]
+[[Category:Main Office Team]]