Data Warehouse is a technology use to analyze, extract and evaluate data into information
which produce knownledge in the form of analysis to provide an advice in decision making
process. Designing a Data Warehouse using ETL (Extract, Transformation and Load)
process serves as the collection of data from different data sources into a multitude of
integrated data sets. By using snowflake scheme for the design of the data warehouse make
data prepare well and ready for analyze on Data Warehouse. The result of  this reseach is …

International Journal of Artificial Intelligence Research ISSN: 2579.7298 Vol 5, No 2,
December 2021, pp. 132-137 function to collect data from different data sources making the
entire data set integrated. Kimball or nine-step Kimball method was introduced by a
warehouse and business intelligence data expert named Elph Kimball who was used for the
steps of building and developing a data warehouse namely Choosing the process,
Choosing the grain, Identifying and conforming the dimensions, Choosing the fact, Storing …