Fraser Mercantile’s FM Analytics
Delivers customized end-to-end data analytics capabilities to provide transparent, iterative, and actionable reporting and analysis solutions.
Who we are
Multi-disciplined consultancy, with extensive experience in business and risk intelligence, data analytics, report solutioning, capital demand and credit risk methodologies, frameworks and analytical systems development, and business analysis.
Mission
Build strong, cross-functional and collaborative business relationships, to successfully develop strategic projects and deliver scalable data-driven solutions to meet, and exceed, customers expectations.
Tailored Solutions
Empowering Your Financial Journey
offerings
As a means to improve reporting and analytical efficiencies, Fraser Mercantile offers customized risk intelligence and data analytics solutions to perform ongoing data exploration, automate and enhance existing processes, and to build new frameworks. Business intelligence platforms provide secure, interactive and automated reporting solutions, aid in fulsome results analysis, and garner actionable insights.
Key highlights of offerings
Data project planning and design including development lifecycle overview and conceptual approach to inform build opportunities, track responsibilities and deliverables, and determine model design with transparent review and approval process
Exploratory data analytics (EDA) performed on data sources through extract, transform and load (ETL) processes allowing for profile analysis and reporting, cleaning and transformation, and data change management, without affecting underlying sources
Reports and dashboards builds with BI tools, providing for automated and interactive visualizations, user collaboration, story telling, AI based insights, and a Q&A interface for deep-dive analyses and presentations
Development of parameters, indices and variables allow for seamless period-over-period updating with straight-forward maintenance (i.e. referencing)
Reports and dashboards are published to secure online service portal for end users’ ease of access and ensures data integrity, use specific contrasting, and golden source reporting
Dashboards and reports may be filtered at user level or customized for specific user / group view
Data Project Planning and Design
Life-cycle and Conceptual Approach
The conceptual approach, performs data analysis and develops proof-of-concept model(s) to communicate capabilities and strategize on enhancing reporting metrics, while developing data analytics processes in parallel.
Entity Relationship Diagram
Development of ERDs to conceptualize data and process flows to ensure completeness in requirements gathering, uncover challenges in design phase, and provide templates for testing and deployment.
Exploratory Data Analytics (EDA)
Leveraging business intelligence platforms (i.e. Power BI) perform analytics to identify data anomalies, deficiencies, and patterns; transform source data post extraction; and report all finding and results of analytics.
EDA Highlights
Source data (warehouse) remains unaltered with downstream data actions fully transparent for audit function
Data extractions are user defined based on Data Warehouse normalization schema
Ongoing profiling data provides transparent analysis of data quality, profile, distribution and dispersion characteristics and data element relationships
Data transformation and cleaning of profiled data creating a single golden and data integrity
Data Change Report records all transformations (auditable back to source) performed on pre-loaded data
Exploratory analysis is completed on configured data to identify patterns, trends, relationships, and correlations elucidating potential business challenges and opportunities
Report and Dashboard Builds
Development of automated, transparent, interactive, and reusable visualization tools to analyze trends, identify key drivers to explain changes, and provide actionable insights to decision makers. Deliverables include: periodic reporting and stress / sensitivity testing with descriptive and diagnostic assessments, granular risk-profile analysis, portfolio return metrics, and credit loss analysis.
Credit Risk Capital Report
Tableau
Global CO2 Emissions
contact us
STILL NOT SURE?
Frequently Asked Questions
Everything You Need to Know About Us
What specific data analytics services does Fraser Mercantile offer?
FML provides full Business Intelligence and data analytics services. This includes, data transformation, and cleaning, descriptive, diagnostic and predictive analysis, parameter, metric and KPI development, data visualizations and interactive report and dashboard builds.
Does FML specialize in any particular data analytics tools or technologies? If so, which ones?
While we can develop reporting solutions in several business intelligence platforms, we specialize in Power BI and Tableau.
What differentiates your data analytics services from competitors in the market?
Beyond the data analytics services, we have over 2 decades of methodology development, and reporting and analysis for Financial Institutions, spanning Enterprise, Credit and Climate risks. We have worked and collaborated with both business and technology partners to deliver value add and transparent data-driven solutions.
Can you describe a recent project that showcases your company's capabilities?
We recently developed a conceptual end-to-end data analytics risk management solution for a vertically integrated retail operation providing the entity with the ability to perform four functions:
Exploratory data analytics
Data analysis with references and parameterization
Visualizations with period specific reports and dashboards including driver analysis
Sensitivity testing and forecasting
What size of companies do you typically work with?
We have worked with very large institutions (billions $ in assets) to smaller independent operators.
What common pain points or challenges do your ideal clients typically face?
The largest common pain point is data. Typically, their data is:
In a very rough state, requiring formatting, cleaning and transformation
Denormalized, making analysis very inefficient
A mystery, where the client simply does not know what they have and what to do with it
What technical infrastructure or data maturity level should potential clients have?
This is really dependent on the client size. While we have worked with clients who maintain data in spreadsheets, we would recommend organizations should have, at a minimum, a database solution (i.e. SQL Server), but this is also an area for discussion to potentially be improved upon.
What initial low-commitment engagement options do you offer for new clients to experience your
services?
For a short term (i.e. 4-week) engagement, FML can develop a customized and interactive report and dashboard package through data importing. This would be fully transparent, secure, and internet accessible by the client, across both desktop and mobile devices. Further, this may be maintained and updated under a monthly service contract.