Mertel Insurance is implementing a Microsoft® SQL Server® database that will track customer information, policy information, and transaction histories. The biggest concern is providing access to the information each team needs. Sales representatives need to access customer information to better serve their clients. Claims representatives must access policy information to determine coverage. Supervisors would like to access transaction histories to monitor employee performance. Compliance officers often must gather different and varied information for various regulatory agencies. Mertel executives want to monitor key metrics stored in the database to gauge company performance.What methods do you recommend that Mertel Insurance use to retrieve information from its databases? Will you use a custom application or a more generic tool such as SAP® BusinessObjects™ or Microsoft Excel? Would a team of analysts be in charge of running reports and distributing the information? Will the same approach work for all the users? Defend your recommendation.
Mertel Insurance is implementing a Microsoft® SQL Server®
For Mertel Insurance to retrieve information from its SQL Server database, It is using a combination of methods. Here the
methods are:
Custom application:
A custom application can be developed specifically for Mertel Insurance that provides access to the data based on the
specific needs of each team. For example, the custom application can provide an interface for sales representatives to
access customer information, while providing a separate interface for claims representatives to access policy
information.
Business Intelligence tools:
Tools such as SAP BusinessObjects or Microsoft Excel can be used to retrieve, analyze and present data in a meaningful
way. These tools can provide pre-built dashboards, reports and data visualization to support the needs of different
teams.
Report distribution:
A team of analysts can be in charge of running reports and distributing the information to the relevant teams. This
approach ensures that data is accurate, up-to-date and properly analyzed before being presented to the teams.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
