Self-service data warehousing

on YouTube ↗30m

" summary

Oracle bundles Autonomous Database with ready tools—Data Transforms, Catalog, Insights—so a departmental analyst can load CSVs or cloud objects, fix case and extra-month errors, and build an analytic view without hand coding. The demo creates Movie_Sales_2020_Q2, automatically detects dimensions and hierarchies, and populates materialized aggregate caches for transparent, fast queries; the Insights tool runs ML (regression/slope) to flag anomalies. The end-to-end flow is preinstalled, federates cloud stores, and produces immediate, traceable results.

AI-written summary · about

" chapters (18)

1. 0:00Intro
2. 2:16Data analysis in the traditional market Best-of-breed enterprise-class tools, tailored for the specialist
3. 3:15Autonomous Database expands addressable market for Oracle
4. 4:30Different customer profile in new market
5. 5:04The data analysis medley
6. 6:53Enterprise Data Warehouse
7. 7:32Budgets shift to lines of business
8. 7:43Dawn of self-service era Proliferation of tools to address requirements of fragmented market
9. 8:41Transition from self-service to autonomous analytics Essential ingredients are data consolidation and continuous learning from user actions
10. 12:20Oracle Autonomous Database as Modern Data Warehouse Empower business innovators with next generation doud data warehouse
11. 13:15Oracle Movie Stream
12. 14:58Data Load
13. 17:17Data Transforms
14. 19:25Business model in the database promotes consistency
15. 19:48Performance: Business models optimize query processing
16. 24:25Data Insights
17. 26:06Catalog
18. 29:15Autonomous Database with built-in tool suite The next-generation DB Cloud Service from the industry's leader for data management

" related talks

• 28mReliable data integration from applications to analyticsJayant Mahto · Oracle CloudWorld 2022
• 21mDeep dive: Data loadingBud Endress · Oracle DatabaseWorld 2022
• 23mOracle Autonomous Data Warehouse and data lakesAlexey Filanovskiy · Oracle CloudWorld 2022
• 20mTips and tricks: Data warehousing for Oracle E-Business Suite and SaaS dataJayant Mahto · Oracle DatabaseWorld 2022
• 27mAutonomous Database Data StudioMike Matthews · Oracle DatabaseWorld: AI Edition 2024
• 14mMulticloud Analytics Made SimpleMarty Gubar · Oracle DatabaseWorld: Multicloud AI Edition 2025
• 32mIntroducing Oracle Autonomous AI Lakehouse Open Multicloud Data PlatformÇetin Ozbutun · Oracle AI World 2025
• 43mData warehousing reinvented for today's needsKonstantina Mavrodimitraki, Konstantinos Papageorgiou · Voxxed Days Ioannina 2024