BusinessQlik for Fashion Retail

BusinessQlik for Fashion Retail is the BI system of the business analysis for retail networks of fashionable fashion BI business intelligence clothes.

BusinessQlik for Fashion Retail (2016)

The Business-Qlik for Fashion Retail application provides expanded analytics on wholesale and retail sales, cards of loyalty and merchandising, with an opportunity to trace lifecycle of the separate article. The Business-Qlik for Fashion Retail application includes about 150 different analytical indicators and considers turnover of goods, accomplishment of the sales plan by brands and commodity groups, conversion, seasonality of demand and cost efficiency of sales. In addition to standard applications for advanced analysts, the flexible report which includes all possible indicators on sales and merchandising with a possibility of independent creation of visualization is developed.

Solution tasks

• Provide category managers with the convenient analytical tool for the purposes of analytics of sales.
• Provide company management with reliable and operational information on sales.
• Eliminate need of report generation manually.
• Eliminate temporary logs in obtaining information by the management and operational employees.
• Create the analytical solutions exceeding the existing reports on functionality and high-speed performance: (ratings of shops, actions, complex LFL analysis, connection of plans forecasts).

Features of the solution

• The analysis on four sales channels – retail, wholesale, franchizing, the Internet trade.
• Combination of the analysis by parameters of outlets – the canal, the territory, a brand, discount, age.
• The analysis by a fashion - brands, seasons, collections, the nomenclature.
• The analysis on final sales and shipments, with returns without returns, including VAT and excluding VAT.
• The analysis of franchizing on two types of the franchisee with different conditions - a consignment, shipment, sale.
• Condition monitoring of warehouses of shops of the franchisee.
• Complex contrastive analysis (LFL - YTD/MTD) – revenue, units of production, the average price, marginality, checks, passability, on one shop.
• Connection of specially developed calendar of LFL, for correct carrying out contrastive analysis.
• Connection of sales plans in Eksel.
• Connection of analytics of attendance of Rstat shops, conversion calculation.
• The complex analysis of markdowns by 14 parameters and 4 indicators.

Functionality

Plan fact

• The combined plan-fact contrastive analysis (YTD/MTD), by channels and shops, with a possibility of disclosure of indicators in dynamics on days.

KPI

• More expanded, combined plan-fact and contrastive analysis (YTD/MTD) by channels and shops, on indicators of revenue, quantity of the sold goods, loadings of shops, the average price, indicators on one shop, marginalities, checks, conversion.

Range

• The plan-faktno-forecast analysis of sales on brands and commodity groups on not efficiently for a month.

Shops

• The analysis of sales of shops on commodity groups, in the ratio with age and a format of shop on the range, with the layout in dynamics on the periods about one day.
• A configurator of ratings of shops, with a possibility of the free choice

Actions

• Tracking of markdowns in dynamics by dates of a markdown, on types of markdowns, on indicators of sales in piece, rub, percent and the amounts of markdowns, cost value, marginality.
• The choice of number of comparable days to a markdown and later.
• Forecasting of implementation of a remaining balance in comparison to efficiency of price actions.

Contrastive analysis

• The analysis in comparison on two periods, on indicators of sales and marginality in 26 measurements.

Geography of network

• Display of parameters of geography of retail network on indicators of sales.

Users of the application

• Top managers - the CEO, the Commercial director, the Chief financial officer.
• Operational workers – Analysts, Category and Brand managers.