DCSIMG
BI & Cloud Computing - Ella Maschiach's BI Blog

Ella Maschiach's BI Blog

BI, Olap Technologies, Tools, System Analysis and Design

News

About Ella Maschiach

Business Inteligence

BI & Cloud Computing

Well I guess the future is really up in the cloud...

The last strategic move for Panorama is joining Google and offering a BI Analytics tool to work with Google Docs - PowerApps. But that's old news by now. GoodData has recently gotten funding for their BI in the cloud, giving you a complete platform for storing and analyzing your data. Business Objects offers "OnDemand" another platform that enables you to share Crystal Reports over the web. The list goes on, with other companies trying to get a piece of the pie.

So maybe that's what pushed Microsoft from just enabling you to store data on its SSDS (SQL Server Data Services) and add also Data Mining to the cloud... The SQL Server Data Mining Team has just put up a site to preview the abilities you could have for data mining over the web. The site currently has Adventure Works DW sample data and also enables you to load a CSV file of your own, for you to work on and experiment:

 

The visual effects are wonderful and should really help you better understand what potential lies in your data.

You could see the Key Influencers for cars (according to the AW Sample Data):

 

Or predict the sales for the following period:

Data Mining just got a whole lot more interesting for me - check it out for yourself!

Comments

Navi said:

hi Ella,

I was wondering if you, and other customers of ours would like to see such capabilities as part of the PowerApps offering from Panorama (i.e - datamining, forecasting).

I was also wondering if using a tool like what Microsoft offers here, with no data management, storage, etc, is feasible for the enterprise?

I would love to hear more.

# September 23, 2008 3:15 PM

Ella Maschiach said:

Hi Navi,

Interesting to know that Panorama reads me… :)

I admit I would be interested in getting capabilities of Data Mining from Panorama, but I don't think my organization will switch to PowerApps very soon. My customers use Excel and I think that will be the case for a bit longer, though I wouldn't want to predict the future in the TA Municipality.

I think that if Microsoft (or Panorama for that matter), would enable me to load an Excel of mine to the internet and further analyze it there, I would have been more than happy. That's even if it wasn't stored in the cloud and I would save the result on my PC.

But all of the above is just my personal opinion and does not, in any way, reflect any opinions of the Tel Aviv Municipality or the people working in it.

All the best,

Ella

# September 24, 2008 3:29 AM

Bogdan Crivat said:

Hello, Ella

I noticed, in your comment response, that you would like to have the ability to perform the analytics for Excel. First, the Cloud data mining project also includes an Excel add-in that connects directly to the cloud servers, using web services (free, zero installation effort, zero configuration).

If you need more control or to manage/store your data mining models, you can do this  with Analysis Services  and the free full Data Mining add-ins for Excel which are available here: www.microsoft.com/.../details.aspx

Besides the Table Analysis Tools against your own server, this also includes a rich data mining client for Excel

Regards

bogdan

# September 25, 2008 11:30 PM

Ella Maschiach said:

Hi Bogdan,

Thank you for visiting, it's quite an honor! I'll definitely check out the links.

Regards,

Ella

# September 26, 2008 5:25 AM

PedroCGD said:

hi Ella!

Very good post, and very good the data mining world...

I'm fascinated about data mining, it's the real intelligence of BI!!!

Bye!!

pedro

# September 30, 2008 8:56 AM

Joan Benedict said:

It was rather interesting for me to read that article. Thanks for it. I like such themes and everything connected to this matter. I definitely want to read more on this site soon. BTW, rather good design this site has, but what  do you think about changing it every few months?

Joan Benedict

<a href="escort'>www.baccaratgirls.com/">escort service in London</a>

# May 4, 2010 2:52 AM

Farzad said:

Hi Ella

I am a BI Analysts and OLAP Developer and DBA on Banking Systems . I need some white paper about the BI and CLOUD COMPUTING architucture for may presentation . unfortunately , I can not fine a suitable resource to extract these concepts. is t possible to help me to find that or guide me what can I do ?

many thank you .

Farzad

# November 30, 2010 6:34 AM

Ella Maschiach said:

Hi Farzad,

I couldn't find anything specific. I recommend you look ask for more assistance on the SQL Azure Forum:
social.msdn.microsoft.com/.../threads

All the best,

Ella

# December 1, 2010 2:42 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 


Enter the numbers above: