Step by step working on powerBI

1. List Bob Norberts course schedule in spring 2008. For each course, list the offering number, course number, days, location, time, and faculty name.
2. List Bob Norberts course schedule in spring 2008. For each course, list the offering number, course number, days, location, time, course units, and faculty name.
3. List the course number, the offering number, and the number of students enrolled. Only include courses offered in spring 2008.
4. List the course number, the offering number, and the average GPA of students enrolled. Only include courses offered in Fall 2007 in which the GPA of enrolled students is greater than 3.0.
5. List the student number, name, and major of students who have a high grade (>= 3.5) in a course offering.
6. Retrieve the name, city, and grade of students who have a high grade (>=3.5) in a course offered in fall 2007 taught by Leonard Vince.
7. Retrieve the social security number, name (first and last), department, and salary of faculty who are not students.
8. List the faculty number, the last name, and the number of unique courses taught.
9. You will create a dashboard and include the answers for the questions 5,6,7 and 8 inside the dashboard. You can use the Q&A on Power BI service if you want.

\begin{tabular}{|l|l|r|} \hline CourseNo & \multicolumn{1}{|c|}{ crsDesc } & CrsUnits \\ \hline FIN300 & FUNDAMENTALS OF FINANCE & 4 \\ \hline FIN450 & PRINCIPLES OF INVESTMENTS & 4 \\ \hline FIN480 & CORPORATE FINANCE & 4 \\ \hline IS320 & FUNDAMENTALS OF BUSINESS PROGRAMMING & 4 \\ \hline IS460 & SYSTEMS ANALYSIS & 4 \\ \hline IS470 & BUSINESS DATA COMMUNICATIONS & 4 \\ \hline IS480 & FUNDAMENTALS OF DATABASE MANAGEMENT & 4 \\ \hline \end{tabular} Data \begin{tabular}{|r|r|r|} \hline OfferNo & stdNo & EnrGrade \\ \hline 1234 & 123456789 & 3.3 \\ \hline 1234 & 234567890 & 3.5 \\ \hline 1234 & 345678901 & 3.2 \\ \hline 1234 & 456789012 & 3.1 \\ \hline 1234 & 567890123 & 3.8 \\ \hline 1234 & 678901234 & 3.4 \\ \hline 4321 & 123456789 & 3.5 \\ \hline 4321 & 124567890 & 3.2 \\ \hline 4321 & 789012345 & 3.5 \\ \hline 4321 & 876543210 & 3.1 \\ \hline 4321 & 890123456 & 3.4 \\ \hline 4321 & 901234567 & 3.1 \\ \hline 5555 & 123456789 & 3.2 \\ \hline 5555 & 124567890 & 2.7 \\ \hline 5678 & 123456789 & 3.2 \\ \hline 5678 & 234567890 & 2.8 \\ \hline 5678 & 345678901 & 3.3 \\ \hline 5678 & 456789012 & 3.4 \\ \hline 5678 & 567890123 & 2.6 \\ \hline 5679 & 123456789 & 2 \\ \hline 5679 & 124567890 & 3.7 \\ \hline 5679 & 678901234 & 3.3 \\ \hline 5679 & 789012345 & 3.8 \\ \hline 5679 & 890123456 & 2.9 \\ \hline 5679 & 901234567 & 3.1 \\ \hline 6666 & 234567890 & 3.1 \\ \hline 6666 & 567890123 & 3.6 \\ \hline 7777 & 876543210 & 3.4 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline FacNo & FacFirstName & & FaclastName & & FacCity & FacState & FacDept & FacRank & FacSalary & FacSupervisor & FacHireDate & FacZipCode & SALINCREASED \\ \hline 98765432 & LEONARD & & VINCE & & SEATTLE & WA & MS & ASST & 35000 & 654321098 & Saturday, October 4, 1997 & 981119921 & 38500 \\ \hline 543210987 & VICTORIA & & EMMANUEL & & BOTHELL & WA & MS & PROF & 120000 & & Sunday, January 4, 1998 & 980112242 & 132000 \\ \hline 654321098 & LEONARD & & FIBON & & SEATTLE & WA & MS & ASSC & 70000 & 543210987 & Friday, January 5, 1996 & 981210094 & 77000 \\ \hline 765432109 & NICKI & & MACON & & BELLEVUE & WA & FIN & PROF & 65000 & & Thursday, November 4, 1999 & 980159945 & 71500 \\ \hline 876543210 & CRISTOPHER & & COLAN & & SEATTLE & WA & MS & ASST & 40000 & 654321098 & Wednesday, January 3, 2001 & 981141332 & 44000 \\ \hline 987654321 & JULIA & & MILLS & & SEATTLE & WA & FIN & ASSC & 75000 & 765432109 & Friday, March 15, 2002 & 981149954 & 82500 \\ \hline \end{tabular} Data Data \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline OfferNo & CourseNo & OffTerm & OffYear & OffLocation & Offtime & FacNo & OffDays & OffLimit & OffNumEnrolled \\ \hline 1111 & IS320 & SUMMER & 2008 & BLM302 & 10:30:00 AM & 654321098 & MW & 0 & p \\ \hline 1234 & IS320 & FALL & 2007 & BLM302 & 10:30:00 AM & 98765432 & MW & 0 & p \\ \hline 2222 & IS460 & SUMMER & 2007 & BLM412 & 1:30:00 PM & 654321098 & TTH & 0 & p \\ \hline 3333 & IS320 & SPRING & 2008 & BLM214 & 8:30:00 AM & 98765432 & MW & 0 & p \\ \hline 4321 & IS320 & FALL & 2007 & BLM214 & 3:30:00 PM & 98765432 & TTH & 0 & p \\ \hline 4444 & IS320 & WINTER & 2008 & BLM302 & 3:30:00 PM & 543210987 & TTH & 0 & p \\ \hline 5555 & FIN300 & WINTER & 2008 & BLM207 & 8:30:00 AM & 765432109 & MW & 0 & p \\ \hline 5678 & IS480 & WINTER & 2008 & BLM302 & 10:30:00 AM & 987654321 & MW & 0 & p \\ \hline 5679 & IS480 & SPRING & 2008 & BLM412 & 3:30:00 PM & 876543210 & TTH & 0 & p \\ \hline 6666 & FIN450 & WINTER & 2008 & BLM212 & 10:30:00 AM & 987654321 & TTH & 0 & p \\ \hline 7777 & FIN480 & SPRING & 2008 & BLM305 & 1:30:00 PM & 765432109 & MW & 0 & p \\ \hline 8888 & IS320 & SUMMER & 2008 & BLM405 & 1:30:00 PM & 654321098 & MW & 0 & p \\ \hline 9876 & IS460 & SPRING & 2008 & BLM307 & 1:30:00 PM & 654321098 & TTH & 0 & p \\ \hline \end{tabular} \begin{tabular}{|c|} \hline Search \\ \hline Course \\ \hline CourseNo \\ \hline crsDesc \\ \hline CrsUnits \\ \hline Enrollment \\ \hline EnrGrade \\ \hline OfferNo \\ \hline stdNo \\ \hline> Faculty \\ \hline offering \\ \hline CourseNo \\ \hline FacNo \\ \hline OffDays \\ \hline OfferNo \\ \hline OffLimit \\ \hline OffLocation \\ \hline OffNumEnrolled \\ \hline OffTerm \\ \hline OffTime \\ \hline OffYear \\ \hline> Student \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline stdNo & stdFirstName & stdLastName & stdCity & stdState & stdMajor & stdClass & stdGPA & stdZip \\ \hline 123456789 & HOMER & WELLS & SEATTLE & WA & IS & FR & 3 & 981211111 \\ \hline 124567890 & BOB & NORBERT & BOTHELL & WA & FIN & JR & 2.7 & 980112121 \\ \hline 234567890 & CANDY & KENDALL & TACOMA & WA & ACCT & JR & 3.5 & 990423321 \\ \hline 345678901 & WALLY & KENDALL & SEATTLE & WA & IS & SR & 2.8 & 981231141 \\ \hline 456789012 & JOE & ESTRADA & SEATTLE & WA & FIN & SR & 3.2 & 981212333 \\ \hline 567890123 & MARIAH & DODGE & SEATTLE & WA & IS & JR & 3.6 & 981140021 \\ \hline 678901234 & TESS & DODGE & REDMOND & WA & ACCT & SO & 3.3 & 981162344 \\ \hline 789012345 & ROBERTO & MORALES & SEATTLE & WA & FIN & JR & 2.5 & 981212212 \\ \hline 876543210 & CRISTOPHER & COLAN & SEATTLE & WA & IS & SR & 4 & 981141332 \\ \hline 890123456 & LUKE & BRAZZI & SEATTLE & WA & IS & SR & 2.2 & 981160021 \\ \hline 901234567 & WILLIAM & PILGRIM & BOTHELL & WA & IS & SO & 3.8 & 981131885 \\ \hline \end{tabular} Data