News from PASS Summit’14 for Business Analytics Professionals: #sqlpass #summit14


This post is a quick summary for all Business Analytics related updates that I saw at PASS Summit’14:

1. Theme of the Keynote(s)/Session(s) seemed to be around educating the community about the benefits of the NEW(er) tools. I saw demos/material for cloud-based tools like SQL databases, Azure stream analytics, Azure DocumentDB, AzureHDInsight & Azure Machine learning. The core message was pretty clear: A data professional does two things – 1) Guards data OR 2) helps to generate Insights from Data – And they will need to keep up-to-date on the new tools to future-proof their career.

Read more about this here:

2. Coming soon: Power BI will be able to connect to on-premise SSAS data sources (multi-dim & tabular).

3. Coming soon: A better experience to create Power BI dashboards.

Read more about Power BI updates here:

4. Azure Machine Learning adds a free-tier! You won’t need a credit-card/subscription to sign up for this.

5. I also saw sessions proposing new way of thinking about an architecture for “Self Service BI” and “Big Data” which might be worth following because since these are newer tools, it’s definitely worth considering an architecture that’s designed to make the most of the investments in these new tools. That’s it & I’ll leave you with a quote from James Phillips from Day 1’s keynote:

Gartner’s Hype cycle for CLOUD COMPUTING: 2008 – 2009 – 2010 – 2011


In second half of 2008, I had taken a class on Distributed systems. As a part of that class, We were asked to write a paper on the subject of our choice. I had chosen  the subject that focused on answering: How is cloud different from traditional approaches? My aim was to figure out why was CLOUD getting all the “attention”. And i chose this topic because, at that time [2008], I used to follow few blogs (including Gartner) at that time and almost all of them seemed to be “heavily promoting” cloud. So I asked myself “why is world going crazy about cloud?” “What makes cloud different from traditional approaches?” And I decided to find answers to this question and convert it into a term paper for the class. And during the term paper assignment, I got a traditional Hosting account and deployed one of my project there. And compared it with what literature on cloud computing had to say at that time. This approach was super helpful because I had a benchmark on what traditional hosting felt like and then what cloud computing enthusiast had to say about why is cloud better than traditional approaches.And after getting my head around that concept, it’s been fun following how “cloud” has evolved over time. One of the best ways to recap it is to analyze Garnter Hype cycle. To this end, Here’s a recap of where Gartner Places Cloud Computing (and its different flavors) on hype cycle from 2008, 2009, 2010 and 2011. Here’s a recap:


Gartner Hype Cycle for CLOUD COMPUTING 2008


Gartner Hype Cycle for CLOUD COMPUTING 2009

2010: (Note the presence of different flavors of cloud on the hype cycle)

Gartner Hype Cycle for CLOUD COMPUTING 2010


Gartner Hype Cycle for CLOUD COMPUTING 2011

Image Courtesy:

And That’s about it for this post. Your feedback is welcome!

And Let’s connect! I Look forward to Interacting with you on any of these people networks:

paras doshi blog on facebookparas doshi twitterparas doshi google plusparas doshi linkedin

Seven software delivery models and why software as a service (SaaS) is the future!


This is a reflection piece I thought of writing after watching a demo lecture from a cloud computing course offered at Stanford by professor Timothy Chou. URL of the demo lecture is here: Now, I would suggest you to spare 60 minutes and watch the video but If you do not want to, you can read this blog post in which I aim to summarize the lecture which was pretty much about seven software delivery models and show why SaaS (software as a service) makes sense and why it’s our future. so here we go!

There are seven software delivery models:

1. Software licensing model

2. Open source model

3. Outsourcing model

4. Hybrid Model

5. Hybrid+ Model

6. SaaS (software as a service) Model

7. Internet Model

To truly understand the models in detail, I urge you to watch the video – here I am to just going to reflect upon what I heard and so there might be gaps in what I have to say or you may not understand it completely since the discussion is brief here. Any-who, here is my reflection after watching the video on each software delivery model

