SQL Server for the Clouds

image

http://www.sqlserverdatamining.com/cloud/

Is Microsoft Really going the cloud way ?

Thanks to a post on www.analyticbridge.com which brought this to my notice.

You load data from a local .csv file.I used the Microsoft demo dataset. Then go in series of the top tab. All screenshots belong to Microsoft Corp.

image

image

image

Want more ? Visit http://www.sqlserverdatamining.com/cloud/

 

Good Ole Microsoft . And God Bless Bill and Jerry (from the ads!)

Yahoo Finance Analysis

Sector Chosen -Indian Outsourcing Sector since past two years compared to Benchmark Indices in both India and US

Interestingly the sector destroyed more value even after compensating for Financial Sector Recent Crisis -Partly because it suffered from currency uncertainity ,and macro economic uncertainities of two countries India and US. GE which did a deal to sell a big stake in Industry leader earlier at 12 USD per share seems to have a made a wise bet, and so did British Airways which exited at time of WNS’s IPO. The rest of investors who have either invested long or short seemed to have lost value. With new added economic uncertainities , and political backlash to unfettered tax break enabled offshoring – Are India’s outsourcing glory days over ? Or is it just a maturing of the Industry with the hype factor taken out of the P/E Multiples of Indian Outsourcing Companies.

image

Screen shot courtesy of Yahoo Finance – which remains the leader in beautiful financial graphical tools for finance at http://finance.yahoo.com

Online Analytics -June Dershewitz

June Dershewitz

One of World’s Leading and Well Known Authority on Web Analytics

1) What’s the latest trend you see in Online Analytics over the next year and next three to five years.

I strongly believe that web analytics is on its way to becoming business analytics. In the early days we were solely focused on analyzing clickstream data, but in recent years we’ve relaxed our definition of web analytics to include things like voice of customer
and offline outcome data and multivariate testing. More and more I hear people talking about how online customer interaction fits in with the overall goals of the business rather than as an isolated island of activity. In the future I think we’ll see less of a distinction
between traditional business intelligence and what we currently consider to be the separate field of web analytics.

2) Tell us how you came in this field of work, and what factors made
you succeed.

I entered the field of web analytics in 1999. Like many people who got their start at that time, it happened totally by chance. I had applied for a job as a web developer, but the interviewer thought I’d be perfect for another open position – as a web analyst. I took it just to see what it was like. Here it is a decade later and I’m still in web analytics – so I guess you could say it worked out.

Why is web analytics is a natural match for me? Well, I’ve always felt quite comfortable

Continue reading “Online Analytics -June Dershewitz”

R and Google Docs

I was working on R and generating a huge number of graphs. These then needed to be uploaded to Google Docs for Collobrative working. A bit taxed, I asked a query on the

R Help list r-help@r-project.org

My fears were right – there was no such package. But then a great programming wizard Duncan from Omegahat wrote back that he has just developed a package to do that.

Hallejuah !

Cloud computing /Google Docs say hello to the R Statistics package.

R say hello to the cloud.

R can be used for data mining as well (but it is dependent on RAM as it works in RAM memory).It is an ideal fit for Statistics Packages as a SaaS on something like Amazon EC2 given high annual costs of  other stats packages, and local hardware needed.

I first wrote about this fit in the Ohri Framework which talks of the fit of cloud computing and open source statistics.R is free and has thousands of developers.

Anyways ,Download the RGoogleDocs package from below site

http://www.omegahat.org/RGoogleDocs/

"

The RGoogleDocs package

Last Release: 0.1-0 (24 Sep 2008)

This package is an example of using the RCurl and XML packages to quickly develop an interface to the Google Documents API. It was written to test RCurl and also to illustrate how to use these tools with modern Web applications. Google Documents is a REST "application" and so this is an example of using R to interface to that.

The package allows you to get a list of the documents and details about each of them, download the contents of a document, remove a document, and upload a document, even binary files.

There is some documentation for the package at this point in the form of a "user’s guide" (or in PDF form). These are included with the package.

If you want to upload binary files, you will want to install a beta version of the RCurl package. Duncan Temple Lang <duncan@wald.ucdavis.edu> Last modified: Wed Sep 24 11:51:45 PDT 2008

"

OT:Books,Copyrights and Career Articles

Here is a list of articles written by me for a Website circa Jan-March 2008 during my free lance days. I accepted payment for them (400 USD for ten articles) from a senior Alumnus from my B school, so the copyright belongs to this website.

