Skip to content

hadiMh/data_warehouse_of_online_course_website

Repository files navigation

Data Warehouse of Online Course Selling Website

Data Warehouse to keep track of database data of an online course selling website.

datawarehouse-min

Data Marts:

  1. Course Education

    • Facts:
      1. Course_Education
      2. C_Fact_CourseBuying
      3. C_Fact_CourseBuying_Periodic
      4. C_Fact_CourseDownloading
      5. C_Fact_Course_Downloading_Periodic
  2. User Behavior

    • Facts:
      1. U_Fact_UserRating
      2. U_Fact_PassedCourses
      3. U_Fact_UserRate_Acc
      4. U_Fact_Comments
      5. U_Fact_CommentRating
      6. U_Fact_InfluentialUsers_Acc
  3. Human Resources

    • Facts:
      1. Human Resources ترامHR_Fact_InstructorCourse_T
      2. HR_Fact_InstructorCourse_ACC
      3. HR_Fact_InstructorRate_Daily
      4. HR_Fact_StaffPayment_T
      5. HR_Fact_StaffPayment_Yearly
      6. HR_Fact_Tickets_Daily

Dimensions:

  1. S_Dim_User
  2. S_Dim_Course
  3. S_Dim_Date
  4. C_Dim_CourseTopic
  5. HR_Dim_Instructor
  6. HR_Dim_Staff
  7. HR_Dim_TicketCategory

Dimensions Details:

  1. S_Dim_User

  1. S_Dim_Course

  1. S_Dim_Date

  1. C_Dim_CourseTopic

  1. HR_Dim_Instructor

  1. HR_Dim_Staff

  1. HR_Dim_TicketCategory

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages