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.

Business Challenge

Client has an online learning platform that enables users such as Developers, IT Professionals etc. to learn courses for free, in a self-paced manner. The content publishing team wanted to study differences in usage behaviour of highly or poorly engaged users. Knowledge of user behaviour helps to devise strategies and implement actions that will drive higher content consumption.

Approach

• TurnB devised a metric termed consumption that quantifies user engagement.
• Identified a group of users who signed up in the same time frame which was done to obtain an unbiased analysis.
• Brainstormed and identified an exhaustive list of factors and framed hypothesis to study inherent differences in behaviour of high and low consumption consumers.
• Computed Consumption at a user level and segmented the user base into groups.
• Extracted data for all factors and performed inter segment and intra segment study of factors.

Implications

• The client flagged off a campaign, on subsequent days of signup that improved % of users re-visiting the platform.
• Short videos were introduced for multiple courses which improved course fields.