Implementation of Business Intelligence In Analyzing Data Using Tableau at PT Global Bintan Permata

PT Global Bintan Permata is member group Yafindo (Batam, Indonesia) which is engaged in the distribution and import goods consumption and goods consumption throughout Indonesia . one _ business being run is distributing sugar _ throughout modern market and delivery some are via transportation and some are done in a manner independent . The target market namely the big modern market like Alfamart , Alfamidi , Indomarco , Indogrosir , Tiptop, and there is also a small modern market like Totalfruits , Grandlucky , etc. _ Of the many transactions made by the company this company _ This Still Not yet own Dashboard application for monitoring activity operations and transactions . So from it is needed something deep data visualization dashboard shape . Method used to data warehouse design is use method kimball nine-step technology. For the Extract, Transform and Load (ETL) process for data warehouse design using tools in the Pentaho Data Integration application , meanwhile For dashboard visualization is done with use the Tableau Public app . Result of application Tableau Public app is form generated data visualization


I. INTRODUCTION
A very valuable source of assets for companies in the era of the industrial revolution 4.0 is data, so its existence requires good management so that it can be put to good use [1]. Data must be well documented [2]. Therefore the data will be very useful in the future [3]. Data that is processed in such a way can be very useful information, making it easier to make decisions [4]. Business Intelligence (BI) is a solution in answering the need to answer questions related to existing problem analysis, and the results of this analysis can be used in the process of making a decision [5]. The Business Intelligence system is designed to be able to visualize sales and marketing data at PT Global Bintan Permata which is expected to be a solution in helping companies to collect data and process business information that has been processed and can help companies make better decision-making processes and achieve results. what you want faster.
As a business grows, so does the complexity of the information needed to make decisions. Businesses and companies must use technology that enables them to collect, process, and also present this information to authorized parties such as supervisors, administrators, or others. A useful tool to improve the quality of decision making.
This need allows business people and entrepreneurs to use the concept of business intelligence, which enables optimizing decision making through the availability of available information, creating quality information and presenting information in a timely manner, in its simplest form, this technology allows decision makers to obtain up-to-date insights into ongoing business performance.
PT Global Bintan Permata is a member of the Yafindo group (Batam, Indonesia) engaged in the distribution and import of consumer goods and consumer goods throughout Indonesia. PT Global Bintan Permata is a trading company, we hold several brands to be distributed throughout Indonesia, especially in Java and Sumatra. Our brands such as: GMP and PSM sugar, Garemin salt, MOMOGI, MILANO, Gomi, Super Coffe Instant & Cereal and K.B.Food. The data source used is sales data at PT Global Bintan Permata which will be built as needed, so it is possible that this information system will continue to develop according to existing needs so that new opportunities will open up for information retrieval and analysis that was not previously available.

A. Business Intelligence
Business intelligence or Business Intelligence (BI) combines methodologies, platforms, database systems, applications, analysis tools, and architectures [6]. Business Intelligence itself is activities such as in the process of presentation and analysis of the information that has been collected and will then be processed into the data warehouse so that it is easy to use in the decision-making process as well as possible [7]. BI consists of architecture and operational operations that are connected and integrated with each other, and are tools to support decision making [8].
The implementation of a business intelligence system can be used as a way to be able to analyze, extract information, and learn from cases of the corona virus that have occurred. Furthermore, with the implementation of the Business Intelligence system for the corona virus case, the learning process and decision making can be easily carried out [4]. In developing a business intelligence within a company there are 4 main phases or stages that must be carried out, which include analysis, design, planning, and finally implementation and control [9].

B. Tableau
Tableau is a tool that can be used to visualize data in the form of a dashboard, so that data can be more interactive and easy to analyze. Visualization is carried out by transforming transactional data periodically in tabular form into graphical form, geographic mapping, so that data can be easier to read and more interactive [10]. The Tableau platform has the ability to connect and retrieve data from various data sources, has the ease of creating dashboards, accesses information anywhere using mobile devices and can export data analysis results [11].
Tableau combines SQL on databases with a descriptive language to create graphs and creates a database visualization language called VizQL [12]. The version used by the author is Tableu Public which is free.

C. Dashboard and Data Visualization
Dashboard and data visualization are terms to help organizations, companies, people or individuals understand the significance and connectivity of data, by placing transactional data that was originally in tabular form into a visual form [13]. Dashboards and data visualization have become an integral and inseparable part in the world of business intelligence, and are increasingly needed in managing case studies in everyday life [14].
Dashboard and data visualization aim to understand history, program, and context, analyze various forms of data, assist data collection, so that it can communicate with stakeholders. Dashboards and visualization of data in BI are also very useful for increasing the value of the librarian's work, as well as providing additional, more detailed and in-depth knowledge of the work to the librarian [15].

D. ETL (Extract, Tranform and Load)
Extraction, Transformation and Loading (ETL) is the process of extracting, transforming and loading data from a variety of data sources, where the main function of ETL is to transform data from several data sources into useful strategic information [16]. This process consists of Extraction, Transformation, Loading, and several processes that are carried out before being published to the data warehouse. So, ETL or extract, transform, loading is the data processing phase from the data source into the data warehouse. The purpose of ETL is to collect, filter, process and combine relevant data from various sources to be stored in a data warehouse. ETL can also be used to integrate data [8].
1. Dimensional Modeling A popular data model for the data warehouse is the multidimensional model. Some of the well-known concepts of data warehouse modeling in multidimensional models are star schema, snowflake and fact constellation schema [17].

