This post takes a close look at how an Oracle Application Express (APEX) application brings to life a data set using Oracle Analytic Views. Oracle APEX provides great looking tables, charts and geographic maps. Analytic views makes it easy to populate them with data, including aggregate data and time series calculations, using just a few SQL query templates.