PORTFOLIO OF WORK
Data Model, Analysis, Visualization and Charts
How do we eat our honey ?
How do we eat our honey (India) ?
We know the obvious uses but did you know honey potato/chili honey potato has been a consistent interest ? food brands can take notice.
#Immunity is not the buzz word any more
Which honey brands had the highest recall factor ? By recall I mean, consumer know what to look for without prompts. Wouldn't all brands or #startups vie for that ?
1 Dabur honey
2 Patanjali honey
3 Saffola honey
4 Zandu honey
Consumer price - Monthly analysis
Quick Analysis of consumer price data. We compare Jan 2021 with Dec 2020
Analytical study of consumer price volatility for food and beverage
Here, we look at price volatility for food and beverages across rural areas of Indian states.
Fashion Knowledge Graph
Knowledge graph helps us understand the inter-connected nature of business. Here, we explore the complex world of fashion - luxury brands, fashion houses, types of fashion, awards, events, country-wise fashion, cosmetics, beauty products, designer wear, clothing, body art, haute couture, designer and finally customer interacting with these various elements.
This relationship helps us easily find opportunities or threat to a fashion business in this network. One will find a way to assess a popular trends or an event's impact in your business by traversing through this network
Top 50 consumer food brands in India by their recall factor
Ranking of top 50 brands in India for the year 2020. Google search query data has been used to derive at this ranking. This ranking implies consumer brand recall and brand name they directly use in their search. These ranking should be seen as 'Brand recall' ranks of consumer brands (Food and Beverage) in India
Cosmetic Market Research
Cosmetic market has become very specialized over time. With advances in biotechnology and new research in science has created greater depth in product and services available to consumer. From hair care, skin care, nail care, perfumery to an industry of personal aesthetics, there are global brands vying for consumers attention. Humans could miss opportunities or threats in this growing web of information. With aid of data, his decision making is more accurate and less uncertain.
If a robot or an intelligent machine wants to reason in the cosmetic industry, he has to start with this base understanding, like an intern or apprentice learning about a craft, This connected data depicting the relationship between various plays in the cosmetic industry sets the stage for training the algorithm.
Singapore market based on Income-bracket
If one wants to market online, he can craft this message based on this heatmap. The darker the region, higher is the concentration of household.
And a new food retailer dependent on non-tourists, will choose the region based on his offering and affordability expressed by the income bracket.
Country : Singapore
Anticipating consumer’s choice
Ordering noodles for a party ?
We discovered that you will chose chicken, vegetable, egg, prawn noodle, in this sequence, to decide your quantity of order-mix. This is similar to predicting your ‘noodle basket’ or which noodle you are likely to pick in your shopping cart.
And interestingly, this doesn’t use surveys to find answer.
This is 2020 Dairy chart for the selected states. After mining search queries, some interesting pattern emerges.
1) Butter, cheese and paneer are more popular this year than last.
2) Ice-cream and yogurt have taken hit in interests in 2020. Increased interest in paneer might have come at the cost of yogurt.
Also, did you know that Milk is more popular in Tamil Nadu than Punjab and Karnataka has a growing love for paneer.
How did we learn this ? Not from consumer survey though.
Technology sector Study (database)
Mapping the inter-relationship in the business of database with data center, database software, hardware, data query language, Data in the cloud and many players - AWS,Google Cloud, Microsoft Azure, Oracle and others.
Alternative data : Retail sales (offline and online) in 2020-21
Point of sales (Pos) with credit card and debit card along with mobile transactions should be a good proxy to understand retail sales (especially urban sale). Average mobile transaction includes payment with UPI, which will cover Google Pay, Paytm, Amazon, PhonePe.
Key Takeaways - Comparing Jan 2020 and Dec 2020
Average transaction value from credit card is up by 10.5% while average debit card transaction is up by 25.8%
Average mobile transaction in Dec 2020 was close to Jan 2020 figure. But could be worrying is total volume and total value of mobile transaction are both lower by approximately 42%
Both Debit card and Credit card usage volume is down by 17.2% and 14.1% respectively
While total spend value for debit card is up by 4%, the total credit card value is down by 5%.
Country:India, Data: RBI
Singapore Food and Retail - Analysis
Retail and Food sales are inching towards Pre-covid level. Most of 2020 was without tourists. When tourists are back, we should see the food sales crossing 2019 by a significant margin
Country : Singapore
Marketing Strategy based on Household
One can find concentration of household in the region. For example, Tampines and Jurong west has the highest concentration of 4 person household.
The single person household prefers Bedok, Ang Mo Kio, Bukit Merah. So if your product focus on SIngle person, this should be region of focus
Sustainability Influencers (Indonesia)
Key people in Indonesia who play a vital role in sustainability discussion and policy direction. The graph help us unwind the different relationship and interests among various entities. Some are more vocal on single use plastics whereas other speak up on elephant, peatland, ocean pollution, recycling. We use this information graph to help us find the nodal influencer, who make the most difference to the discourse
Singapore Food Format
Fast food has been growing more than any other segment even before the pandemic. Fast food’s drop was shallow with a quick recovery. Food caterer’s have been most affected and looks like they need out-of-box thinking and wait for the normalcy to return.
Marketing Strategy based on people's occupation
If a marketer and retailer wishes to target consumer based on the occupation, then he can find the concentration of people based on their occupation.
Country : Singapore
Yearly breakdown of flavors in Noodle
Not all year are same in the world of noodles. Manchurian was popular in 2018 and 2020 but not in 2019. Hakka has been consistently popular.
Consumers online behaviour
he plot show what are other food item people will also look for when they search of pasta.
This is close to building a profile of your consumer. This tells us when someone looks at the product, what else she might buy along with it or inplace of it.
ea has also taken a healthy turn in 2020. Few would be surprised.
This charts represents the current reality but there are flavors that have steadly grown and are not just a blip.
How the conversation changed over a week ? (Indonesia)
The diagonal line denotes similarity between two consecutive weeks, while upper left and lower right shows new and fresh conversation.
Country : Indonesia
How similar is Indonesian with rest of the world
Here, we compare Indonesia with French, Spanish, German and English speaking countries. We try to understand the topics which are common between Indonesia and others. Its also tell us where Indonesia (bahasa) finds most similarity in their curiosity.
Country : Indonesia
Curiosity Tracker (Indonesia)
What are people most curious about where they have taken the pain to dig further and read about it on wikipedia. Some trending topics don't mean much, but some topics where people take special interest by going deeper.
Country : Indonesia
Identifying New opportunities
We identified new opportunities.
Almost everyone identifies batter with idli and dosa. We found that consumer also wanted batter for cake, pancake, waffle and jalebi. Interesting enough this demand isn’t fulfilled by the incumbents.
Segment study (Juice)
This is a real-time analysis of juice market, extracted by mining India’s search data. This is more reliable than a survey based study or other market estimates. We saw this trend, much ahead of the juice sales number by companies.
Country : India
Resident Age (Singapore)
Singapore has a significant population over the age of 65. Since life expectancy is high, with a fairly rich population we find this segment very lucrative market which brands could focus.