(1) Software license model:  This has been the traditional way in which software companies made money. They develop a software and the model is such that if you wish to use the software, you buy license to use the software. And generally if say 10 users are going to use the software, you buy ten licenses. This is the one time cost. Also optionally you pay support charge for the software which is generally on yearly basis. It may include talking about problems in installing the software, figuring out a configuration problem, install updates/patches, etc. And also significant money is then poured in “managing” that software. And managing software requires man-power which is not cheap. Management includes making sure that software is up and running (ideally) 24×7, making sure the software gives required performance, keeping the software secure, taking backup’s, etc. And it costs money. Lots of it!

e.g.. Oracle Database. you buy an Oracle database software. you pay support money. and you invest in managing it. So this was software license model for you. Now let’s move on to next model.

(2) Open source model: Here the software is “free” but you need money to manage the software. optionally you can opt in to receive support.

(3) Outsourcing model: In this model, the software is bought with the one time fee. optionally support cost is paid year by year. But the management work is outsourced. in other words, the management side of the software is performed by some other company. so how does it help? and more importantly, how does it save money?  As we had discussed earlier that managing the software requires man power is not cheap. So say a company in USA hires a software administrator to manage the software for them. He would be paid $100k per year to do so. Now what if we can bring this cost down. This is exactly what companies that accept outsourcing work do. They hire an individual in a country where system administrator’s are paid $50k per year (or even less!) and thus they bring the cost down. And obviously it is not as simple as I said but you get my point, don’t you!?

e.g.  IBM accepts outsourcing work. Infosys (Indian IT giant) accepts outsourcing work. And there is a long list of companies that does this work.

(4) Hybrid Model: Here the company that sells the software also manages it for the client. yes! they do that. The client may not want to have the data center on their site so the software company sets up the datacenter for the client and manages it too for the client. Client may also choose to have the datacenter on their site but still software is managed by the company who sold it. it saves money – you may ask how?! For this I’ll say what professor had to say “standardize, specialize and repeat”. if you do not understand what it means – watch the video!

(5) Hybrid+ Model: It is the hybrid model with simplified cost structure. Just compare the values for the hybrid and hybrid+ and I believe you are smart to understand the difference! I believe that all readers of my blog are smart!

(6) SaaS: Now it is the extension of the hybrid+ model where the client does not get to choose where to run the software. They just get the software via Internet with no questions asked!! Every other detail is managed by the software vendor. All customer needs to do is to sign up for the service and start consuming it via Internet. End of story! Now why is SaaS our future. Well, as you can see from the tables itself that it lets the companies save money. secondly, it let’s the companies focus on what they do best and now worry much about the compute infrastructure that they may need to support their business. Now, for a mid size firm, SaaS does not involve upfront investment. Yes! you subscribe for a software for a month and then you do not like, you can simply say bye-bye to the SaaS vendor or simply, switch the vendor. I do realize that it’s not smooth but at least it’s smoother as compared to traditional models. And moreover, we see SaaS vendors that specialize in particular software. So there may exist a SaaS vendor who specialize in CRM for hospitals. yes! CRM’s only for hospitals. so hospitals that are looking to automate their processes can just give it a spin. End of story! the beauty of it all being that it simplifies the process and it is more effective.

e.g.; Just search “software as a service” and you will find a list of companies that do this today. Also the video has a slide that has a list of all companies that are into SaaS – so watch the video!

(7) Internet Model: Instead of trying to write about it. I am just going to say “Google”. Do you pay Google to use the search engine? No, right?! is Google a Not for profit organization? No! Then, how do they make money. The answer is advertisements. Internet services (or should I call them businesses) like Facebook, Google, Gmail, etc rely on advertisement and thus the cost of the software is not charged from the user.

Now, if you love seeing things from money perspective, here it is:

For first four Models:

Software LicenseOpen sourceOutsourcingHybrid
Software$5000/user/year(One Time)$0/user/year$5000/user/year(One Time)$5000/user/year(One Time)

For remaining three models:

Software +Support +Management$300/user/Month$150/user/MonthAdvertisement. No cost from the end-user perspective.

Disclaimer: values are entered in each Model just for the sake of comparing different models and it may not necessarily be true  for all real world scenario’s.

So yes. That’s it. This was my reflection piece. Do post your comments/feedback/suggestion. And yes, watch the video!