We know that there’s a lot of campus data noise \u2013 here’s an overview of the tools and data sources that are the most important for the largest number of 51ÁÔÆæ data consumers.<\/p>\n\n\n\n
Below, we’ve included the most commonly-used official systems for capturing\/reporting the current state of 51ÁÔÆæ data, as well as the tools used to visualize and export that data for other day-to-day purposes.<\/p>\n\n\n\n
PAWS<\/abbr> is the student information system used by 51ÁÔÆæ students and staff for capturing the current state of all academic \u2013 course enrollments, program\/plan\/advisor assignments, degree processing, among many others. It is the system of record for 51ÁÔÆæ student data, and the primary source of data for the majority of campus reports and dashboards.<\/p>\n\n\n\n Requests for role-specific administrative access for additional functionality (such as grade roster access or student advisor functionality) can be submitted through the DAR<\/abbr> form. Please see the PAWS Administrative Access page<\/a> for more information.<\/p>\n\n\n\n <\/p>\n\n\n\n Power BI is a Microsoft BI tool that combines industry-leading visualization and data analysis capabilities and tight integration with other Microsoft 365 (previously Office 365) offerings to create impressive dashboards and reports and a more meaningful way for data consumers to read and interpret campus data.<\/p>\n\n\n\n In March 2020, the DGCC recommended that the campus adopt Power BI as the new campus-wide ad-hoc reporting tool. <\/p>\n\n\n\n There are two Power BI license types which are assigned to individual Microsoft 365 users: <\/p>\n\n\n\n Power BI Free<\/strong> <\/strong>licenses are assigned to all 51ÁÔÆæ faculty and staff with an EMPL1 designation and allow you to consume content in Premium Workspaces (see below) and publish content to your own personal workspace\u2014Free<\/strong> users are not able to share content with other users through the Power BI service. <\/p>\n\n\n\n Power BI Pro<\/strong> licenses allow you to share your data, reports, and dashboards freely with other users who also have a Power BI Pro license. You can also create and be a contributing member of workspaces, publishing content for other campus users. <\/p>\n\n\n\n Power BI Free licenses are automatically assigned to all 51ÁÔÆæ faculty and staff during ePanther provisioning. Power BI Pro license requests must be submitted through the Data Access Request<\/a> form, and will be reviewed to assess need and determine additional security for higher-risk data or more broadly distributed content. <\/p>\n\n\n\n There is also one other component which is important for understanding Power BI sharing functionality: <\/p>\n\n\n\n The Power BI Premium Capacity<\/strong> is not a per-user license like Free or Pro. Instead, it provides dedicated server resources that can be applied on a per-workspace basis. Premium Workspaces <\/strong>can host large datasets, reusable data flows for updating commonly used data, and most importantly, share published Power BI content with anyone with a Free license. There are significant, additional funding costs for 51ÁÔÆæ departments wishing to utilize these additional server resources. <\/p>\n\n\n\n To recap \u2013 Power BI authors who will only be developing content in Power BI Desktop do not need a Power BI license. Power BI authors who want to distribute that content through the Power BI Service will need a Pro license to share and create and manage workspaces for their users. Power BI consumers will either need a Pro license or a Free license (if they are consuming content published in a Premium Workspace). <\/p>\n\n\n\n Adopted in fall 2014, Navigate combines technology, research, process improvement and predictive analytics to enable proactive, data driven conversations with students. Visit the Academic Affairs Navigate webpage<\/a> for more information about obtaining access and creating Navigate reports.<\/p>\n\n\n\n The system below is the officially-supported campus data sources for student information. As new data sources are integrated into common 51ÁÔÆæ reports and dashboards, we’ll add them to the list below.<\/p>\n\n\n\n The 51ÁÔÆæ data warehouse (DW) is a database of student information that is updated regularly with PAWS data. The DW has two types of data \u2013 1) operational data (updated with the previous day’s PAWS data between midnight and 6am) with things like course enrollments, students’ academic plans\/advisors and 2) snapshot data (captured on a set schedule and\/or frequency) with enrollment\/application information for historical comparison and\/or mandatory reporting purposes. <\/p>\n\n\n\nPower BI<\/h3>\n\n\n\n
Power BI Licenses and Sharing<\/strong> <\/h5>\n\n\n\n
EAB Navigate<\/h3>\n\n\n\n
\n\n\n\nData Sources<\/h2>\n\n\n\n
51ÁÔÆæ Data Warehouse<\/h3>\n\n\n\n