Changes

Jump to navigation Jump to search
6,354 bytes added ,  17:19, 28 January 2022
no edit summary
Line 41: Line 41:  
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.
 
[[File:EDR - A trusted source of data.png|thumb|alt=|628x628px]]
 
[[File:EDR - A trusted source of data.png|thumb|alt=|628x628px]]
 +
 +
==Tools==
 +
Analytics tools that are currently available to our SSC users are Power BI (Coming Soon) and SAS.
 +
 +
The EDR can be accessed through both Power BI and SAS.
 +
 +
==='''Power BI'''===
 +
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 (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.
 +
 +
Whether you're a data scientist, business analyst, statistician or forecaster, you'll discover the real power of SAS® to explore, analyse and visualize data.
 +
 +
The EDR can be accessed with the below suite of SAS tools. Connections to the database have already been made, no special requests are needed to access it after you start using the tool of your choice.
 +
{| class="wikitable"
 +
|
 +
|'''SAS Enterprise Guide 8.1'''
 +
|'''SAS Visual Analytics'''
 +
|'''SAS Add-On For Microsoft  Excel and Microsoft Office'''
 +
|-
 +
|'''Typical User  Profile'''
 +
|​'''Programmers:''' someone who  wants to extract, transform and/or load data.
 +
 +
'''Statisticians:''' someone who  wants to describe and analyze data and draw conclusions.
 +
 +
'''Analysts:''' someone who  wants to derive insight from data through analysis and reporting.
 +
|'''Developers:''' someone who  builds dashboards.
 +
 +
'''Consumers:''' someone who  visualizes dashboards.
 +
 +
|'''MS Office user:''' someone  who wants to use MS-Excel, MS-PowerPoint or MS-Word to run analyses, generate  reports, and share data available from the SAS Server.
 +
|-
 +
|'''Description'''
 +
|SAS Enterprise Guide provides transparent access to data as well as  the ability to export it to other applications. It's an easy-to-use menu- and  wizard-driven tool for analyzing data and sharing results.                                         
 +
|SAS Visual Analytics is a powerful web-based tool to  visualize your work.   
 +
 +
                                    
 +
|Upon installation of SAS Enterprise Guide, a SAS add-in  application feature is available via Microsoft Office programs, including  Excel. Analysts can import data from SAS and the EDR into Microsoft Excel to  work in that environment.
 +
|-
 +
|'''Training Videos'''
 +
|Overview of SAS  Enterprise Guide 8.1 - SAS Enterprise Guide - SAS Video Portal
 +
|Overview of SAS Visual  Analytics - on SAS 9 - SAS Video Portal
 +
|VERSION 8: Get Started  Using SAS® Add-In for Microsoft Office - Version 8 - SAS Video Portal
 +
|}
 +
 +
==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.
 +
 +
==='''Data Literacy Program'''===
 +
The Government of Canada's mandate is to provide a data-driven decision-making process.
 +
 +
Enterprise Information and Data Management Services directive supports:
 +
 +
*Bulleted list item
 +
Assisting you with your learning and development needs
 +
 +
*Bulleted list item
 +
Creating and maintaining a curriculum of learning resources
 +
 +
*Bulleted list item
 +
Promoting available learning resources to the Department
 +
 +
*Bulleted list item
 +
Current trends in Data Literacy learning and development
 +
 +
=Data and Analytics Networking=
 +
Analysts can find resources and support through the communities 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.
 +
 +
This community serves as a hub for analytics resources as well as providing access to analytics training and development opportunities.
 +
 +
For more information, or news on our upcoming events, please visit [[gccollab:groups/profile/5755677/enall-things-analyticsfr|the Enterprise Analytics Community of Practice]] GCCollab page.
 +
 +
 +
                                                                                                                                                                                 
 +
 +
== '''Data Stewards Community of Practice''' ==
 +
 +
 +
The Data Steward Community of Practice (DSCoP) is a working-level community responsible for building the structure within which data stewardship can be formalized as a role and a practice.
 +
 +
The DSCoP also serves as a forum to exchange ideas, provide insights, bring forward challenges and highlight best practices related to data stewardship within Shared Services Canada (SSC).
 +
 +
== '''Enterprise Data Repository Technical Working Group''' ==
 +
 +
 +
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:
 +
 +
* Élément de la liste à puces
 +
Issues and concerns with data security and privacy requiring further investigation
 +
 +
* Élément de la liste à puces
 +
Recommendations associated with SSC’s data governance policies and standards
 +
 +
* Élément de la liste à puces
 +
Consistency of data usage across the enterprise
 +
 +
* Élément de la liste à puces
 +
Improvements in the analytics solution
 +
 +
* Élément de la liste à puces
 +
Recommended priorities for technical changes and the impact they might have on various users
 +
 +
* Élément de la liste à puces
 +
Recommended priorities with respect to adding new data or functionality to the EDR
 +
 +
* Élément de la liste à puces
 +
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|dacoe-cead@ssc-spc.gc.ca]]'''

Navigation menu

GCwiki