This is what we do
FAQ
An Excel model that automatically compiles sustainability statistics was developed for JB Travel, which needed to present clear and comparable statistics to its corporate customers. The model collects data on emissions, travel, costs and booking changes, among other things, and compiles this in a professional and easy-to-use report.
Automate your reportsLearn more about our Office templates
JB Travel is a specialized business travel agency that combines personal service with modern digital solutions. The company offers customized and cost-effective travel arrangements for companies with high demands on flexibility, security and time efficiency.
Transport and Logistics
25
JB Travel collected emissions data for flights and hotels from various sources. All processing was manual, time consuming and prone to errors. In addition, they lacked an easy way to deliver customer-specific reports.
To meet customers' needs for clear travel statistics, a solution was needed that automated collection, analysis and visualization.
We built a model that automatically retrieves and processes data via PowerQuery. Using VBA, JB Travel was able to export both PDF reports with charts and Excel tables with selected customer data. The model also includes a pivot table for flexible analysis and comparison against averages.
The result is an automated process that saves time, minimizes the risk of errors and makes it easy to deliver tailored reports to customers. JB Travel can now offer its customers a quick and professional overview of travel patterns and sustainability impact - a tool that strengthens both analytical capabilities and the customer experience.
