Resolving Data Connectivity Challenges

Case Study

About the client

A prestigious travel agency struggling with laborious manual tasks to meet the finance goals. Our aim is to enhance their finance report and provide them smart BI solutions to run their business in a very effective and smooth manner by avoiding manual tasks and increasing efficiency of results in Profit and Loss statement and Balance Sheet.

Industry

Travel management

Revenue (USD)

Million

Head Count

Employees

Countries Of Operation

US

Use case Overview

  • Create Finance Report system for in-depth financial analysis
  • Consolidate P&L statements and Balance Sheet across GL accounts
  • Enhance decision-making
  • Enhance financial performance through robust reporting capabilities
  • Developing a comprehensive solution for resource forecasting

Challenges

  • Manual referencing of GL data from Excel for creation of P&L and Balance Sheet
  • Laborious monthly update process
  • The subsequent manual sharing of reports amplifying inefficiencies
  • Time consuming report generation and sharing
  • Inappropriate resource forecasting methods

List of KPIs

Diacto created different dashboards which has the Report and Insights on Profit and Loss and Balance Sheet

by incorporating these KPIs and utilizing the Pivot tables, the dashboard enables users to gain valuable insights into the company’s revenue, net income, ticket volumes, and P&L performance. Provides capabilities to drill down into different accounts.

The visualizations and data tables provide a comprehensive view of financial data, facilitating informed decision-making and analysis. These insights support better decision-making and enable efficient financial management for the organization.

KPIs for Profit and Loss report are-

  1. Revenue current year YTD
  2. Net income current year YTD
  3. Detailed Profit and Loss statement
  4. Comparison of last vs. last to last month-
    • Revenue
    • Net operating income
    • Cost of sales
    • Other income and expenses
    • Gross margin
    • Net income

KPIs for Balance Sheet report are-

  1. Current assets
  2. Fixed assets
  3. Long tern assets
  4. Liabilities
  5. Stock holders equity
  6. Consolidated Balance Sheet with all groupings

Tools and Technologies Used

Due to the ease of access to insights on their fingertips, the Finance Team, leadership and business stakeholders benefited from this implementation.

ODBC via Workbench connector

A workbench was established to pull client’s data from Excel sheets, streamlining retrieval. This automated approach replaced manual extraction, enabling efficient data access and integration for analysis and reporting.

Governance

Using BI Governance, Diacto team cleaned the instance and removed any unwanted Datasets and Cards for creating clean environment.

Transformation using Magic ETL

DOMO's Magic ETL (Extract, Transform, Load) tool was utilized to transform the data into a format suitable for building the desired dashboards and visualizations.

Data Architecture

DIACTO helped by using a BI tool, a data management and visualization platform, brought significant enhancements to travel agency’s entire functionality The following improvements were achieved in the complete architecture:

1

Data Source

2

Data Connectors

3

Centralized Repository

4

Data Transformation

Target Audience

The target audience for these points would include:

  1. Finance Managers and Executives
  2. Financial Analysts
  3. Stakeholders and Decision-makers
  4. Finance Team
  5. Internal and External Auditors

Overall, The audience involves this travel agency’s financial management, analysis, decision-making, and auditing roles.

Solution

Enhanced Financial Insight:

Real-time reports and dashboards provided instant access to key metrics, aiding decision-making and improving financial visibility.

Time and Cost Efficiency:

BI tool's automated reporting saved time, reducing manual work, enhancing productivity and generating cost savings.

Improved Data Precision:

1.Integration lowered errors, ensuring reliable data for decision-making, analysis.

Deeper Analysis:

BI tool's drill-down capabilities enabled comprehensive financial scrutiny, aiding targeted decisions across accounts, divisions, regions, and driving improvements.

Real time data monitoring:

It offers a dynamic dashboard, instant insights, enhancing decision-making, detecting trends, and optimizing performance efficiently.

Business on portable devices:

Mobile friendly business dashboards offer seamless access, empowering users to monitor and manage vital data conveniently on the go, boosting productivity and adaptability.

Impact

Here’s how Diacto contributed to improvement of finance function:

  1. Data Integration
  2. Real-time Reporting
  3. Customizable Dashboards
  4. Report Automation
  5. Access Control and Data Privacy
  6. Automated Reporting and Alerts

Overall, BI tool improved financial reporting which lead the travel agency to enhance efficiency, accuracy and decision making.