2024 JITI-23-01-15-2551-Tirta+Pratama-OK
2024 JITI-23-01-15-2551-Tirta+Pratama-OK
2024 JITI-23-01-15-2551-Tirta+Pratama-OK
Keywords: waterfall, google data studio, dashboard, business intelligence, management information system
151
Jayadinata et al./ Development of Performance Monitoring Dashboard … JITI, Vol.23(1), Jun 2024, 151-161
in features for point-and-click data visualization monitoring performance, the top management
and analysis. These so-called management user ends up making decisions ineffectively, which
interfaces have boosted the number of users for reduces its competitiveness in relation to rivals.
BI systems and provided whole new information Therefore, this research attempts to provide a BI
management paradigms, like self-service BI. dashboard to help businesses monitor and
Meanwhile, the phrase "enterprise evaluate the performance of their critical
dashboard" is used by (Malik, 2005) to refer to a operations effectively and efficiently. This
computer interface that displays several charts, research is crucial for BI solutions through the
reports, visual indicators, and alarm systems on a development of a BI Dashboard for the
dynamic and pertinent platform. While (Orts, organization, particularly in the operations
2005) used the word "dashboard" to describe a department.
tool used to regularly monitor an organization.
Decision-makers may obtain data that can be II. RESEARCH METHOD
used to actively steer business performance by The waterfall methodology was chosen as
seeing Key Performance Indicators (KPIs) in a the approach for this research. Each activity will
single interface. A group of indicators known as be thoroughly described, along with a list of
key performance indicators (KPI) concentrate on
required tools. Dr. Winston W. Royce was the
the aspects of organizational performance that pioneer in introducing the waterfall methodology
are most important to the success of an as the inaugural approach in the software
organization (Parmenter, 2015). There is a helpful development lifecycle (SDLC) (Powell-Morse,
acronym for summarizing the fundamental 2016).The waterfall methodology, according to
features of an organizational dashboard, i.e., (Sherman, 2014), uses a sequential or linear
IMPACT (Interactive, More data history,
approach to software development. The project is
Personalized, Analytical, Collaborative, broken up into tasks, with phases being the
Trackability) and SMART (Synergetic, Monitor, highest-level grouping. A proper waterfall
Accurate, Responsive, Timely) (Malik, 2005). approach requires phases to be finished in order
Operational dashboards, tactical dashboards, and and to have clear exit criteria, frequently a project
strategic dashboards are the three categories into stakeholder sign-off. In the waterfall
which dashboards may be categorized based on
methodology, a necessity exists for thorough
the level of management they provide (Eckerson, definition and precise documentation, which
2006; Few, 2006). serves to prevent misunderstandings and
A great tool for producing attractive and communication gaps (Calvello, 2021). The
understandable data visualizations is Google Data waterfall methodology adheres to a
Studio (Snipes, 2018). As part of Google's predetermined sequence of stages, which can
premium Analytics360 package, Google Data result in the creation of anticipated timelines and
Studio was introduced in May 2016 and is a user-
guarantee the project's punctual completion (Van
friendly tool for presenting complicated data sets Der Merwe, 2017). The waterfall methodology
in an engaging and understandable way (Snipes, may be a suitable option for intricate projects
2018). characterized by clearly outlined requirements
PT. MPM is the case study for this research. It and unchanging timelines (Van Der Merwe, 2017).
is one firm that is interested in using BI solutions (Utami et al., 2023) used waterfall methodology
to enhance its operational performance. They are
for developing Yogyakarta web-based food recipe
a regional producer of packaging based in application and based on the test results using a
Indonesia, providing a wide range of products. An black box, the system created has functional
efficient and strong information system is crucial, features according to what is expected. SDLC
and BI solutions may be used to do this. waterfall methodology also used in development
Due to the lack of a suitable application of project management system and it can support
and/or system for properly assessing and
152
Jurnal Ilmiah Teknik Industri p-ISSN 1412-6869 e-ISSN 2460-4038
153
Jayadinata et al./ Development of Performance Monitoring Dashboard … JITI, Vol.23(1), Jun 2024, 151-161
satisfaction. Alpha testing, in the form of user the assigned staff engage in a comprehensive
acceptability testing, is important to identify any review and adjustment of prevailing production
issues and flaws that a system might have before levels to optimize efficiency. This planning also
the finished system is distributed to the users. involves a retrospective analysis of historical sales
Beta testing, which is carried out by a specific data, inventory availability, and insights from the
group of actual users of the program, is another production division manager. Every quarter, PT.
type of acceptance testing. Since it is the highest MPM undertakes aggregate and material
degree of testing, it is carried out in a real or planning. Aggregate planning, a facility-wide
operational setting. The software is sent to a small strategy, is adopted to enhance resource
number of outside participants or users for this allocation, considering various factors such as
type of testing, and they offer their opinions on changes in customer orders. This approach
the system's layout, usability, and overall quality. contributes to the optimization of resource
After Alpha and Beta testing, the assessment utilization despite fluctuations in specialized
procedure will be carried out. If the evaluation product demand. Its production system also
step is unsuccessful, the procedure will restart at operates as a form of specialized mass
the development stage. If favorable, the manufacturing. Multiple workstations are
corporation may fully employ the suggested BI strategically positioned, and the assembly line
dashboard to begin evaluating and tracking the cycles through each of them. Work at these
performance of its main operations. stations follows a specialized workflow, with each
station accountable for specific tasks.
III. RESULT AND DISCUSSION
Conceptual Model
PT. MPM undertakes both mass production
To portray the conceptual model, a data flow
and customized job orders, spanning retail
diagram will be employed in this study. In this
packaging, consumables, and shipping supplies. It
investigation, two data flow diagrams will be
typically receives sales forecasts in three formats –
generated: data flow diagram (DFD) level 0 and
annual, quarterly, and monthly – from its clientele.
DFD 1. Positioned at the highest level, DFD level 0
When these projections reach the organization,
154
Jurnal Ilmiah Teknik Industri p-ISSN 1412-6869 e-ISSN 2460-4038
155
Jayadinata et al./ Development of Performance Monitoring Dashboard … JITI, Vol.23(1), Jun 2024, 151-161
Development of BI Dashboard
Figure 5. Production Data Warehouse
The outcome of this research will yield the
sales performance dashboard and the production
Division, and Production Period. Output data performance dashboard. It’s important to note
requirements are also produced by the sales and that the data exhibited in the forthcoming
production performance analysis information dashboard are not authentic due to the
systems. company’s confidentiality. The sales performance
Modeling a data warehouse constitutes a dashboard, which is depicted in Figure 6, enables
pivotal phase in the creation of a business the company's senior management to assess
intelligence (BI) dashboard, as it grants the sales performance and evaluate if it satisfies its
developer the ability to depict the KPIs. The user of a BI dashboard may examine the
interconnections among data repositories. Figure variation in addition to comparing the accuracy of
the anticipated value to the actual value. The
initial portion of the dashboard's design is seen in
156
Jurnal Ilmiah Teknik Industri p-ISSN 1412-6869 e-ISSN 2460-4038
Figure 6 section A. The control chart, from which dashboard, along with the name of the
the user may choose the required data depending dashboard and the firm.
on the date range, quarter, customer ID, and The second phase of the dashboard design is
product category, is presented at the top of the seen in Figure 6 section B. Two pie charts are
included in this section where the user may learn
157
Jayadinata et al./ Development of Performance Monitoring Dashboard … JITI, Vol.23(1), Jun 2024, 151-161
more about how well the company's clients and used to display the data in a pivot table. The color
goods are performing. The computation may of each cell indicates its rank, the darker the hue,
consider both the volume of goods sold and the the higher the rank, and vice versa. The user may
income made. The ultimate section of the sales also choose the pivot table's display style using
performance dashboard, illustrated in Figure 6 the expand-collapse function.
Section C, entails a comparison between the
company's projected and realized values. The Testing and Evaluation
table on the left adopts a heatmap format, with After the system is created, it must be tested;
each cell's hue indicating its performance ranking; in this study, both alpha and beta testing are
brighter colors signify lower rankings and vice done. The alpha testing has multiple aims: to
versa. Conversely, the right side features a combo ascertain that all the system's features and
chart, permitting users to contrast more than two functions work as intended, to see if the system
datasets simultaneously. satisfies the specifications outlined at the start of
Figure 7 depicts the production performance the development process, to determine whether
dashboard, the secondary dashboard created. the proposed system satisfies the system
This dashboard furnishes the company's upper requirements and to evaluate the system's
management with the capability to scrutinize the features and operations. The functioning of the
Overall Equipment Effectiveness (OEE) across each system will be tested in a system environment by
production line within the company. Beyond the using the list of system functions. The results of
OEE figure, users can delve into the analysis of the alpha testing are displayed on Table 1.
machine-specific aspects. Moreover, the Table 1 shows that with all eight functions
company's senior management can conduct an passing the alpha testing, the beta testing phase
evaluation of the production department’s can be conducted. In the beta testing process,
productivity by contrasting the projected there were several PT. MPM stakeholders that
production count against the actual production participated. The user is supposed to use the
count. system to find flaws or mistakes while using it,
The initial segment of the design is and then submit comments to the developer as a
illustrated in Figure 7 section A. Positioned in the guide to enhance the proposed system. This beta
dashboard's header are both the dashboard's testing will also be termed a UAT (User
name and the company's name. This is followed Acceptance Test). The researcher created a survey
by a control chart, facilitating user selection of to gather feedback after the system's user testing.
specific desired data through certain options. The The five criteria that will be assessed are
second element of the production performance perceived satisfaction and usefulness, technical
dashboard is shown in Figure 7 section B. The system quality, information quality, service
gauge chart at the top of this section is used to quality, and perceived satisfaction.
illustrate the OEE (Overall Equipment Five PT. MPM stakeholders tested the
Effectiveness) factors, which comprise product proposed business BI dashboard. Users of the
ratio (performance), time ratio (availability), and dashboard were selected from the operations,
quality ratio (quality). The difference in output production, finance, and president and director of
between planned and reality is then depicted in a the business. A six-point Likert scale with a rating
bar chart. The anticipated production number and from strongly disagree (scale 1) to strongly agree
the actual production number for a certain time (scale 6) is used to rate each statement in the
are summarized in the two scorecards to the right questionnaire.
of this paragraph. The last element of the Based on the overview presented on Table 2,
production performance dashboard is shown in the mean score for beta testing of the proposed
Figure 7 section C. The company's top BI dashboard system tallies to 4.9 or 82 percent,
management may evaluate each machine's OEE signifying a satisfactory outcome. The most
(Overall Equipment Effectiveness). A heatmap is elevated score emerges from perceived
158
Jurnal Ilmiah Teknik Industri p-ISSN 1412-6869 e-ISSN 2460-4038
Total Total
Criteria Indicator Score
Score Score %
Technical System Quality System User Friendliness 5.2
Usefulness of features provided 5 5.1 84%
BI Dashboard Availability 5
Information Quality Information Completeness 4.8
Information Accessibility 4.4
Information Clarity and Understandability 4.2 4.7 78%
Information Relevancy 4.6
BI Dashboard Interface Quality 5.4
Service Quality Instruction Clarity 4.8
Quality of Service Provided 4.6 4.7 78%
Responsiveness and Cooperation 4.6
Perceived Satisfaction & BI Dashboard Performance Satisfaction 5.2
Usefulness BI Dashboard assist user perceive information 5.2
5.2 86%
BI Dashboard assist user in decision making process 5
BI Dashboard Usefulness 5.2
Average Score 4.88 4.9 82%
159
Jayadinata et al./ Development of Performance Monitoring Dashboard … JITI, Vol.23(1), Jun 2024, 151-161
implying some challenges in users other divisions like finance, buying, and logistics.
comprehending the information displayed by the Secondly, the enterprise resource planning (ERP)
system. This challenge could be attributed to the system should be installed so that all
need for users to adapt to the novel system, a departmental data may be connected into one
process that is expected to become smoother as system for the BI dashboard network to function
familiarity with the system increases. successfully. The company can expand the use of
the BI dashboard to other departments. In
Implementation addition, it is recommended to the company that
Both alpha and beta tests show that the for the BI dashboard network to operate
system has successfully satisfied all the system's effectively, the ERP system needs to be
success criteria. Because of this, the proposed BI implemented, so that all department data can be
dashboard is currently at the implementation integrated into one system.
stage, where the firm may fully exploit the usage References
of the BI dashboard to gauge and keep an eye on Boell, S. K., & Cecez-Kecmanovic, D. (2015). What is an
the efficiency of its main operations. information system? 2015 48th Hawaii International
Conference on System Sciences, 4959–4968.
Calvello, M. (2021). Waterfall methodology: How to use
IV. CONCLUSION it for your next big project. In G2-Business Software
The sales performance dashboard and the Reviews. https://www.g2.com/articles/waterfall-
production performance dashboard are two methodology
developed BI dashboards that are included in the Eckerson, W. (2006). Deploying dashboards and
current research. The waterfall methodology, scorecards. The Data Warehouse Institute, 1–24.
Few, S. (2006). Information dashboard design: The
which consists of six stages: analysis, requirement,
effective visual communication of data. O’Reilly
design, development, testing, and
Media, Inc.
implementation, was used for developing the BI Gilad, B., & Gilad, T. (1988). The business intelligence
dashboard. Google Data Studio was used as the system: a new tool for competitive advantage. (No
dashboard development tool; as a result, it is a Title).
web-based dashboard that users can access from Hanief, A., Pratama, A. T., & Awibowo, S. (2020). Project
any computer with an internet connection. The Management System Development for Improving
proposed BI dashboard is approved and complies Infinitigroup Project Performance. Proceedings of
with system criteria. The technology may now be the 2021 International Conference on Engineering
and Information Technology for Sustainable
fully exploited and integrated into the business
Industry, 1–6.
operations of the organization. Alpha and beta
Hostmann, B., Rayner, N., & Herschel, G. (2009).
testing have also been conducted on the Gartner’s business intelligence, analytics and
suggested BI dashboard system, and the performance management framework. Gartner
dashboard system passed both. The technical Research Note.
system quality, the information quality, the service Lee, A. S. (2010). Retrospect and prospect: information
quality, and the perceived satisfaction and systems research in the last and next 25 years.
usefulness were the four criteria used in the Journal of Information Technology, 25(4), 336–348.
design of beta testing questionnaire. The Lin, Y.-H., Tsai, K.-M., Shiang, W.-J., Kuo, T.-C., & Tsai,
C.-H. (2009). Research on using ANP to establish a
participants expressed satisfaction and agreement
performance assessment model for business
with the suggested BI dashboard, as evidenced by
intelligence systems. Expert Systems with
the average score of 4.9 or 82%. Applications, 36(2), 4135–4146.
Based on the evaluation of the research Lu, M. (2014). Discovering Microsoft Self-service BI
findings, several recommendations are made for solution: Power BI.
the business, future research, and enhancements Malik, S. (2005). Enterprise dashboards: design and best
to the BI dashboard. Firstly, the organization may practices for IT. John Wiley \& Sons.
utilize the business intelligence dashboard in Nyblom, M., Behrami, J., Nikkilä, T., & Solberg Søilen, K.
(2012). An evaluation of Business Intelligence
160
Jurnal Ilmiah Teknik Industri p-ISSN 1412-6869 e-ISSN 2460-4038
161