|
We are pleased to announce the following training courses to
build your competence in the areas of Data Mining and Data
Warehousing.
|
PROGRAM I: DATA WAREHOUSING |
|
Subject |
Data Warehouse Applications in Business |
|
Dates: |
23rd - 25th August,
2007 (3 Days) |
|
Fees: |
Rs. 12,000/- per person + Service Tax
(12.36%) |
|
Venue: |
Pragati Software Pvt. Ltd.
207, Lok Center, Marol Maroshi Road, Andheri
(E), Mumbai 400 059 |
|
Timings: |
9:30 am to 5:30 pm |
|
|
|
Program Objectives: |
This program is designed to provide comprehensive
discussions on designing & building of Data
Warehouse as well as OLAP applications.
Demonstration will be made as well as hands-on
experience imparted to participants to design and
build Data Warehouse.
|
Audience: |
-
Senior executives who oversee data
warehousing projects.
-
Middle level IT executives who will
participate in the Data Warehouse
project.
-
Any other senior / middle level IT
executives who plan to go for Data
Warehousing project.
|
|
Course
Contents: |
|
Day 1
|
Session |
Topic |
|
1.
|
Overview of Business Intelligence
Applications |
|
2.
|
Overview of Data Warehouse Design |
|
3.
|
Data Warehouse Design – Discussing
Business Cases |
|
4.
|
Data Warehouse Design – Various
Situations |
Day 2
|
Session |
Topic |
|
1.
|
Data Warehouse Design - Exercise |
|
2.
|
Data Warehouse Building - Data
Extraction, Loading and
Transformation - Presenting Concepts |
|
3.
|
Analyzing Data – OLAP – Presenting
Concepts and Exercise |
|
4.
|
Fine Tuning Design – Aggregates
Building, Partitioning – Presenting
Concepts
Fine Tuning Design – Aggregates
Building - Exercise |
Day 3
|
Session |
Topic |
|
1.
|
Demonstrating a Data Warehouse
System using SQL Server |
|
2.
|
Hands-on designing and building Data
Warehouse System using SQL Server |
|
3.
|
Hands-on designing and building Data
Warehouse System using SQL Server
(Cont) |
|
4.
|
Demonstration and Hands-on Analyzing
Data Warehouse System using OLAP -
SQL Server |
|
|
PROGRAM II: DATA MINING |
|
Subject |
Data Mining |
|
Dates: |
30th - 31st August, 2007 (2
Days) |
|
Fees: |
Rs. 9,000/- per person +
Service Tax (12.36%)
|
|
Venue: |
Pragati Software Pvt. Ltd.
207, Lok Center, Marol Maroshi
Road, Andheri (E), Mumbai 400
059 |
|
Timings: |
9:30 am to 5:30 pm |
|
|
Program
Objectives: |
This workshop is designed to provide a
comprehensive overview of how Data
Mining techniques are applied in
business situations to improve Business
Performance. The participants undertake
hands-on exercises using XLMiner, a Data
Mining tool that is an Excel add-in.
|
Course Contents: |
|
Day 1
|
Session |
Topic |
|
1.
|
o Business Intelligence
System
o What is BIS?
o BI Requirements
o Data Warehouse
o Data Analysis
o BIS Model
o BI Requirements
through KPI – Dupont
Model and Balanced Score
Card
o Analysis Techniques
o Management Information
System (MIS)
o SQL Query & Reports
o On Line Analytic
Processing (OLAP)
o Statistical Analysis –
Hypothesis Testing
o Data Mining
o Decision Support
System (DSS)
o Concept of
Dashboard & Executive
Information System (EIS) |
|
2.
|
o Data Mining
Overview
o What is Data Mining?
o Data Mining
Applications
o DM and KDD
o Supervised Learning
Techniques
o Data Partitioning
o Evaluating Model
o Overview of Different
Techniques
o Unsupervised
Techniques
o Clustering
o Affinity Grouping
o Overview of Different
Techniques
|
|
3.
|
o Market Basket
Analysis
|
|
4.
|
o Classifying and
Predicting using
Decision Tree
|
Day 2
|
Session |
Topic |
|
5. |
o K-means Clustering and
Hierarchical Clustering
o K-Nearest Neighbors
|
|
6. |
o Neural Network
o Application Exercise
|
|
7. |
-
Multiple Linear
Regression and
Logistic Regression
-
Application Exercise
|
|
8. |
o SDLC for BI Project
o Case Discussions -
Data Mining Applications
o Exercise |
|
|
|
|
LEAD INSTRUCTOR
PROFILE: |
|
Dr. Sunil D. Lakdawala, a Ph.D. from Yale
University-USA and post graduate from I.I.T.-Mumbai is
an independent consultant and trainer. He has over 20
years of experience in IT with various companies
including CMC Ltd. and Tech Span India Ltd. He has
specialized in the area of BI and has a rich experience
in consultancy, project execution and training in that
area.
He
has imparted customized BI training to various
organizations like HLL, HP-India, ABN Amro
Bank,Prudential, Mastek, Financial Technologies, Kotak
Mahindra, BPCL, HPCL, National Insurance Academy, Rave
Technology, Tata AIG, Symentec Corporation, Prodigy
Informatics, and many more.... |
|
|
SPECIAL DISCOUNT SCHEME: |
|
PARTICIPANTS: |
DISCOUNT |
|
Corporate Discount: Group of 4 or more participants |
5
% |
|
|
REGISTRATION DETAILS: |
|
