Data warehousing
DATAWARE HOUSING is a database which is used for data analysis.Data is collected from one or more disparate sources. DATAWARE HOUSING process allows historical as well as present data to be stored which is a helping hand for trending reports. The source of Data is scrutinized by transforming it and preparing Catalogues. It is provided for online analytical process or data mining. Dataware housing is also helpful in market research and decision support purposes. A DATAWARE HOUSING system manages to retrieve lost data, analyze data, extract then transform data and finally loading data to its repository. Data dictionary and Business intelligence is also a part of DATAWARE HOUSING SYSTEM. DATAWARE HOUSING system maintains data history and thus helpful in providing precise information about organization. Having single database made-up of multiple databases helps gather information in intact form. Customer relationship management becomes easier due to Data ware houses. Complex analysis of queries can be done easily with the help of DATAWARE HOUSING. Tactical reporting during sales purpose and validation of data in product marketing are the practical utilities of DATAWARE HOUSING. Aarvy eduTech students get a 3 months course in which all the concepts related to DATAWARE HOUSING is covered. Course is taken by expert data analysts and those trainers who have excellent work experience in IT industry. This helps students to win right direction for securing job. Training is placement oriented and placement assistance will help to secure better opportunities.
DATA WAREHOUSING INTRODUCTION TO DATA WAREHOUSING
- Data warehouse Concept
- Difference between Transaction and warehose data
- Data warehouse Architecture
- Logical and physical Design
- Difference between Data warehouse and Data Mart
- Source Data , staging Data and target Data
- Operational data source (ODS )
- OLAP . ROLAP , MOLAP
- Star schema , star flake schema and snow flake schema
- Normalizatin and De-normailzation
- Meta data and mining
Entity – Relation Model (E-R Model for transactional database
- Defining entities and their relationship
- Distribution of attributes under entities
- Normilization of entities
- Modeling logical E-R Model using E-R win tool
- Conversion of logical model into physical model
- Application of Business Rules
- Constraints , triggers , Domains , Back-end programs , etc
- Two case studies
DIMENSIONAL MODEL (STAR SCHEMA ) FOR DATA WAREHOUSE
- Informatica Server setup
- Repository manager : Repository creation Deletion , backup & restore
- Repository manager : Multiple Repository , Multiple Folders
- Repository manager : Folder Creation , Deletion and privileges Setup
- Repository manager : User , group & Privileges Management
- Designer: Defining Source from RDBMS , Semi –RDBMS ,Flate File , XML File , Cobol File
- Designer : Defining Target for Staging Database & for Data warehouse .
- Designer : Creating Multi –Dimensional Cubes
- Designer : Transformation Developer for Reusable User – Defined transformation
- Designer : Mappletes for reusable User –Defined Mappings
- Designer : Mapping to apply Transformation using 14 Transformation
- Designer: Global referencing of object across Folders * Repositories
- Designer : Data staging
- Server Manager : Setting up server for Repository
- Server Manager : Creating session and Batches
- Server Manager : Schudling session and Batches
- Server Manager : Monitoring Sessions and Batches for data loading
- Server Manager : Troubleshooting Data loading Erros
AB-INITIO
- Introduction
- Hardware Platforms
- Products of Abinitio s/w Corporation
- Feature of Abinitio
- Building a Basic Abinitio Graphs
- Case – Study
- Multi-File System / Multifile Directory
- Types of parallelism
- Testing Abinito Graphs
- EME ( Enterprise meta > Environment )
- Project
- Sandbox
- Version Control
- Performance Tuning of Abinitio Graphs
OLAP & PRESENTATION USING COGNOS 8 BI
- Introduction of Data Warehousing process
- Detailed explanation about O.L.T. P System
- Explanation of DWH Life Cycle
- Detailed explanation of OLAP Life cycle
- Detailed explanation of COGNOS 8 BI Architecture
- Types of OLAP's
- Detailed explanation of Dimensional Modeling
- Detailed explanation of STAR and SNOW FLAKE SCHEMA
- Detailed explanation Classes and variables
- Detailed explanation of D.I WEB.I Bussiness intelliegence and tools.
- Data mining concepts , model concepts
CREATING PACKAGES AND MODELS BY USING COGNOS 8 FRAME WORK MANAGER
- Cognos 8 BI Framwork Manager : Designing Metadata Models
- Cognos 8 BI Transformer : Designing OLAP Models 4 day
- Cognos 8 BI Data manager : Building Data marts with Enterprise Data
- Publishing Packages
- Generating simple and ad –hoc reports using Cognos8 BI tools
GENERATING REPORTS WITH QUERY STUDIO
- Cognos 8 BI Cognos Connection for Consumers
- Cognos 8 BI Query Studio : Building Ad – hoc Reports
- Cognos 8 BI Analysis Studio : Analyzing Data
- Cognos 8 BI Report Studio : Authoring statement style Reports in Express Authoring Mode
- Cognos 8 BI Analysis for Excel : Analyzing Data in Microsoft Excel
GENRATING REPORTS WITH REPORT STUDIO
- Cognos 8 BI Report Studio : Authoring Proffessional Reports
- Cognos 8 BI Report Studio : Authoring Reports with Multidimensional Data
- Cognos 8 BI Report Studio : Introduction
- Cognos 8 BI Report Studio: Intermediate
- Cognos 8 BI Event Studio : Creating , Schedudling and Managing
- GENERATING REPORTS WITH EVENT STUDIO
- GENERATING REPORTS WITH ANALYSIS STUDIO
- GENERATING CHARTS AND MULTI DIMENSIONAL REPORTS USING COGNOS 8 BI SUITE
- PUBLISHING REPORTS ANALYSIS AND REVIEW
- SCHEDULING REPORTS USING BI SERVER
- COGNOS 8 BI ADMINISTRATION AND USER CREATION WITH PRIVILEGES
- OLAP & PRESENTATION USING BUSINESS OBJECT
- Supervisor : Creating repository and Supervisor
- Supervisor : Database Conections.
- Supervisor : Defining Groups and Users
- Supervisor : Defining privileges and profiles for users
- Supervisor : Broadcast Agents
- Supervisor : Scheduling users Connections Sessions
- Designer : Creating and maintaining Universe
- Designer : Defining tables & columns as Class and objects
- Designer : Creating and Maintaining measures
- Designer : Defining relations , formulas , etc
- Business objects: Defining Query , reports type
- Business objects:formatting reports
- Business objects:slicing & dicing reports
- Business objects: drill- down , drill –up Reports
- Business objects: filtering records , Grouping Records , etc