Client background:A pioneer in providing digital solutions to powersports, recreational vehicle, and commercial truck and equipment segments
Industry: Media
Products/Services: Advanced Analytics

Data engineering and analysis augmenting dashboard intelligence

Business Challenge

  • Serve OEMs by building intelligent-rich dashboards

  • Provide intelligence encompassing consumer interests, visitor trends, dealer churn, dealer buyouts, product line additions, product line seasonality and demographic information

  • Map right datasets to various KPIs

Business Solution

  • Data exploration covering Salesforce, Omniture, google ad manager, Facebook ad manager and other application database

  • Data pipeline development for retrieving data from different sources

  • Cleansing and transformation of the sourced data

  • Data analysis for ensuring data availability for visualizing various KPIs

Business Benefits

  • Comprehensive dashboard intelligence covering marketplace report, dealer network performance and visitor profile report

  • Insights into audience engagement & customer interests

  • Better campaigns to improve sales, reduce customer attrition

Environment

  • Python, Shell script, AWS, PowerBI