Business
Challenge:

  • The client is a Fortune 50 multinational technology giant & the worldwide leader in software, services and solutions.
  • They have a learning group within the organization that is responsible for designing, creating & driving sales of training assets related to their technology products in the market.
  • The client runs a subsidy program for its Partners to promote the sales of their learning products.
    • Client’s BI engineering team needed support in identifying the key metrices and finalize the logic to calculate these metrices.
    • Conduct UAT to ensure there is no errors in dashboard numbers and logics are properly implemented.

TurnB Approach

Metric Design

Conducted multiple brainstorming sessions with stakeholders and finalized the critical metrics required for leadership team to track the rhythm of business.

Logic Building

Listed down all key business rules that would impact the logic formulation for decided key metrics.

Listed down multiple business scenarios that should be considered.

Helped BI team in devising the appropriate logic to calculate the metrics covering all business rules in place and multiple business scenarios

UAT

Conducted a full-fledged UAT on the developed dashboard.

Identified multiple discrepancies in dashboard numbers; deep dived and found the root cause; pointed out errors in logic building and exception handling.

Implications

Dynamic BI dashboard provided a holistic view of business to key stakeholders.

Multiple enhancements and logic updates carried out over time catering to dynamic business requirements: updated metrics and visualizations based on changing KPIs and business objectives.