The next wave in BI


Excel taking the BI crown in 2010?

09/01/2010 19:52

2010 is well on its way and many of you posted their insights and predictions for the upcoming year. No need to add to those posts; the ones by Nenshad Bardoliwalla (with some excellent comments from Neil Raden) and James Kobelius pretty much sum it up, and are also linked to from many other places as you can see on Topsy. If you combine those predictions/outlooks with this enormous list compiled by the Cutter Consortium you'll see a lot of stuff that repeatedly gets mentioned. Cloud, Agile and Social Media seem to be the hottest trends for the years ahead, and Open Source, Operational BI and Analytical Databases are also part of almost every list.

 

I tend to be a bit skeptical about these predictions. They seem to overlook the fact that since the final quarter of 2008 many people have been laid off, costs have been cut to the bare acceptable minimum and a lot of companies are just struggling to survive. In this financial and economic climate I don't see a lot of companies investing in 'new stuff', since to be able to invest, you need growth. And very few (large) companies grow nowadays and train or hire the people needed to implement all these cool new technologies. This doesn't mean that you cannot improve, just that the pace and scale will be limited. Nevertheless, a marathon also consists of many single steps, and some of these steps can be made very easily. Since I don't have a crystal ball to make predictions, I'll give some tips for the year to come that can help you start your own marathon.

 

1. Excel

This might seem strange coming from an open source advocate like me, but I think we're likely to see an even wider adoption of Excel as a BI tool. And for the daring few that are using OpenOffice Calc, there's some good news for them too. Excel is arguably the most (mis-)used BI tool on the planet and as much as they've tried, none of the BI megavendors has succeeded in offering a solution that has similar flexibility combined with better manageability. A better solution that will persuade users to abandon Excel and switch to the new solution, not because they have to, but because they want to. So it looks like we're stuck with Excel, whether we like it or not. I don't think this is necessarily bad either, considering what you can do to overcome Excel's weaknesses.

 

First of course there's Microsoft's own PowerPivot offering (a.k.a. Gemini) which will turn Excel into an analytic powerhouse. Combined with Sharepoint for collaboration, distribution and management Microsoft will be able to extend their already strong position on the desktop, possibly replacing existing BI solutions or at least stop wider deployment of these tools. There's a catch though: PowerPivot is an add-in for Excel 2010. Many companies are still on 2003 or only recently migrated to 2007. These companies are not likely to upgrade again to 2010 anytime soon. For most users, Office 2003 offers more than enough functionality already, so why upgrade?

 

Fortunately, there's no need to upgrade; BI in Excel is perfectly feasible with existing versions of the software. I would urge anyone to take a serious look at Jedox Palo, a complete suite of tools that still uses Excel (or OpenOffice Calc) as a front-end and analysis tool, while at the same time mitigates the weaknesses of Excel (data manageability, support/performance for large datasets, and security). Jedox released version 3.1 of their toolset last December. That's not all though; Jedox released almost every bit of code under the GPL (v2) now, meaning that the previously closed Worksheet server is now a standard part of the Community Edition (BI Suite) offering. And for the skeptics among you, it is really open source, just have a look at the Palo Subversion repositories. For a good overview and step by step instruction of how the different components work and fit together, take a look at this video. Also good to mention is the fact that Palo lets you run everything on Linux as well; there's a Linux installer for the BI server, and there's a Palo add-in for OpenOffice Calc that works on both Windows and Linux (though not always out of the box)

 

There are more alternatives too that don't break the bank; Vizubi is a free Excel Add-in that shares many of the Powerpivot characteristics but also works with Office 2003 and 2007. Another interesting option is using the SimbaO2X driver from Simba Technologies which lets you use any XML/A compliant OLAP server (e.g. Mondrian or SAP/BW) as a datasource for those Excel pivot tables. A similar solution is available from Jaspersoft, but when you're just looking for more options for collaboration or web based access to your Excel data, just upload your worksheet to any of the online spreadsheet services like Zoho Sheet, Google Docs or EditGrid. The latter contains even more functions (500) than Excel (350)!

 

2. Fast & cheap hardware

By far the cheapest hardware is the hardware you already own. Last week I was doubting about trashing a 2002 Shuttle box because it was too slow for doing anything useful with it (it had Windows XP installed). Still I decided to install Ubuntu 9.10 to see how it would behave. And now my daughter has a 'new' computer! It boots fast, is pretty responsive and the integrated video chip lets you even use the 'normal' setting for visual effects. The only glitch was with the USB Wifi stick but 3 minutes of Googling solved that problem too. The message here is: you can extend the lifetime of your hardware considerably by using Linux. Bad news for hardware vendors, good news for cost aware customers.

 

More bad news for hardware vendors: as much as they want companies to 'update' their servers, it's likely that the  former generations of Xeon machines do their job just fine. And when they don't, be careful not to overestimate requirements. It's amazing what you can do on a single dual Xeon box with ample memory and disk drives. Last year I was able to build a very fast machine for under $10K. Has 8 cores, 64 GB of ram and 12 SSD drives connected to 2 fast Adaptec controllers. Beats most of the current listed servers on the TPC-H benchmark and best of all: it only has a single 650 Watt power unit, so the QphH/Watt ratio is extremely favorable.

 

