AnsweredAssumed Answered

Specific fact/dimension table combinations (including fields) to produce the report below

Question asked by Jasmiene Domingo on Oct 25, 2019
Latest reply on Oct 26, 2019 by Jasmiene Domingo

Using Power BI, which fact & dimension tables (including Field Name) to join in order to

generate a monthly status report for courses under a selected sub-account level.

 

SAMPLE NO. 1 

selected sub-account + selected date range + course id + faculty who handles the course + total no. of students enrolled + number of content published 

 

SUB-ACCT

DATE RANGE

COURSE ID

FACULTY

NO. STUDENTS ENROLLED

NO. OF CONTENTS PUBLISHED

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

5

 

SAMPLE NO. 2

selected sub-account + selected date range + course id + faculty who handles the course + total no. of students enrolled + specific content published + number of unique views + number of unique responses 

 

SUB-ACCT

DATE RANGE

COURSE ID

FACULTY

NO. STUDENTS ENROLLED

SPECIFIC CONTENTS PUBLISHED (Heading)

NO OF UNIQUE VIEWS

NO. OF UNIQUE RESPONSES

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

Announcement 1

15

0

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

Quiz 1

43

37

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

Discussion 1

2

0

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

Discussion 2

4

0

CAS

Sept.2-Sept. 30, 2019

ADV 2

Juana Dela Cruz

45

Discussion 3

41

0

 

Outcomes