bi syllabus by n.p. singh 13.pgp

8/11/2019 BI Syllabus by N.P. Singh 13.Pgp

1/6

Dr. N.P. Singh, Professor (IT)E-mail ID: [email protected]

anagemen! De"elopmen! Ins!i!#!e

ehra#li $oad, S#khrali, %#rgaon -&''

Post Graduate Programme in Management

Syllabus of

Business of Intelligence Data Wrehouse & Data Mining

Professor: Dr. N.P. Singh, $oom No. E-*Mobile: 99!"9!#$% Wireline: $"'('#)*

+(mail Id: ,n-singh.mdi/ac/inSingh/netra-al.yahoo/co/in

0redit: 1ull( 2erm (3

+o#rse Descrip!ion:

"Business Intelligence- Data warehouse & Data Mining Course is designed togive students a detailed understanding of the latest database techniques,including Data warehouse, OL!, data ining and database ar#eting$ %hecourse is highl a''lied in nature and requires solving e(ercise using currentdata warehouse & data ining software$

Many organi4ations are committing considerable human% technical and financial resources tomanage & -rocess their data/ 2he organi4ations are collecting transaction data% clic,(stream data%e5ternal data about regulatory en6ironment & com-etitors and -lanning data on a regular basis/ Inaddition% legacy data has been archi6ed and maintained as -art of the cor-oration7s ,no8ledge

base/ 2he organi4ation data is shared by the ,ee-ers of the data% the o8ners of the data% and theusers of the data/ 2hese -layers al8ays e5hibit a territorial interest & need for the data/ n theother hand% management struggles 8ith decisions regarding customer relationshi-s% eturn onin6estment% manufacturing mi5% re;uirements -lanning% and -roduct im-ro6ement 8hich certainlyneed the organi4ation data/ 2he -rocess of database decision ma,ing is nothing but intelligent usageenter-rise data to the challenges of management/

In todayor functions done by com-uters 8ith res-ect to data are-rocessing of data relating to orders% generate -ic, lists% and shi- -roduct/ In addition -rocessing ofdata to maintain -ersonnel records% to -rint -ayroll chec,s% to generate stoc, re;uisitions% to issue-urchase orders% and to -ay 6endors is also done by com-uters 8ithin an organi4ation/

In earlier days costs of storing large amounts of transaction data 8ere -rohibiti6e? technologies forreassembling the data in a meaningful 8ay 8ere lac,ing/ 2oday% storage costs are considerablylo8er and data 8arehousing 6endors ha6e sol6ed the -roblem of ca-turing and cataloguing &reassembling the large set of data/

0or-orate analysts and line managers often ha6e access to unbelie6able large 6olumes of ra8 data/@nalysis and usage of this huge amount of data is both managerial and technological issue/ 2helarge ra8 data should be con6erted into actionable intelligence for ma,ing right decisions in theorgani4ation 8ith the hel- of a6ailable technology such as data 8arehouse & front(end analytics/

BI(DWDM Page $ of # 9A$'A"$'
mailto:[email protected]:[email protected]


2/6

Dr. N.P. Singh, Professor (IT)E-ail: [email protected]

2herefore% to ma,e best use of data% decision ma,er need to ,no8 the business% the data% thetechnology% and the techni;ues to -rocess data/ It demands an understanding of 8hat data loo,sli,e and ho8 data is stored% integrated & -rocessed/ 1urther% it demands that the data be regardedas an asset/ It also demands the recognition that the asset is a ra8 material% not finished goods/

Specific ec!i"es:

2he course 8ill introduce students to the issues and techni;ues in6ol6ed in handling large

6olumes of data and e5tracting information from that data/

2he to-ic 8ill be e5-lored through the use of a te5t% hands(on 8or, 8ith data and tools/

@t the conclusion of the course% students 8ill be familiar 8ith large databases% business

intelligence issues% and data mining technology/

/e01ords 2pplicale !o career De"elopmen! 3 o 4#n!ing

Data Mining & 3isuali4ation

Data ;uality & standards

Data 8arehouse A data MartA -erational data Stores

Decision Su--ort Systems DSSC

+5tractionA 2ransformationA oading +2C

Multidimensional Database MDDC

nline @nalytical Processing @PC

Star Schemas% Sno8fla,e Schemas

Structured Euery anguage SEC%

@rtificial Feural Fet8or, @FFC/

Pricing Models

+o#rse $e5#iremen!s:

2he course 8ill consist of si5 class sessions and 8ill include:

@ssigned readings?

0lassroom discussions?

+5ercises and assignments?

Pro>ect Wor,

Mid(term e5am?

1inal e5am/

Grading in the course 8ill be based on demonstrating an understanding of the to-ic through-artici-ation in class discussions & ;ui44es "C% assignments $C% -ro>ect 8or, "C%midterm e5am "C% and final e5am "C/ 2his can be changed as course -rogress/

BI-DWDM Page 2 of 6 9/14/2014


3/6


4/6


Decision Su--ort

Data ;uality: 0ase Studies of racle 2ools/

LLL

Data Mining

Data Mining : +$ISP 8D odel

2pplica!ions:1inancial Data @nalysis% etail Industry 2elecommunication Industry% @nalysis of Stoc, Mar,et 2rends%

1raud Detection% 0redit rating 0ross Selling etc%

"

L//

ining 2ssocia!ion $#les in 9arge Da!aases

@ssociation ule Mar,eting

Mining Single Dimensional @ssociation ules from

2ransactional Data

Mining Multi Dimensional @ssociation ules from

2ransactional Data

Mining Multi Dimensional @ssociation ules from elational

databases & Data 8arehouse

Da!a ining +ase&:Mar,et Bas,et @nalysis/

"

0lassification & -rediction Issues regarding classification & Prediction

@rtificial Feural Fet8or,s

2y-es of @rtificial Feural Fet8or,s

Da!a ining +ase':eal +state @--raisal using @FF

Da!a ining +ase :2ime Series @nalysis using @FF

Da!a ining case S!#d0 ;:0hurn Management

"

0lassification & Prediction

0lassification by Decision 2ree% Bayesian 0lassification% J(

nearest Feighbor% 0ase Based easoning% Genetic @lgorithmsand their business a--lications//

Da!a ining +ase S!#d0 :2ra6eling Salesman Problem

+ase S!#d0 &:Who is using fa5 machines from home/

+ase S!#d0 &&: Segmenting 0ellular 2ele-hone 0ustomers

$

E?!rac!ing In!elligence from +omple? da!aases $



5/6


Multidimensional @nalysis & Mining of com-le5 data ob>ects

Mining Multimedia Databases% 2ime series & Se;uences Data%

2e5t databases% and WWW for business a--lications/

+ase S!#d0 &':Web =ar6esting

$eading a!erial

&. Sonia @yachi Ghannouchi et al "$C/ Pro-osal of data 8arehouse in the conte5t of healthcare -rocess reengineering % Business Process Management Houranl% $#'C: #!!(*$"/

'. Doug Barrett and Feil Barton "#C/ Best -ractices building a data 8arehouse ;uic,ly%Business Intelligence Houranl% $$'C: )*('

. Singh% F/P/ and Fayeem% K/ "$$C/ 0ritical @nalysis of +5-ansion Strategies of S@P%IBM% racle and Microsoft in the area of Business Intelligence , International Hournal of

Strategic Information 2echnology and @--lications% ""C: ")(')/

;. Singh% F/P/ "$)C/@nalysis of +merging 2rends and 2echnologies Influencing the 1utureof Business Intelligence BIC Mar,et% International Hournal Business Intelligence esearchIn ProcessC/

. 0unningham% 0/% Il(Neol Song% and 0hen% P/P/ "#C/ Data 8arehouse design to su--ortcustomer relationshi- management @nalyses% Hournal of Database Management% $*"C: #"(!'/

&. Go8an% H/@/% Mathieu% /G/% and =ey% M/B/ "#C/ +arned 6alue management in a data8arehouse -ro>ect% Information Management & 0om-uter Society% $'$C: )*(/

&&. Keng% Nun et al ")C/ +nter-rise integration 8ith ad6anced information technologies:

+P and Data 8arehousing% Information Management & 0om-uter Security% $$)C: $$($""/

&'. Dorte Jronborg% 2ue 2>ur% and Bo 3incents $99!C/ 0redit scoring: Discussion ofmethods and a case study% htt-:AAe4learn/cbs/d,AstatA-re-rintsAstat(--($99!(*/-df/

&. Mar, Schreiner "C/ +redi! Scoring for Microfinance: 0an It Wor,O%htt-:AA888/microfinance/comA+nglishAPa-ersAScoring0anItWor,/-df/

http://ezlearn.cbs.dk/stat/preprints/stat-pp-1998-7.pdfhttp://www.microfinance.com/English/Papers/Scoring_Can_It_Work.pdfhttp://ezlearn.cbs.dk/stat/preprints/stat-pp-1998-7.pdfhttp://www.microfinance.com/English/Papers/Scoring_Can_It_Work.pdf


6/6


&;. @ntonio Blanco% @na Irimia% and Maria Dolores "$C/ li6er0redit scoringmodel for small firms in the J using logistic regression%htt-:AA888/google/co/inAsearchO;QcaseRstudyRofRcreditRscoringRmodelR-df&hlQen&gb6Q"&-rmdQi6ns&eiQ!H-Nih1srrEfb'0'0E&startQ$&saQF/

&

bi syllabus by n.p. singh 13.pgp

Documents