Sunday, June 16, 2013

Why principles of pricing/price discrimination do not work at barber saloons

    Whenever I visit a barber's(or to be more politically correct. hairdresser!) saloon and pay the same rate on a Sunday morning as on a weekday afternoon, I wonder about what if the barber was to apply management principles of pricing to do the following:-
  1. There would be price discrimination by time(charge more on Sundays/evenings)
  2. Each person would be charged differently as per ability to pay-the migrant on daily wages would pay less than the CEO
  3. There would be a membership with credits, to encourage repeated visits to that saloon, and other perks like loyalty program, and benefits like appointments through apps to minimize waiting
          However we have the benefit of observing a corporate chain of saloons i.e Javed Habib, and I notice this does not happen. Why is this so? Firstly, price discrimination by time i.e applying congestion pricing[charging more during high peak hours] would need customer assent, and is more difficult to stomach than merely raising the average price. Secondly, the customer DOES incur some waiting time(indirect costs) while having haircuts done during peak hours, so it is in his interest to come during off peak hours.

Ability to pay is factored in since saloon rent/wages are factored in the costing. And those who care about these costs would frequent a roadside barber or less expensive saloon. So it does not matter, and is not required i.e price discrimination as per ability to pay.

Since people usually frequent the same saloon/barber, loyalty program would entail unnecessary complexity and expenditure-something like why electronic micropayments is not taking off in India, when there is a much easier option i.e cash/notes/ which will anyways be there, why add complexity.
     
     

Saturday, June 15, 2013

Lenskart.com-the next flipkart of eyecare?

I ordered my new pair of spectacles online from www.lenskart.com after the old one broke. It had lived its life of 3yrs and getting a new one is difficult logistically since I get only weekends free and hardly any opticians shop near where I stay, so finally decided to give online shopping a try, and I was not disappointed. My review below of lenskart, but this post is more on the business model,
http://www.mouthshut.com/review/Lenskart-com-review-tulortuqrr

What do I mean by 'flipkart of eyecare'? Well, flipkart to me means speed, reliability(no cancelled orders), polite and prompt customer service and (till recently) deeply discounted rates passing on cost savings. All these seem true for lenskart.com as well. 

For some background, I read articles about them and founder Peeyish Bansal in Business Today and Economic Times. He is not a first time entrepreneur, in fact he had set up e-commerce ventures earlier in the USA and India in education and eyewear i.e searchmycampus.com) and Flyrr.com. However, due to logistics issues and economic conditions, his focus shifted away from them to Lenskart.In November 2010, he set up Lenskart.com, starting with contact lenses. In February 2011, he included eye-glasses and in March, sunglasses as well.  As per an Apr12 article in Business Today, Lenskart now gets about 45,000 visitors every day, of whom about 400-500 spend an average Rs 1,200 on ordering contact lenses, spectacles and eye accessories, and an expected FY12 topline of Rs 15-20 crore.

Lessons I could glean for this success[I call it success from the customer front, not so sure about the profitability but considering this is his 2nd venture, it should be profitable]
  1. Second time venture, so lessons learnt:-Logistics/customer service probably excellent due to this. Advertising on Facebook is also a good way to tap customers. 
  2. Tapping into an imperfect unorganized sector:-Like how www.redbus.com found its niche in bus travel, they found theirs in eyewear, which saw entry of retail chains like Reliance and Titan only recently. As per ET article, optical shops typically sell frames even at 100-200% margins and an average person has no idea what a frame actually costs. “A frame that’s priced at Rs 5,000-6,000 in a store actually costs only Rs 2,000. Also, rates vary as per area, unlike e-commerce, so thats a perfect way to make the market efficient.
  3. Huge scope yet information asymmetry:- Almost one-third of our population has a vision correction problem and off these, only 25% use any kind of eyewear. The market in India is worth around $2 billion, growing at 25-30%. People usually trust their optician to prescribe something within their budget, but that is far from ideal. Online purchasing makes it transparent with his buying guide, risk free returns, and 'Try on your face'. Also, with use of smartphones and laptops increasing eye-strain, the market potential only goes up
  4. Savvy HR policy:- As per Business Today article. LensKart, for instance, has strict rules against poaching. Candidates are employed only if they have not changed jobs frequently in the recent past, and are not offered more than a 15 to 20 per cent hike over their existing salary. This ensures they do not pay too much for talent which quits soon. 
  5. Excellent customer service:-Be it instant chat on website, SMS asking whether satisfied or not, prepaid returns label for BlueDart and returns form, procedures are very streamlined.
  6. Great logistics They handle it in-house via EComExpress, which is quite responsive too, they accepted my request to deliver at residence quite easily, and followed up professionally. 
  7. Great offline ideas like 'Home Try-On', tieup with opticians etc, so they do not ignore the offline sector as well or the importance of physical customer connect.
  8. Spreading common costs like logistics across multiple verticials:- Bansal has launched three more websites, each of which, like Lenskart, aims to become the category leader on the net. While Watchkart and Bagskart were launched last year, Jewelskart went online in January. Valyoo’s investor seems to approve of the strategy. IDG Ventures MD TC Meenakshisundaram says that Valyoo focuses on creating category leaders in product segments where supply chain inefficiencies lead to high costs. Also, synergies arise from giving customers a coupon book to use for the other websites as well, I got coupons 'worth' Rs 2,000 with my eyeglasses.
  9. Getting domain names efficiently:-LensKart/WatchKart/BagsKart/JewelKart all convey their name at a glance, and probably save plenty of advertising dollars. 
