Fashion Retail Analytics using PowerBI

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:

Please contact the following for demo:
Apoorv Chaturvedi: support@mndatasolutions.com;support@turbodaatatool.com
Phone:+91-8802466356

Website; https://mn-business-intelligence-india.business.site/

Reducing long query times through data compression and sql reduction

Nightly process completion at Afro Incorporation

Irfan, Production Manager, met Sohail(IT Head) in the meeting room.

Irfan: what happened champ? Look worried?

Sohail: It is the nightly report process that begins at 12 am. It is not completing by 9 am. Suneet(IT Manager) is asking for a new server costing Rs. 25 lakhs. Currently my SLA(service level agreement) is not been met.

Irfan: what will happen with the new server?

Sohail: will speed it up. The management is saying that there is no budget left for this year for IT.

Irfan: Now what?

Sohail: am stuck. How is it going for you?

Irfan: very nice. Since the new Japanese(Takashida) came in. He is removing the constraints in production, reducing inventory and increasing throughput. Why do you start the daily process at 12 am. Why not before?

Sohail: because complete data comes by midnight.

Irfan: say a transaction has happened at 11 am in the morning, then  as per the production team, it is in stock for 13 hours since the other data has not come. Am I correct?

Sohail: correct.

Irfan: Takashida would pre process the data immediately and remove the constraint. He would then store the same in a Work in progress area so that the final fitment is quick.

Sohail: basically work for 24 hours instead of 9 hours.

Irfan: correct. Remove the time constraint. But how would you store the work in progress output?

Sohail: I had this consulting team from M&N BI come up to me that it could store the Work in progress output in a separate database by pre processing the business logic

He gave me this link for data consolidation, datatransformation, data cleansing and even Business Intelligence from his website. The company was saying that even advanced analytics and resolving complex inventory issues should be possible by using its products.

What do you suggest?

Irfan: Let us see what Wasim(CEO) says.

An example of what his team has done for another firm is attached herewith:
http://mndatasolutionsindia.blogspot.in/2018/01/query-reductionimplementation-example.html

If you have the same problem as Sohail, contact the following

By:

Name: Apoorv Chaturvedi

Email: apoorv@mnnbi.com

Website: www.mnnbi.com

Phone: +91-8802466356