Tag Archives: data warehouse

Case Study for Relacom

Today we generate our KPIs on a daily basis. Prior to deploying Analysis Services, back when we created them by cutting and pasting, we only updated our KPIs on a monthly basis.
– Ake Soderberg, Operational Project Manager, Relacom.

With more than 15,000 employees operating in 17 countries, Relacom provides managed services for wired and wireless networks. To accommodate its growth, the company needed a more robust and flexible business intelligence (BI) data warehouse, which had been hosted using Oracle and the UNIX operating system. The company migrated its BI data warehouse to Microsoft SQL Server 2005 Enterprise Edition (64-bit) database software running on Windows Server 2003 Enterprise Edition for 64-Bit Systems…

Situation: Relacom, headquartered in Stockholm, Sweden, provides a range of data and telecommunication network services—from construction services, to equipment installation, to network maintenance—serving customers through its operations in 17 countries around the world. The 15,000 employees of Relacom provide managed services to customers ranging from private sector and government network owners to businesses and consumers. Servicing both wired and wireless networks, Relacom provides preventative and corrective maintenance services…
Click here to learn more about Relacom

Register to mark your Comments


Case Study of Barnes and Noble Inc

Barnes & Noble, the world’s largest bookseller, operates 821 stores in 50 states. To help improve its business operations and respond better to customer needs, the company needed new business intelligence tools that could access information faster and provide more detailed reports to managers. The company, which runs Oracle databases for operational systems, decided to deploy a new data warehouse using Microsoft® SQL Server™ 2005 running on an HP Integrity Superdome server equipped with Intel Itanium processors…

Situation: Barnes & Noble is the largest bookseller in the United States. As of August 2005, the company owned 821 bookstores in 50 states plus the www.bn.com online store. About 80 percent of its stores operate under the Barnes & Noble Booksellers trade name, and the company also owns and operates B. Dalton Bookseller. Through these outlets, the company offers trade books, hardcover and mass-market paperback books, magazines, computer software, and music and video titles, as well as runs in-store coffee shops. Headquartered in New York City, the publicly traded company employs about 40,000 people and reported revenues of U.S.$4.87 billion in its most recent fiscal year. Click here to read further on Barnes and Noble Inc

Register to mark your Comments

Case Study for Raiffeisen Bank Aval

Raiffeisen Bank Aval is one of the leading banks in Ukraine. It provides a wide range of standard and innovative banking services through its nationwide network. Established in 1992 as Joint Stock Postal Pension Bank Aval, in 2005 it became part of Raiffeisen Bank International. The bank’s network is comprised of 934 branches located in large cities, provincial and community centers and villages throughout Ukraine.

The history and development of Raiffeisen Bank Aval’s data warehouse spans 12 years. In 1998, the bank’s IT team was asked to consolidate information from disparate operating systems in order to enable consolidated financial reporting. In those days, solving such problems did not require specialized software. Instead the first data warehouse at the bank was based on a traditional database, Sybase Adaptive Server Enterprise (ASE). This data warehouse was later enhanced, and is still an integral part of the bank’s overall information management system. It is currently used to generate daily analytics reports for the National Bank of Ukraine and consolidated tax accounting.

View more on Raiffeisen Bank Aval

