76
edits
Changes
no edit summary
[[File:DACoE Impact.png|thumb|alt=|790x790px|left]][[File:The Suite of the Data Analytics Center of Excellence (DACoE) Products and Services.png|thumb|790x790px|alt=|left]]
[[File:DACoE Impact.png|thumb|alt=|790x790px|left]][[File:The Suite of the Data Analytics Center of Excellence (DACoE) Products and Services.png|thumb|790x790px|alt=|left]]
==Data: The Enterprise Data Repository (EDR)==
==Data: The Enterprise Data Repository (EDR)==
===What is the Enterprise Data Repository (EDR)?===
=== What is the Enterprise Data Repository (EDR)?===
Siloed data sources have been brought together, modelled for referential integrity, ensuring accuracy and consistency of data in the EDR to allow 360-degree views by service and/or organization, including historical trends. The EDR is a tool agnostic Oracle data base, which can be accessed by an analyst's preferred method. Currently available tools to access the EDR are Power BI (Coming Soon), and the SAS suite of Enterprise Guide (EG), Visual Analytics (VA), and SAS add-in for MS Excel.
Siloed data sources have been brought together, modelled for referential integrity, ensuring accuracy and consistency of data in the EDR to allow 360-degree views by service and/or organization, including historical trends. The EDR is a tool agnostic Oracle data base, which can be accessed by an analyst's preferred method. Currently available tools to access the EDR are Power BI (Coming Soon), and the SAS suite of Enterprise Guide (EG), Visual Analytics (VA), and SAS add-in for MS Excel.
===The Data Challenge===
===The Data Challenge ===
SSC’s business lines are producing a wealth of data and information from a variety of sources across multiple domains. Being able to use this data effectively and efficiently in a consistent and replicable way has been a pervasive challenge for SSC.
SSC’s business lines are producing a wealth of data and information from a variety of sources across multiple domains. Being able to use this data effectively and efficiently in a consistent and replicable way has been a pervasive challenge for SSC.
Why is the EDR Important to SSC?
Why is the EDR Important to SSC?
* Improved access to authoritative data sources. The EDR is a central database bringing data together from across various sources.
*Improved access to authoritative data sources. The EDR is a central database bringing data together from across various sources.
* Consistent reporting results from a central source which is approved and validated by data owners and governance for accuracy, relevance, and reliability.
* Consistent reporting results from a central source which is approved and validated by data owners and governance for accuracy, relevance, and reliability.
* Faster, more frequent reporting enabled from up-to-date source data which is regularly refreshed in the EDR (reduces reliance on unmanaged, unsupported, and outdated black books).
*Faster, more frequent reporting enabled from up-to-date source data which is regularly refreshed in the EDR (reduces reliance on unmanaged, unsupported, and outdated black books).
*Richer insights since EDR data across the enterprise can be joined to provide a 360 view thereby improving decision making.
*Richer insights since EDR data across the enterprise can be joined to provide a 360 view thereby improving decision making.
== Tools==
==Tools==
Analytics tools that are currently available to our SSC users are Power BI (Coming Soon) and SAS.
Analytics tools that are currently available to our SSC users are Power BI (Coming Soon) and SAS.
Power BI is a software tool to turn your data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises data sources. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
Power BI is a software tool to turn your data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises data sources. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
===SAS Suite===
===SAS Suite ===
SAS (Statistical Analysis System) offers a suite of software packages used for statistical analysis and data visualization. The SAS group of computer programs works together to store data values and retrieve them, modify data, compute simple and complex statistical analyses, and create reports.
SAS (Statistical Analysis System) offers a suite of software packages used for statistical analysis and data visualization. The SAS group of computer programs works together to store data values and retrieve them, modify data, compute simple and complex statistical analyses, and create reports.
|}
|}
==Training ==
== Training==
Training and skills development for data consumers, curators, stewards and scientists are available including, Data Literacy and available training for Power BI and SAS tools at no cost to the learner.
Training and skills development for data consumers, curators, stewards and scientists are available including, Data Literacy and available training for Power BI and SAS tools at no cost to the learner.
Analysts can find resources and support through the communities of practice.
Analysts can find resources and support through the communities of practice.
===Enterprise Analytics Community of Practice ===
===Enterprise Analytics Community of Practice===
The Enterprise Analytics Community of Practice (EACoP) has been created to cultivate an analytical community within SSC and give users of enterprise data and analytical tools the opportunity to share their knowledge, ideas and analytical expertise.
The Enterprise Analytics Community of Practice (EACoP) has been created to cultivate an analytical community within SSC and give users of enterprise data and analytical tools the opportunity to share their knowledge, ideas and analytical expertise.
The role of the Enterprise Data Repository (EDR) Technical Working Group is to develop, maintain and improve the quality, usability, and integrity of EDR data to ensure its effective and consistent use across SSC and to provide recommendations to the Data and Business Analytics Council (DBAC). Specifically, the group will provide input regarding:
The role of the Enterprise Data Repository (EDR) Technical Working Group is to develop, maintain and improve the quality, usability, and integrity of EDR data to ensure its effective and consistent use across SSC and to provide recommendations to the Data and Business Analytics Council (DBAC). Specifically, the group will provide input regarding:
* Issues and concerns with data security and privacy requiring further investigation
*Issues and concerns with data security and privacy requiring further investigation
*Recommendations associated with SSC’s data governance policies and standards
* Recommendations associated with SSC’s data governance policies and standards
*Consistency of data usage across the enterprise
*Consistency of data usage across the enterprise
*Improvements in the analytics solution
*Improvements in the analytics solution
*Recommended priorities for technical changes and the impact they might have on various users
* Recommended priorities for technical changes and the impact they might have on various users
*Recommended priorities with respect to adding new data or functionality to the EDR
* Recommended priorities with respect to adding new data or functionality to the EDR
*Identification of training and other support that would help the user community
*Identification of training and other support that would help the user community
'''Got questions, need more information or want to be Involved? Contact the DACoE via [Mailto:dacoe-cead@ssc-spc.gc.ca%7Cdacoe-cead@ssc-spc.gc.ca dacoe-cead@ssc-spc.gc.ca]'''
'''Got questions, need more information or want to be Involved? Contact the DACoE via [Mailto:dacoe-cead@ssc-spc.gc.ca%7Cdacoe-cead@ssc-spc.gc.ca dacoe-cead@ssc-spc.gc.ca]'''