As shared in October , progress continues on the retirement of the legacy reporting systems tied to PeopleSoft HR and Finance, and will be complete at the end of calendar year 2021. In preparation for the shutdown, multiple activities have been completed or are ongoing to ensure that business and data analysts will have access to legacy data as needed. See the full post for more details and additional activity highlights.
The first Tableau User Group (TUG) meeting for the 2021/2022 academic year will be held on Thursday, October 21, 2021 from noon to 1 p.m. via zoom. Registration is required . Sarah Murphy, Liana Crisan-Vandeborne, and Tim Byrne will provide a developer's Tableau Refresh workshop, reviewing how to create basic and specialty charts and apply tools from the analytics pane.
Remaining activities for the university's Workday rollout include the retirement and shutdown of PeopleSoft data sources, BuckeyeOasis tools, and eReports and BuckIQ reporting services. Beginning November 1, access to these systems will be restricted to a small group of core users prior to system shutdown on December 31, 2021. Please review the full announcement for more detailed information on how to access common reports and historical data using new data tools.
The Tableau data visualization tool allows users to quickly create visual representations of data through interactive dashboards. During the upcoming October 13 "Introduction to Tableau for Data Visualization" workshop, attendees will learn how to start using Tableau and gain a foothold into harnessing the power of their data. Interested Ohio State faculty, staff, postdocs, and graduate student researchers can check out the full post to see the agenda of topics and obtain registration information. Please register only if you can attend, workshop attendance will be capped at 30 participants.
Microsoft Azure is a private and public cloud platform that provides a set of services that allow you to build, manage and deploy applications on a massive, global network using your favorite tools and frameworks. Ohio State Azure services are available to Ohio State employees. Azure for Research offers focused services and offerings.
eReports and BuckIQ will be retired on Friday, December 31, 2021. Historical PeopleSoft data (from 12/31/20 and prior) will only be available through historical reports in Tableau, archived reports in EDM, and by working with key central unit reporting teams. In addition, the databases for these reporting systems will also be retired, including: Financial Data Warehouse (DWRPT), Enterprise Data Warehouse (EDWRPT), Employee Analytics (EA), and GL Analytics Mart (DWRPT). Student data eReports and BuckIQ reports will also be moving to new tools.
Workday go-live might not seem like something to celebrate six months later, considering our user community is still adjusting to the changes. However, it's exciting to think that the closing of fiscal year 2021 is the first annual close using transactional data from Workday! We all should be proud and keep in mind that we collectively implemented an entire enterprise system, during a pandemic, at a size and level of complexity not undertaken before at Ohio State! Kudos to all project team members, business stakeholders, and most importantly our end users in the Ohio State community for helping us reach go-live. We should all take a moment to pause and reflect on the impressive work that went into Workday Release 1.
As a part of the effort to retire the eReports system, pre-run copies of a select number of financials-based reports have been archived in the Enterprise Document Management (EDM) system (OnBase). Copies of the reports for fiscal years FY15 through FY20 (listed in the full article) have been loaded into EDM and are now available for view or download. For information on how to access and view these files, please review the Retrieving Historical Reports from OnBase (EDM) job aid found in the Administrative Resource Center (ARC). Addendum: As of July 29, archived historical files for FY21 period 1 (July) through period 6 (December) are now also available for view or download by Ohio State financial analysts.
The Data and Analytics team is offering one-hour Tableau hands-on help sessions. Initial sessions will be held weekly. The agenda for the sessions includes how to request appropriate access, walking through Tableau login steps, how to interact with data sources, how to use common reports, and how to save report filters. Time will also be allotted for an open question and answer period. See the full blog post for the MS Teams session link to join.
Ohio State’s Tableau User Group (TUG) helps bring together passionate users to learn, share and solve common data challenges.
During the March 18 meeting, TUG members will welcome Eric Mayberry, Senior Manager of OCIO’s Data Analytics Team. Eric will be providing a developer’s walkthrough for the Ohio State COVID-19 Dashboard and share techniques for: 1. Organizing dashboards with containers, 2. Filtering multiple dashboard objects with calculated fields, and 3. Guiding users through their dashboard experience. Check the full article for registration details.