The analytics module developed for the
fashion industry incorporates the following needs for the end clients:
·
Consolidation of data from
various sources such as spreadsheets and other relational databases.
·
Need of the end client to have
a consolidated overview from various retail channels such as Retail sales,
consignee sales, showroom sales.
·
Flexibility for analysis of the
fashion data across various parameters: client, description of the module,
style, size and color. The end clients are also looking at analysis across
various date/time granularities such as year, year quarter and year month.
The module developed for the fashion
industry enables the end clients to do the analysis across any levels of hierarchy.
It enables the following:
·
Develop custom KPIs at any
level of snapshot(date/time and garment granularity)
·
Enable data consolidation
across multiple data sources
·
Flexibility in doing analysis
across various views
The value proposition for the product comes
as follows:
The benefit matrix of the product for the
end client is as follows:
· The product is looking at ease of
deployment, ease of delivery, ease of maintenance.
The grid matrix for percentage calculation is as
follows:
·
· Based on the 2(two) measures quantity and
value the end client should get at least 30 KPIs for percentages across various
levels of date/time and product hierarchies.
Attached are the first set of views for the
end client:
Consolidated dashboard: this view entails
the comprehensive overview of metrics and KPIs after the consolidation has been
completed. The following are the key tenets for the consolidated dashboard:
·
The view is independent of time
·
The view is independent of date
Client view for value by year:
In the above view, we are looking at 2(two)
separate measures quantity and sales.
In the attached dashboard,
The above is client analysis by fiscal
years.
The
above module is the percentage client break up for a given fiscal year.
Thus the team has taken care of percentage
snapshots at various levels of hierarchies.
Client View for Total Value
By Year:
Client View
for Total Quantity By Year:
Client View For Value By Quarter:
Client View
For Total Quantity By Quarter:
Apoorv Chaturvedi: support@mndatasolutions.com;support@turbodaatatool.com
Phone:+91-8802466356
Website; https://mn-business-intelligence-india.business.site/