[youtube http://www.youtube.com/watch?v=rlPmM8Gsg_c&w=560&h=315]

Register to mark your Comments

Case Study on Lyttelton Port Company

As the major deep-water port in the South Island, LPC offers a full array of shipping services, handling over nine million tonnes of containerised cargo, bulk products and imported vehicles annually from over 1,200 visiting vessels. Multiple and complex source systems needed to be consolidated into a data warehouse as a first step on a business intelligence path.

Supported by a staff of over 400 in operational, management and administrative roles, LPC’s challenge was to bring the many mechanisms and systems that supported different reporting and analysis tasks together into one centralised and consolidated framework, thereby empowering managers with improved, accurate information for decision making. Click here to read more…

Register to mark your Comments

Case Study on Capital & Coast District Health Board

Capital & Coast District Health Board (C&C DHB) wanted more affordable and detailed business intelligence (BI). To achieve this goal, C&C DHB replaced its previous BI solution with a new one based on the Microsoft SQL Server Fast Track Data Warehouse and the HP Business Decision Appliance. In just 12 months, C&C DHB transformed its BI capabilities, cut software costs by about 50 percent, and improved insight, efficiency, and agility. Click here to read more…

Register to mark your Comments

Case Study: Laurentian Bank of Canada

Founded in 1846, Laurentian Bank of Canada is a Quebec banking institution operating across Canada, dedicated to meeting the financial needs of its clients through the excellence of service, simplicity and proximity. It needed to provide branch employees with the information needed to successfully run their businesses. It deployed Business Intelligence (BI) solution incorporating a data warehouse, fast Web access to information for reporting and analysis, and scorecarding for the management team. Click here to read more…

Register to mark your Comments

Case Study on Jobsite

Strategy: Each candidate’s profile is personal and different and the task of ensuring candidates are only alerted to relevant vacancies and Jobsite Career Tools is made yet more complicated in that candidates might be registered with, and identify with, one of several hundred Jobsite brands and partnerships. Using an in-house developed email marketing tool was a laborious, time consuming and resource-hungry process. Deep segmentation and finely tuned targeting and personalisation was impossible and opening rates and customer loyalty were being impacted.

Implementation: Neolane provides conversational marketing technology that enables organisations to build and sustain lifetime one-to-one dialogues. “We were able to run our first campaigns on the platform just four weeks from commencing implementation,” said Vince Keay, email and database marketing manager at Jobsite. “Our own and Neolane’s team worked well together; Neolane not only brought product implementation expertise, but supported linking to our single customer view data warehouse.” Today, as well as highly targeted job alerts, marketing campaigns include event-driven relationship emails and core newsletter campaigns offering tips as well as promoting Jobsite Career Tools…
Click here to view further about Jobsite

Case Study on Anglia Support Partnership

If you want to create a better National Health Service with less money… you need to put the right information in front of the right people. A BI solution based on SQL Server 2012 helps us do that in a managed, straightforward, and intuitive way.
Jeremy Lane. Data Warehouse Manager, Anglia Support Partnership.

Business Needs: Anglia Support Partnership (ASP) is the leading provider of support services to healthcare organizations in eastern England, including general practitioners, primary care trusts, and National Health Service (NHS) trusts. A business division of the NHS, the support group focuses on helping healthcare organizations improve efficiency and cut costs. With new healthcare reforms taking effect, ASP wanted better BI tools to support healthcare commissioning processes…

Solution: ASP turned to Ascribe, a Microsoft partner with a gold competency in business intelligence, to help design a centralized BI platform with self-service tools based on Microsoft SQL Server 2012 data management software. Ascribe provides IT solutions to healthcare organizations worldwide, and has worked with more than 70 NHS trusts. ASP decided to implement the Ascribe Commissioner Accelerator data warehouse and BI solution with Microsoft SQL Server 2012 Enterprise. The Ascribe platform provides the contracting and budgetary information required in the commissioning process. ASP wanted enhanced BI tools and a database solution it could rely on… Find out more on Anglia Support Partnership

Register to mark your Comments

Case Study on Integrated Customs Duty and Tax System

Abstract: Integrated Customs Duty and Tax System. This submission describes a programme to support the implementation of an Integrated Customs Duty and Tax System for the Polish Customs. The programme comprises several discrete projects, covering such activities as: ZEFIR: Budget Accounting and Tax/Customs Settlement System and CELINA: Declaration Processing System which included Validation and Risk Analysis Modules, Reference Data Sub-system, Data Warehouse and Customs Government Gateway. Click here to read more on..

Register to mark your Comments

Case Study about Scandinavian Airlines

Senior executives at Scandinavian Airlines (SAS) have implemented a new data warehouse based on Microsoft and Intel technology, replacing the aging IBM DB2 mainframe solution that had been supporting business analysts.

Business Needs: To operate effectively, Scandinavian Airlines (SAS) manages large volumes of operational and customer data. Historically, an IBM DB2 information management solution supported all data warehousing, but this became expensive and difficult to manage and could no longer provide timely access to data. As a result, the company wanted a new information management environment that could:…
For more information on Scandinavian Airlines click here

Register to mark your Comments