Business Challenge: The client is a leading retail giant in GCC with multiple stores and warehouses across a geography with a large portfolio spread across departments like FMCG, Electronics, Garments, Household etc. The client followed a manual siloed version of the reporting framework to track and assess the inventory level. In order to control the significant loss of sales and excess inventory levels the client approached TurnB to design and develop a real-time BI dashboard with an exhaustive view. This improved the tracking and measurement of inventory management such as stock-outs, deadstock, slow-moving, excess stock etc. TurnB Approach:

• TurnB gained clarity on data capturing mechanisms deployed at each stage of stock movement
• Performed exploratory data analysis on stock related datasets & various data discrepancies due to improper data capturing, exceptional scenarios etc. were handled
• Identified SKU inventory planning factors like current stock, active days, supplier lead days, burnout days, re-order level, stock in transit etc. and revamped the calculations based on identified factors and logics backed by inventory standard techniques like FIFO
• SKUs in the red zones like stock-outs were flagged and high-value SKUs from product categories were identified based on their revenue contribution and demand
• Designed and developed an analytical data layer at the client environment and enabled automated scheduled updates for the analytical datasets to refresh with the real-time data.
• Designed metrics to monitor and assess the current inventory level in-house or in-transit and KPIs were designed to shed light on various inventory challenges such as stock-outs, deadstock, excess stock, slow-moving etc.
• Designed and developed separate dashboard views for users at different levels – from top management to store category buyers.
• Provisions were provided to deep dive on SKU segments based on sales performance, seasonality, procurement types like central, local, overseas etc.

Implications:

• The dashboard enabled the business users and strategic planners to analyze various metrics across different dimensions and make informed decisions considering the inventory levels.
• Timely actions on top SKUs which are out of stock/ on the verge of stock out resulted in minimizing the opportunity loss.
• Exposed non- moving and excess stocked SKUs in each location and reduced the inventory levels by clearing this excess stock.
• Revamped inventory calculations enabled efficient stock replenishments through informed reordering and internal stock transfers.
• Logical calculations deployed in the reports were used in other operational areas like LPO preparations, supplier negotiation, reordering etc.

Business Challenge: The client is a Fortune 50 multinational technology giant. The client provides free training and certification programs on the latest technologies and services to its top customers. The client encourages its customers to take exams to achieve certification after undergoing training. The client and its customers want to know exam and certification status periodically to see how the program is progressing towards their annual skilling targets. TurnB Approach

• The team extracted the required data from the client’s database.
• After completing the exploratory analysis, errors were corrected.
• Key metrics were designed to evaluate the performance of customers.
• A dynamic report in Excel and PowerBI was prepared to analyze exam status from the base level.
• The reports and insights were shared with the client and customers to act on time.

Implications

• The client and its customers were able to act on time to boost up the program.
• The number of participants who attended the exams increased.
• Certification targets were attained.

 

Business Challenge

Client is a leading real-estate company in the Middle East dealing with both sales as well as leasing of properties. Client has many leasing agents, working on renting out the available units of the client and bringing in tenants. The client wanted to have a report to monitor and measure the performance of various agents.

The TurnB Approach

• TurnB identified and extracted relevant data elements from the client’s database and checked its accuracy.
• An exhaustive list of factors related to agent’s performance were identified.
• Upon identification, KPIs and metrics were designed that accurately reflects the client’s business.
• A well-formulated storyboard was drawn up for developing a dashboard to meet client’s current need.
• The pre-designed KPIs and metrics were incorporated into a Power BI dashboard which efficiently tracks the performance of various agents.

Implications

• Identified and rewarded the better performers amongst leasing agents.
• Designed a solution which helped to evaluate the under performing agents and recommended corrective measures for improvement.
• The dashboard’s timely tracking feature now enables the client to take proactive measures regarding sales and leasing.