OAS Lunch & Learn Video Library
Click the Thumbnails Below to View or Download Each Video
Enter Key Words to Search the Video Library (Ex. Customizations, Project Planning, Budgeting, Reporting):
Turning Unanet Data into Executive Intelligence for FP&A/Financials & Project Reporting
PARIS Technologies showcased BI tools for Unanet, including Power Analytics for FP&A and Project Reporting, using Excel add-ins for real-time, customizable reporting.
These tools support budget vs. actuals, forecasting, and multi-dimensional analysis within a familiar Excel interface.
Unanet Datalake & Microsoft Power BI
Paul Natalizio and Courtney Drews presented on Unanet Data Lake and Power BI integration, explaining how the Data Lake provides real-time, read-only access to production data in Power BI. They demonstrated dashboarding and visualization capabilities and highlighted advantages over Unanet dashboards, including combining data sources and external sharing.
Syncing Data with Excel from Custom API Endpoints
John McPherson of ResultSet presented a session focused on extracting and manipulating data from Unanet AE into Excel using API endpoints. He walked through setting up API calls and authentication, demonstrated configuring and testing API calls in Excel using Power Query, and reviewed data transformation and refresh capabilities.
