users

userid INT $(11)$

usergender VARCHAR $(200)$

userdob VARCHAR$(200)$

ads VARCHAR $(200)$

referralcode VARCHAR$(200)$

usertype VARCHAR$(100)$

userjoin date DATETIME

Indexes

discount

discountid INT$(11)$

discounttype VARCHAR$(200)$

discounttypevalue DECIMAL $(10,2)$

discountam ounttype VARCHAR$(200)$

discountam ountvalue DECIMAL $(10,2)$

discountcode VARCHAR$(200)$

discountdateexpire DATETIME

discountm axuse INT$(11)$

Indexes

enrollment

enrollmentid INT $(11)$

enrollmentstudentid INT$(11)$

salesorderid INT $(11)$

enrollmentclassid INT$(11)$

enrollmentcheckinstatus VARCHAR$(200)$

enrollmentcheckindate DATETIME

enrollmentclasspaid DECIMAL $(10,2)$

enrollmentstatus VARCHAR$(200)$

Indexes

I need to build a Data Warehouse of the above data, give me an ERD for all KPIs together or Individual.

Need to Create an SSIS package solution that can perform ETL process to load data into the OLAP database

Give me all the details and explain step by step what needs to be done to get answers for below KPIs in Visual studio. The figure above shows tables of the Dance class's OLAP.

Five KPIs for data warehouse are mentioned below:

$1.$Class attendance per class, and average student per class

$2.$How frequently for one student to miss class, take classes in a week and in a month?

$3.$Sum of Sales Dollar by month.

$4.$Impact of discount to sales dollar.

$5.$How often does one customer add class to shopping cart and purchase it $($conversion rate$)?$