Building a better BI

Datameer Analytics on Big Data

2012-02-14T04:31:00.001-08:00

This allows visualization on Hadoop and seems to be the best out there doing this

Datameer Analytics Solution

Pentaho ETL software for Hadoop

2012-02-11T04:45:00.000-08:00

Pentaho ETL tool now makes it really easy to build MapReduce jobs for Hadoop

http://www.youtube.com/watch?v=KZe1UugxXcs&feature=colike

Open Source ETL comparision

2012-02-07T09:43:00.001-08:00

I agree to some of the analysis here. The future for open source integration looks bright, the competition is good. Pentaho and Talend are front runners. Talend has the advantage of being deployed onto any Java server but Pentaho has more users and is slightly easier to use.

Open Source ETL vs Commercial ETL

View more presentations from JonathanL

Oracle's BI Strategy and OBIEE Overview

2012-01-29T19:00:00.001-08:00

Oracle business intelligence overview

View more presentations from nvvrajesh

Doing BI the Agile Way

2012-01-28T05:58:00.001-08:00

BI the Agile Way

View more presentations from nvvrajesh

Hadoop Links

2012-01-26T11:32:00.000-08:00

thanks to Sameer Farooqui from Linkedin..

++ MapReduce Framework ++
Great 1 hour video introduction: http://nosqltapes.com/video/understanding-mapreduce-with-mike-miller

Read the famous 2004 paper from Google that kicked off the MapReduce revolution. This is a very readable paper that can be digested in about 2 - 3 hours:http://research.google.com/archive/mapreduce.html

Here's a 33 minute video on what kinds of simple things you can do with MapReduce:
http://www.cloudera.com/videos/mapreduce_algorithms

Google's MapReduce course:
http://code.google.com/edu/parallel/mapreduce-tutorial.html

++ Beginner Hadoop ++
Excellent beginner's video on understanding Hadoop, MapReduce and HDFS:
http://www.cloudera.com/protected/?resource=introduction-to-apache-mapreduce-and-hdfs

Understanding the Hadoop ecosystem:
http://www.cloudera.com/protected/?resource=apache-hadoop-ecosystem

++ HDFS ++
An easy 2-3 hour read about Hadoop's distributed File System:
http://www.aosabook.org/en/hdfs.html

++ Labs ++
Install VirtualBox on your laptop, get an Ubuntu Virtual Machine going and follow this excellent tutorial to install your first Hadoop node:
http://www.michael-noll.com/tutorials/running-hadoop-on-ubuntu-linux-single-node-cluster/

Then use this to scale your cluster to multiple nodes:
http://www.michael-noll.com/tutorials/running-hadoop-on-ubuntu-linux-multi-node-cluster/

Run a MapReduce job in Python on your cluster:
http://www.michael-noll.com/tutorials/writing-an-hadoop-mapreduce-program-in-python/

++ Bonus ++
Dynamo/Cassandra is a good alternative to Hadoop/HBase and is worth as least being familiar with: http://nosqltapes.com/video/understanding-dynamo-with-andy-gross

Hadoop real time

2012-01-13T10:12:00.001-08:00

http://www.slideshare.net/parallellabs/sigmod-realtime-hadooppresentation

http://www.rhipe.org/home

Oracle Strategy on Endeca

2012-01-13T05:53:00.001-08:00

This is a good presentation on strategy...

Endeca allows business analyst to explore data
Endeca has hooks to Hadoop and has a smart cube builder
Oracle bought this last year and has plans to integrate these tools...

http://www.oracle.com/us/corporate/acquisitions/endeca/general-presentation-517133.pdf

Hadoop... short presentation

2012-01-12T20:13:00.001-08:00

Hadoop For Enterprises

View more presentations from nvvrajesh

Good link for Oracle DBA related tips

2011-12-15T16:26:00.001-08:00

Cloudera - Hadoop for enterprise

2011-12-07T19:54:00.001-08:00

this is competition to EMC's Greenplum and is a startup. I like the passion of this company.

https://ccp.cloudera.com/display/SUPPORT/Downloads

They also created "sqoop" which allows Oracle/MySQL data to be pushed easily into HDFS.

http://www.cloudera.com/downloads/sqoop/

Generating OBIEE Catalog Report

2011-11-07T18:52:00.001-08:00

OBIEE allows to query the webcatalog via a webservice:

http://gerardnico.com/wiki/dat/obiee/web_service

http://tipsonobiee.blogspot.com/2009/07/obiee-web-services-using-net-and-c.html

http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

Generating OBIEE RPD Report

2011-11-07T18:51:00.000-08:00

This is pretty useful for a knowledge transfer. Click on tools -> utilities and then select "Repository Report"

Hadoop getting started

2011-08-24T15:24:00.001-07:00

Time Dimension Build up in OBIEE

2011-08-17T19:52:00.001-07:00

http://www.oraclenerd.com/2010/03/obiee-report-drilldown.html

Datawarehouse Interview Quesitons

2011-07-27T04:54:00.000-07:00

