RIS622 A D

T: 051 401 2754 itinfo@ufs.ac.za
www.ufs.ac.za/it

RIS622
–

A
DVANCED

D
ATABASES

Dr. Eduan Kotzé

2012

M
ODULE

O
BJECTIVE

•
Learn

the

fundamentals

of

Business

Intelligence

(BI)

and

how

apply

the

knowledge

of

BI

delivery

channels

(reports,

cubes

&

dashboards)

to

deliver

information

from

data

warehouses
.



•
Learn

the

basics

of

data

mining

and

apply

some

of

the

data

mining

techniques

on

sample

data
.



D
EVELOPMENT

E
NVIRONMENT

•
Microsoft Business Intelligence Development
Studio (BIDS) 2008:

–
Analysis Services (SSAS)

–
Data Mining (part of SSAS)

•
Visual Studio 2010 (with
MDX
)

•
SQL Server 2008 R2


•
For further reading visit:
http://en.wikipedia.org/wiki/Business_Intelligence_Development_Studio

A
SSESSMENT

•
Class Tests (20%)


•
Practical Assignments (20%)


•
Practical Project (60%)

–
No

written

examination
.

–
Build

a

Dashboard

(VS

2010
)

for

a

customer

which

must

include

Grids,

Reports,

KPI’s

etc
.

The

data

sources

will

consist

of

dimensional

databases

and

cubes
.


P
RESCRIBED

B
OOK

(
USED

IN

RIS625)

Data Warehousing Fundamentals

For IT Professionals


2
nd

Edition

Paulray

Ponniah

Wiley Computer Publishing

New Jersey

2010


ISBN: 978
-
0
-
470
-
46207
-
2



T: 051 401 2754 itinfo@ufs.ac.za
www.ufs.ac.za/it

Questions?

Vrae
?