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: 28/03/2020

By: CyberXObjep

Subject: Eskadron -- brand loved by jockeys all around the world

Eskadron is one of the very appreciated equestrian brands in the world that focuses on the creation of highquality design clothing and equipment. This Italian concern has been founded by Pikeur wanting to meet with the jockeys' needs, who were looking for professional but also stylish equestrian accessories. So, why is Eskadron therefore special and why their selections are so popular with passengers?Eskadron Why do riders from all over the world love this new?
Eskadron has been exceptionally popular among horse riding fans for twelve or even more years now. This new products are characterized by their high-quality attention to detail. Eskadron can be valued for their unique practicality, elegance, and innovativeness of their endeavors, contemporary layout, and availability. The brand's offer includes both pro ones and items for recreational riders. So, you'll discover basic design clothes, expert equestrian, and various accessories necessary for the proper saddling of a horse. Eskadron offers saddle cloths, halters, rugs, bell boots for horses, boots, fly vases, drapes, however in addition hoodies, t shirts, breeches, even show coats. All products come from the European Union, which in addition verifies their caliber.Eskadron's ranges
Eskadron has lots of selections. Some are seasonal, many others are constantly accessible their deal. The very popular collections of the brand are:
Vintage Sports - established twice per calendar year, this line consists only of horse equipment. Services and products from this collection are very straightforward, in standard soft colors but at precisely the same time very elegant.
Platinum - launches once a year for those who prefer conventional solutions. You'll mostly find gray and black colors combined with delicate picture themes.
Young Star - line for children that begin their adventure with horse riding. It has basic horseriding accessories in bright colours and exceptional designs.
Equestrian Fanatics - clothing line made for riders who like to stand outside. Available coats, hoodies, and backpacks successfully combine casual clothing with equestrianism.
Vintage offer - Their steady offer of clothing, equipment, and accessories. You'll find products useful for training and regular rides but also elegant reveal clothing.

Eskadron can be a fresh used by cyclists from all around the world. For the comfort of safety and riding both yours and your horse, it might be well worth buying high-quality articles, which would allow one to fully appreciate this sport that is exceptional.

—————

Date: 27/03/2020

By: agrohimcmu

Subject: калий удобрение купить

