Establish the cube for Physical and Chemical Index Analysis in Bi project notes over the years

This system is a data warehouse system. It is essentially different from the traditional management information system and is designed as a "theme-oriented" system. The topic-oriented approach is conducive to data organization and utilization, as well as user understanding and use.

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_chemistry. checktime field)

Sample dimension

Main indicators:
Total Sugar % totalsugar
Reducing Sugar % reducingsugar
Nicotine % nictine
Chlorine % Chlorine
Potassium % kalium
Total Nitrogen % totalnitrogen
Sugar-alkali ratio sugariratio
Potassium to chlorine ratio potassiumratio
Sugar to nitrogen ratio sugarratio

Statistical items: Average, maximum, and minimum values of each indicator


Data Source settings:

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	Tqc_raw_sample
2	Tqc_raw_chemistry	Physical and Chemical Index Detection	Tqc_raw_chemistry   The checkdate field is derived from the tqc_raw_chemistry. checktime field.

Report Style

Region	County	Level

 

Physical and chemical quality
Total Sugar	Reducing Sugar	Nicotine	Chlorine	Potassium	Nitrogen	Sugar-alkali ratio	Potassium/chlorine Ratio	Sugar-nitrogen ratio
Totalsugar	Reducingsugar	Nictine	Chlorine	Kalium	Totalnitrogen	Sugariratio	Potassiumratio	Sugarratio

Final effect:

Client Demo:

 

Establish the cube for Physical and Chemical Index Analysis in Bi project notes over the years