This video introduces the new Denodo 9.5 metric view feature, designed to centralize complex business metrics, KPIs, and dimensions. It provides a step-by-step demonstration on creating these views via a graphical wizard, defining dimensions, and setting up aggregation expressions. Additionally, the video shows how to execute the metric view using a VQL shell. Finally, it outlines the process for connecting the view to Power BI using an ODBC driver and direct query to visualize the aggregated data. https://community.denodo.com/docs/html/browse/9.5/en/vdp/administration/creating... https://community.denodo.com/docs/html/browse/9.5/en/vdp/data_catalog/metric_vie... Timestamps: 00:10 - Introduction to the new Denodo 9.5 metric views and their capabilities. 01:04 - Demo: Initial steps to create a new metric view. 01:30 - Working in the Model tab and managing views with pre-referenced associations. 02:57 - Manually creating relationships and mappings between views without existing associations. 03:58 - Configuring the Output tab: Defining dimensions, metrics, and expressions. 05:54 - Cleaning up overlapping dimension fields and saving the view. 06:29 - Executing the metric view within a VQL shell using the evaluate_metric function. 08:12 - Visualizing Denodo metric views in Power BI via an ODBC connection using DirectQuery. 09:49 - Selecting fields to populate and display the final data graph in Power BI.
Details:
