Business Intelligence and Data Warehousing.


Business Intelligence and Data Warehousing :

Business Intelligence is a process and methodology to convert raw data in to meaningful information for business use.

     Business Intelligence Tools can be Categorized Into :
  • ETL Tools :
For Extracting Transforming and Loading the data to Data warehouse.
  • Reporting Tools :
Read data, process the data and format the data in to structured reports
and dashboards those are delivered to business users.
  • Data Mining Tools :
Data mining is commonly used for marketing, surveillance, and fraud detection.
  • Knowledge Management Tools :
          Knowledge management tools are used capture, develop, share, and effectively                                          using organizational knowledge


              

What is Data Warehousing ?

A data warehouse is a collection of corporate information, derived directly from operational systems and some external data sources. Its specific purpose is to support business decisions, not business operations.


Characteristics of a Data Warehouse:
  • Subject-oriented Data
 •        Collects all data  for a subject,  from different sources
       Read-only Requests
        Loaded during off-hours, read-only during day hours
  • Interactive Features, Ad-hoc query.
       Flexible design to handle spontaneous user queries.
       Pre-aggregated data
       To improve runtime performance
  •  Highly demoralized data structures
Data Mart :

         It’s a smallest level or Subset of the data warehouse and is specific to a business.
          Example : Sales Data Mart, Orders Data Mart, Finance Data Mart.

Staging Area  :
  •  Is an Intermediate storage area between the source and data warehouse.
  • It’s an area where the cleansing of  raw data takes place
  • It might be UNIX storage mount or relation staging table based on the requirement.
Sources :

It might any OLTP relational or file sources:
   Example : ERP, Mainframe, Oracle, Teradata , DB2.

Available BI Tools In market ?

ETL Tools 
  • Informatica
  • Abintio
  • Data Stage
  • Talend 
Reporting Tools.
  • Cognos
  • Business Objects (BOXI)
  • OBIEE
  • MicroStrategy
Data Bases and Operating Systems used for DW Design

Popular Relational Databases.

• Oracle
• IBM DB2
• Teradata
• Sybase
• MySQL
• Greenplum
• VectorWise

Popular OS Platforms.

• Red Hat Linux
• Solaris Unix
• Window 

Difference Between OLTP and OLAP

OLTP
OLAP
1
OLTP is for Business process or Business Operations.
OLAP is for Business Decisions and Analytics
2
OLTP involves short and fast inserts and updates initiated by end users.
Periodic long-running batch jobs refresh the data
3
Highly normalized with many tables
De-normalized with fewer tables
4
Clerical Users
Managerial/Business Users
5
Detailed Oriented Data
Subject Oriented Data
6
Entity Attribute Relationship Model
Dimensional Modeling
7
Contains Instant Data
Contains Historical Data

 Types of OLAP

ROLAP :

·         Relational Online Analytical Processing.
·         ROLAP data will be stored in Standard Relational Database as a result it doesn’t need any pre computation.
·         ROLAP is scalable to handle large volumes of data.
                Ex : Business Object       
               
MOLAP :

·         Multi Dimensional Online Analytical Processing.         
·         MOLAP is alternative to ROLAP
·         Store pre-computed data in an optimized multidimensional array storage we call it as  cube
·         Query performance will be very high due to the optimized storage.
                 Ex : Cognos.

HOLAP :

·         Hybrid Online Analytical Processing.
·         It’s a combination of ROLAP and MOLAP.
·         Increased Aggregation and Query performance.
                Ex : Micro strategy.



28 comments:

  1. Thanks shivakumar, nice blog to sharing valuable information Java Training Chennai

    ReplyDelete
  2. Hi am, interested learning datawarhousing tool. but i don't selected which tool best in the this tool? please discuss to me shiva Java Training in Chennai

    ReplyDelete
  3. Great post, and great website. Thanks for the information! Odzyskiwanie danych Łódź

    ReplyDelete
  4. Might you be able to envision what the thing that matters is between the over a significant time span showcasing systems?data science course in pune

    ReplyDelete
  5. I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Analytics, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data analytics course in Mumbai to equip it as their primary skill.

    ReplyDelete
  6. Great post!
    Thanks for sharing this list!
    It helps me a lot finding a relevant blog in my niche!
    Java Training in Chennai
    Java Training in Coimbatore
    Java Training in Bangalore

    ReplyDelete

  7. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. I would like to state about something which creates curiosity in knowing more about it. It is a part of our daily routine life which we usually don`t notice in all the things which turns the dreams in to real experiences. Back from the ages, we have been growing and world is evolving at a pace lying on the shoulder of technology. data science course will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.

    ReplyDelete
  8. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    pmp certification in bangalore

    ReplyDelete
  9. Such a very useful article. I have learn some new information.thanks for sharing.
    data scientist course in mumbai

    ReplyDelete
  10. I curious more interest in some of them hope you will give more information on this topics in your next articles.

    Data science course in mumbai

    ReplyDelete

Featured Post

Cloud : A Trendsetter Technology