Will be interesting to see how they progress. 


Saturday, June 1, 2013

How to review an Excel spreadsheet aka spreadsheet auditing

Anyone who has installed a spreadsheet software like Excel/Open Office can create a spreadsheet. but reviewing one is much more challenging. One needs technical expertise on the subject matter, but also an ability to review/audit the spreadsheet, which depends on diligence/knowledge of Excel audit tools etc. Having searched this topic for a hour today, I give below my insights on the same based on referenced links, and my own experience. Surprisingly, there is little focussed training on this, both in professional firms or in organizations where it is presumed that people will pick it up on the job.
  1. Keep data/constants separately, at one place for ease in updation, and document the assumptions/link to source file. 
  2. Build in checks(like period y-o-y changes), constraints etc to ensure arithmetic accuracy, sanity check on reasonableness etc.
  3. Use relative references and constant file naming conventions/file structure conventions, so that updating links possible using 'Edit Links' option. 
  4. If any manual changes made to formula cells, shade that cell for identification or else identify it separately. Otherwise, excel has an option to identify cell not simillar to its surrounding cells, that may help you identify cells where formulas have been edited different to that copied across range.
  5. Ensure the Excel is ready for printing, and for copying in presentation. This means, in addition to segregating data from algorithms, placing meaningful column and row labels in each portion of the spreadsheet, and not just what the preparer understands.
  6. Develop "Summary'/'Analytical Tab'  to synthesize the results of all key assumptions and analytical results, concurrent with the ongoing analysis, so that only key findings and results will be presented or communicate

A visit to CCD, Cyber City(DLF Phase III Gurgaon)

At 11pm, when you feel the urge for a hot bite and drink, making it yourself is not the best option for a bachelor(ok even married men would hesitate at waking up their wives for this, but then they would probably be housetrained for basic cooking :D). When I walked 5min to the nearest foodcourt, CCD caught my eye and surprisingly it was still open! Following were my observations-btw what drew me in was the value for money Samosa+Chai/Coffee for Rs 49(+taxes=Rs 58), comparable to what I'd pay in the much less comfortable food court.
  • It is open from 8am-4am(!!!) even longer than McD which is from 9am-1am. Am not sure whether the counter person meant  8pm-4am, actually that would kinda make more sense. There was just a single person on duty there. 
  • Comfortable cushioned couches instead of the normal chairs I saw in other CCDs
  • A TV playing Movies OK channel 'Maine Tujhe Pyar Kiya'!
  • A wall advertisement by www.yebhi.com having QR codes of products which users could scan to get directed offers. Personally, I felt that was pretty cool
  • Promotional pamphlets by Samsung for its Galaxy S4, and by Vodafone for its trial 3G pack of 500MB for just Rs 49. Both being yuppy brands, advertising in CCD is a good idea
  • The usual merchandise of coffee, cups, strainers etc for those inclined to purchase
  • CCD times-an in house publication.
In all, a comfortable place to hang out and apt for the luxuriant ambience of Cyber City. 

Friday, May 31, 2013

Some insights on the radio taxi industry

