Tableau Implementation and Operating Environment/Effects at JAL Group Companies
JAL Engineering Co., Ltd.
Faster Deployment of Airplane Breakdown Prediction Monitoring Tools and Removal of the Reliance on Specific Individuals’ Skills
“At companies throughout the JAL Group, operational improvements are being made that make good use of Tableau to contribute to the ‘Best Baton Pass’. One representative example is the accelerated deployment of airplane breakdown prediction monitoring tools and the removal of the reliance on specific individuals’ skills at JAL Engineering Co., Ltd. Kuniharu Harada is a member of the Reliability Management Group at the Systems Technology Office in the Engineering Dept. of JAL Engineering Co., Ltd. Here, he describes the issues faced by the company prior to Tableau deployment.
“We developed a model to predict airplane breakdowns using flight data and have deployed that for use in monitoring operations. Initially, we used Excel macros to implement the logic we developed, and there were only a few people who knew how to use VBA, so the work tended to be reliant on specific individuals. Design, testing, and revisions all took an extremely long time to do. Other problems were that we weren’t able to do anything complex with Excel graphs, and they were lacking both in terms of aesthetics and interactivity,” said Harada.
Implementing Tableau solved all of those problems. We reduced the number of days needed to implement logic to one-tenth of the time, from roughly ten business days to just one. Moreover, although we have implemented roughly 100 Viz, you don’t need to do any scripting to use Tableau, so anybody can easily maintain the Viz or change requirements.
“Ease-of-use improved dramatically, and we drastically reduced the amount of time between users making decisions based on data and taking action based on that data. In addition, the range of analysis being done has increased now that users are able to do it themselves, and the fact that it is now easier than before to identify some risks is also helping to improve the quality of our equipment,” said Harada.
Building on these results, Makoto Higashijima of the IT Digital Promotion Dept. at JAL Engineering Co. emphasizes the following.
“If all you want to do is create dashboards, anybody can do that, and they can also do it with other tools. However, Tableau enables individual people to analyze data from the specific perspective in which they’re interested and display it as-is on their dashboard, so everyone is able to look at that and compare their current work flow with the ideal work flow to engage in deeper discussions and make improvements. I think the best part of Tableau is its potential to serve as a powerful tool for making operational innovations in this way,” said Higashijima.
Training Review Planning Office, Japan Airlines Co., Ltd.
Preflight Sharing of Visualizations of Landing Routes
Meanwhile, at the Flight Operations HQ of Japan Airlines Co., Ltd., Tableau is used for preflight sharing of visualizations of landing routes at airports. Airplane landing routes for each airport are changed as necessary based on weather conditions and direction from air traffic control. This requires pilots to calculate entry paths and elevations in advance based on several patterns and share this work with other pilots on the same flight. According to Harumi Ikeshita of the Training Review Planning Office at Japan Airlines Co., Ltd., integrating Tableau into this process improved the efficiency of preparatory work, made it easier to share information thanks to visualizations, and drastically improved the accuracy of mutual understanding between operators.
”In the past, for some types of takeoff routes, individual pilots would prepare for flights by plotting routes by hand on a topographic map. This could result in some differences between individuals with respect to flight paths and elevations, and there was a risk that pilots would not notice mistakes. Moreover, since this was done by hand, it involved a lot of work. Even once finished, it was possible that an error might have been made, so it was not always easy to share one’s work with other pilots,” said Ikeshita.
Using Tableau drastically reduced the workload involved in plotting maps and making calculations. As a result, it became possible to respond more quickly and appropriately than before in situations like the Sakurajima volcano eruption of July 2022, enabling personnel to quickly create and share landing routes to Kagoshima Airport that avoided the smoke from the eruption.
“By enabling pilots to share data with each other, it is easier to check whether there are any errors in the route settings. It also establishes a shared visualization of routes between pilots of the flight ahead, enabling flights to be conducted more smoothly and precisely. Additionally, the use of, among other things, up-to-date satellite imagery to show actual structures on the route and checkpoints along the way has dramatically improved visualization and interactivity. These advancements have made it easier to get an idea of turning points, elevations, and other aspects of flights as well as to compare multiple routes to each other, all of which directly benefit flight safety.
Takeoff and Landing Routes
JAL NAVIA Co., Ltd.
Better Customer Service for Counter Users
Tableau has also proven to be a powerful tool for improving customer service. JAL Plaza is JAL’s only face-to-face counter where customers can buy flight tickets and make inquiries. At JAL NAVIA Co., Ltd., which is responsible for operating the counter, work is underway to use Tableau to improve operations. At the center of those efforts is Aya Suzuki of the General Affairs Group in the Tokyo Center JAL Plaza Business Office.
“Although we had always collected data on visitors and customer service, aggregating and analyzing that data in Excel took time and didn’t help improve the quality of customer service provided by individual staff members. After Tableau was introduced, it became possible to aggregate customer service data for all 40 staff in an instant, and we were able to conduct briefings to improve individuals’ skills based on data on specific staff members’ customer service work volume and hours. We’ve also launched initiatives to optimize personnel allocation by identifying time periods with a lot of customer traffic and matters that take a lot of time to handle, and initiatives to provide customers with the right services by understanding trends in the purposes for which people come to the Plaza,” said Suzuki.
Quantitatively, as well, it can be seen from the data on time spent handling web-related inquiries that incorporating SMS and QR into the customer service process reduced average service times by around 10 minutes; from 31 minutes and 52 seconds to 22 minutes and 29 seconds.
Safely Planning Group, Safety Promotion Dept., Japan Airlines Co., Ltd.
Improving Aviation Safety and Security Data Monitoring
At the Safety Planning Group in the Safety Promotion Dept. at Japan Airlines Co., Ltd., which is in charge of aviation safety and security for the entire JAL Group., Tableau is used to improve the monitoring of aviation security and security data. Daisuke Higaki, also in the group, said the following:
“Previously, there was a system in place for the entire JAL Group that aggregated Excel data from each department. However, it did not have statistical analysis functionality. With Tableau, now anyone can easily handle large amounts of collected data. Dashboards that have been polished based on discussions with viewer users, and the documentation thereby created, are now used in many meetings by the management council and others,” said Higaki.
For example, if a question is asked during a meeting, Tableau makes it possible to simply look at the data and respond immediately rather than postponing the answer until more research can be done, making for smoother discussions. Higaki said that was the biggest benefit to using Tableau. He continued as follows:
“Safety is the most important thing to an airline company, and in order to discover and accurately deal with risks that threaten that safety, airline companies need to try out various methods of classifying events, etc., and run through a PDCA cycle. Tableau enables faster visualization and analysis that catalyze this PDCA cycle, and that has been an extremely big step forward for us,” said Higaki.