Доброго времени суток товарищи!
Минеральные удобрения– вещества, имеющие неорганическую природу происхождения. Они традиционно используются в сельском хозяйстве, так как являются более доступными, чем органические, дают быстрый положительный эффект, и имеют широкий спектр действия. Также их гораздо удобнее и дешевле транспортировать.
1)[url=https://agro-himiya.by]аммиачная селитра купить в минске [/url] - Минеральные удобрения купить в Минске можно самовывозом в течении 20 минут, либо c оперативной доставкой.Покупая у нас, вы можете заказать товар, как оптом, так и в розницу. Крупным заказчикам всегда предоставляются скидки в объеме соответствующей величине сделки между нами.
2)[url=https://agro-himiya.by]минеральные удобрения купить Минск[/url] - Мы предлагаем вам приобрести только комплексные препараты, позволяющие полностью насытить потребности растения после обработки. Наши поставщики имеют в штате квалифицированных специалистов, способных точно произвести расчёты и анализ почвы, а на основе этих показателей создать для вас удобрения с идеальным набором макро- и микроэлементов.
3)[url=https://agro-himiya.by]неорганические удобрения купить[/url] - Каждый товар проходит тщательные клинические испытания на различных видах почв и только после этого запускается в серийное производство. Вы можете использовать нашу продукцию не только в целях крупной агрокорпорации с тысячами гектаров земли, но и для облагораживания приусадебного участка, дачных посевов.
4)[url=https://agro-himiya.by]минеральные удобрения в Беларуси[/url] - Мы заботимся о том, чтобы предоставляемый нами сервис был высокого уровня. В этом нам помогает наличие главного офиса, складов для готовой продукции, сети дилеров. Кроме того, мы дорожим своей репутацией и несем ответственность за качество нашего товара.
Мы будем рады Вас видеть у нас на сайте [url=https://agro-himiya.by]НАЖМИТЕ ССЫЛКУ[/url]
От всей души Вам всех благ!
https://lookw.ru/user/agrohimbxk/
https://www.rusforum.com/member.php?u=1174912
https://virtualvarig.com.br/vv/forum/viewtopic.php?f=16&t=377563
https://trubeckoy.by/user/agrohimfst/
https://1000-skidok.ru/2020/02/02/2632/comment-page-1133/#comment-10922

—————

Date: 27/03/2020

By: SandraDug

Subject: Hi! Only from 18+!

Hurry up to look into loveawake.ru you will find a lot of interesting things





I congratulate all women on the holiday!>>>[/url]

Click here!..[/url]

—————

Date: 26/03/2020

By: getusaMix

Subject: Get news in USA Mart

tholis.webnode.com oxycontin and xanax mixphobie avion xanax <a href="https://xanaxnw.com/">xanax buy southside</a> xanax 213 ig8 xanax

—————

Date: 26/03/2020

By: Forexthync

Subject: Currency Trading Brokers

Independent Reviews about Foreign Exchange Brokers. currency-trading-brokers.com

—————

Date: 26/03/2020

By: Jannaygi

Subject: окна пвх рехау

Привет господа[url=https://evroplast.by/]![/url]
Наша контора занимается свыше 10 лет изготовлением окон пвх в городе Минске.Основные направления и виды нашей деятельности:
1)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]купить окна пвх [/url] - Наши сотрудники осуществляют монтаж на высоком профессиональном уровне, имея за плечами многолетний опыт работы.

2)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]окна пвх [/url] – Окна пвх, собираемые из профилей ведущих производителей, имеют безупречный срок эксплуатации более 30 лет.

3)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]пластиковые окна[/url] - В ассортименте нашей компании "ОкнаЕвроПласт" вы сможете заказать окно из выбранного именно вами типа профиля и стеклопакета, подобрать качественную фурнитуру и дополнительные аксессуары.

4)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]пластиковые окна в минске купить[/url]- Представленные в нашем ассортименте алюминиевые рамы характеризуются не только высоким качеством и интересным современным дизайном, но и продолжительным сроком службы.

5)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]окна пвх цены [/url]- При должном уходе алюминиевые конструкции не теряют эстетики своего внешнего вида и функциональные свойства.
Всегда рады помочь Вам!С уважением, компания ЕвроПласт. https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb

https://www.colegiodenotariospr.com/notarios-noveles-reciben-orientacion-para-comenzar-su-practica/?unapproved=780&moderation-hash=39f0a408cd75f27201d09ff0fefe832e#comment-780
https://ppi.org.ua/index/8-449
https://upliftroi.com/blog/post/10-beautifully-designed-ecommerce-websites/?unapproved=534&moderation-hash=941c30a5c1d4628da2d3f750068d72b2#comment-534
https://www.broadwaydistrict.info/?unapproved=35864&moderation-hash=b00b7815bdbc3ccd0ec3ccbad1d5069e#comment-35864
https://www.spielhallen.net/rizk-casino/?unapproved=38731&moderation-hash=7e2c6978e05685acce0f6c06e38afe08#comment-38731

—————

Date: 26/03/2020

By: BrianInert

Subject: raw food world reviews on cbd hemp oil

