Last year, I had rigged up a OLAP cube in MS SQL Analysis server with sales data for the channel team I am part of. The front end was Dundas data viz software. The interface itself wasn't fast but I could build some nice visual dashboards. Then realized that for quick slicing and dicing of voluminous data, I could connect to the server thru MS-Excel (how-to here). The resultant pivot in XL amazing flexibility to analyze the data.
The logon credentials was done thru windows authentication. Starting last week, I couldn't connect to the cube and I just couldn't figure out what the problem was! All I could think was that this was probably because I had changed my windows password at about the same time.
The IT guys after a few days of trial and error found a simple solution, remove my 'Document and Setting' folder and let Windows create a new profile! This is a dirty quick-fix. I am still looking for the correct answer to this problem. So far the best explanation and discussion I got is in the expert exchange forum.
Since morning, I have been getting "Out of Memory" errors when accessing the VBA Editor in MS Excel 2007 .
I created/edited a macro that cleaned up and formatted about 1500 rows of purchase order data downloaded from Walmart's Retail Link/Orbit site. The macro ran fine and the final sheet had about 300 rows and 16 columns of data that I needed. The problem started when I tried to open this sheet. The sheet takes a long time to load with a 'not enough system resource' message at the end and 'out of memory' message when I tried to open VBA editor to edit the macro.
After a frustrating half day trying to figure why this happened, I simply took this tip and recreated the workbook thru a simple copy-paste. I guess, I should suspect my macro modules. After all, I spent a lot of time editing the module, and they probably became corrupt over time. (This has been a known problem for some time in VBA.)
Also noticed how the file with the same data shrunk from 6MB file went down to 171kb on doing this. Guess this works for the time being and will figure out the cause when I have enough time.
A good discussion on memory problems with Excel can be found at these pages:
http://www.decisionmodels.com/memlimitsc.htm
http://www.decisionmodels.com/memlimitsd.htm
Yesterday one of my colleague came up with a peculiar problem... She was unable to open Orkut/YouTube on both Chrome & IE. Every time she typed either of the URL, she would get the message, "ORKUT/youtube IS BANNED, Orkut is banned you fool,The administrators didnt write this program guess who did?? MUHAHAHA!! ". Then the browser would close. IE was quick, almost as if it crashed while Chrome took some time to close.
I first happened to see this on Chrome. So thought, some intelligent friend of hers put a nice piece of add-on code (javascript!) into her browser to check URLs and close on finding Orkut/Youtube in the address bar. After 10 minutes of futile search on her comp, realized that this wasn't a friendly add-on prank. It turned out to be a worm (W32.USB) that spreads thru USB drives and was detected almost a year back. Microsoft forefront client security (with virus definition: 1.67.470.0), the virus software my company uses, didn't detect it. My conspiracy theory is that its a deliberate choice by M$ to exclude this worm from virus defection. After all it targets Google sites and Firefox browser.
Its fairly easy to remove this annoying code. The link above should give the instructions. If you are interested to see the code, its here.
Trying to keep up with blogging with all the work... So, from today, will starting a series called 'problem for today' which will have some problems & solutions if I manage to crack the problem or get a solution from the net.
Last month (August) was when India sort of panicked on Swine flu. As of today, in India, more deaths happen due to H1N1 than same time last month and no one seems to bother as much.
Almost every company worth its salt with any product remotely related to health care wanted to benefit from this panic and had ads associating their products preventing flu infections. While this is true in all countries, in India, due to the lax advertising standards, the ads were a little over the top. And almost every one did booming business.
Here are a few ads, that according to me, are quite a bit over the top!
Finally got my machine up and running with Ubuntu Juanty and got the mac4lin theme up and running.
Just a bit of work left on getting all settings for my partition right and then its full time on Linux again.
While reading on the DDoS attack on Twitter yesterday, I landed upon a page at cnet. The first thing that I noticed while there, is not the article or its heading, but this ad of Olympus. I later realized that this was a regular TVCs adapted for online! Hence the YouTube link below and not the original ad.
An attractive looking lady in slow motion plus one of my favorite hobbies, photography. It was catchy! I clicked on it to find out what PEN was all about only to land at this really stupid page. It just had a product shot and didn't tell me what PEN was. Which was on the last frame of the ad and the reason why I clicked. Didn't have any inclination to explore further and Olympus lost a little more money on this ad (either for the impression or the click).
I am sure that Olympus would be checking how this ad performed but what was interesting was the CBS feedback page on this ad. It set me thinking on how much research goes on, on online marketing & banners anyway. Firstly, what advertisers think is effective might itself be incorrect (difference of opinion between advertisers and audiences on ad effectiveness). Also, my take is that advertising measures for online ads need to be a lot more different from conventional media considering what consumers think of online ads (chart 2 below). And the fact that consumers are very frustrated by many of today’s popular types of internet ads. The feedback being sought by CBS was very much like for an TV ad. It reminded me of an article on number of marketers testing an email campaign.
A few charts below courtesy marketing charts.
I am having trouble with my passport renewal.
Have already done a few rounds of the the passport office and the nearest police station. This entire process is getting onto my nerves. Am wasting half a day again today, for the second time, to clarify the 'objection' (what this objection is, is a complete mystery) they have on my application. Am completely pained with the entire process and the snooty people (almost everyone, security to office boys to officials) there.
Will live tweet the proceedings, want to see how hilarious the entire process and my agony sounds!
Of late every website wants you to spend more time on their site. Realizing the current craze of people is of posting 140 characters or less, every social media site worth its salt has put in a similar feature and asks you a question to type in something.
Here's the sites that I am on, want me to say...
- Twitter: What are you doing?
- Google Reader: Have some thoughts to share?
- Orkut: Set your status here
- GTalk Status: Availability and Status
- Blogger: Post Articles & Status updates
- FriendFeed: Posts and Updates
- Facebook: What's on your mind?
- Linkedin: What are you working on now?
- Yahoo! Mail / Y! Messenger: What are you doing right now?
- Flickr: Status updates
- Yahoo! 360: What are you doing now?
Depending on the region you are in, I am sure there are a number of other social sites that you might be on. A few popular ones that I could think of - MySpace, Wordpress, Typepad, Delicious, LiveJournal, AIM, hi5, myYearbook, Friendster and Photobucket...
Now, that's a lot of sites asking you to be on them and keep updating!
A few days back, I saw Hans Rosling visualize HIV data in this presentation at TED talks. I was looking for (to purchase or create) such a graphing tool for quite some time (incidentally, my requirement is a combo of heat map, bar/pie chart & motion chart). A little research revealed that Google purchased Trendalyzer, the graphing tool used in this presentation, from his company Gapminder in March 2006. A version of it has been integrated into Google Spreasheets as Motion Chart.
Luckily, I found some Indian Mobile-GSM subscriber data during the same time, cleaned it a bit, added some data and here's how the trend looks...
Gave this question a long thought during the rains a few days back and realized I had answered this question in the B School interview I gave during my Engineering!
Not in any particular order...
- Infrastructure
- Education
- Health Care
Managed to get a download of all travels I did using my Amex. It makes for an interesting analysis.
Chennai was my favorite destination (for software trouble shooting), Delhi (for business) and Hyderabad (surprise! for personal work)
The first week is spent planning. Then, I slog a lot during mid month and do end of the month target achievement trips.
Again mid week is when I travel the most.
And overall costs have been fairly stable I should say except for the occasional foreign visits.
With the overall costs / trip coming down.
Ever since status messages gained popularity to communicate thoughts and messages, I was looking for an option to sync my statuses across all social networks I was on.
First tried this...
Then realized that Ping already offered a nice service...
After a few days, realized that not every message is apt for everyone (across networks). Now trying for a better way to manage my updates based on classification of users. And I still have a few sites to integrate.
Update 30th July 2009:
- This page gives you info on how to link Google Reader & Twitter using Friendfeed. But, didn't find the options working for India.
- Twitter Feed has since upgraded and now offers better control of posting from Google Reader.
10th of June was a very hectic day for me! Started work at 8:45 AM and went on non-stop till 11 PM. At 8:00 PM, my computer gave up and crashed after spawning up innumerable windows! Tried closing as many as I could, gave up and had to finally reboot.
Unable to fathom why this happened. I guess its because of the updates that my company runs, but not sure. Any explanation of why this happened is welcome.
Then, a couple of hours later, this happened on Facebook! I guess this had something to do with the username setting opening up at that time.
Luckily, no errors occurred during work :)
Everything on this site/blog is available under Creative Commons Attribution-Noncommercial-Share Alike license.
View this License Deed and its Legal Code.
Happy copying!
Having handled complaints and now experiencing trouble with a few service and product providers, made me think of the entire Complaint management cycle that a company should have...
A few basic thought starters in random order
- Are you selling a product or service?
- What is the value of this product or service? And what is the premium you are charging?
- Who is the complainant? Internal or External? If external, Customer or Consumer?
- How critical is complaint resolution and management to the brand equity of the product?
- What types of complaints will be your liability and to what extent will they be entertained?
- Till when (time) should you take the liability (and extent) of ensuring the quality of the offering?
- What is the resolution process? Internal and Externally visible processes. Time between processes?
- Is the treatment the same for both internal and external people?
- How long should the final response time be?
- How much of information on the complaint will be shared with the consumer?
- How do you measure satisfaction of the entire complaint resolution process?
What stuck me was the speed. Its almost instantaneous and gives you no
time to react if you are under it.
The Volvo B7R that I was traveling in from Chandigarh to Delhi stalled very close to Delhi after a 300 minutes nonstop run. The driver started fiddling with the dash and out of curiosity I looked at the dash to see what he was doing and man was I surprised... I had a fair idea of the Volvo B7R dash as in my earlier travels, I used to check the speedo to see how fast these buses go (and trust me, these mean machines have a nice top speed)
This one had a lot more controls crammed into the Dash with a neat LCD screen in the center. A red triangle with "Stop" was flashing continuously and the LCD screen indicated "____ belt wear predicted". And as predicted, when the driver opened the engine boot, one of the belt's had slipped.
I believe the new buses have an integrated Engine management system (EMS2) which take data from several sensors on the engine with scope for diagnosis and fault tracing which was what I saw. Now, if only the semi literate Indian drivers knew how to read the these dash messages!
I also started noticing new multi-axle Volvos on the Mumbai roads...
...and road travel has just got a little better.
12:30 in the night, new city, you take a cab, tell a destination and start feeling the driver is taking a lot of time to reach the destination. You suspect that he is taking you around with an aim to fleece you. What do you do? iPhone to the rescue.
A route map, distance and average time taken with a rough idea of where you are. Its just what you want in such a situation.
I was planning a tour of Punjab to visit the Bharti Wal*Mart stores, an account which I now handle for my company, to get to know the ground realities. Was going to do a road trip - Chandigarh > Amritsar > Kapurthala > Jalandhar > Ludhiana > Patiala/Karnal > Ambala. Accordingly, was on my way to Amritsar last night. And at 7:30 PM as soon as I reached Phagwara bypass I saw a few people blocking the highway and setting a few tires on fire on the road to block the traffic. What I thought to be a small protest on the road is now a full blown sectarian clash. Here are the
news results on the incident.
25/5/09: - 10:34 PM: Finally found the layout I liked. Will take time to edit it to my liking. But it will do for the time being with the postings.
2/5/09: - 8:52 PM: In the process of updating the layout to my taste. The page layout will be erratic for a while.
Its funny the number of times I have been logged out today while reading my subscribed feeds on Google Reader.
A similar problem was reported on Dec 22, '08 on Google Groups. More on this later.
I was reading a feed on the financial crisis and the need for US to maintain world confidence... And right below the feed was an advertisement for LK Advani as PM?
Now this is new! A little researching showed that he threw his online campaign open by launching his website and blog on Novermber 08. What I noticed is the heavy use of Google AdSense network by him and words like fundraising, economy, economic confidence are being used by him. Infact, in a matter of minutes, I spotted him on atleasts 3 of my regular feeds (Indian Stock Research (word-economy), Tech feed (word-fundraiser) and business (word-economic confidence).
What's interesting is that these ads don't feature the "Ads by Google" text though they are being shown by Google. I think this oversight by Google is a heavy mistake.
I believe Google opened a dedicated political ad sales office, with 25 staffers, in Washington DC sometime in Jan this year.
"You can geotarget as finely as a zip code, so almost to within a mile or so radius of where the voter is. If you want to reach a voter in New Hampshire it means you're not wasting media spend on users in Vermont who can't vote. Refine it even more if you just want to reach women by running on sites like MarthaStewart.com," said Peter Greenberger, head of elections and issue advocacy at Google's Washington office.I wonder if Google has any such advocacy group in India? And also think that Google should not allow its adwords & adsense technology for use for any political campaigning in India.
update Feb 04, 09: A few other words taken up by him..."bad to worse", "vision", "United States", "blog","case","founder","justice","prospect". BTW, I started noticing his add's on a lot of articles on 'twitter'. More on this later
Just caught an ad for Google Mobile for India...
The page has a nice interactive demo as well has a text box to type in your mobile number and start getting info on your mobile. Of course, by sending an SMS you are bound to Google, YouTube and Google Maps Terms of service.
The question is how soon is Google going to monetize this service by inserting ads. Its a no brainer if they succeed, they will mint millions tapping into the India mobile phone user base which is 4-5x India internet user base.
My workgroup in office is in the midst of a turmoil. Archaic processes, change of leadership, strained team dynamics and average business performance in these challenging times have led to the cause. We are now in the midst of a rethink exercise for the future. I think these articles from HBS are extremely useful in this situation...
Why Don't Managers Think Deeply?
Professor Jim Heskett poses this provacative question to HBS Working Knowledge readers.
The Seven Things That Surprise New CEOs
In the newly released book On Competition, professor Michael E. Porter updates his classic articles on the competitive forces that shape strategy. We excerpt a portion on advice for new CEOs, written with HBS faculty Jay W. Lorsch and Nitin Nohria.
Strategy Execution and the Balanced Scorecard
Companies often manage strategy in fits and starts, with strategy execution lost along the way. A new book by Balanced Scorecard creators Robert S. Kaplan and David P. Norton aims to make strategy a continual process.
Creating a Positive Professional Image
In today's diverse workplace, your actions and motives are constantly under scrutiny. Time to manage your own professional image before others do it for you. An interview with professor Laura Morgan Roberts.
Seven Tips for Managing Price Increases
Consumers get hit with the price-increase hammer every time they drive past a gas station. Harvard Business School professor John Quelch offers tips on how marketers can cope with inflation and consumer sticker shock.
Marketing Your Way Through a Recession
In a recession, consumers become value oriented, distributors are concerned about cash, and employees worry about their jobs. But a downturn is no time to stop spending on marketing. The key, says professor John Quelch, is to understand how the needs of your customers and partners change, and adapt your strategies to the new reality.
2900 days after Windows XP and 700 days after Office 2007 were released, my company finally decided to install them on my Machine. Now that's speed of adoption!
I currently work in a FMCG company and there was a request from a charity organization for samples. My companies has a separate manager (lets call him Co. Rep) for all such CSR initiatives and hence a separate budget. Usually, such things should be fairly routine and once the concerned head approves. But after 53 days or rather 1238 long hours action is still pending that too when
The reporting structure is as follows
Co. Head (Co. Head Secy) > Function Head > Sub Function Head (Sub Function Secy) > Sub Function Reportee
| From | To | CC | Type | Date | Time Taken (mins) | Time Taken (days) |
| Requestor | Co Rep | Intro & Proposal | 15/11/2008 20:51 | |||
| Co Rep | Co Head | Co Head Secy | Reco & Request | 15/11/2008 22:06 | 1:14:52 | 0 |
| Co Rep | Co Head Secy | Co Head | Reminder | 01/12/2008 17:20 | 379:14:00 | 11 |
| Co Head Secy | Co Rep | Co Head | Confirmation | 02/12/2008 12:22 | 19:02:00 | 2 |
| Co Rep | Co Head Secy | Co Head | Clarification | 02/12/2008 14:23 | 2:01:00 | 1 |
| Co Head | Co Rep | Function 1 Head | Recommendation | 02/12/2008 14:48 | 0:25:00 | 1 |
| Co Rep | Function 1 Head | Co Head | Reco & Request | 02/12/2008 18:39 | 3:51:00 | 1 |
| Function 1 Head | Co Rep | Sub Function 1 Head | Reco & Forward | 03/12/2008 09:44 | 15:05:29 | 2 |
| Co Rep | Sub Function 1 Head | Function 1 Head | Reco & Request | 03/12/2008 10:20 | 0:35:31 | 1 |
| Function 1 Head | Co Rep | Function 2 Head | Reco & Forward | 03/12/2008 10:26 | 0:06:00 | 1 |
| Function 2 Head | Co Rep | Sub Function 2 Head | Reco & Forward | 03/12/2008 10:48 | 0:22:00 | 1 |
| Sub Function 2 Head | Co Rep | Sub Function 2 Reportee | Clarification | 09/12/2008 12:15 | 145:27:41 | 5 |
| Co Rep | Sub Function 2 Head | Sub Function 2 Reportee | Clarification | 10/12/2008 08:45 | 20:30:12 | 2 |
| Sub Function 2 Head | Co Rep | Sub Function 2 Reportee | Clarification | 10/12/2008 10:04 | 1:19:00 | 1 |
| Co Rep | Sub Function 2 Head | Sub Function 2 Reportee | Reco | 11/12/2008 17:31 | 31:26:07 | 2 |
| Sub Function 2 Reportee | Requestor | Talk | ||||
| Sub Function 2 Reportee | Franchise Head | Sub Function 2 Head | Clarification | 02/01/2009 12:54 | 523:23:00 | 17 |
| Sub Function 2 Head | Sub Function 2 Reportee | Sub Function 2 Head | Approval | 02/01/2009 12:54 | 0:00:00 | 1 |
| Sub Function 2 Reportee | Sub Function 2 Secy | Request | 02/01/2009 12:59 | 0:05:00 | 1 | |
| Sub Function 2 Secy | Agency | Instruction | 06/01/2009 10:50 | 93:51:00 | 3 | |
| Action | Pending |
...If I were Scott Adams, I would have made a Dilbert cartoon out of this. A perfect example of how bureaucratic even private companies in India are and how much time even simple decision making takes.
The formating for this post has gone completely haywire, will rectify it in due course
On way to Peb Fort trek
From my apartment roof top/Mahim
Posts
