- This video explains how data flows from Filevine into Domo/Periscope, specifically using an Amazon S3 bucket as the preferred transfer method.
- Reports are created in Filevine, scheduled for delivery (typically daily in the early morning), and pushed into an AWS S3 bucket where the raw, uncleaned data is stored.
- Domo then pulls those raw datasets directly from the S3 bucket, making them available for transformation and use on the platform.
- Once inside Domo, data goes through an ETL (Extract, Transform, Load) process where it is cleaned, filtered, and optimized specifically for dashboard reporting.
- Dashboards are not real-time — they are only as current as the last scheduled sync, which is a common reason for data discrepancies between Filevine and Domo/Periscope.
- The final datasets produced through the ETL process are what power the cards and dashboards, making data transformation a critical step in the overall workflow.
Comments
0 comments
Please sign in to leave a comment.