in 6 months
in data processing
Region: EMEA
Industry: Financial Services
Department: BI/Analytics/Data Science
Company Background: Bank al Etihad is a bank offering a diverse range of personal and business banking services including bank accounts, credit cards, loans and more.
Recently named the “Most Innovative Digital Bank” in Jordan and the Middle East, Bank al Etihad strives to live up to the award. The Jordan-based financial and banking services company operates a growing network of 53 branches across the Kingdom and wanted to automate the time-consuming process of data preparation and reporting to improve performance, efficiencies, and time to market.
The business intelligence team at Bank al Etihad leverages a wide range of analytical outputs including daily, weekly and monthly KPI reports that help drive decision-making by management at the bank branches.
They faced numerous challenges using Excel spreadsheets and manual processes including time-consuming data cleansing and prep that took an average of two days per report. “We were facing many problems extracting the data because of the variety of data sources,” said Batool Madanat, Business Performance Analyst at Bank al Etihad. The team also had trouble fulfilling ad hoc requests due to the time it spent on manual ETL activities.
Bank al Etihad partnered with systems integrator Neogenesis to identify and implement a solution for data consolidation and data prep for bank reports and dashboards that are used by company management.
We wanted a solution that would save us time, reduce human error and improve accuracy.
Batool Madanat
Business Performance Analyst
Bank al Etihad
The team at Neogenesis recommended Alteryx, the analytics platform they use internally to replace Excel spreadsheets and automate reporting processes. “We talked to many vendors and researched a lot of technologies,” said Mahmoud AlQadi, Product Manager for Neogensis. “We found Alteryx to be most useful because of it’s simple interface and high processing power,” said AlQadi.
During a proof of concept phase, the BI team tested the automation process using a small set of reports to determine the best way to convert the data using Alteryx. “We work with our customer’s subject matter experts to recommend and prioritize use cases based on business needs,” said AlQadi.
The Neogenesis team then trained the BI teams to build workflows and create reports using multiple data sources including Excel, Oracle and SQL server. The integrator also guided the BI team with the strategy to best execute and finalize the technical architecture. All reports are now directed to Alteryx, where joins and advanced calculations are completed, output files sent to the correct databases and then tables created that connect to PowerBI.
Using Alteryx, Bank al Etihad automated 75% of process workflows in 6 months. By automating manual data processes, the Business Performance and Analysis team reduced processing time by 80% and improved decision-making with insights they couldn’t see before Alteryx.
Alteryx unlocks the insights that are buried in your data, so you can experience the thrill of getting to answers faster.
Mais Nsour
Data Analytics Engineer, Neogensis
By connecting tools to perform analytic processes in a workflow, Alteryx enabled the BI team at Bank al Etihad to realize the potential of what’s possible with analytics. The performance team can now plan more accurately, set more realistic deadlines, and be much better equipped to support their organization using Alteryx.
Alteryx reduces the time it takes to prep, process and analyze data by 80%
Automated analytics reduces human error and improves data quality and accuracy
Subject matter experts and non-technical users can easily perform analytics in the context of their expertise
Region: EMEA
Industry: Financial Services
Department: BI/Analytics/Data Science
Company Background: Bank al Etihad is a bank offering a diverse range of personal and business banking services including bank accounts, credit cards, loans and more.
[BLOG POST] Automated Analytics Defined: The Five Benefits of Automation
Read Morelargest banks use Alteryx
RSM US
How RSM Uses Alteryx to Decode Crypto and Blockchain Transactions
Global tax and audit firm uses Alteryx to reduce the time it takes to decode crypto and blockchain transactions from weeks to hours.
Read MoreZurich Insurance
Zurich Insurance Automates Analytics and Reporting Processes with Alteryx
Zurich Insurance uses Alteryx to automate customer analytics and financial reporting processes for deeper insights and better decision-making.
Read MoreRSM UK
RSM UK: How Sarah Belsham made her vision of Analytics for all, a reality
Learn how RSM UK’s first Data & Analytics partner, Sarah Belsham, established a data analytics innovation program to provide better client results & upskilling their audit practice.
Read More