Staging Data
Not all data from data sources will be used, only data that supports the information needed by the user will be used. The place to select the necessary information and prepare the data for further processing to the data warehouse is the staging area and the data is called staging data [18].

Business Intelligence Roadmap
The Business Intelligence Roadmap is divided into 2 methods, namely the analysis method and the design method [19]. The explanation of the Business Intelligence Roadmap is as follows: 1. Justification The first step should be seen as the progress of Business Intelligence. The research carried out is to analyze the data contained in PT Global Bintan Permata and then understand similar research journals.

Planning
This stage develops a BI project plan that will be designed which will then select the data sources to be used and the tools they need.

Business Analysis
This stage examines additional detailed information to gain an inside and outside understanding of existing information sources, data requirements for information sources, and expands the logical data model..

Design
This stage, the data warehouse planning is completed through the creation of a data warehouse consisting of a fact table and a dimension table. Then the ETL configuration as an outline of the implementation of the role in the ETL process that will be carried out following the data warehouse plan.

Construction
This stage is the construction of a data warehouse on the xampp database, the ETL process for each dimension table and fact table and the application of the Tableau tools in making dashboard visualization reports.

Report
This stage, the preparation of the final report from start to finish is carried out by combining ideas.

E. Nine-step Technology
According to Ralph Kimball, quoted from the journal Ganda Wijaya [20], known as the nine-step design methodology that is carried out systematically, it can build a good data warehouse. The following is an overview of the nine steps, namely: 1. Choose The Process, which is to be more specific in choosing the interactions that determine the main subject. The main subject is in organizational business exercises that can answer very significant business questions. 2. Choose the Grain, which is to find out what the fact table will cover. Next define the dimension table  associated with the fact table. Specifying items in the fact table also defines items in the dimension table. For this situation, Grain can be obtained from the exchange of information. 3. Identify and Conform the Dimensions, which is to be more specific the most common way to distinguish and relate dimension tables to fact tables. Dimensions are various perspectives that are important to describe a reality. 4. Choose the Facts, which is Grain selection from the fact table to find out which facts can be used. At this stage, decide on the actions to be used and required in the fact table. 5. Store Pre calculations in the Fact Table, in this stage the consequences of calculating a trait are viewed as stored in the data set. This is valuable for reducing errors in the program when calculating this quality. 6. Round Out the Dimension Tables, on the dimensions that have been identified then a drawing is made containing organized data about the characteristics of the dimension table. The dimension table is made to make sense in depth so that it is effectively known by the user. 7. Choose the Durations of the Database, The selection of the information period to be placed into the information is still determined at this stage. For example, organizational information for more than one year or more is retrieved and placed into a fact table. 8. Determine the Need to Track Slowly Changing Dimensions, which is dimensions can go through slow changes and become problems. There are three basic types of slow layered changes, specifically fixing a changed characteristic, creating another record in a dimension, or creating a optional property to retain another value. 9. Decide Physical Design, At this stage, do the physical design of the data warehouse. In addition, determine the problems that might occur in the physical design of the data warehouse.

III. RESULTS
The source of the data was obtained from PT Global Bintan Permata, the data was in the form of transaction data from January 2021 to December 2021 and marketing data on PT Global Bintan Permata.
Transaction and marketing data in xls format with a total of 2 files with a total of as many (transaction data) and 4 (marketing data) records data. bit-Tech, 2023, 6 (1), 43

A. Data Warehouse Visualization
In part This containing explanation about analysis to data visualization through appearance chart or table related to transaction data and marketing data.    December 3,193,520. Appearance sales trend information can seen as in Fig. 3. Fig. 3 Visualization of Sales Trends c) Regional Information Result of visualization This is display regional information or any area _ sale This done . Appearance regional information can be seen as in Fig. 4.

Fig. 4 Regional Visualization d) Information Regional Sales
Result of visualization This is displays information How level regional sales in 2021 in each the month . Appearance information regional sales can seen as in Fig. 5.  f) maps Result of visualization This is displays regional mapping against sale product . Featured through openstreetmap . Appearance visualization this regional map can seen as in Fig. 8.

B. Visualization on the Marketing Dashboard
Visualization This produce various type the information displayed in form graphs and tables. Following is results from visualization with use the Tableau application. a) Sales Information Result of visualization This is displays sales information such as sales name and sales code respectively. Appearance visualization sales information can seen like Fig. 9. Result of visualization This is displays information magnitude profit from sales on each sales with add customer dimension or the name of the customer handled by each sales and display time in form month from january to December . Appearance visualization information profit sales sales can seen as in Fig.11.

IV. CONCLUSIONS
Based on results application Tableau app for do visualization of data owned by PT Global Bintan Permata in processing transaction data and marketing that started with the Extract, Transform and Load (ETL) process up to making dashboard visualization then can concluded that : 1. Business intelligence development in manage data with using Tableau has produce good information _ in form visualization graphics , text and tables. 2. The resulting dashboard containing information in form the data visualization it consists of from transaction and marketing data in 2021. Dashboard give information For know How development sale Good product and sales are also developing transactions with customers in 2021 later will become base in taking decision. 3. Management of PT Global Bintan capable apply business intelligence dashboard-based for more easy in produce Transaction data reports are also capable help in analyze problem , take right decision _ as well as enhancement quality and service