http://www.geekinterview.com/Interview-Questions/Data-Warehouse
http://www.phlonx.com/resources/nf3/ --> Normalization process
Top N query in Oracle: http://www.oracle-base.com/articles/misc/RankDenseRankFirstLastAnalyticFunctions.php

OBIEE 11g and Essbase short documents

2011-07-22T11:10:00.000-07:00

Good site with short documents on how to use ODI and Essbase - which are now part for OBIEE suite.
http://learnhyperion.wordpress.com/

Also check out the video tutorials: http://learnhyperion.wordpress.com/category/obiee-video-tutorials/

TOGAF key links

2010-12-13T18:53:00.000-08:00

Enterprise System Bus and BI

2010-11-15T18:35:00.000-08:00

I'll be in a 3 day IBM training to understand if ESB is a fit for Business Intelligence within our organization. In preparation, reading the book "Enterprise Integration Solutions" (ISBN 0-7356-2060-1). Some links on this topic:
http://www.b-eye-network.com/view/3018

Excel Plug in setup for OBIEE

2009-10-09T14:13:00.001-07:00

http://oraclebispace.blogspot.com/2009/07/using-oracle-bi-office-in-obiee-for.html

OBIEE Connection Pool best practice

2009-10-08T16:08:00.000-07:00

http://oraclebiblog.blogspot.com/2009/08/connection-pools-best-practices.html

Good architecture articles

2009-10-05T11:37:00.000-07:00

There are quite a few articles here of BI architecture interest - not related to Teradata

http://www.tdwi.org/research/reportseries/reports.aspx?pid=819

OBIEE basics - how to start development

2009-10-02T15:19:00.001-07:00

This is a simple document, but explains how to start OBIEE developement
http://bidwsig.org/bidwsig.files/BI%20SIG%20OBIEE%20Presentation%2010%2014%2008.pdf

OBIEE future roadmap - Rittman link

2009-10-01T11:22:00.000-07:00

This i a good article talking about how the architecture will evolve in OBIEE... this is from Mark Rittman and not Oracle.

The SOA is the key concept in my view - will this be accepted by the industry for data warehouse dealing with Peta bytes of data???

http://www.rittmanmead.com/2008/02/15/a-future-oracle-obiee-architecture/

Performance Reporting

2009-09-28T09:12:00.000-07:00

Found a good article that talks about the different layers need for BI:
http://www.databaseanswers.org/tutorial4_integrated_performance_reporting/index.htm

QlickView

2009-09-18T07:46:00.000-07:00

This is a desktop analytical product which is visually appealing (Ajax) and easy to use. Rittman wrote a good article comparing this with Oracle's Essbase http://www.rittmanmead.com/2009/08/15/a-quik-look-at-qlikview/

Key Highlights
1. It is meant for desktop.
2. It does in memory computation. It compresses data so a 1 GB essbase database is 4 MB in qlickview.
3. Visualization is intuitive and allows user to dig into areas which he/she wants to.

So, which BI tool will this get integrated with in the future?

Some interesting links

2009-09-08T22:42:00.000-07:00

What not to do in OBIEE:
http://majendi.blogspot.com/2009/06/dont-try-this-at-home-kids.html

Modeling Header:
http://greatobi.wordpress.com/2009/07/16/modeling-header-details/

Tips site: http://tipsonobiee.blogspot.com/

Vertical text:
http://blog.trivadis.com/blogs/andreasnobbmann/archive/2009/07/17/vertical-text-in-obiee.aspx

OBIEE Initialization Block

2009-06-29T08:18:00.000-07:00

Initialization Block is powerful in setting one time per session.

http://www.rittmanmead.com/2008/09/03/obiee-repository-variables-filtering-and-conditional-formatting/

Ragged Hierarchies and OBIEE

2009-06-09T19:28:00.000-07:00

This is the best article on implementing ragged hierarchies in OBIEE which does work - http://www.rittmanmead.com/2007/06/21/obiee-data-modeling-tips-3-ragged-hierarchies/

OBIEE Variables

2009-06-02T09:53:00.000-07:00

Good link discussing OBIEE variables http://shivabizint.wordpress.com/2008/10/02/oracle-bi-ee-variables-overview/

Oracle BI or Business Objects?

2007-05-27T22:50:00.000-07:00

Which tool to use - Oracle BI (Siebel Analytics) OR Business Objects? Until now Oracle BI has been good for dashboards and Business Objects has been good for ad-hoc queries.

Off late, both of them are trying to enter each others market. Which one will live on for the next 10 years is a mystery.

Web 2.0 and BI?

2007-05-27T08:50:00.000-07:00

Will Web 2.0 impact BI?

How does BI take advantage of this new trend where content is provided on the fly by the customers. BI does have a trend called "pervasive intelligence"

Good video from KSU about Web 2.0 = http://www.youtube.com/watch?v=NLlGopyXT_g

If you are interested further = http://www.youtube.com/watch?v=tYcS_VpoWJk

Which database to use Oracle or Teradata?

2007-05-20T12:36:00.000-07:00

First and underlying resource of a BI stack is the database. Which database is better - Oracle or Teradata? Does it matter? Do current projects need pre-planning for this? Are the tools ready to support Teradata?