Thursday, May 21, 2009

Attended Microstrategy 9i BI class today

Attended Microstrategy 9i BI Class today:

Real good BI tool & lot of good things on the Microstrategy 9i.
Microstrategy identified lot of previous issues had been resolved with this new version. I had worked in the Datawarehouse environment more than 10 years starting from MSTR 6 , 7 , 8i & now it is 9i.


The main thing I see compared to other BI tools:
1) OLAP Cube + ROLAP / HOLAP together using MSTR architect.
2) While drilling it can go from predefined cube to regular reports to detail level executed from database. No tool supports this. [I liked this very much]
The problem with other tools are :
While building cube you need to specify all of the levels / dimensions into one cube , there is no way you can link multiple cubes link together in other tools. But In New Microstrategy , it supports that.

3) Dashboards are really interactive, I am sure users are going to like it very much.
4) Way to implement quick & dirty way of importing excel data sources directly to MSTR & do the quick Proof of concept to satisfy immediate needs of urgent user without going through the regular ETL Process & getting the data out through DB.
-- This satisfys the short term goals of any BI Project to show the progress quickly & it would be temprary solution until the actual and real proper solution. And also Quick Proof of Concepts.
Since I experienced with lot of bigger clients they wated immediate needs of some analysis , I happend to hard code some of the stuff & put into table directly & do similar approach & configure in the MSTR as a sepearte projects to satisfy the short term solutions. But now it is going to be the quick through regualr MSTR project itself.

5) Prepackaging integration of schema objects from distributed team environment also good. Because most of the BI projects are in the distributed environment nowadays. It is kind of similar to sending Cognos metadata files & migration.
6) Lot of things which done through MSTR Desktop now , regular business users can do , so less problem for the IT team to support these kind of Public object
creation & Maintanance.
7) Creating Dashboard made it very easy in MSTR 9i.
8) Web Single Sign On is added through configuration
9)MSTR architect user interfaces seems to be easy now. Conceptwise it is samething.

I will write more about it once I go through full.

Thanks,
Srini Centhala,
www.absolut-e.com


8 comments:

  1. Microstrategy does put out a good product. Too bad we don't use it where I am :)

    ReplyDelete
  2. To your point #1: Sounds good but what volume can you really get into the new intelliget cubes. I can't imagine it's near the value traditional MOLAP.

    ReplyDelete
  3. Hi David,
    Cubes in MSTR 9i , There is no limit , but really depends on the Server Resources availability such as RAM & Disk Space & processor Capacity.
    1. Case 1: When you have 2GB-10GB of Cube size , 2 GB RAM , part of Cube would be kept in the RAM and additional data would be kept in Disk.
    2. Case 2: When you have 1GB of cube size , it will utilize RAM full in case of free RAM. Else it keeps in the Disk , it provides when ever request comes.

    Good think on this new MSTR, User Does not know the source is from Cube or Disk or From Database if it is drill down to detail level. The integration of Cube & Relational DB data is seamless to the user.
    Where as other BI Tool vendors are having lot of limitations such as what ever the lowest level needs to be included while building the cube.

    ReplyDelete
  4. Thanks for the clarity Srini. Do you notice any performance degradation when moving from RAM to disk?

    ReplyDelete
  5. Hi David,
    Yes. Little bit in seconds. Again it is based on the size of the file , Processor Speed & Disk Speed.

    ReplyDelete
  6. Srini, in case anyone is inspired to try MicroStrategy upon reading your blog, I wanted to mention MicroStrategy's new, free reporting package. Good for departments and small-to-midsize organizations: www.microstrategy.com/freereportingsoftware.

    ReplyDelete
  7. It's Very informative blog and useful article thank you for sharing with us , keep posting learn more about BI Tools
    Tableau Online Training

    ReplyDelete
  8. A very awesome blog post. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. 투데이서버

    ReplyDelete