Biographical Information

Bill Inmon
Bill Inmon is universally recognized as the "father of the data warehouse." He has over 26 years of database technology management experience and data warehouse design expertise, and has published 36 books and more than 350 articles in major computer journals. His books have been translated into nine languages. He is known globally for his seminars on developing data warehouses and has been a keynote speaker for every major computing association. Before founding Pine Cone Systems, Bill was a co-founder of Prism Solutions, Inc.

Ralph Kimball
Ralph Kimball was co-inventor of the Xerox Star workstation, the first commercial product to use mice, icons, and windows. He was vice president of applications at Metaphor Computer Systems, and founder and CEO of Red Brick Systems. He has a Ph.D. from Stanford in electrical engineering, specializing in man-machine systems. Ralph is a leading proponent of the dimensional approach to designing large data warehouses. He currently teaches data warehousing design skills to IT groups, and helps selected clients with specific data warehouse designs. Ralph is a columnist for Intelligent Enterprise magazine and has a relationship with Sagent Technology, Inc., a data warehouse tool vendor. His book "The Data Warehouse Toolkit" is widely recognized as the seminal work on the subject.

INTRODUCTION TO DATA WAREHOUSE

INTRODUCTION TO DATA WAREHOUSE

Most of the companies are having vast potential information in their organization. The data has all the information about the performance & the trends an organization has gone through during the past few years. If they can tap into this information they can improve the quality of decision making. The problem is that their operational systems were never designed to support this kind of business activity. To meet these needs new technology was introduced which is known as DATA WAREHOUSE.

DATA WAREHOUSE DEFINITION ( 1 )

· Foundation of Decision Support System

· To take facts based decisions

· Building intelligence to business.

WHAT IS BUSINESS INTELLIGENCE ?

· Converting information into knowledge.

· Converting information into actionable decisions.

· Discovering unknown things.

WHY A COMPANY NEEDS BUSINESS INTELLIGENCE?

· To make better decisions.

· Increase Sales.

· Deepen Customer relationships

· Build better products

· Provide better services

· Streamline operations

· Reduce costs.

BI TERMINOLOGY

· Data Warehouse

· Data Mart

· OLAP

· Mining

Start Learning DataWarehousing

Hi Friend
I am a Data Warehousing developer. I have some basic knowledge in Data warehousing and ETL and Reporting tools. In my blog i decide to share that knowledge with other. I think sure it will be use for readers. If u have any doubts mail me sundar.skec@gmail.com. friends learn the content in date wise then it will be easy to understand.

Introduction to Data Warehousing:

• Data Warehousing Concept
• Difference between Transactional and Warehoused Data
• Data Warehousing Architecture
• Logical & Physical Design
• Difference between Data Warehouse & Data Mart
• Source Data ,Staging Area & Target Data
• Operational Data Source (ODS)
• Star Schema & Snow Flake Schema

Data Warehouse Design and Modeling:

Dimension Model (Schema) for Data Warehouse

• Defining Dimensions And Measures
• Defining Levers and Hierarchies
• Granularity of data
• Introducing Star Schema
• Introducing Snow Flake Schema
• Dimension Table And Fact Table

ETL (Extract, Transform & Load) Using Informatica:

• Designer : Defining Target for Staging data base & Data Warehouse
• Designer : Creating Multi-dimensional Cubes
• Designer : Creating Mapping (with different transformation) and Mapplets
• Transformation
1. Filter
2. Router
3. Sorter
4. Rank
5. Aggregator
6. Expression
7. update staterge
8. Lookup
9. Normalizer
10. stored Procedure
11. source qualifier
• Task
1. Session
2. command
3. Email
4. Event Wait
5. Event Raise
6. Timer
7. Assignment
8. Control
• Server Manager : Creating Sessions and batches
• Concepts Workflow monitor

OLAP & PRESENTION using COGNOS:

• Impromptu Administration : Defining database and setting up catalog
• Impromptu Administration : Creating and Managing Folders, Prompts, Filter, Formula
• Impromptu Administration : Defining Classes, Users & Privileges
• Impromptu Administration : Generating & Formulating Falt Reports
• Impromptu Administration : Generating Query Definition File
• Cognos Powerplay Transformer : Creating Dimensions and Measures
• Cognos Powerplay Transformer : Generating Cubes, Manipulating Cube Properties
• Cognos Powerplay Transformer : Generating Multi-Dimensional reports using cube
• Cognos Powerplay Transformer : Formatting & Printing Reports
• Cognos Powerplay Transformer : Drill-down, Drill-up and Drill-through Reports
• Cognos Powerplay Transformer : Generating Chats using cube

OLAP & PRESENTATION using BUSINESS OBJECTS

• Supervisor: Creating Repository and Supervisor
• Supervisor: Database Connections
• Supervisor: Defining Groups and Users
• Supervisor: Defining Privileges and Profiles for users
• Supervisor: Scheduling Users Connection Sessions
• Designer: Creating and Maintaining Universe
• Designer: Defining Tables & Columns as Classes and Objects
• Designer: Creating and Maintaining measures
• Designer: Defining Relations, Formulas etc
• Business Object: Defining Query, Reports Type
• Business Object: Formatting Reports
• Business Object: Slicing & Dicing Reports
• Business Object: Drill-down, Drill-up Reports
• Business Object: Filtering Records, Grouping Records etc.