Single source of truth with integrated data warehouse
As an integrated services platform working across international shipping routes, Navig8 worked with multiple data sources across different divisions and back-end systems. Before Tableau, each data source would be exported to Excel, and different people would put the data together for their own reporting needs. Everyone was using different Excel sheets and creating inconsistent ad hoc reports.
“It was extremely dangerous to move data around like that,” recalls Nick. “We could have had potential consequences such as misreporting and compliance issues.”
With Tableau, all of Navig8’s nine back-end systems such as their bunkering operating system, credit risk and enterprise resource planning package were integrated within a single data warehouse. Their partner Oak Consulting played an instrumental role in helping them build this data lake in Tableau, and today, all of Navig8’s business units use this data warehouse, shares Nick.
Within the past three years, the business has seen significant returns. Integrating over 200 entities from their finance package into the data warehouse has helped Navig8 eliminate the need for 400 Excel sheets and month-end finance reports, which used to take up to 20 man days of effort every month by a team of people solely working on these reports.
“With Tableau, all our financial data is available in one click, and our CFOs can get any information they want anytime.”