Case Study: Multiply Revenue as well as Customer Base


Case Study: Multiply Revenue as well as Customer Base

The Case:
This is a project which can be very well used by any indstry to Multiply their revenue, increase the customer base as well as multiply loyal customer base with increased customer satisfaction ratio.

The Company is a multi-national sports and lifestyle shoes manufacturer and retailer which has stores spread across Asia and Europe. In its 15 years of existence, Company had created a loyal customer base primarily in the form of trendy teens and middle-aged (25-40 years old) men and women.
While the footwear was mid-range to premium, the growth was never stumped for the first 14 years. Infact, they recorded a growth of 12% for the 5 year period from 2007-2012.

Prior to 2005, their only sales channel was in the form of company owned physical stores spread across Asia. Then in 2005, they expanded their presence through the franchise route to Europe. They also sell through multi-brand retail outlets and also have tie-ups with online retailers.
In 2008, they started their website followed by a mobile app in March 2013. While the web platform served as an end-to-end channel allowing potential customers to scan through the variety of footwear, make a choice and complete the order by making the payment, the mobile app was essentially a scanning platform with no functionality to complete the order.

In early 2013, seeing the boom of social media as a channel, they quickly designed a social media campaign where people could dedicate a love message to their upset counterparts on the Facebook page of Company.
Though the campaign was highly successful and widely appreciated in terms of its popularity, it did not translate to enhanced sales. Their social presence was restricted to this campaign.

In November 2013, the CEO and founder of the Company realized the need to use ‘Digital’ intelligently to achieve the business strategy and as a result, an expert in Digital Strategy and implementation was brought in.

The case study is to help the Company to digitally transform using below 3 point strategy:

Design a digital strategy leveraging the digital channels and assets to maximize the revenue for the Company.

How can the Company utilize technology to leverage the data from all channels to enhance the customer experience?

The technology architecture to support the digital strategy

The Solution:

Design a digital strategy leveraging the digital channels and assets to maximize the revenue for the Company.
Develop fully functional mobile and website apps
  • Design web and mobile app with new Content and Layout for attracting and engaging target customers for all mobile Operating Systems
  • All engagements to have facility to place Orders and make payments from apps
Promote apps on social media to target audience and loyal customers
  • Reach out on all social media platform and promote new app with attractive contests to attract target audience
  • Specially reach out to existing customers for expanding Loyal customer base
Track apps usage, user experience and feedback at stores
  • Create campaigns/ surveys on website and apps, track usage trends from the campaigns and track user satisfaction feedback from users at stores as well as on social media
Combine all information into “Data Lake” and top It up with Actionable Analytics Dashboard for maximizing revenue
  • Create Data Lake with all web and apps info, user feedback, carts, orders and all sources
  • Provide decision makers with Actionable Dashboards using Advanced Analytics
How can the Company utilize technology to leverage the data from all channels to enhance the customer experience?
Data from all channels and sources into Data Lake
  • Pull all data from apps and website, usage tracking, orders, carts and payments into a single destination Data Lake
  • The Data Lake is ready to use for Advanced Analytics to create dashboards using historical data from social media, payments and campaigns
Actionable dashboards on top of Data Lake
  • The information from Data Lake will be put into dashboards that will highlight User experience related points on negative as well as positive scale for all channels
  • Action items can be placed from the dashboards for channel managers so that User experience can be iteratively enhanced at all levels and channels
  • The dashboards and reports using information from Data Lake can also be effectively used to convey action items for maximizing revenue
Immediate use, effectiveness tracking and iterative enhancement
  • Historical data in Data Lake will enable Dashboards to be useful from day one
  • With incremental data and action items tracking, the solution will get further enhanced iteratively resulting in effective tracking of returns on investment for Analytics
The technology architecture to support the digital strategy
Cloud infrastructure for creating Data Lake
  • Due to presence of various data sources as well as due to huge amount of data for the Data Lake, using a scalable cloud infrastructure for Data Lake creation and Storage is required
    • Integration Engine – tools like Informatica, Talend or Pentaho
    • Cloud Engine – PaaS such as Heroku, Google App Engine or Redhat Openshift
    • Storage – Google BigQuery, Google Storage, AWS S3 or AWS Redshift
