Twin Workshops on Data Warehousing and Data Mining at Mumbai in January 2008

PROGRAM I: DATA WAREHOUSING

Subject	Data Warehouse Applications in Business
Dates:	29th - 31st January, 2008 (3 Days)
Fees:	Rs. 14,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
	Overview of Business Intelligence Applications
	Overview of Data Warehouse Design
	Data Warehouse Design – Discussing Business Cases
	Data Warehouse Design – Various Situations

Day 2

Session	Topic
	Data Warehouse Design - Exercise
	Data Warehouse Building - Data Extraction, Loading and Transformation - Presenting Concepts
	Analyzing Data – OLAP – Presenting Concepts and Exercise
	Fine Tuning Design – Aggregates Building, Partitioning – Presenting Concepts Fine Tuning Design – Aggregates Building - Exercise

Day 3

Session	Topic
	Demonstrating a Data Warehouse System using SQL Server
	Hands-on designing and building Data Warehouse System using SQL Server
	Hands-on designing and building Data Warehouse System using SQL Server (Cont)
	Demonstration and Hands-on Analyzing Data Warehouse System using OLAP - SQL Server

PROGRAM II: DATA MINING

Subject	Data Mining
Dates:	18th - 19th January, 2008 (2 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 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.

Audience:

Senior Executives in Business and Information Systems areas.

Course Contents:

Day 1

Session	Topic
	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)
	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 SEMMA Methodology
	o Market Basket Analysis Application Exercise
	o Classifying and Predicting using Decision Tree Application Exercise

Day 2

Session	Topic
5.	o K-means Clustering and Hierarchical Clustering o K-Nearest Neighbors Application Exercise
6.	o Neural Network o Application Exercise Genetic Algorithm
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 imparted customized BI training to various organizations like:

ABN Amro Bank, BPCL, Financial Technologies, HLL, HPCL, HP-India, Kotak Mahindra, Mastek, National Insurance Academy, Prodigy Informatics, Prudential, Rave Technologies, Symantec Corporation, Tata AIG

and many more....

SPECIAL DISCOUNT SCHEME:

PARTICIPANTS:	DISCOUNT
Corporate Discount: Group of 4 or more participants	10 %

REGISTRATION DETAILS:

Registration compulsory:	Please note that you need to register for these programs atleast 6 days in advance from the start date of the training. We would be unable to accommodate any participants on the day of the training without prior registration.
Sufficient Enrolment Needed:	Pragati Software reserves the right to postpone any program due to insufficient enrolments.

Need More Information:

Tel: +91- 22- 2920 1583, 2920 6976, 2925 7840, 2920 9720, 2920 4122, 2925 7632, 2920 4130, 2920 8902, 2925 3052, 2925 7689, 2920 7387, 2920 6329 Fax. No: +91-22- 2920 7388.

Unsubscribe:

This mailer is being sent to you assuming that you are interested in the training activities of Pragati Software. In case you wish to be removed from our mailing list, do let us know. If you are not the right person handling the training activity for your company, kindly give us the name and E-Mail ID of the right person.