Client Description

The Gap, Inc. is an international specialty retailer operating retail and outlet stores. The Company sells casual apparel, accessories, and personal care products for men, women, and children. The Gap operates stores in the United States, Canada, the United Kingdom, France, Ireland, and Japan.

The firm operates about 3,200 stores worldwide, including 450-plus franchise stores across Asia, Australia, Eastern Europe, Latin America, the Middle East and Africa.The company sell its products in more than 90 countries.  Gap has built its iconic casual brand on basics for men, women, and children, but over the years has expanded through the urban chic chain Banana Republic, family budgeteer Old Navy, and Athleta, a purveyor of activewear. Other brand extensions include GapBody, GapKids, GapFit, GapMaternity, and babyGap; each also has its own online incarnation. All Gap clothing is private-label merchandise made exclusively for the company. From the design board to store displays, Gap controls all aspects of its trademark casual look.

Gap’s Old Navy brand, a lower budget version of the Gap brand, is its biggest earner at about 45% of total sales. The Gap brand itself brings in 35% of sales, followed by upmarket Banana Republic with more than 15%.

Gap has three other brands besides: Athleta, a range of activewear; Intermix, a designerwear brand; and Weddington Way, a wedding clothing store.


The Gap wanted to retire a legacy data mart, named Mars, which had sales, inventory, promotions, and plan data.  They wanted an independent, technology-agnostic partner, who would help them craft a durable strategy, that would scale, with positive ROI.


iOLAP  carried out the evaluation of business benefit compared to cost involved, requirements gathering, mapping, design, develop, testing, deployment & warranty support.  As usual, the entire project was based on agile methodology.   iOLAP built new semantic tables to meet the reporting needs and retrofitted outbound extracts.


The major highlight of this project was the PUB/SUB architecture, which reduced the load on Teradata, and thus resulted in savings of millions of dollars for The Gap.

  • Tools: MicroStrategy | PowerBI | Teradata
  • Categories: Big Data, Strategy, Analytics
  • Tags: Retail