create data warehouse to data mining predictions

Question

I have a database including these tables

student,subjects,marks,etc in mark table i have the columns  which will be predict.  i want to create data warehouse in order to create mining models for get predictions.

I want to know what table is prefer to as a fact table and what are the dim tables ?

Answer 1

you do not need a "data warehouse" to create data mining models.

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

Answer 2

thanks for the reply :)  but the thing is this is my research project so my examiner wants to do this using warehouse.

Answer 3

ok - sorry about assuming.

I do not want to give out a straight answer because it's your project. But In simplest of terms:

Fact table contains numbers (that you want to sum/average/count/...)

Dimension Table contains Fields that you want to group them by.

So if you want to group "average(marks)" by subjects.

your fact = marks

your dimension = subject

I hope it's a decent starting point for you.

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

Answer 4

I will look in to it,thanks for your support !!! :)