When the university asked OTDI to modernize our administrative systems with cloud-based Workday, Ohio State gained the ability to maintain a primary source of trusted data (a single source of truth) that could be shared by all of Ohio State and the Wexner Medical Center.
In addition to Workday (implemented in 2021) the university knew it also needed a new application to enable better reporting and data analytics for its business transactions. By adding Tableau as a partnering tool, Ohio State's data analysis and data visualization competencies have expanded. Check out this quick 5-minute History of OTDI video highlighting Tableau to learn how it was incorporated into Ohio State’s suite of powerful enterprise tools.
The Big Ten Academic Alliance is collaborating to celebrate Love Data Week. The international Love Data Week event is a means of celebrating “all things data” and seeks to bring people together to share their data experiences, learn data visualization best practices, and have fun during the process. Please reach out to Ohio State’s coordinator for Love Data Week, Maureen Henry , with questions. Learn about the events , Learn how to participate in the competition , and Learn more about International Love Data Week .
The Flexible Payroll Expense Data report allows users to customize worktags for payroll expenses. The tableau report interface for the custom worktag selection will be enhanced to improve the end user experience. Instead of users selecting the "select column" icon from the top right of the report, now all the column selections will appear above the column’s headings and will remain displayed. Attend the August 2023 Office Hours for a demo of the enhanced view. In addition, check out the full NewsLink post to see a visual comparison of the old and new report interface.
A recording of the Tableau Server Fundamentals training is now available on demand in BuckeyeLearn . Users can search for “ Tableau Server Fundamentals ” in BuckeyeLearn and take the class at their own pace. This course covers the fundamentals of Tableau Server – navigation, subscriptions, saving report parameters, and sharing data and is intended for anyone who uses Tableau Server.
A secondary payroll expense detail report has been made available in Tableau to allow users a more customizable experience when interacting with Payroll Data.
Flexible Payroll Expense Details - a customizable grouping payroll expense report with two worksheets.
Flexible Cumulative Payroll Actuals and Encumbrances - provides customizable journal attribute grouping and returns a year-to-date total spend based on parameters selected in the prompt as well associated remaining encumbrances Flexible Monthly Payroll Actuals - provides customizable journal attribute grouping based on periods selected in the prompt.
Reporting users have shared that sporadic data is missing from Tableau reports using the “ [CERTIFIED] Workday FIN Mart - Journal Line Detail ” Tableau data source. This data source is powered by journal line related datasets flowing into the Reporting and Analytics Environment (RAE) from Workday. T he reload/update of the journal lines data in the RAE is expected to be complete by August 24, 2022.
In the fifth and final part of the three-year look back at Tableau series, we'll revisit the prior posts shared in the series and take a moment to see where the Tableau service is today at Ohio State and where it's headed. Read more .
In part four of our three-year look back at Tableau series, comments from the Tableau 2022 survey will be shared to gain insight into the data and analytics goals of Ohio State thought leaders, business partners, and members of the Tableau community who responded to the survey. Read more .
In part three of our three-year look back at Tableau series, we’ll learn more about how the increased use of Tableau and the collaboration it affords has led to an actual Tableau community at Ohio State. Read more .
Starting the week of April 5, 2022, we will be working behind the scenes to reload the core Journal Line dataset from Workday into the Reporting and Analytics Environment (RAE), starting with January 2021 data and finishing through current day. The reload process is expected to be complete no later than April 15, 2022. We will load the data incrementally in monthly buckets due to the size of the files. Thus, during this 10-day period, updates will appear as the load steps complete.
There will be no system outage or downtime due to this work. Users, reports, and dashboards should not be affected. Updated and complete data will flow into your existing queries without any changes on your part. Once the reload is complete, we will send out a follow up notification.
