Chat with us, powered by LiveChat

Improving data quality and data reporting

A Microstrategy Case Study
Let's talk
This leading bill payment service provider facilitates fast and secure bill payments for Australian consumers. Supported by over 150 banks and credit unions nationally, its reach spans 95 percent of the consumer banking market. Processing an average of 1.5 million transactions each day, reliable reporting capabilities are fundamental to this organisation – particularly in relation to safeguarding against fraud.  This case study explores the design and implementation of new reporting capabilities. 

The Challenge

For some time, our client had relied on MicroStrategy data analytics and visualisation tools for reporting. While the in-house reporting team were able to maintain existing reports, they lacked the tool-specific skills and experience to build new dashboards and visualisations. This meant they had a limited ability to quickly and easily report on important parts of the business such as fraud and transactions processed through member institutions.  

In the event of a new reporting request, the team were dependent on manual, time-intensive workarounds, such as exporting MicroStrategy data to Microsoft Excel. This approach was vulnerable to data inconsistencies, resulting from a lack of standardisation in reporting as well as human error. With multiple data sources, there was no single source of truth for key data points. This presented a risk for the client, as it complicated the detection of fraud and other unacceptable activities within the business.  

The Solution

We were engaged to design and implement new reporting capabilities, enabling our client to build a rich and reliable picture of its business operations. As the organisation already had a data warehouse in place to provide the critical infrastructure for transaction reporting, we focused on building a robust, flexible and easy-to-use business intelligence capability with a focus on front-end design.

To minimise implementation challenges and maximise the value of the client’s prior investment in both software and staff training, we designed a solution that leveraged MicroStrategy, which was a familiar tool across the client’s business. The project was conducted in two phases to progressively build new capabilities for fraud reporting (phase one) and member reporting (phase two).  

Phase 1: Fraud reporting 

In phase one, we worked closely with client business representatives to fully understand their key fraud risks, as well as the necessary indicators to predict and identify instances of fraud. The team then developed a suite of interactive dashboards to paint a complete picture of potential fraud activity in the business.  

The report set includes fraud reports, breach reports and industry benchmarks and trends, with both interactive and printable versions available. The reports are designed to be analysed and interrogated within the MicroStrategy platform, enabling users to drill down to underlying data and interpret cases without needing to conduct manual analyses in Excel. In doing so, the project has significantly improved the client’s ability to monitor and detect fraud across its business.  

Phase 2: Member reporting 

In phase two, we assisted the client in increasing visibility over payments with member institutions, which includes some of Australia’s largest banks and financial institutions. The client needed to understand the size, volumes and trends in relation to members’ transactions, as well as registration activity.

Our team built new reporting capabilities to make such information readily accessible, leveraging the same database as the fraud reporting project for compatibility and ease-of-use. The reports provide extensive activity summaries using both point-in-time and trend data. Additionally, the reports present information at multiple levels of granularity, with the ability to focus on single member institutions, select groups or all institutions in a single view.  

As a result of these new reporting capabilities, the client has a much stronger ability to identify trends in the market and proactively manage potential risks or issues across the industry

Results

The implementation of new business intelligence and reporting capabilities has yielded significant benefits for our client:

  • The quality and reliability of reporting data has significantly increased for fraud and member reporting, as the reporting team is no longer dependent on manual Excel-based workarounds.  
  • The use of a flexible, automated and fit-for-purpose tool means that reporting is faster and less cumbersome for analysts.  
  • Senior management have increased confidence in reporting data and an improved their ability to make timely decisions in response to issues and risks.  
  • The inclusion of industry data and benchmarks within the reporting suite has improved the client’s ability to understand, analyse and proactively engage with the market.  

As a result of this project’s success, the organisation plans to engage Analytics8 to build additional dashboards and reporting capabilities across both fraud reporting and member reporting. 

Let’s Talk.

Analytics8 is an Australian-based analytics, business intelligence and data warehousing consultancy founded in 2002. Our vendor-agnostic team of 60+ consultants has deep expertise and implementation experience. We specialise in design, development and deployment of effective data solutions. 
enquiries@analytics8.com.au

Sydney: +61 2 9299 4430

Melbourne: +61 3 8605 4880

  • This field is for validation purposes and should be left unchanged.

Sydney:

Level 4

350 Kent Street,

Sydney, NSW, 2000

+61 2 9299 4430

Melbourne:

Level 8,

350 Collins Street,

Melbourne, VIC, 3000

+61 3 8605 4880

Not based in Australia? Our team in the UK or the US would be happy to help.