Goal
The Reporting Team has been asked to transition their Tableau dashboards to PowerBI by June 2027. The following is a plan for this transition.
Contigencies
This plan is contingent on the availability of network connections from PowerBI Desktop Pro to the Metadb reporting database and Cornell Fabric server environment by June 1, 2026. As a temporary measure, dashboards can be set up to use Excel files as a data source until direct connections to the Metadb reporting database can be made.
Dashboards
Dashboards will be converted from Tableau to PowerBI in order of priority.
| Dashboard | Priority | Status | Notes |
|---|---|---|---|
| FBO Daily Reports | High | ||
| FBO Invoices in Reviewed Status | High | ||
| FBO Vouchers Date Range | High | ||
| FBO Lost Item Reconciliation | Low? | ||
| Approved Invoices Details | High | ||
| Cost by Publisher and Annual Material Expenditures, FY2014-FY2023 | No longer needed | ||
| CU Research output eusage costs by publisher | No longer needed | ||
| EUsage by Platform and Publisher Annual 2021 | No longer needed | ||
| Eusage by Title Annual 2021 | No longer needed | ||
| Fund Details with Expense Class | High | ||
| IvyPlus_Research_Output | No longer needed | ||
| Orders Split Funds | No longer needed | Sharon will archive | |
| Patron Purchase Requests | High | ||
| Borrow Direct Interlibrary Loans Details | Low | consider archiving (see Joanne) | |
| Circulation Desk Transactions | Low | ||
| Cornell University Library Annual Trends FY2013-FY2018 | No longer needed | ||
| Count of Volumes Added in FY2025 | Not needed, for A&P internal use only | ||
| Data_Cleanup | High | ||
| Ejournals Usage 2022-2024 | High | Ebsco counter data, hopefully will be available in a local schema in Metadb | |
| Ejournals Usage 2020-2023 | No longer needed | We keep a dashboard showing the latest three years of data | |
| Eusage Counts Annual 2022 | No longer needed | We keep a dashboard showing the latest three years of data | |
| LTS Acquisition (metadb) | High | ||
| LTS Cataloging (metadb) | High | ||
| Material Counts | Low | ||
| Missing Lost Claimed Returned and In Transit Items | High | ||
| Patron Item Requests | High | ||
| Physical Item Circulation Counts | Low | ||
| Presentations (Instruction) | |||
| Reference Interactions | fed by Box file from SpringShare data | ||
| Reference Interactions HeatMaps | fed by Box file from SpringShare data | ||
| Service Interactions | |||
| Withdrawals and Transfers | Not needed, for A&P internal use only | ||
| Withdrawals and Transfers FY2026_Q3 | Not needed, for A&P internal use only | ||
| Count of Volumes added in FY2025 | Not needed, for A&P internal use only | ||