"BI Project Notes" Analysis on the change of mean value of sensory assessment in the past years the establishment of cube

Original: "BI Project Notes" Analysis on the change of the mean value of sensory assessment in the past years the establishment of cube

Analysis topics
Main dimensions:
Tobacco leaf grade, tobacco leaf grade by grade information, tobacco leaf grade according to grading standard (standard dimension)
Place of origin (parent-child dimension)
Detection time (Time dimension, to Tqc_raw_smokingtest. Checktime field derived checkdate field)
Dimension of sample

Main indicators:

Aroma Characteristics _ Fragrance _ Average
Aroma characteristics _ Sweet-smelling _ average
Aroma Characteristics _ burnt _ average
Flue gas Characteristic _ concentration _ average
Flue gas Characteristic _ momentum _ average
Quality Characteristics _ flavor _ Average
Quality Characteristic _ Aroma Amount _ Average
Mass Characteristics _ Miscellaneous Gas _ Average
Quality Characteristics _ stimulation _ average
Quality Characteristics _ aftertaste _ average
Quality Characteristics _ total _ average

2 New named calculations:

ETL Design

Dimension tables that need to be extracted:

Serial number	Table name	Description	Note
	Tobacco leaf Grade:
1	T_gbgradecode	Leaf Level Code Information	Yyerp the corresponding table in the library T_gbgradecode
2	T_tobaccoleatpart	Leaf Parts	Yyerp the corresponding table in the library T_tobaccoleatpart Upper, middle, lower, variegated, no-site, foot, parietal
3	T_distinction	Tobacco Leaf Grade Information	Yyerp the corresponding table in the library t_distinction
4	T_gradestandard	Grading criteria	Yyerp the corresponding table in the library T_gradestandard
5	T_tobaccoleaftype	Flue-cured tobacco	Yyerp the corresponding table in the library T_tobaccoleaftype Burley tobacco, flue-cured tobacco
	Origin:
6	T_origin	Tobacco leaf origin	Yyerp the corresponding table in the library T_origin

The fact table that needs to be extracted:

Serial number	Table name	Description	Note
1	Tqc_raw_sample	Sample Table
2	Tqc_raw_smokingtest	Assessment of quality inspection of suction

Final Browsing Effect :

Client Display effect:

"BI Project Notes" Analysis on the change of mean value of sensory assessment in the past years the establishment of cube