I tried combining into a free -ebook , but it seems once you give away your product, you really give it away.Even from yourself.

Anyway, if you are a student, or have a young teenager wondering which career road to take, these articles might just help you. Not most of the context is in India, but they can also be used with some customization for other countries.

They are March 2008 dated , so not updated for recent Wall Street events 🙂

http://www.coolavenues.com/know/gm/ajay-bpo-india-1.php


http://www.coolavenues.com/mbasp/ajay-scm-1.php


http://www.coolavenues.com/mbasp/ajayohri-ranking-1.php


http://www.coolavenues.com/mbasp/ajay-internet-1.php


www.coolavenues.com/mbasp/ajay-automobile-1.php


 

www.coolavenues.com/mbasp/ajay-fmcg-1.php


www.coolavenues.com/mbasp/ajay-coaching-1.php


www.coolavenues.com/mbasp/ajay-finance-1.php


www.coolavenues.com/mbasp/ajay-summer-internship-1.php


www.coolavenues.com/mbasp/ajay-equity-1.php


www.coolavenues.com/mbasp/ajay-career-1.php

However if you are in the need for some poetry -here are some books for me.

The royalty is Rs 1 for me, but the books are between 3 and 4 USD.Took me

six years to write. But this time - I kept the Copyright :)

http://pothi.com/pothi/book/ajay-ohri-corporate-poetry


http://pothi.com/pothi/book/ajay-ohri-case-i-dont-see-you-again

 

Just remember to check fineprint of the wiki,or a website community regarding copyright

when you are contributing something including code/articles/opinions. This issue came up on the SAS -L

list also recently.

Sometimes you end up just giving away your work to people without knowing it is gone forever.

 

Flavours of Search Engines

Yes there is life outside Google in Search.

Consider the following search engines –

1) www.Indeed.com – For Jobs . I tested it for a month and used a RSS feed to get results in My Yahoo reader.

Excellent,convenient ,better than any job or search engine (even  google.com for jobs)

image

2) www.PipL.com -For People search -this is quite good. Use it to research potential clients, bosses,employees or even yourself.

image

3) www.Guruji.com The India based search engine .Divides categories into most searched categories.Also used user feedback to iterate and improve results.

image

4) www.mp3.baidu.com One of the most widely used HTTP search engines for .Mp3 files (other than Torrent or FTP files ). However it is in Chinese and legality of downloads is not sure either.

image

5) www.Cuil.com Pronounced Cool. It is started by Ex Google Inc people. Good featues include design, auto suggest, very good layout of results. Still building up its index of cached web pages (thats the database from which search engines retrrive information), but stilll good enough for most mainstream queries. Also uses a suggest site faeture to jumpstart the search index.

image

image

6) www.Ask.com Changing Skins , Categoried Search,Layered Output.

It is a very innovative search engine.

image

But Google still rules . And with the Yahoo search deals – it will capture 90 % of search market.Never before in the history of man, has so many searches by so few websites.

Unless Microsoft -Advertising clients stop the merger.The irony of Microsoft petioning another company for monopoly – well thats the technology world for you !!

Note-Screenshots belong to respective websites. Visit them for a personal take.

Tip: Google Docs for backup during Travel

My standard procedure while traveling is to upload a copy of E tickets, scanned copis of passport and Visas ,Insurance documents, identification on Google Docs. Share them with my family. It allows access from anywhere where there is an internet so quite useful if traveling and you want to back up travel documents safely.(Note Some details hidden)

image DOCUMENTS

image GRAPHS/SPREADSHEET

For important meeting especially bulky presentations, I upload to Google docs, to avoid/back up hardware failure. Also loading them in browser is faster and looks better during the meeting (besides getting a wow factor)

http://docs.google.com

Only problem- Google Docs doesnot support PDF uploads more than 10 mb. This is especially a problem when creating a large number of graphs using R, as they can be heavy. The workaround is splitting the PDF (if it is a normal document) , or Modifying R for pictures per page to reduce size.

 

image PDFimage PPT

So Try uploading a sample document to www.docs.google.com today and get surprsied.

For creating a free collobrative space between team members globally ,similarly check out http://sites.google.com .

If you want you can even build your corporate intranet or knowledge sharing wiki here , and track usage statistics through Google Analytics.

image

Cost is free. No ads. Since Google earns so much from ads and now from phones, this is their way of changing the way the world works better.

ps You can download all data/maintain offline copies using Google Gears and click delete in less than a minute if you need to shut it down.