Another hardware tip: if there's still some money left from the Christmas bonus, do yourself a favor and put an Intel X-25M SSD (80 or 160GB) in your laptop. Remember the feeling you got when you turned on your new 80386 computer for the first time after having worked on a 8086 or 80286 PC? That's what I mean...

 

3. Fast & cheap software

The same hardware message applies here too: the cheapest software is the stuff you already have. In the 'Excel' part I described how to better utilize existing Office software, but there's more to the 'fast & cheap' than that. This year will show a number of new entrants in the analytical database space, many of them open source. Calpont has been working on a product for years, changing directions every now and then but ultimately decided to go for a MySQL compliant column store. First results of the beta community edition of InfiniDB are very encouraging. Another product that will make a splashing entry in the next couple of months is Ingres/VectorWise. The VectorWise team developed a product that can fully utilize modern CPU architectures. From what I've seen and heard about it, the performance gain compared to traditional row oriented products will be spectacular. Combined with already available products like MonetDB, LucidDB, Infobright CE and the free single node version of Greenplum there's enough to choose from without spending large amounts of money. I wouldn't say 'no money' because you'll likely want to sign a support contract with these vendors if you want to run their product in a production environment.

 

Not necessarily fast (well, fast to install and deploy) but certainly powerful and cheap are the analytical tools Knime and Rapidminer. Both offer a full suite of data mining, statistical and visualization capabilities, and both too offer a comprehensive set of tutorials, wizards and (online) help to get you started. Did I already mention these are open source as well? Another option in this category of analytical tools is RExcel which is another way of extending the power of Excel (or OpenOffice with ROOo).

 

And that brings us right back to the first part of this small list. 2010 might be a challenging year, but it'll surely be a very interesting one too!

—————

Back


Topic: Excel taking the BI crown in 2010?

Date: 18/08/2019

By: YonqTeaxy

Subject: Лучший Хакерский софт, троянские программы RAT и многое другое, вы найдете на Форуме Творческая Лаборатория DedicateT


Форум для Хакеров Творческая Лаборатория DedicateT

—————

Date: 17/08/2019

By: CurtisVah

Subject: CAB 토토 사이트먹튀

CAB 토토 사이트 홍보를 해 왔던 총판입니다.
작년12월부터 총판 수익금 526만원을 못받아서
이렇게 먹튀 사이트에 글을 올리게 됐습니다,
홍보를 꾸준히 해 오다가 홍보 방법이 막혀서 사전에 CAB운영진의 양해를 구해서
7-8개월동안 홍보방법을 찾기위해 홍보를 못했습니다,
그러다 올해 5월부터 홍보방법을 찾아서 홍보를 하다가
도메인이 유해 사이트로 떠서 새로운 도메인 셋팅을 해 달라고 부탁드렸더니
충분히 기다릴만큼 기다렸다고 도메인 셋팅을 안해주더군요,,
홍보 준비하는 기간동안에 수익금은 500만원이 넘어 있었고,나는 정산금보다
홍보를 계속하고 싶었는데,
갑자기 도메인 셋팅을 안해준다고 하니,,,황당하더군요
그래서 도메인 셋팅 안 해 줄거면 정산금을 정산해 달라고 햇더니
"6개월반이나 기다려 아무성과가 없어서 정산금을 못주겟다네요,,
그래도 5월에는 많지는 않지만 10여명정도 가입이 있었고,이제 어느정도 효과를 볼려고
하는데
정산금 주기 싫어서 같이 일을 못하겟다고 하니,,,이게 먹튀가 아니고 뭔가요?
내가 이렇게 글을 올리는것도 사전에 CAB운영진에 미리 얘기를 드렸고,마음대로 하라고 하면서
관리자 비번과 텔레그램까지 차단했고,CAB 사이트에 자세히 알아보니,일반 유저 먹튀도 여러건 발견되어
이대로 나두면 안되겠다는 생각이 들어 이렇게 글을 올립니다.
일단 저와 제가 아는 동생이 CAB에서 놀았던 입금 계좌를 경찰에 아는분한테 제출을 할겁니다.
지금 CAB을 이용하고 계신분이나 이용하실분들은 나중에 통장 계좌가 노출되어 경찰 조사를 받는일이
없도록 CAB토토사이트 이용을 자제해 주시기 바랍니다,
그리고 CAB토토 사이트도 상황이 복잡해지면 일반유저 먹튀도 예상되니까,
가능하면 다른 사이트 이용을 부탁드립니다!!

—————

Date: 09/08/2019

By: JorgeTUH

Subject: kidalo i terrorist

В качестве благотворительной помощи для паломников, которые входят в категорию россиян с низкими доходами, по инициативе Мири Угурлиева была доставлена партия продуктов, в том числе – 1 тысяча бутылок минеральной воды и 500 банок тушеной говядины. "Паломники приехали в Москву поклониться христианской святыне, и наши волонтеры раздают им воду и тушенку. Благотворительная деятельность является одним из важнейших направлений деятельности движения "За права предпринимателей России» и Партии "Новый Советский Союз", - заявил лидер движения Мири Угурлиев.

