Microsoft BI powers Sales Analysis to report in runtime on top Three items on Amount/Quantity basis with Invoice level details

Microsoft BI powers Sales Analysis to report in runtime on top Three items on Amount/Quantity basis with Invoice level details

Posted by

Microsoft BI powers Sales Analysis to report in runtime on top Three items on Amount/Quantity basis with Invoice level details

Microsoft BI powers Sales Analysis to report in runtime on top Three items on Amount

This report has been developed with many salient features which have great impact in Sales and Inventory analysis for one our client.

  • Identify the top 3 products on the basis of Amount and Quantity.
  • Calculate the percentage of each product for total purchase against Amount/Quantity.
  • User can provide the Date range for which top 3 products will be found.
  • User can select any customer in the list. Wildcard search has been implemented on the list to enhance search functionality.
  • Each record against Amount/Quantity has drill down functionality. The drill down report shows Amount/Quantity against all products in Agreement/Non-Agreement category. Invoice level details are shown in last drill down report.
  • Report is available on desktops and mobile devices which enhances its remote accessibility.
The following two tabs change content below.
Abubakr Asif

Abubakr Asif

President at Panni
Abubakr has over ten years of experience implementing business solutions in the Calgary Energy marketplace. His experience spans implementing of ERP systems, workflow and systems integration and Business Intelligence solutions. He started his own company, Panni, in 2009, which help companies automate their business processes by leveraging the Microsoft based Toolset such as SharePoint and BizTalk. Since 2009, the company has grown at a rate of more than 100% every year. Abubakr has a undergraduate in engineering as well as an MBA from the University of Victoria. Previous to founding Panni, he was working for a big four consulting firm in Calgary.

Leave a Reply