Overview

Log Workspaces is a powerful tool for analyzing and monitoring financial transactions and system performance. This feature enables you to use SQL queries and visualizations to gain valuable insights into your operations and make data-driven decisions to improve performance and efficiency.

Benefits

Using Log Workspaces in the finance industry offers several benefits:

• Real-time monitoring: Track financial transactions and system performance in real time
• Issue identification: Quickly identify and diagnose technical and business-related issues
• Performance analysis: Analyze trends and patterns to optimize processes
• Reporting and auditing: Generate reports for compliance and auditing purposes

This guide demonstrates how to use Log Workspaces with an example focusing on credit card details and bill payment processing.

Understanding the data

The example in this guide focuses on two key functions within the finance industry:

• Credit Card Details: Processing and managing credit card transactions.
• Bill Payment: Processing bill payments.

For each function, the following metrics are tracked:

• Total Count: The total number of requests
• Success: The number of successful requests
• Business Failed: The number of requests that failed due to business-related issues
• Technical Failed: The number of requests that failed due to technical issues
• TechFail %: The percentage of technical failures

Bringing in your data source and building your queries

Create a workspace and add a data source. In this example, credit cards and bill payments each have three data source cells, each filtering to the logs that are relevant to the analysis. For instructions on how to create a workspace and bring in your data source, see Log Workspaces.

With the data from your credit card and bill payment data sources, you can create an Analysis cell using SQL to calculate and compare key metrics for both processes. This analysis helps you track success rates, identify failure patterns, and monitor performance trends.

SQL query analysis

Query purpose and structure

This query uses a UNION to combine key metrics for two financial processes (Credit Card Details and Bill Payment) into a single comparative view, making it easier to analyze performance across both functions.

(
    SELECT 'CreditCard Details' AS "Function",
        (totalcount - businesscount - techcount) AS "Success",
        businesscount AS "Business Failed",
        techcount AS "Technical Failed",
        totalcount AS "Total",
        (100 * techcount / totalcount) AS "TechFail %"
    FROM (
            SELECT COUNT(DISTINCT creditcards_totalrequest.requestId) as totalcount,
                COUNT(DISTINCT creditcards_technicalunsuccessful.requestId) AS techcount,
                COUNT(DISTINCT creditcards_businessunsuccessful.requestId) AS businesscount
            FROM creditcards_totalrequest
                FULL JOIN creditcards_technicalunsuccessful ON creditcards_totalrequest.requestId = creditcards_technicalunsuccessful.requestId
                FULL JOIN creditcards_businessunsuccessful ON creditcards_totalrequest.requestId = creditcards_businessunsuccessful.requestId
        )
)
UNION
(
    SELECT 'Bill Payment' AS "Function",
        successcount AS "Success",
        businesscount AS "Business Failed",
        (totalcount - successcount - businesscount) AS "Technical Failed",
        totalcount AS "Total",
        (100 * (totalcount - successcount - businesscount) / totalcount) AS "TechFail %"
    FROM (
            SELECT COUNT(DISTINCT bill_totalrequest.requestId) as totalcount,
                COUNT(DISTINCT bill_successfulrequest.requestId) AS successcount,
                COUNT(DISTINCT bill_businessunsuccessfulrequest.requestId) AS businesscount
            FROM bill_totalrequest
                FULL JOIN bill_successfulrequest ON bill_totalrequest.requestId = bill_successfulrequest.requestId
                FULL JOIN bill_businessunsuccessfulrequest ON bill_totalrequest.requestId = bill_businessunsuccessfulrequest.requestId
        )
)
ORDER BY Total DESC

SELECT 'CreditCard Details' AS "Function",
    (totalcount - businesscount - techcount) AS "Success",
    businesscount AS "Business Failed",
    techcount AS "Technical Failed",
    totalcount AS "Total",
    (100 * techcount / totalcount) AS "TechFail %"
FROM (
        SELECT COUNT(DISTINCT creditcards_totalrequest.requestId) as totalcount,
            COUNT(DISTINCT creditcards_technicalunsuccessful.requestId) AS techcount,
            COUNT(DISTINCT creditcards_businessunsuccessful.requestId) AS businesscount
        FROM creditcards_totalrequest
            FULL JOIN creditcards_technicalunsuccessful ON creditcards_totalrequest.requestId = creditcards_technicalunsuccessful.requestId
            FULL JOIN creditcards_businessunsuccessful ON creditcards_totalrequest.requestId = creditcards_businessunsuccessful.requestId
    )

SELECT 'Bill Payment' AS "Function",
    successcount AS "Success",
    businesscount AS "Business Failed",
    (totalcount - successcount - businesscount) AS "Technical Failed",
    totalcount AS "Total",
    (100 * (totalcount - successcount - businesscount) / totalcount) AS "TechFail %"
FROM (
        SELECT COUNT(DISTINCT bill_totalrequest.requestId) as totalcount,
            COUNT(DISTINCT bill_successfulrequest.requestId) AS successcount,
            COUNT(DISTINCT bill_businessunsuccessfulrequest.requestId) AS businesscount
        FROM bill_totalrequest
            FULL JOIN bill_successfulrequest ON bill_totalrequest.requestId = bill_successfulrequest.requestId
            FULL JOIN bill_businessunsuccessfulrequest ON bill_totalrequest.requestId = bill_businessunsuccessfulrequest.requestId
    )

Query output

The query from the Analysis cell populates a table, allowing for easy comparison of each function’s performance. By analyzing this data, you can identify areas for improvement, such as reducing technical failures or resolving business process issues.

The following is a sample of what you might see from running the SQL analysis:

Visualizing the data

Finally, paint a clear picture by visualizing your data. Log Workspaces offers several visualization options, including:

• Tables
• Toplists
• Timeseries
• Treemaps
• Pie charts
• Scatterplots

Filter your datasets by status, environment, and other variables to focus on specific aspects of your data. Financial institutions gain valuable insights through these visualizations. Use them to identify trends in transaction processing, troubleshoot issues across payment systems, make data-driven decisions to improve system reliability, and enhance customer experience by reducing technical failures.

For more information, see Log Workspaces - Visualization cell. These visualization capabilities provide a powerful way to transform raw transaction data into actionable intelligence for your financial operations.

Further reading

お役に立つドキュメント、リンクや記事:

Learn more about Log WorkspacesDOCUMENTATION