Tutorial Overview¶
Scenario¶
In the solar generation field, site generation, ambient temperature, and horizontal radiance are common metrics used in site monitoring.
Based on device-level generation, ambient temperature, and horizontal radiance data, data preparation, dimension building, and fact table building are used to develop and query the cumulative generation metric at the solar site level, the day-level ambient temperature metric at the site, and the site-level cumulative horizontal radiance metric.
Tutorial Objectives¶
In this tutorial you will learn how to prepare data, define and configure dimension tables, define and configure fact tables, and develop and query metrics.
Prerequisites¶
Before starting, make sure you have the following ready:
The user account has been assigned the menu group containing Metric Library, Dimensions, Fact Tables, and Metric Insights.
MySQL version 5.7 has been installed.
The user account has permission to use the Data Source Registration service.
Units¶
This tutorial contains the following units:
20 minutes
Unit 2: Defining and Configuring Dimension Tables
30 minutes
Unit 3: Defining and Configuring Fact Tables
40 minutes
Unit 4: Developing and Querying Metrics
30 minutes