Data Warehouse Reporting & Analytics
WashU has defined a strategic vision to develop a centralized repository of data so that a shared, single source of truth may exist. This central repository, called a data warehouse, along with tools, training and processes, will enable units to leverage the university’s data as an asset. Our goal is for units to use this asset, through reporting and analytics, to help them make insight-driven decisions.
The integration of industry best practices will help us to develop the new environment efficiently and effectively in a way that permits future expansion.
Reporting vs. Analytics: what’s the difference?
Operational Reporting is the process of organizing data into informational summaries in order to monitor how different areas of business are performing.
Reporting is typically focused on one area of business.
Reporting looks at the past.
Analytics lets us transform data assets into competitive insights that will drive business decisions and actions using people, process and technologies.
Analytics typically crosses multiple lines of business and may incorporate data from external agencies.
Analytics looks forward.
In other words, Analytics gives us a way to make sure the whole business is running right, and lets us discover factors that give us a competitive advantage.
Jump to a section
Types of Reporting
Whereas Workday will be the primary location for HR and financial reporting, the data warehouse will be the central location for most other reporting, including:
The data warehouse also provides reporting for systems without strong reporting capabilities.
Cross-domain reporting: Combining data from various data domains, such as Research, Finance, and Physical operations, in a single report. In the new data warehouse, all incoming data is translated into a similar “language” so it can be combined.
“Legacy” reporting on HRMS and AIS/FIS data: Now that Workday is live, all new HR and finance data will be entered there. As part of the systems retirement plan, users will be able to access data and run reports in HRMS and AIS for at least a year after Workday go-live. However, eventually, those systems will be shut down, and the warehouse will be where users go to access legacy (pre go-live) HRMS and AIS data.
What is meant by Legacy Data?
Legacy data refers to FIS and HRMS data prior to the Workday go-live date.
Legacy data structures (old General Ledger to FDM- financial data model in Workday) got changed for the MyDay initiative.
Both can be used to do multi-source analysis, but with a few key differences:
- Cognos is very good at crunching large volumes of data but it needs to have packages built to develop reports
- Tableau is very good at visual representations of data but it can’t crunch large volumes of data; it is more exploratory
Therefore we are using both these tools in order to leverage the strengths of each.
What’s in the Warehouse?
All of the new data flowing into the new data warehouse has been transformed so it can “mix” with other data, enabling cross-domain reporting.
The following key data sources are currently loaded in the data warehouse:
- NIH data
- Legacy HRMS data
- Legacy FIN data
- Legacy SFS data
- Slate data
- Workday data
- Limited RVU and Provider data
- Workday Journals
- Workday Compensation
- Workday Benefits – coming early November 2021
- Space data
- RMS data
Please note that some data requires a request for access. Learn more about requesting access here.
Data Warehouse Resources
All resources require a Box login
A Data Reference Model is a high-level representation whose primary purpose is to promote the common identification, use, and appropriate exchange of data/information across the university. The DRM helps us to create standards for both the objects in the model and how they relate to one another.
Washington University Data Reference Model (view on this page)
Washington University Data Reference Model (Box file)
When you are interfacing with the data warehouse, it is important to understand the bigger picture. Our data is vast and complex – a collection of multiple businesses put together – so a mind map like the Data Reference Model (above) is helpful to understand it.
Why do you need to know how our data is structured? A few reasons:
- New hires (like BIs/BAs) – need to understand where is the data, gain insight into how it all relates to one another
- Helps you understand where do certain funds come from, complexities of business (for your area), etc.
- Helps you understand how the same data can appear in multiple domains (staff, faculty, student, patient, etc)
- Helps you understand how to accomplish answers to business questions, especially if more than one domain is involved