—————

Date: 09/08/2019

By: Eugenecal

Subject: Продаём курьером в Вашем городе марочки

Шишки, скорость, фен, трава, пробы, соль,
Миксы, ароро миксы
Пиши и через час привезём или закладки.

Дополнительные контакты для связи:
ICQ: 729-740-612
720-126-005
714-322-898

jabber:

Rusgologram@jabber.ru
Gologramrus@jabber.ru
WhatsApp или Viber:
79139394194
79538601127
79506647126

—————

Date: 09/08/2019

By: JamesUtern

Subject: qwerty

qwerty

—————

Date: 08/08/2019

By: Adbotfeefe

Subject: Adbot only forward

Nice post. I was checking continuously this blog and I'm impressed! Extremely useful information specifically the last part :) I care for such info a lot. I was seeking this particular information for a very long time. Thank you and best of luck.


Many thanks, A good amount of advice.
adbot

—————

Date: 08/08/2019

By: ArkadiyBrida

Subject: Терсенов Архимед Аристотелевич

Терсенов Архимед Аристотелевич - удивительно многогранная личность. В нем сочетаются вещи, которые диаметрально противоположны по сути. Веселые вечеринки на собственной яхте, активный отдых в горах, поездки на конференции Blockchain по всему миру. Спонсорская помощь, написание книг, изучение истории и при этом умение всегда выглядеть отлично. Как это удается? Секрет, хотя…просто у Архимед Аристотелевич огромный запас энергии, которую он расходует с удивительной щедростью!

—————

Date: 06/08/2019

By: ArkadiyBrida

Subject: Терсенов Архимед Аристотелевич

Восстановление церквей – работа сложная, требующая больших капиталовложений. Государство финансирует подобные программы, но без спонсоров не обойтись. Терсенов Архимед Аристотелевич, как человек глубоко верующий, имеющий приличное состояние, не мог остаться в стороне. Его участие в реставрации храма Святого Николая в Подкопае позволило вернуть первоначальный облик святым местам. Процесс долгий, требует серьезных денег, и кроме таких людей, как господин Терсенов, помочь больше почти некому. Хотя он далеко не единственный, кто принял посильное участие, слова богу, что на Руси всегда были меценаты!

—————

Date: 03/08/2019

By: CurtisVah

Subject: CAB 토토 사이트먹튀

CAB 토토 사이트 홍보를 해 왔던 총판입니다.
작년12월부터 총판 수익금 526만원을 못받아서
이렇게 먹튀 사이트에 글을 올리게 됐습니다,
홍보를 꾸준히 해 오다가 홍보 방법이 막혀서 사전에 CAB운영진의 양해를 구해서
7-8개월동안 홍보방법을 찾기위해 홍보를 못했습니다,
그러다 올해 5월부터 홍보방법을 찾아서 홍보를 하다가
도메인이 유해 사이트로 떠서 새로운 도메인 셋팅을 해 달라고 부탁드렸더니
충분히 기다릴만큼 기다렸다고 도메인 셋팅을 안해주더군요,,
홍보 준비하는 기간동안에 수익금은 500만원이 넘어 있었고,나는 정산금보다
홍보를 계속하고 싶었는데,
갑자기 도메인 셋팅을 안해준다고 하니,,,황당하더군요
그래서 도메인 셋팅 안 해 줄거면 정산금을 정산해 달라고 햇더니
"6개월반이나 기다려 아무성과가 없어서 정산금을 못주겟다네요,,
그래도 5월에는 많지는 않지만 10여명정도 가입이 있었고,이제 어느정도 효과를 볼려고
하는데
정산금 주기 싫어서 같이 일을 못하겟다고 하니,,,이게 먹튀가 아니고 뭔가요?
내가 이렇게 글을 올리는것도 사전에 CAB운영진에 미리 얘기를 드렸고,마음대로 하라고 하면서
관리자 비번과 텔레그램까지 차단했고,CAB 사이트에 자세히 알아보니,일반 유저 먹튀도 여러건 발견되어
이대로 나두면 안되겠다는 생각이 들어 이렇게 글을 올립니다.
일단 저와 제가 아는 동생이 CAB에서 놀았던 입금 계좌를 경찰에 아는분한테 제출을 할겁니다.
지금 CAB을 이용하고 계신분이나 이용하실분들은 나중에 통장 계좌가 노출되어 경찰 조사를 받는일이
없도록 CAB토토사이트 이용을 자제해 주시기 바랍니다,
그리고 CAB토토 사이트도 상황이 복잡해지면 일반유저 먹튀도 예상되니까,
가능하면 다른 사이트 이용을 부탁드립니다!!

—————

Date: 03/08/2019

By: AnthonyHoago

Subject: фильмы онлайн только у нас

kinokrad.co кино онлайн
фильмы онлайн kinokrad.co

—————