cbd drug [url=https://www.romaverband.at/2020/03/19/how-cbd-oil-feels-like/]url[/url] is cbd oil legal in michigan?
amazon.com cbd oils for sale [url=https://nanae.at/?p=5805]webpage[/url] should cbd oil be taken with food or on an empty stomach
buy cbd florida [url=https://mejoramientodesuelos.com/why-cbd-oil-potency-matters/]their website[/url] cbd ejuice

what is it that reliefs the pain cbd or hemp oil <a href="https://kulej-dociepl.pl/index.php/where-is-cbd-oil-made/">More Bonuses</a> cbd adverse reaction
cbd gummies for sale walmart <a href="https://asmak-tarwah.com/2020/03/17/cbd-oil/">consultant</a> cbd oil for sale in new jersey
b+cbd <a href="https://www.alpna.in/where-to-buy-cbd-oil-in-19096/">read here</a> cbd oil mixed with oxycodone

—————

Date: 25/03/2020

By: Jannaphp

Subject: рама минск

Доброго времени суток дамы и господа[url=https://evroplast.by/]![/url]
Наша контора занимается свыше 10 лет изготовлением окон пвх в городе Минске.Основные направления и виды нашей деятельности:
1)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]купить окна пвх [/url] - Наши сотрудники осуществляют монтаж на высоком профессиональном уровне, имея за плечами многолетний опыт работы.

2)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]окна пвх [/url] – Окна пвх, собираемые из профилей ведущих производителей, имеют безупречный срок эксплуатации более 30 лет.

3)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]пластиковые окна[/url] - В ассортименте нашей компании "ОкнаЕвроПласт" вы сможете заказать окно из выбранного именно вами типа профиля и стеклопакета, подобрать качественную фурнитуру и дополнительные аксессуары.

4)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]пластиковые окна в минске купить[/url]- Представленные в нашем ассортименте алюминиевые рамы характеризуются не только высоким качеством и интересным современным дизайном, но и продолжительным сроком службы.

5)[url=https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb]окна пвх цены [/url]- При должном уходе алюминиевые конструкции не теряют эстетики своего внешнего вида и функциональные свойства.
Всегда рады помочь Вам!С уважением, компания ЕвроПласт. https://drive.google.com/open?id=1sdC2AWgInEl6RtP0zCwm8wljAIS8Bfmb

https://kodiaddons.blog/metalliq/?unapproved=139481&moderation-hash=4529b458fc7203898782d3b097986de6#comment-139481
https://lowentropy.ca/reality/?unapproved=46644&moderation-hash=e9f1d1c514cc33ac40d1702191b291bd#comment-46644
https://rdpsupport.com/change-rdp-port/?unapproved=1737&moderation-hash=da071ae78ec54fa1764c1fd1074356ee#comment-1737
https://www.tebarron.com/?unapproved=1486&moderation-hash=87f2380ba8fe999387fb4aeac2f52f61#comment-1486
https://www.chengdu-tour.net/blog/7-days-lhasa-tour-from-chengdu-by-train/?unapproved=24291&moderation-hash=cd8b83362f7c08fae2f79f3c0010cefe#comment-24291

—————

Date: 23/03/2020

By: BrianInert

Subject: does cold pressed hemp seed oil have cbd?

cbd interaction with statins [url=https://www.terredeilargoni.it/where-is-cbd-oil-legal/]look at this now[/url] cbd retailers near me
urine drug test cbd water soluabe [url=https://www.praxis-tegernsee.de/do-cbd-oil-bath-bombs-work/]visit their website[/url] cbd and the endocannabinoid system
cbd durant ok [url=https://www.aboutrelax.com/does-cbd-gummies-expire/]visit here[/url] cbd liquid drops

cbd vs hemp oil <a href="https://www.flirtcams.com/buy-cbd-oil-capsules-from-canada/">get more</a> hemp cbd
cbd vape oil wholesale <a href="https://masterkris.cl/buy-cbd-oil-in-dallas-yx/">go to this site</a> cbd arctic muscle
best cbd companies to invest in <a href="https://chachacraftea.com/2013/06/20/pure-cbd-oil-reviews/">read review</a> ananda cbd products

—————

Date: 22/03/2020

By: SandraDug

Subject: Hi! Only from 18+!

Hurry up to look into loveawake.ru you will find a lot of interesting things





Show more>>>[/url]

Click here>>>[/url]

—————