Advanced Data Analytics tools with Statistical engine
  • With need for user experience enhancement, sentiment analysis needs to be a part of Analytics solution on Data Lake
    • Statistical engine – R language and engine
    • Scripting engine – Python
  • Other advanced analytics techniques with ad-hoc data exploration feature on all devices need to be incorporated for suggesting immediate action items for maximizing revenue and improving user experience
    • Analytics and presentation engine – Qlikview, Tableau or Pentaho BI

Click to read more »



CLT20 2013 Twitter Analysis


CLT20 2013 Twitter Analysis of League

CLT20 just concluded with Mumbai Indians winning the trophy. Congratulation!!!! Mumbai take the double of the IPL and Champions League title the same year. Chennai Super Kings did it in 2010.
Sachin Tendulkar completed 50000 Runs in Cricket... AWESOME!!!
Here is how the Twitter world was discussing the different topics in Champions Trophy T20 this year (2013).

Click here to find a graphical picture of the tweets during CLT20 2013. Total list of topics are here.
This is our very own Social Media Bigdata project using Twitter Firehose - Live Tweets. There were about 300 to 1000 tweets analysed Live per second during the matches.

TWITTER ANALYSIS OF CLT20 LEAGUE

00

Babagyan CLT20 2013 Analysis

This is How it works at the technical level.

The twitter data is loaded in to the Analytics server by using Python program. This ocean of tweets is kept into the BabaGyan Gyankund (knowledge base) for further analysis.
Then another program (R with Python) scans the GyanKund tweets and uses its Intelligence to find the relevance and then sends it to BabaGyan.com database and web server.
The database is then accessed by BabaGyan.com's Analytics page to show analysis results in text and graphical format.

Click to read more »

Tool: Project Stages Tracker in excel for Startups - free to use and share


Tool: Project Stages Tracker in excel for Startups - free to use and share In Project Management, there are many phases or stages such as Opportunity Discovery, Contract negotiation, Contract Sign off, Development, Testing and Implementation. Sometimes it is all followed by Support, Enhancement and Maintenance.

There are different tools - free and paid that are well verse of each phase of the Project Execution. However, for initial Start-Ups or Small Businesses, it will not be feasible to start using any available tool unless there is visibility of how the Business is going to grow.

For this reason and many other, we have created a simple to use to use and track excel - it spans from Opportunity to Delivery of Projects.

This is free to use and share EXCEL spreadsheet by BabaGyan.
There are three sheets - Report, Tracker and Values. The Report tab provides you with the summary of your business. The Values has the List of Values that you can use. Currently it is defined for Stages and Products/Solutions on BabaGyan.com.

The Tracker sheet is the one where you will list down all your actual Business Opportunities and Projects.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Project Tracker Excel file to download.

Click to read more »

Tool: Daily Expense Tracker in excel - free to use and share


Tool: Daily Expense Tracker in excel - free to use and share How many times it has happened that you wondered where all your money went? Where did you spend all of it? How frequently do you take out cash and spend it even more frequently and immediately.
All you wanted is to know a trend of your spending so that you can plan and if necessary, control it.

There are many sites and phone applications that are available for this but not all are easy to use.
Every application has its own method of usage - some ask you to create and define bank accounts while others just don't seem to be secure. All you really want is is place where you can mention how much you spend and earn and keep a track.

Here is an option for you in our very own EXCEL spreadsheet by BabaGyan.

All you have to do is update the rows with your account transaction - both credit and debit. Also available is a Cash sheet where you should enter your cash transactions. The ATM withdrawal transaction from Account tab is added into Available Cash in your Cash tab. This way, you don't need to worry about Cash Credits at all.

There is also an optional Forecasting tab. Here you should list down all the routine transaction like Rent payment, Fuel expenses, EMI installments, etc. This will help you predict how much you can save at the end of the month. If you need more to save, just spend less - at least try for it.

In short - Update the cells in Orange before starting to use the sheet and daily update the cells in Green.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Expense tracking Month Excel file to download.

Click to read more »