azure cloud Linux microsoft olap patent SSAS

Microsoft and Linux and the Cloud

I read this week that Microsoft is targeting even more companies in its patent infringment case against Linux. This time it is HTC they are going after who makes smartphones. Microsoft is targeting the Android phone OS that HTC uses in some of its phones. Android is of course made by Google, a huge competitor to Microsoft. Read more…

This week I have been learning the latest parts of Analysis Services on SQL Server 2008. This is a powerful piece of software to create the basis of any company’s BI solution. To learn the basics about Analysis Services have a look at the tutorial Technet SQL Server Analysis Services Tutorial. Currently SSAS isn’t part of the SQL Azure platform but I’m sure someone is working on it. Nothing stopping you from using Amazon and putting your SQL Server in the cloud there. Or using our services to provide you with the information you are looking for.

I find the SSAS not quite up to standard of Cognos or Business Objects tool set. But those tool sets are very mature and typically used by only the largest companies. SSAS could be used by a medium sized company with a Excel front end to manipulate the pivot tables. An alternate client solution is to use the free Microstrategy Reporting Suite. This is fully featured and has most of the bells and whistles anybody would need.

Keeping on this topic I have noted some companies are building BI solutions when there is no need. Perhaps it is the hype or mis-information that fools some into thinking that a full blown BI solution is needed. With the output being just a number of reports – I wouldn’t recommend a BI solution. BI means OLAP, and whilst a OLAP system will generate reports, the real purpose is to allow dynamic discovery – hence the OL in OnLine. If nobody is doing that then don’t build cubes and don’t install clients. You’re wasting money. Any consultant worth his lunch should tell you that. Well, at least I would.

My collegues and I at Chameeya take your requirements, analyse them and come back with the solution which best fits your needs. If you have larger needs in the future we will take this into account and provide a solution that will scale up or be open to have new modules added easily. If you really do need BI then we’ll happily build it for you, but in my experience most customers don’t need it.
Now I’ve got to read through the upgrade information for Linux Ubuntu 10.04. No matter what Microsoft does, Linux is rock solid and will always run my network.