If you have to reach any place in time and/or in style, then taxis far outbeat autos. Besides the comfort(4 wheeler vs 3 wheeler, AC vs ordinary) in cabs, another advantage is their being waterproof, heatproof and having transparent meters and fares vis-a-vis autorickshaws. Having used radio cabs extensively in Bangalore and NCR(less often in Mumbai, Chennai and Hyderabad), some comments on the same
  1. These fares have an upper regulated limit depending on the city. Many newcomers undercut these tariffs but may not be reliable on timing or availability(may cancel at the last minute)
  2. The industry works on a model where both cab driver and customer pay. The two models are
    1. Drivers drive company owned cabs paying Rs 1000-1500 per shift, and bearing the fuel charges. In turn, they can keep their entire earnings, and get the reservation fee share for the extra distance driven to pickup a fare
    2. Drivers owning their own cabs pay a monthly subscription fee to the cab company, and usually a per pickup success fee. Tying up with one company is not enough, so often a single owner has 2-3 company tieups to ensure greater cab utilization. 
  3. If you are not going for a long distance/airport drop off, then the cab may cancel if they get a better deal elsewhere. Of course, in organized reputed firms like Easy Cabs/Ola Cabs(I will NOT count Meru since it cancelled on me twice, once for an airport trip), drivers are fined if they do not reach 
  4. There are many cab services in NCR which offer headline fares at Rs 10/km. What are the extras are-which make Meru/EasyCabs look cheaper for short distances
    1. Min Billing anywhere from Rs 100-200 per trip
    2. Airconditioning charges extra usually Rs 20-25
    3. Luggage charges extra beyond X  bags
    4. Call Centre reservation charges(since often NO online reservation)
  5. How not to get conned/and save money
    1. Book online where possible, to save on the convenience charge. Create an account to save frequently used destinations. 
    2. Insist on a receipt for toll/tax, often the driver has a monthly pass but will still try and extract charges from you
    3. Use the Google Navigator on to guide the driver in case of confusion on route, else on the per km model, any detours are at YOUR expense
    4. Use the mobile apps where available-they offer discounts(like Ola Cabs 10%) and enable easy tracking of your cabs(i.e Ola Cabs)
    5. Keep adequate change with you for the cab, often the cab will pretend that the credit card machine does not work OR will extract the bill even before you can take out your card. Tell the driver you want to pay by card, and if he plays tactics, complain to the company. It won't help for that trip, but will deter future pranks
  6. How to choose a radio taxi firm
    1. Give patronage to one which services ALL your needs including night time trips/short distances, not just the long trips. That is why Easy Cabs gets my vote vs Meru
    2. Prefer one which allows online tracking of the cab to avoid tension of phoning call centre and tracking the cab progress

Monday, February 4, 2013

My experience at Jaipur Literature Festival 2013

The first time I heard about the Jaipur Lit Fest was during my years on the IIM Ahmedabad campus, when a few friends decided to attend. Due to personal commitments at those times, I could not attend but when the 2013 version came and I was at Gurgaon, I decided to attend it on Republic Day. So when the nation was celebrating(or rather indifferent to!) Republic day, me and many other literature lovers were enjoying the various sessions on offer. So without much ado, I recount my experience and some tips for getting the most out of the fest
  1. The venue(Hotel Diggi Palace) is very close to SMS Hospital(which all autos/buses know). So rather than spend on a cab and pollute the environment/lighten your wallet, consider taking a city bus or a share auto. That should just cost you Rs 10 each way. 
  2. There is no restriction on taking food/drinks inside the venue. Considering that items are slightly on the upper side, consider taking basic snacks/munchies with you, or have a good breakfast(the awesome poha/parathas/dal bhati) outside and then attend
  3. Registration is free(basic version) or paid(this year Rs 2500 where you get hamper from sponsor, free food and attending the music concert). Even valuing the free food at Rs 600, concert at Rs 400, that means you pay Rs 1500 for the hamper and the pleasure of being a patron of the litfest. Considering you get no other privileges like preferred seating, thats your choice. The name tag for paid registrations has your name, which might help for those of you focussed on networking.Make sure to pre register else if crowds too much, they may close the spot registration.
  4. The souvenir booklet(this year Rs 100) containing bios and detailed description of talk outline, is totally worth it. Otherwise, you spend lots of time Googling the authors to guess what they may be speaking about and stuff like that
  5. Its better to go as a group not only due to the carnival atmosphere, but also to ensure you get seating even when return from lunch/snack breaks. Here, like in any other Indian ethos, the concept of blocking seats exists. While I protested and got my way, you may not be thickskinned enough to do it when alone. So keep that in mind
  6. This year, the bookshop sold books by all attending authors. So if you want to make the author happy(but don't want to/have time to, order online), purchase a book at the litfest and Queue up for the post talk signing. 
  7. The sessions are usually 2+ authors(generally 3-4), literary critics, journalists or other renowned literature personalities, with a moderator. The format is a panel discussion like what you see on TV, except that its better moderated, and has (usually) better quality audience questions. So if you are expected deep insights, forget it, but if you are ok with many short insights from various people, you are at the right place. 
Overall, it was not arty/elitist, and a pleasure to attend. But if you don;t like the program topic, better find an alternate else it may get very boring

Tuesday, January 29, 2013

Interstate bus travel in India-some hard won lessons tips



Over the past 5 months, I've had some interstate bus travel, by public and private operators, so thought I would summarize my experience below(mainly in terms of time, comfort dependent on class of travel etc)
 
From
To
Distance(Kms)
Time taken(hrs)
Average Speed
Month
Travel
Bangalore
Coorg
244
8
31
Dec-12
Pvt chartered bus
Bangalore
Chennai
340
4.5
76
Dec-12
KSRTC
Gurgaon
Jaipur
245
5.5
45
Jan-13
RSRTC
Bangalore
Hyderabad
500
8
63
Sep-12
Pvt operator

 Though the Southern states are usually believed to have better roads, the Bangalore-Coorg trip took very long because of winding traffic packed small roads within Coorg, and also because the bus has a speed limiter which stopped it from making up time on National highways! But even otherwise, the roads were quite pathetic on that stretch. Bangalore-Chennai and Bangalore-Hyderabad roads require no introduction, they are very very good. But when it comes to Delhi-Jaipur stretch(mostly on NH-8), then things become strange. There are two main operators, RSRTC(Rajasthan State Road Transport Corporation) and HSRTC(Haryana State Road Transport Corporation). I succumbed to availability bias(RSRTC e-ticketing) while booking the tickets, but was had a bad experience in terms of speed, bus comfort and stops selection(expensive overpriced places). Later, a veteran traveller said that HSRTC buses are not only more frequent, but also reach you faster. Also, unlike in the South, private buses are actually cheaper than public transport, atleast in Rajasthan. Some lessons
  1. Unlike private operators, state transport buses may not have dedicated customer care/contact numbers where English/Hindi is spoken. So if you do not speak the language or are not familiar with the stops, then god save you!
  2. Since public transport buses should easily get full due to (presumably) cheaper rates and reliable timing, unsold seats are a warning of deeper issues(quality, timing etc), which I ignored in RSRTC
  3. For long distance, Volvo is better, not only in terms of comfort, but also it is faster, and since likely to be full from starting, lesser unscheduled delays while conductors try to pack the bus
  4. No substitute for speaking to veteran travellers on the route, who can not only advice the best bus, but also likely issues(blankets/water etc) for you. 
  5. Don't bank on the DVD/seat lights working, not even for good operators-or they may not keep it on 24*7. Hence, do get your earphones etc along. And go for a bus with a charging point, that people vouch for that works! Else kiss your half day good bye
  6. The service can be astonishingly good(conductor stops where you want) depending on the state(Karnataka is the best imo, its Airavat class services), and many speak English/Hindi, so don't shy away from Govt owned transport due to language factor, provided you have asked about it.
  7. On the plus side, nearly all allow e-ticketing/SMS tickets nowadays, along with web based booking and inexpensive cancellation charges.
 In all, considering difficulty in getting train tickets and comparable travel times on the said routes, inter state bus travel should never be ruled out!


Saturday, December 22, 2012

Good experience at Bangalore Book Festival 2012

As a Mumbaikar who loves books, the nearest I'd come to book exhibitions/festivals was the annual strand sale, but even that was a single retailer. Hence, when I noticed the ad of the Bangalore book festival at Palace Grounds, Mekhri Circle; I jumped at the chance to attend one, especially given its timing at the fag end of my stay here in Bangalore.  The fair's description as reported in the Hindu stated that This year, over a million books and 50 renowned writers will converge at the festival, which will boast 307 stalls, lakhs of book titles and books in all languages, promised the organisers, at a press conference held here on Thursday. This list includes about 90 Kannada publishers, 150 English publishers, other regional language publishers, developers of book apps and e-books, book portals and online book sellers. By the time I'd come, all the writers had come and gone, and the number of stalls had drastically fallen, but still it was a good experience.
  1. Entry fee @ Rs 20(as I'm not a student or teacher) was reasonable
  2. F&B arrangements were decent inside(only veg though) and conveniently located
  3. The prime spaces were taken by online portals/children's books-a lead indicator of the things to come? I've felt before that the most profitable portions of the publishing industry would be online book retailers(due to lesser real estate/stocking costs) and children's books(as otherwise rational parents want only the 'best' for their kids, and are unlikely to use pirated/ebook versions). 
  4. Several Indian publishers like Jaico, Pustak Mahal, Orient-Longman, National Book Trust were present, but surprisingly, Rupa was not there. Very few foreign publishers present though
  5. Several niche publishers were there like those focussing on tantra, Hindu literature, Ramkrishnan Mission, Islamic books, leftist literature, which gave a good overview on stuff not usually found in book stores. Even browsing them stimulates the mind.
  6. Some magazine publishers like OPEN, Week, Network18 were present. I picked up a 1 year subscription to OPEN magazine for Rs 649, versus the market price of Rs 1045. Given the stellar content of the magazine(and a cover price of Rs 35, versus the effective per copy price of Rs 13 for being couriered to my office), its worth it.
  7. Many stalls were of retailers, who played the price/bargain game like 1 book Rs 50/99, Rs 100 for 3books and so on. So much so, that the organizers were repeatedly playing announcements requesting the stalls to remove the prominently displayed price tags!! Given that we Indians are suckers for bargains, its not surprising that this strategy worked!I picked up a Shobha De book for Rs 100(Super Star India), and an old Readers Digest adbridged classics set for Rs 49(this was my best bargain from the entire thing). I also picked up some books from the National Book Trust.
  8. Some stalls however, were not related to books at all, for example a stall of educational software for MS Office, Coding etc, devotional music and so on.
  9. An interesting feature was the number of stalls focussing on book lending libraries, as well as sites like homeship18. They were prominently there.
Overall, the book fair did meet the criteria of serendipity(http://andy161.blogspot.in/2012/11/why-i-window-shop-in-physical.html) while the deep discounting did help convert some selections into buys. Would certainly attend another one if held next year.

Thursday, November 29, 2012

Why I window-shop in physical bookstores but buy online


As Gary Becker and Richard Posner put it Amazon’s book-recommendation program is primitive, and is no substitute for browsing in a well-stocked bookstore.  And even if the book recomendation alogorithm is refined(like the famous Netflix one) taking into account previous purchasing/browsing history, social media, recommendations etc, it removes the element of serendipity. If I want to check out books and look for new ideas/mental models, then a bookstore is the best place to start. Also, I may see titles that may just be right for a friend/relative.

Also, browsing through the pages of a book is rarely possible online, even Amazon gives hardly 10% of the book. On the other hand, Amazon etc have excellent reviews, which often give away the gist of the book itself and state both positive negative points. Hence, on the quality assessment/preview front, online probably wins.

One also cannot compare the prices-paying list price online, often import parity prices despite the increasing Indian editions these days, versus locating the lowest cost book often at discounts upto 40% through sites like www.kbooksearch.com or www.isbn.in. From the cost angle therefore, online is not comparable.

Evidence also states that people hardly read most books they purchase. Hence, to prevent information overload/buying books you are not likely to read, a cooling off period and searching for online reviews/alternatives is a good thing before making a decision to buy something you saw offline.

Still, having stated why I do it, it would be fair to give examples where physical book stores may actually work and prosper.
  1. http://www.forbes.com/sites/philjohnson/2012/05/10/the-man-who-took-on-amazon-and-saved-a-bookstore/  This gives the example of an independent bookstore which installed the Expresso 'print on demand' book printer, and pays fanatical attention to customer service with an unrivaled staff of passionate and educated booksellers. 
  2. http://www.theverge.com/2012/8/13/3238391/singularity-and-co-sci-fi-bookstore-dumbo-brooklyn  This book gives information about the rare book market, for which online buying may be more expensive, and the book may not be there next time you return. This is a good business model for those who can tie up supplies.
  3. Impulse purchases books like those in airport/railway/bus stations, for which no alternative is available
  4. Stores supported with coffee/food cafes, music/related merchandise etc. The Landmark chain of bookstores owned by the Trend Group(part of Indian conglomerate Tata Group) is a prime example. This is because it creates an entire experience complete with sofas/bean bags etc, for which customers feel the urge to pay

Friday, October 12, 2012

The shoddy experiences with Goibibo and Redbus

I had earlier praised Redbus on this blog(http://andy161.blogspot.in/2012/03/10-reasons-why-i-book-bus-tickets.html), and that is why I write this post, to give the other perspective. Earlier last month, when I needed to book tickets to Hyderabad, I sought to use the ICICI 10% discount code for the tickets. For some weird reason, it was not working. When I called up customer care, they sought to put the blame on my browser/cache, advised me to refresh and try etc. When even that did not work, they claimed that I was no longer eligible for that offer. When I still went ahead and booked the tickets w/o the coupon code, they even refused a goodwill waiver, stating that I had already used another lesser value discount code. When I challenged them about another ticket, then they stated the real reason that they would not apply discount codes to tickets once booked. Fair enough, but why give a misleading response and try deflecting blame? From the fact that they took down the ICICI offer code the next day, it seems that they had realized the technical issue or else had let it expire without renewal(likelier reason). While I have no issue with their technology, this experience left a bad taste in my mouth.

But their competitor GoIbibo was no better. Even their coupon code worked with great difficulty and repeated efforts. Their customer care was little knowledgeable about the website, and did not call back about failed payments/unconfirmed bookings status. This was for both bus and flight tickets. And to top it all, their search platform is quite cumbersome. So without discounts to compensate for that, who in their right mind would use it over a Redbus or a cleartrip?

Thursday, August 2, 2012

Is it fair to treat prepaid customers badly?


A customer who is acquired at zero costs, costs you nearly nothing to service, pays you money in advance and yet who receives minimal customer service. Most businesses would salivate at such a customer. But why do telecom companies focus on their postpaid customers(who take min 1-2months to recover their channel partner commission, who pay late/have credit period, who need expensive payments/collections mechanism etc)? One reason is that postpaid customers, as the conventional wisdom goes, have higher ARPUs than their prepaid peers, and are likely to stay longer on the network.  However, they also cost the telco more for bill delivery, credit costs and customer service. In an era where these costs are almost fully variable, one can tangibly accurately estimate the relative profitability of prepaid and postpaid customers. Just imagine, a prepaid customers costs you nothing to acquire(in direct cost terms), pays his own channel commission(that Rs 1-3 channel fee) and gives you valuable float. He IS rewarded with better tariffs(usually) but that’s owning to competition and not from any benevolence of the telecom operators.
Particulars
Prepaid
Postpaid
Tariffs
L
H
ARPU
L
H
Loyalty
L
H
Customer Service Quality
L
H
Credit Risk to Airtel
L(zero)
H
Customer Acquisition Cost
L(zero)
H
Tariff flexibility
H(RCV)
L(few plans)
Customer payment costs
L(they pay it)
H(Airtel bears it)
Risk of outgoing calls barred due to zero balance
H
L
Bill shock risk
L(balance post every txn)
H(unless daily alerts opted)
MNP Risk
L(may just change SIM)
H(are likely to be pursued by other operators)
Loyalty likely due to
Personal choice
Corporate relationships
Bill Delivery Costs
L(zero)
H(mandatory)
Free Itemized Bill on Email ID
No(same Rs 50 charge)
Yes

Thursday, July 12, 2012

You can be a data scientist for big data just using Excel and Access

Just google 'Big Data' and watch the explosion of results. Some herald it as the next big thing, others peddle their consulting services/software/systems as the magic recipe for companies to mine gold from their (till now) ignored legacy data sets. However, as I've realized from a customer service project during the past few weeks, spreadsheets can do the trick equally well, provided you follow a few basic ground rules

  1. Understand the underlying data, its fields/formats and the limitations. This may need visiting the field/POS/scanners/call centres to get a feel for the source data, but can do wonders in understanding what can be relied upon and what can't. After all, all the number crunching in the world even using 500 columns is useless if the underlying data is not reliable
  2. Frame hypotheses(even though they may seem 'obvious') and look for data to validate and disprove them. For example, if you think that customers recently added on the network will face more issues with their bill delivery, then choose data fields that can help you validate that hypothesis. A few fields well chosen can really reduce the time used for import/export of data. 
  3. Use subject matter experts to review the findings and offer their views. often, if a finding challenges their conventional wisdom, they can offer alternate reasons for the same. 
  4. Creatively think of dimensions like time, space, temperature to analyze data sets. Often, these physical variables are ignored but are available in the system. Using the existing data is far cheaper than trying to get it from scratch. 
  5. Data mining for social networks, stock trading data and other massive data volumes would obviously need some automation via neural networks, crawlers, AI etc. But for everything else, one can use spreadsheets to squeeze out that last drop of insight from existing data sets
  6. Understand the import/export features of spreadsheet/database software like Excel/MS Access etc. If  your data set with some tweaking can fall in that range(like below 1million odd rows etc), then using those standardized tools may be faster and efficient. Also, no need to call expensive data conversion experts, you can do the job yourself(for example importing .txt files to Excel)
  7. Don't be afraid to google any trouble areas. Often, excellent solutions available online(for instance, how to export more than 65,436 rows from MS Access to Excel-the online solutions include exporting w/o formatting, or using OCDBC)
Bottomline:- Don't be awed by big data sets. Use pivot tables etc to summarize the data and get a feel for it, then slice and dice it the way you can using Excel/Access. Often, those quick wins may win you a justification for a bigger data mining project

Sunday, July 8, 2012

How to(and should you) purchase a 3G data card/dongle in India

Having shopped for prepaid dongles in Mumbai and Bangalore, besides having spoken to dealers, distributors and company executives(not just Airtel), I think this post can give some insight and save people money while purchasing data cards.
  1. As telecom operators do not have a pan India 3G license, they resorted to reciprocal roaming arrangements where the big3(Airtel, Idea, Vodafone) offer free roaming in data to their subscribers across India. So an operator offering 'free pan India roaming' may not be an USP. But benefit from this if the tariffs in your home state is different from that in the destination state. The arbitrage opportunity could exist nevertheless
  2. Negotiate the maximum free usage(and its validity) from your operator. For example, if MTS offers 10GB free for 1mth with data card costing just Rs 999, then others may be prevailed to do so. How it works is that the distributor gets a good commission, and may spend some of that giving you that extra top-up, which may not cost him that much. 
  3. Be aware of the lapsation norms of the prepaid data card. You may need to recharge it within a defined period. Longer it is, the better for you in terms of flexibility.
  4. Though not strictly legal/ethical, some stores charge Rs 100-200 to 'unlock' the dongle' to use SIMs of other operators, thus allowing subscribers to go with the cheapest plan across operators while still using the same dongle. That increases the churn quotient of the subscriber
  5. Remember that promised speeds are indicative and depend hugely on your location. So speeds upto 7.2Mbps may amount to just 2-3Mbps if you are lucky.  So do not spend too much on an operator's plan/prepaid data card before testing the speed in your location. Remember, quality of service/speed are not grounds for a refund under TRAI regulations. 
  6. For usage>6GB/9GB,a wifi hub may be cheaper, or even a broadband connection. Explore those options if you are a heavy user. 
Hope this was useful! 

Saturday, July 7, 2012

Update your registered mobile number at ICICI ATM

When my Airtel coworkers went to the nearest ICICI branch to update their registered mobile number, the branch informed them that they could do so at the nearest ATM also. Hearing this, I was a bit sceptical as you cannot do so via netbanking, so why the ATM channel is open for that. Still, they were able to do so, and so was I. It was a great experience to do so without filling a single form or taking copies of your identity proof. This is what ICICI meant I suppose by advertising that their ATM is almost a branch.

If I have a grouse against ICICI, it is the low savings interest rate and the lack of other benefits for me.  Some other banks actively advice customers what is best for them. Sample this advice from Kotak Bank on their website Now THAT was what I call customer friendly analytics. 
Helpful advice: Kotak Bank has discovered that a majority of the people choosing a Kotak Edge Account actually end up maintaining the Average Quarterly Balance required to maintain a Kotak Pro Account. It may be in your interest to choose the Kotak Pro Savings Account and not miss out on the extra advantages & free services!'

But then, I suppose that is what you get when you sign up with ICICI. Awesome technology, rapid fast and efficient customer service, but you need to count your fingers everytime you shake hands/transact with them :P

Travails of searching paying guest/short term flat in bangalore for men-II

Earlier, while I was searching for a paying guest accomodation in Bangalore, I blogged about the experience http://andy161.blogspot.in/2012/06/travails-of-searching-paying-guestshort.html here. Thankfully, the episode had a happy ending for the time being with me finding a working men hostel about 10min walk from office(even at slow pace!). Given the notorious Bangalore traffic, imminent monsoon(though no sign of it yet!) and my other PG arrangement near Sony Signal falling through(I waived a Rs 1000 deposit because I had buyer's remorse after seeing the place, and the place did not have the warmth/comfort I was looking for!), this arrangement was the best for now, despite the slightly expensive(given the amenities-no washing machine/TV/AC) rate of Rs 9000 for a single sharing room of around 100sq feet with attached bathroom. The room is almost spartan but quite functional, given that I'll be staying here just a month before I shift for greener pastures in North Karnataka and then Gurgaon for training for around 2months, before returning here. Some lessons I learnt from the whole experience was
  1. The Rs 500 deduction from the security deposit is quite standard. Live with it. 
  2. Check the bathroom flush, close the doors and check out the room. You may find leaky bathrooms, jammed doors, non functional lights etc. Make sure you get them repaired before you move in. 
  3. Be clear about the notice period needed before you vacate. Usually it is 15days and if you vacate at shorter notice, you may forfeit the small deposit of Rs 2000
  4. Hot water and is no big deal really if you have a water heater(actually in this climate you don't even need hot water).
  5. A washing machine is really useful as you don't have to risk a dhobi washing your nice clothes with a stone! But many places wash your clothes at a per kilo basis on their washing machines, so do not worry about that. 
  6. Wifi is good to have, but check the speed especially at night time(the more people using it the slower it is). You may find it cheaper to have a data card and no wifi, especially if you are a light user. For heavy users of course, wifi is better :)
  7. While phoning to enquire about the place, make sure your non negotiables are specified so that you do not waste time in viewing places that you will never stay in. 
  8. You can rent a fridge, TV, microwave for around 400/month each(I've never tried it but thee facilities are there), so you can use that if the PG allows.
  9. Bangalore usually has good electricity/water supply but still enquire about that 24*7 status and the backup facility if any, so that you can impose penalties if needed later. 
  10. Food is likely to be like hostel food(bare basics), so you will anyways need to supplement it. Don't expect too much in terms of food even in 'good' PGs.  And then, tiffen services are always possible-online ones cost around Rs 60-120 per tiffen.
Of course, do exercise due diligence, but enjoy the experience on the way!

Which is better-prepaid or postpaid voice plan? Analysis for India

The benefits of working for a telecom company is that you get some insight into how the market works. While I do not claim that a month's experience has made me a guru on this(despite what my friends may think!), some useful insights are below. As always, I take resort to the classic MBA answer 'it depends', to point that for each person depending on their circumstances, the conclusion would differ. For data, there is a separate blogpost.
  1. Tariffs:-Since prepaid customers(other things remaining equal) are seen as more likely to churn, telecom companies offer them good tariffs, and newcomers try to lure them with great tariff plans. While companies DO reward their loyal postpaid customers, the latter are likely to take postpaid for reasons like company reimbursements, address proof, loyalty and not tariffs, so prepaid seems the winner in this. Prepaid 1-Postpaid 0
  2. Customer Service/Billing :-Companies need to retain data for their prepaid customers for a much lesser period than for postpaid customers(due to TRAI billing norms). Hence, CRM analytics, customer segmentation etc becomes easier for postpaid than prepaid. This is not to say that high prepaid spenders don't get differentiated customer service, it is just that companies might not go out of the way to resolve issues for their prepaid base whom they see likely to churn out. And given that getting an itemized bill will cost around Rs 50(ceiling imposed by TRAI), disputing charges or getting waivers becomes much more difficult for prepaid. Also the small fact that in prepaid, your money is at their disposal but in postpaid, your not paying is their bad debt. So once money changes hands, it is more difficult to get it waived or so. Prepaid 0 Postpaid 1
  3. Flexibility:-This is really where prepaid scores over postpaid. For example, if you suddenly need to send bulk SMS or make ISD calls in the middle of your billing period, you need to wait for sometime before switching to a better plan, if you are a postpaid customer. But if you are a prepaid customer, just take a top-up/Recharge voucher and you can immediately change your usage pattern. For example, I've made calls to Singapore and USA for hours this month, at a rate of Rs 7.4/minute, but for a Rs 14ISD prepaid voucher, the same calls would have cost me Rs 2.99 only. Ditto for sudden data usage needs etc. Prepaid 1 Postpaid 0
  4. Usage based recomendation of best plan:-Though Airtel launched a portal earlier this year giving such recomendations for prepaid users as well, that is not yet an industry practice. As the telecom companies have data usage of their postpaid customers, they can more easily crunch numbers and offer them better plans. Ideal for those customers not savvy enough to hunt better plans from the same telco. Prepaid 0 Postpaid 1
  5. Address proofs:-Here, there is no doubt that postpaid is easier. Though one would have utility bills etc, a telecom bill is the easiest address proof to generate in 3months,especially for migrants. Prepaid 0 Postpaid 1
These were the points which I felt crucial to decide between the two. Would welcome your comments.