RIS622 A D

voltaireblingData Management

Nov 20, 2013 (3 years and 6 months ago)

72 views

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
?