Siebel Analytics an Overview

This post has been contributed by Ankit Gupta a friend who is currently working in Siebel Analytics. This post contains an overview of Siebel Analytics and concepts like Data Wharehousing and ETL.

The term Analytics mean a branch of logic dealing with analysis. So we can safely assume that Siebel Analytics means branch of Siebel dealing with Analysis. Siebel has always been transactional application and it is very difficult to do analysis of data that is residing in Siebel. Just to give you an example of what I mean.

Suppose a sales manager wants to know that:

How many opportunities in the last 3 months, from US Region for Product A, have a sales figure of over 3 million dollars?

I don't think there is an easy way to get this kind of data in Siebel easily and this is just very small requirement that a sales manager might have it can get very complex easily.

This is where Siebel Analytics comes into picture. It is a wrapper over Siebel Application.

Siebel Analytics allow an enterprise to measure and evaluate business performance across customers. It helps in analyzing past, present and future opportunities with the help of Dashboard Reports to determine actions required to meet the sales targets. With the help of Dashboard reports we can determine which products and customers are generating most revenue.
 
For understanding Siebel Analytics in more depth one has to know the basic difference between OLAP and OLTP.
 
OLTP stands for On Line Transaction Processing:
OLAP stands for On Line Analytical Processing

The data available at transaction side (Siebel Application) is OLTP and when that data is moved from transaction side for analyzing (Siebel Analytics) that becomes OLAP data.

OLAP brings into picture the concept of Data warehouse.

Data warehouse is a Relational /Multidimensional database that is designed for query and analysis rather for transaction processing. A data warehouse usually contains historical data that is derived from transaction data.
 
Another important concept when we are talking about to Siebel Analytics is ETL.

ETL stands for Extract, Transform, and Load.

ETL is a concept that enables businesses to consolidate their disparate data while moving it from OLTP to OLAP and it doesn't really matter that that data sources are in different forms or formats. The data can come from any source such as Oracle, SQL server, flat files, CSV etc
 
One important function of ETL is “Cleansing” data. ETL consolidation protocols also include the elimination of duplicate or fragmentary data, so that what passes from the 'E' portion of the process to the 'L' portion is easier to assimilate and/or store.

Such cleansing operations can also include eliminating certain kinds of data from the process. If you don't want to include certain information, you can customize your ETL to eliminate that kind of information from your transformation. The 'T' portion of the equation, of course, is the most powerful. ETL can transform data from different sources.
 
For Example: – Data in an Oracle CRM could be transformed right along with data from an SAP Marketing application, with the result being a common data from both the application.

If this helped you in anyway, Please provide your valuable comments. Your comments act as fuel for the author to keep going. You contribution as comments can decide whether you will get more from author or not.

zp8497586rq

75 Responses to Siebel Analytics an Overview

  1. Hi, I am searching for Siebel’s data-warehouse integration capabilities.

    Is bulk unload supported, if positive from which tables? For less source interruption how only changed data can be captured?

    I saw Oracle’s 11g warehouse builder has a new feature for integration but couldn’t test it until now.

  2. Hi, I am searching for Siebel’s data-warehouse integration capabilities.

    Is bulk unload supported, if positive from which tables? For less source interruption how only changed data can be captured?

    I saw Oracle’s 11g warehouse builder has a new feature for integration but couldn’t test it until now.

  3. Thank you so much for this article!

    I’m completely new to Oracle, Siebel, and right now I’ve been searching for information on Siebel CRM and Siebel Analytics. You gave me a much better understanding of how both systems work together.

    Many regards.

  4. Thank you so much for this article!

    I’m completely new to Oracle, Siebel, and right now I’ve been searching for information on Siebel CRM and Siebel Analytics. You gave me a much better understanding of how both systems work together.

    Many regards.

  5. Hi Ankit,
    I was searching for long time, a information which could explain Siebel Analytics to Siebel toddlers like me and ur article is exactly what I needed to start mu journey in Analytics..

    So keep up the good work ..
    keep posting

  6. Hi Ankit,
    I was searching for long time, a information which could explain Siebel Analytics to Siebel toddlers like me and ur article is exactly what I needed to start mu journey in Analytics..

    So keep up the good work ..
    keep posting

  7. Amazingly short and crisp. Can we get something more related to Siebel Analytics.

  8. Hi,
    This is a very useful article indeed I am looking forward to detailed articles dealing with various areas that you have mentioned in you article

  9. Hi,
    This is a very useful article indeed I am looking forward to detailed articles dealing with various areas that you have mentioned in you article

  10. Hi,
    The information given by you was really very clear for a beginner like me… It was really helpful…

    Thanks a lot for your information

  11. Hi,
    The information given by you was really very clear for a beginner like me… It was really helpful…

    Thanks a lot for your information

  12. Hey Ankit,

    It’s been quite a long I am out of touch of analytics, and I needed an overview to kick off, your article has done exactly the same … thank you buddy

  13. Hey Ankit,

    It’s been quite a long I am out of touch of analytics, and I needed an overview to kick off, your article has done exactly the same … thank you buddy

  14. This article has really added a value to my little knowledge about siebel analytics. Reading this article wasnt a waste of time. thanks.

  15. Hello ,

    Currently I have to explore Siebel Analytics , So can i get demo version setup of Siebel Analytics.

    Please reply ASAP.

    Danish

  16. Hello ,

    Currently I have to explore Siebel Analytics , So can i get demo version setup of Siebel Analytics.

    Please reply ASAP.

    Danish

  17. The information provided is phenomenal from a beginnners perpspective.
    Thanks and Regards
    Neeraj Kumar

  18. Hi,

    Thanks for your posting, it is very helpful for the beginners like me. I am looking forward to Siebel Analytics. I have no idea about Siebel Analytics. well I am an Informatica Developer. I wanted to learn Sibel Analytics, could U pls give us what is Siebel Analytics, How it is useful for any organization, what are its functionalities and capabilities, how to start, where to find the software from…. etc.

    Thanks

    Kalycs
    kaleem.informatica@gmail.com

  19. Hi,

    Thanks for your posting, it is very helpful for the beginners like me. I am looking forward to Siebel Analytics. I have no idea about Siebel Analytics. well I am an Informatica Developer. I wanted to learn Sibel Analytics, could U pls give us what is Siebel Analytics, How it is useful for any organization, what are its functionalities and capabilities, how to start, where to find the software from…. etc.

    Thanks

    Kalycs
    kaleem.informatica@gmail.com

  20. Thanks for the nice and use full article…
    Very valuable for beginners to get an idea about Analytics and relation with Oracle and its components

  21. Thanks for the nice and use full article…
    Very valuable for beginners to get an idea about Analytics and relation with Oracle and its components

  22. Hi Ankit,

    The information / article given by you looks very clear for a beginner like me… It was really useful and helpful…

    Thanks you for your article. Pls continue to posting such informative posts.

    Regards

  23. Hi Ankit,

    The information / article given by you looks very clear for a beginner like me… It was really useful and helpful…

    Thanks you for your article. Pls continue to posting such informative posts.

    Regards

  24. Hey,

    Its a very good and simple Article whcih gives lot of Information over Analytics. Its a very good Fundamental.

    Thanks alot,
    Taj.

  25. Hey,

    Its a very good and simple Article whcih gives lot of Information over Analytics. Its a very good Fundamental.

    Thanks alot,
    Taj.

Contribute