Tag Archives: Microsoft Sql Server 2005

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 about Powell Electronics

With BizTalk Server 2006, we can perform as if we were a number one, two, or three company in our industry. That puts us on a level playing field.
Bob Oldrati, Controller and IT Director, Powell Electronics.

Situation: Powell Electronics assembles and distributes electronic components for use in equipment that is manufactured by other companies. Founded in 1946, the company is still owned by the Powell family. Including its New Jersey headquarters, Powell has 12 offices in North America, South America, and Europe, as well as Israel and China. Although the firm is relatively small (with 240 employees in 2007), its value-added services and precisely customized solutions have won Powell ongoing business relationships with major players in the aerospace and defense industries, including Caterpillar, Lockheed Martin, and Boeing…

Solution: Powell Electronics selected Activ Technologies—a Microsoft® Gold Certified Partner specializing in supply-chain infrastructure development—to help design a business process management (BPM) solution that would include the following components:

>Microsoft BizTalk® Server 2006 R2 to serve as the solution’s foundation,
>Microsoft SQL Server® 2005 database software to provide the BPM message storage,
>The Microsoft Visual Studio® 2005 development system to support custom programming,
>Microsoft Office SharePoint® Server 2007 to provide the user interface…
Click here discover more about Powell Electronics

Register to mark your Comments

Case Study of LendingTree LLC

Business Challenge: LendingTree is a relatively young and profitable company progressing at a rapid pace in a highly competitive, very dynamic economic environment. As the company matures, the need for tracking and measuring results becomes increasingly important in order to maintain the company’s competitive advantage. Lei Fu , Vice President of Business Applications summarizes by saying, “we are striving for quicker access to information that the business can act upon.” The Information Services team targeted two fundamental segments of the business, Operations and Sales, for their phase I implementation of the Microsoft and Decision Support Panel (DSP) Business Intelligence (BI) Solution…

Solution: Business Applications and Information Services looked at possible solutions considering both cost and effectiveness. LendingTree implemented a Microsoft solution that included Decision Support Panel’s DSP Portal Edition BI Portal Solution. The products included are as follows: Microsoft SQL Server 2005, SQL Server 2005 Analysis Services, SQL Server 2005 Integration Services, Microsoft SharePoint Portal Server 2003, Microsoft Office PerformancePoint Server 2007 and DSP Portal Edition 4.3, as well as, Microsoft Windows Server 2003 and Microsoft Office Professional Edition 2003. The Microsoft/DSP solution provides LendingTree with a secure, reliable BI platform. The DSP Portal and customizable Web Parts compliment Microsoft SharePoint Portal Server and enable LendingTree to leverage its existing Intranet portal…
Click here to view further information about LendingTree LLC

Register to mark your Comments

Case Study on Visuales Caribe

Situation: Puerto Rico’s credit unions play a significant role in the lives of their customers. Members of these credit unions are considered part owners, and ownership brings with it considerable security and a sense of belonging. The country’s credit unions range in size and have diverse clientele—urban credit unions typically have many offices to serve professionals in the country’s major cities, while rural credit unions have fewer branches but count tens of thousands of farmers and small business owners as clients. The majority of credit union members in Puerto Rico are over the age of 50…

Solution: Involvement in Microsoft early adoption programs helped Visuales Caribe to see the potential of new tools available in Windows Vista, such as the Windows Presentation Foundation, and innovative development tools like the Microsoft® .NET 3.0 Framework. Confident that these tools would help to create a more intelligent and user-friendly solution in less time, Visuales Caribe quickly made the decision to build its application on the Windows Vista platform.The development team at Visuales Caribe built its credit union operations software for use on Windows Vista, and based the solution on Microsoft technologies including Windows Server® 2003, Microsoft SQL Server™ 2005, Microsoft Office SharePoint® Server 2007, Microsoft Exchange Server 2007, and the 2007 Microsoft Office system…
Click here to view further for Visuales Caribe

Register to mark your Comments

Case Study on Autodrome

