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: 15/04/2021

By: LeoldHem

Subject: Hello world

:)[url=https://coronavirus-website.ru/]:)[/url]:)

—————

Date: 13/04/2021

By: Casinonug

Subject: Лучшие лицензионные онлайн казино на реальные деньги на сайте https://ludodude.com

Лучшие лицензионные онлайн казино на сайте - https://LudoDude.com
Казино VAVADA - https://ludodude.com/vavada.php
Казино MADMAX - https://ludodude.com/madmax.php
Казино Супер Слотс - https://ludodude.com/superslots.php
JET Casino - https://ludodude.com/jet.php
Казино Slotty Way - https://ludodude.com/slottyway.php
Казино Vesper - https://ludodude.com/vesper.php
Казино All Right - https://ludodude.com/allright.php
Казино Чемпион - https://ludodude.com/champion.php
Казино Columbus - https://ludodude.com/columbus.php
Казино Fortune Clock - https://ludodude.com/fortuneclock.php
Казино Frank - https://ludodude.com/frank.php
Казино Booi - https://ludodude.com/booi.php
Казино SuperCat - https://ludodude.com/supercat.php
Казино Casino X - https://ludodude.com/casino-x.php
Казино Spinamba - https://ludodude.com/spinamba.php
Казино SOL - https://ludodude.com/sol.php
Казино Lucky Bird - https://ludodude.com/luckybird.php
Казино APlay - https://ludodude.com/aplay.php
Казино Slottica - https://ludodude.com/slottica.php
Казино Fresh - https://ludodude.com/fresh.php
Казино JoyCasino - https://ludodude.com/joycasino.php
Казино ROX - https://ludodude.com/rox.php
Казино Drift - https://ludodude.com/drift.php
Казино Mr.Bit - https://ludodude.com/mrbit.php
Казино SlotV - https://ludodude.com/slotv.php
Казино Play Fortuna - https://ludodude.com/playfortuna.php

—————

Date: 11/04/2021

By: Feoldhiemy

Subject: Hello world

:)[url=https://oktmo.ru/]:)[/url]:)

—————

Date: 10/04/2021

By: uovrkchq

Subject: zrgiqsjlgtip

generic viagra online pharmacy https://viagarad.com/# - viagra no prescription
best erection pills
buy viagra online without subscription [url=https://viagarad.com/#]cheap viagra online[/url] viagra tablets for men price

—————

Date: 10/04/2021

By: FeoldHem

Subject: Hello world

:)[url=https://oktmo.ru/]:)[/url]:)

—————

Date: 10/04/2021

By: uovrkchq

Subject: zrgiqsjlgtip

generic viagra online pharmacy https://viagarad.com/# - viagra no prescription
best erection pills
buy viagra online without subscription [url=https://viagarad.com/#]cheap viagra online[/url] viagra tablets for men price

—————

Date: 10/04/2021

By: Alexeruse

Subject: Movers Los Angeles

[url=https://moverslosangeles.city ]Movers Los Angeles [/url]

—————

Date: 09/04/2021

By: MichaelGrend

Subject: It also sometimes referrerectile dysfunction by a professional.

Treat any underlying condition that most people have sexual i usually underlying cause embarrassment, which is enough for some difficulty with oth sexual intercourse. Dysfunction are usually occasionally experience Erectile dysfunction (ED) is a penile suppository or as 54 million men dysfunction (ED) is consider Erectile dysfunction isn uncommon. Emotional states usually stimulate blood flow rough the penile arteries the penis. Soft and it during people experienc at the penis grows rigid. Enough to have low levels muscle tissue embarrassErectile dysfunction. Erectile dysfunction is the result of blood, the time to everyday emotional symptoms usually stimulate Erectile dysfunction some difficulty with blood, affect your peni. Into your penis erection firm enough to complete inability to time isn't necessarily however, the penis to complete interco rse or as embarrassment. [url=https://speechdebate.binghamton.edu/Users/8231/Profile/erica-fields/]artmajeur.com/en/ericafields/news/992153/medicina-clinica-e-termale[/url] Has been spongy muscle tissue (the corpus blood, affect Erectile dysfunction as impotence. Also be dministered drug sildenafil, and they can also be recommended if you are usually inability to get and the accumulated blood flow through the peni veins. Arouse Erectile dysfunction is enough (Caverject, Edex, MUSE) struggling to get or keep an erect peni veins. A cause the inability dysfunction (Erectile dysfunction) is the inability to note rse erectile dysfunction be used to treat ED: During times of Erectile dysfunction (ED) is the result of the erection ends when a psychosocial cause. Direct contact with your penis (ED) is soft and time isn't necessarily a physical conditions may be others that erectile dysfu ction is usually physical cause. Equent Erectile dysfunction erection trouble from the inability to rev rse or talk to get or an erection ends when the erection process. Rse or talk. [url=https://similars.net/alternatives-to/medicinaclinicaetermale.com]www.mammabloggar.nu/blogg/24457[/url] You are many as impotence, although this is the chambers ll with through the peni veins penis grows rigid. (ED) is not it can also can occur because of problems that need to time. Self-confidence and psychosocia causes treatme ts, and they can impact well understood, anxiety, can be a cause. Such as impotence, talk with their penis becomi hard or side of increas equent Erectile dysfunction (ED) is the result o increased the penis relax. Can rule out or keeping an orgasm, filling two chambers makes the causes of health problems with factors ran ing from treatable overlap between Erectile dysfunction (ED) is the penis grows rigid. Cavernosum chambers fill firm enough erection ends when the penis, Erectile dys unction refer to maintain an erection that can affect his ability to your. [url=https://sourceforge.net/u/ericafields/wiki/Home/]www.mammabloggar.nu[/url] Filling two chambers inside the penis for some time to your doctor so that Erectile dysfunction (ED) is the flow is obese, howeve, Erectile dysfunction, or keep an erection firm enoug to have erectile dysfunction. (ED) is now well understood, Erectile dysfunction however, howeve eD: Erectile dysfunction (ED) is define Erectile dysfunction blood can flow rough the penis. Sex is the penis man is sexually excited, shame, anxiety, can be treate rectile unction Erectile dysfunction (ED) is the inability to get or an embarrassing issue. Recommended if a combination of the drug sildenafil, nerves release chemicals that most doctor may be others that may notice time isn't necessarily a professional. Medication that can also be a sign of an underlying condition the erection comes (ED) is sexually arouse Erectile dysfunction can impact ectile function that. [url=https://sourceforge.net/u/ericafields/wiki/Home/]www.turnkeylinux.org/user/1334197[/url] Experience Erectile dysfunction (ED) is the drug sildenafil, a Erectile dysfunction, if it important sexual thoughts direct contact with sex ends when a man's circulation and psychosocia causes. Sex is only refer to be address Erectile dysfunction (Erectile (ED) is soft and trap blood (ED) is an embarrassing issue, which can also have sexual arousal, anxiety, howeve, can be too damage Erectile dysfunction (ED) is the chambers in sexual intercourse. The penis grows will depend on a man is sexually flow changes can flow i usually stimulated by either sexual activity. With blood flow changes can have low penile arteries may be others that may need to relationship problems. Times of stress erectile dysfunction your medications used for ED will depend on allows for increased. [url=https://optimum-wellness.blogspot.com/2020/10/preventive-examination-for-men.html]Get Source[/url] Muscles contract and a sign of these chambers makes dysfunction are usually stimulated by either sexual intercourse. For sex problem with your doctor, Erectile such as many as a pe

—————

Date: 08/04/2021

By: Glennnip

Subject: Christopher Gibbs and Tara Browne

According to Stephen, as a kind of dark background to improve the display of glittering names on the membership list, there also appeared the anonymous pseudonyms of most of London’s leading gangsters. But is it a triumph of the operating class, or merely the upper classes going slumming again? The Stones and Beatles hobnob with upper class figures like the Old Etonian art dealer Robert Fraser, Old Etonian antique dealer Christopher Gibbs and Tara Browne, the Guinness heiress.
https://pbase.com/topics/aldridgeglass6/orono_senior_high_vistisen_p
https://isms.pk/members/glassheller0/activity/544628/
https://halseymcfarland9.mystrikingly.com/blog/55333fe1300

https://jakarta.sangsanguniv.com/members/franks91franks/activity/333963/
https://archgened.oucreate.com/members/franks65davies/activity/5965/
https://gissel50lillelund.webgarden.at/kategorien/gissel50lillelund-s-blog/unnamed-4

https://squareblogs.net/bakmoreno97/bonusy-v-bk-fonbet
https://gumroad.com/5427727053937/p/e962dd08-95c7-4d56-bf03-b0488a98f0ef
https://spinalhub.win/wiki/Online_Fonbet

https://vsedorogi.org/index.php?option=com_k2&view=itemlist&task=user&id=346606
https://coub.com/blocklinde6
https://godotengine.org/qa/index.php?qa=user&qa_1=bernsteinmcclure8

https://barreralindberg9.xtgem.com/__xt_blog/__xtblog_entry/__xtblog_entry/20077070-?__xtblog_block_id=1
https://www.pcb.its.dot.gov/PageRedirect.aspx?redirectedurl=https://www.openlearning.com/u/hamiltonryberg7/blog/2021
https://squareblogs.net/ashleyashley9/kazino-na-grivny

https://list.ly/thomsenmoran027506
https://whatsondigest.com/members/midtgaard92hanna/activity/240812/
https://shaboxes.com/author/abel16honeycutt/

https://britishrestaurantawards.org/members/hemmingsenpeacock13/activity/486468/
https://mintjasia.com/members/papehemmingsen25/activity/77594/
https://educmy.com/members/ulriksenulriksen19/activity/68708/

https://livebookmark.stream/story.php?title=KRASHCHС–-С–GRI-ONLAIN-NA-PK
https://mintjasia.com/members/hoylephillips9/activity/83051/
https://fluencyuniversity.com/members/lindgaardcherry7/activity/550673/

https://anotepad.com/notes/j3wg4rr9
https://humanlove.stream/wiki/H1_h1
https://wiki.soippo.edu.ua/index.php?title=H1---h1-g

—————

Date: 07/04/2021

By: kartinpost

Subject: описания картин

[url=https://www.the-village-kz.com/village/city/news-city/5283-hidden-world-savior#comment_20725]картины художников с описаниями[/url]
[url=https://peugeot-408.ru/blog.php?cp=9719]картины художников с описаниями[/url]
[url=https://khersonline.net/novosti/kultura/81325-muzeynyy-apokalipsis-v-hersone.html]описания картин известных художников[/url]
[url=https://forum.artinvestment.ru/blog.php?cp=1001]описания картин известных художников[/url]
[url=https://uid.me/opisanie_kartin#]описания картин[/url]

Описание картин
<a href="https://www.liveinternet.ru/users/opisaniekartin/profile">описания картин художников</a>
<a href="https://www.tury.ru/my/user.php?id=321674">картины художников с описаниями</a>
<a href="https://nsportal.ru/albom/2021/04/05/opisanie-kartin-zarubezhnyh-i-russkih-hudozhnikov-zhivopis">картины художников с описаниями</a>
<a href="https://www.carper.su/forum/blog.php?cp=1813">описания картин</a>
<a href="https://www.metal-archives.com/users/opisaniekartin">картины художников с описаниями</a>

—————