This page has not been updated recently.
We have kept it, within the OnWindows Archive, for your reference.

Retail and Hospitality

Case Study:

BI comes into fashion

Apranga Group is now able to analyse sales and inventory in a single BI system

Apranga Group, the leading fashion retailer in the Baltic States, has contracted Microsoft partner New Vision to implement its business intelligence solution based on ProfitBase and Microsoft SQL Server.

Apranga Group currently operates 71 stores in Lithuania, 21 in Latvia and seven in Estonia. The company was experiencing a challenge in selecting a single standardised business intelligence (BI) platform. A short implementation time was a top priority, as Apranga had a very strict deadline. The ability to modify and extend the deployed BI solution easily was another important requirement.

“Market conditions evolve rapidly, the business has to follow,” says Valerijus Budiak, IT manager at Apranga Group. “A rapid development tool for BI is a necessity nowadays.”

Following an extensive evaluation process, Apranga Group contracted Microsoft partner New Vision to implement its business intelligence solution which uses Microsoft SQL Server. This BI solution is based on Association for Retail Technology Standards (ARTS) templates from ProfitBase. The templates enabled Apranga to kick-start the BI solution rapidly, saving time on analysis and implementation, minimising risks and reducing costs. New Vision’s competence in Microsoft Dynamics NAV combined with data connectors from ProfitBase saved a lot of effort loading a data warehouse. Integrating historic legacy data sources was easy and the customer had an Online Analytical Processing (OLAP) system finished in only two and a half months.

Following the implementation of the BI solution, Apranga Group is able to analyse sales and inventory in a single BI system using SQL Server Reporting Services and Office Excel Pivot Tables tools. Previously the same data was analysed by several different reporting and BI systems.

The standardised BI solution at Apranga Group now covers all stores and chains it operates and contains nine years of historic data. The solution has become a central point of information for many employees. The company is planning to extend the BI solution with new functionality according to their business needs.

This article first appeared in the spring 2009 edition of Retailspeak magazine.

Please login/register to add your comments

Review comments:

There are currently no comments on this article



Prime focuses on Microsoft technology in manufacturing, exploring issues from PLM and the supply chain, to plant floor visibility and lean manufacturing.


Finance on Windows is Microsoft’s quarterly enterprise customer magazine for the financial services sector, covering banking, capital markets and insurance.


Speak provides a quarterly digest of news, features and case studies focusing on challenges faced by retail, hospitality and consumer-focused businesses.


Touch is the latest addition to the suite of Microsoft industry publications and the new authority on public sector activity within the EMEA region.

Financial Services Global Outlook 2012-2015

The Financial Services Global Outlook 2012-2015 is an essential resource for those looking to identify solution providers in banking, insurance and capital markets.

Prime Partner Guide 2010/11

The Manufacturing & Resources Global Outlook 2012-2015 is a leading authority on Windows-based solution providers in the manufacturing and resources sectors.

Distribution and Services Global Outlook

The Distribution and Services Global Outlook is a yearly publication that profiles Microsoft technology partners in the retail, consumer goods and services industries.

Public Sector Global Outlook

The annual Public Sector Global Outlook is an invaluable resource for companies in the sector seeking to leverage their investment in Microsoft solutions.

Communications Sector Partner Guide EMEA 2010

The Communications Sector Partner Guide is Microsoft’s official printed directory of partners serving the EMEA communications sector.

Keep up with OnWindows


To find out more about advertisement opportunities online and in our suite of Microsoft industry magazines visit the Partner Zone