Situation: Vehicle dealerships operate in a low-margin market, requiring them to optimise business processes and maximise operational efficiency. With ever-diminishing loyalty among consumers, dealerships compete on price and on the quality of their customer service. In the face of these challenges, leading Dutch dealership Autodrome is using the latest technologies to streamline its operations. The company, which sells 12 brands of cars and commercial vehicles from six locations in the north of the Netherlands, also offers vehicle repairs and fleet rental services…

Solution: To address its operational challenges, Autodrome decided to deploy RPMcar BackOffice, a reporting, analytics, and dashboard tool that optimises the car sales and delivery process and gives insight into what is happening in the dealership. The RPMcar BackOffice solution is based on a Microsoft® infrastructure, including Windows Server® 2003 operating system, Microsoft SQL Server® 2005 database software, and the 2007 Microsoft Office system. Sandra van Leeuwen, Strategic Alliance Manager at RPMcar, says:…
Continue reading..

Register to mark your Comments

Case Study on MAXIMUS

Life is easier for everyone if the information from these different systems can be united in a single repository, and that’s what we’ve done with SQL Server.”
Nora Paape, Vice President of the Educational Services Division, MAXIMUS.

Situation: For more than 30 years, MAXIMUS has been committed to its mission of “Helping Government Serve the People.” The company’s 5,500 employees located in more than 280 offices in the United States, Canada, and Australia, provide services to a spectrum of government organizations including some 2,000 school districts, 300 courts, 100 colleges and universities, and 80 airports. The MAXIMUS Web-based TIENET application suite is valued by school districts because it provides a direct connection between curriculum and assessment for individual and groups of students in both regular and special education…

Solution: Building upon Microsoft® SQL Server™ 2005 database software, and other elements of the Microsoft Application Platform, MAXIMUS has created a BI data mart integration solution for its TIENET users. Data mart information is aggregated into multidimensional cubes for faster online transaction processing (OLAP) queries, using SQL Server 2005 Analysis Services, the OLAP component in SQL Server. The solution runs on the Windows Server® 2003 Enterprise Edition operating system. The company chose to create an OLAP data mart, rather than expand upon reporting already offered in the TIENET OLTP solution, for a number of reasons, including the need to not slow the OLTP production database by running OLAP queries against it…
Click here to view more about MAXIMUS

Register to mark your Comments

Case Study on TDIndustries

Situation: TDIndustries is a premier specialty construction and building services firm based in Dallas, Texas. Owned by its 1,500 employees, TDIndustries has a unique corporate culture—every employee is a partner and no offices have doors—and has ranked among Fortune magazine’s “100 Best Companies to Work For” over the past 10 years. In 2006, TDIndustries brought in U.S.$247 million, the bulk of which came from construction projects focusing on HVAC (Heating, Ventilation, and Air Conditioning), plumbing, high-purity piping, building automation, and refrigeration systems…

Solution: Today, roughly 500 TDIndustries employees use Microsoft Dynamics SL 6.5, with about 150 concurrent users at any given time. In addition to financial management, Project Series, and Service Series modules, TDIndustries recently deployed the Microsoft Dynamics SL Bill-of-Materials, Work Order, and Inventory modules for its manufacturing operation. Working with Microsoft Gold Certified Partner Artis Consulting, TDIndustries rolled out a new business intelligence (BI) solution based on Microsoft Dynamics SL and Microsoft SQL Server™ 2005…
Click here to find out more about TDIndustries

Register to mark your Comments

Brand Loyalty : L’Oréal going CRM’s way

A case study from Microsoft that tells how L’Oréal strengthened the Brand Loyalty with aid from the Customer Relationship Management Solution.
L’Oréal, the world’s largest skin care and cosmetics company, wanted to broaden the scope of marketing for its luxury products division. It decided to implement a company-wide customer relationship management (CRM) system, starting with a pilot project in South Korea. Working with Siebel—and advised on architecture by Microsoft® Services—L’Oréal standardised on Siebel CRM and Analytics software running on Windows Server® 2003 and a Microsoft SQL Server™ 2005 database. The CRM solution has helped boost customer loyalty and reduce churn. As a result of more accurate targeting, the volume of direct mail has been cut by as much as 57 per cent for a single promotion, with a 62 per cent response rate. L’Oréal now has a consistent view of customers across all marketing channels….click here to read ahead

Register to mark your comments