MS Access and Excel workshop to be offered on Feb. 27

By: Xuying Xin

Join the university Libraries’ Research Informatics and Publishing department for informational sessions highlighting data analytics and visualization and geospatial data and mapping services, free to all Penn State faculty, staff and students. All sessions held in W312A Pattee Library, with online access via Zoom.

Data Analytics and Visualization

  • Introduction to Databases: MS Access and Excel — Thursday, Feb. 27, 2 to 3:30 p.m.
  • Business Analytics with MS SQL Server and Business Intelligence (BI)/SSIS, SSAS, SSRS — Thursday, March 26, 2 to 3:30 p.m.
  • Data Visualization with Power BI Desktop — Thursday, April 23, 2 to 3:30 p.m.

These sessions are designed to provide an overview of data analytics, as well as explore some commonly used software tools for demonstrating data analysis and visualization based on a sample data set. Advance registration is recommended but not required.

Maps and Geospatial Analysis

  • Getting to Know Geospatial Data and Mapping — Wednesday, Feb. 26, 3 to 4:30 p.m. in W13 Pattee Library, with online access via Zoom.

This session will introduce participants to geospatial data from U.S. and international sources, along with information on geospatial software access at Penn State, including ArcGIS Online, ArcGIS ArcMap, and ArcGIS Pro. Participants will receive a brief introduction to geospatial data techniques and analysis. Additional resources will be provided to help participants get started using geospatial software in projects. Resources from these Maps and Geospatial guides will be highlighted: Global Partners: International Geospatial DataArcGIS OnlineArcGIS Pro, and Geographic Information Systems (GIS).