Bi project notes: creation of cube for average value change analysis of sensory evaluation over the years

Analysis topic
Main dimensions:
Tobacco level, tobacco level by level information, tobacco level by grading standard (standard dimension)
Origin (parent-child dimension)
Detection time (time dimension, derived from the checkdate field in the tqc_raw_smokingtest. checktime field)
Sample dimension

Main indicators:

Aroma features _ fragrance _ Average Value
Aroma features _ sweetness _ average
Aroma feature _ Jiao xiang_average Value
Flue gas feature _ concentration _ Average Value
Smoke feature _ jingto_average Value
Quality features _ xiangzhizhi_average Value
Quality features _ aroma _ average
Quality feature _ miscellaneous _ Average Value
Quality features _ stimulus _ average
Quality feature _ aftertaste _ Average Value
Quality feature _ sum _ average

Two new names are added:

ETL Design

Dimension tables to be extracted:

Serial number	Table Name	Description	Remarks
	Tobacco level:
1	T_gbgradecode	Tobacco code information	T_gbgradecode
2	T_tobaccoleatpart	Tobacco Leaf Area	T_tobaccoleatpart in the yyerp Database Upper, middle, lower, mixed color, no distinction between parts, foot leaves, top leaves
3	T_distinction	Tobacco grade information	T_distinction
4	T_gradestandard	Grading Standard	Corresponding table t_gradestandard in the yyerp Database
5	T_tobaccoleaftype	Tobacco roasting	T_tobaccoleaftype in the yyerp Database White rib smoke and Flue-cured Tobacco
	Origin:
6	T_origin	Tobacco production area	Corresponding table t_origin in the yyerp Database

 

Fact tables to be extracted:

Serial number	Table Name	Description	Remarks
1	Tqc_raw_sample	Sample Table
2	Tqc_raw_smokingtest	Rating and suction Quality Detection

 Final browsing Effect:

Client display results:

 

Bi project notes: creation of cube for average value change analysis of sensory evaluation over the years