Dea Carissa | 626
namely duplicate data, and
redundancy so data
cleansing needs to be
carried out.
4. At the fourth stage is the
formation of the data
warehouse.
b. Development of ETL Tools
The main focus of this phase is to
develop procedures for validating
data that has been extracted and
moving data in the form of a Data
Warehouse. The development of
ETL tools here uses the SSIS (SQL
Server Integration Services)
application, the function of SSIS is a
tool used to perform the Extract,
Transform, and Load (ETL) process
and is classified as a Business
Intelligence feature. In relation to
Business Intelligence, SSIS is a
feature used to pull data from ERP,
relational databases, or files for the
results to be then saved into the
Data Warehouse. While ETL is a
process to collect data from various
sources (Extract), clean it
(Transform), to then save it into
another system (Load). The
development of the system as a
whole is an actual implementation
of the analysis and design carried
out. In this phase of the project,
researchers designed data
warehouses (fact tables and
dimensions) and ETLs. In addition to
the SSIS application at this stage, it
also uses the SSAS (SQL Server
Analysis Service) application, which
is one of the Business Intelligence
tools. Analysis Services is a
technology for OLAP (Online
Analytical Processing) and Data
Mining. OLAP administration
procedures are carried out in SQL
Server Management Studio
including Viewing data and creating
multidimensional expressions.
OLAP used is Drill down and
Pivot (rotate). Drill down represents
the data in more detail while pivots
visualize operations that rotate the
axes of the data as an alternative in
the presentation of the data.
c. Development of Metadata
Metadata describes the content,
quality, conditions, and other
characteristics of a piece of data
written in a standard format. In this
case, the reporting metadata format
standard used by PT XYZ refers to
the standard metadata provided by
the management. Metadata itself
has several functions, including
identifying data, grouping similar
data, distinguishing data according
to certain criteria and providing
important information related to
data.
d. Development of Applications
The method to verify data in Data
Warehouse is to prepare reports in
Analysis Services SQL Server
Management Studio or use a BI
application and compare it with
reporting data managed by users
which is later reported to
management.