Page 316 - DMGT303_BANKING_AND_INSURANCE

Unit 14: Marine and Motor Insurance

Notes
In addition, not all Heungkuk departments could conduct data management and business
intelligence (BI) activities. Only planning or finance employees could perform analysis,
so managers and decision makers in other departments had to request reports and often
waited several days before receiving them.
"We realized that if we spent two years developing our next-generation core banking
system before taking steps to improve our enterprise data platform, we might fall behind
our competitors," says Woo.
Heungkuk wanted a mission-critical enterprise solution that would centralize the
company's data and provide self-service BI tools for all employees.
Solution
After reviewing technologies from Oracle, IBM, and SAP, Heungkuk decided to deploy a
data warehouse and BI solution based on Microsoft SQL Server 2008 R2 data management
software.
"Out of all the solutions we evaluated, the Microsoft proposal offered the most user-
friendly approach," says Woo. "Also, with a Microsoft solution, we saw that we could
comply with regulatory data-security requirements without having to purchase a third-
party solution." Heungkuk worked with its IT infrastructure partner, INBREIN, to develop
and deploy the new solution.

To speed deployment, Heungkuk used Microsoft SQL Server Fast Track Data Warehouse,
a set of reference architectures based on best practices for data management and optimized
for specific hardware components. To reduce systems-integration delays and further
decrease the project's time-to-market, Heungkuk selected an enterprise data warehouse
appliance from HP.
In addition to SQL Server 2008 R2, the new solution includes Microsoft SharePoint Server
2010. With the data compression capabilities of SQL Server 2008 R2, the solution can scale
up to 48 terabytes. Transparent data encryption helps Heungkuk protect data and log files,
easing compliance with regulations without requiring any changes to applications.

The solution loads data from the company's line-of-business applications into one central
data warehouse. Employees in all departments can use familiar Microsoft Excel spreadsheet
software to perform analysis on this data and create visual representations of the results.
Users who need to perform more complex analysis have access to Microsoft SQL Server
PowerPivot for Microsoft Excel, with which they can analyze hundreds of millions of
rows of data on their desktops. Users can share the results of their analysis in a SharePoint
Server 2010 portal, all without any assistance from the IT department.
Heungkuk is also planning to deploy Microsoft SQL Server 2008 R2 StreamInsight to
support complex event-processing applications. With SQL Server 2008 R2 StreamInsight,
Heungkuk can have almost real-time access to information from a variety of data streams,
further reducing the cost and time needed for manual analysis.

Benefits
The Microsoft data warehouse and BI solution has helped Heungkuk Fire & Marine
Insurance Company provide all employees with data-analysis capabilities and speed the
delivery of key reports to decision makers. The IT department can now avoid the cost of
developing and maintaining the custom dashboards that were part of the previous solution.
Integrated security tools help the company protect its customers' privacy, and the innovative
solution strengthens the reputation of Heungkuk as an industry leader in Korea.
Provides BI Tools to All Employees Contd....

LOVELY PROFESSIONAL UNIVERSITY 311