3 Business Intelligence Data Process Flow
1. Information coming from numerous resources is actually refined with the ETL (Essence, Change, Tons) procedure that includes the complying with procedures:
Information Recognition
The information removal procedure begins with right below, the information participated in the Datawarehouse should be actually legitimate as well as helpful information for evaluation, void as well as unrelated information don’t require to become taken.
Information Cleansing
Fixed inaccurate information as well as standard/uniformed inconsistent information, for instance Jkt, Jkrt, Jakarta, DKI Jakarta were actually standard right in to Jakarta.
Information Changing
The information is actually altered fit, for instance, integrating pillars or even dividing pillars, signing up with various other information resources, transforming information kinds if required, including brand-brand new pillars because of computations as well as different various other information modifications.
Information Aggregation
Information is actually aggregated like Amount, Avg, Matter along with specific column teams.
Information Launching
Information is actually participated in the Datawarehouse inning accordance with the framework
Datawarehouse.
2. Datawarehouse could be split right in to little areas referred to as Information Mart. Information Mart is actually typically kept along with an unique schema such as a celebrity or even snowflake schema.
3. The arise from BI could be utilized for different functions like Multidimensional information handling, or even evaluation along with the Control panel request, or even shown towards records / records in visuals type, could be utilized once once more for Information Mining where information is actually excavated towards view designs and after that could be utilized towards carry out forecast, as well as could be utilized for body notifies / cautioning bodies.
