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.