Industry: Investment Management
Function: Wealth Management, Financial/Investment Advisory, Asset Management, Tax Planning, Estate Planning & Wealth transfer Service, Retirement Planning, Succession Planning Services, Fund/Portfolio Management Services, Real Estate Advantage Portfolio.
Firm needs to consolidate data from multiple systems, different sources and present it in an easy to understand format
Meristem Wealth had a variety of ERP’s that is used to capture and store Customer Data, Transactions, Investment Deals, Market Share activities.
Aggregate financial data, Customer Data Profiling and making it consistent and usable
Optimize the process of analyzing financial data on managed funds and funds under management.
Meristem deployed Qlik BI to monitor market and counterparty risk analysis for different Funds and assets
Leverage on Qlik BI to Aggregate data from multiple sources of data such as ERP, CRM
Using Qlik BI, Meristem created applications to generate reports, ease data analysis, and focus actions on sensitive data
With Qlik BI, Meristem created Applications to enable them achieve;
Financial Analysis: Provides dashboards and ad-hoc analysis; Analysis of funds and their composition; Analysis of deviation between funds and their benchmarks; Analysis of ex-post performance and risk indicators; Analysis of ex-ante risk indicators.
Executive Analysis: Assess via dashboards and monthly reports key financial metrics across funds, performance, deviations, and risk.
Benefits for Meristem Wealth Limited
+ Achieved considerable time savings for report generation and management analysis
+ Improve the overall quality of the analyses and reports produced and Ensuring data accuracy
+ Greater understanding of what is happening across the firm’s activities
+ Reports are now be instantly updated
+ Aggregated Information from disparate source systems, Saving time in data extraction
+ Provide instant access to necessary financial details of transactions, financial status and balances for top management.