Dashboard For Daily Order Processing Statistics
About Client
Our client is a technology-driven medical and industrial gas company in the US that utilizes a network business model to manage the gas supply chain.
Business Challenges
The process of generating Daily order processing statistics was manual. The Client’s IT Team pulled data on a daily basis and created reports which consumed a lot of time and effort. The team used to share Excel reports via email to their internal team to see high level status related to their customers. In the absence of the IT resource, the team was unable to see reports.
Venture7 Solutions/Engagement Model
We have automated their manual report by creating a Dashboard that represents data in the form of graphs against the different KPIs. Further, we have extended the report functionality by adding the following on the Dashboard:
- Show all high level stats: # of orders, # of Invoice and # of cases generated by their customers on each day
- The trend of high level metrics for the past 30 days
- Historical Invoice and Incidents
- Order Revenue Trends
- Order Counts by Time Period
- Ordering Method Trends
- Digital Journey Customers List
- MD&A Inbound Order Stats
Tools & Technology
-
SQL Server
-
Tableau Desktop
-
Tableau Online
Key Benefits/ Value Delivered
- Viewing robust data from various sources in a single place
- Easy access to all their customers’ stats on a daily basis
- 100% accurate report as no human intervention
- Easy process to store all historical data
- Real time report availability