Oracle Database Analytic Views

Presented by Dan Vlamis, Mike Caskey and George Lumpkin

Analytic views (new in Oracle 12.2 and discussed at Oracle OpenWorld) will let you easily transform tables into the next-generation data source for BI applications and Excel Pivot Tables. Analytic views add analytic content to data using a dimension model and a library of hierarchical, time series, and other calculations. They are the perfect complement to Oracle Database In-Memory, allowing you to add analytic content to tables in the in-memory column store, conventional tables, and views. Learn how analytic views transforms a star schema (and more) into a rich model with time series and hierarchical calculations. See how these views are easily created using both tools in Oracle SQL Developer and SQL data definition language and query them using SQL and Microsoft Excel.

Let’s discuss your options

Contact us to discuss next steps.