Updated: 2023-09-13 (Fall 2023)
Navigating a Power BI Report
How to Use This Page
This page explains what to expect when navigating a Power Bi report, beginning with a table of helpful keyboard shortcuts for Mac and Windows. Next there is a general description of how to navigate power bi reports and visuals using the keyboard. Finally, there is a long description of each report page and the visuals on the page. The description outlines the key takeaways from each visual and includes summarized data tables where relevant. For the most detailed information access the report itself.
Keyboard Shortcuts
Mac
Across the product
- Move focus between sections e.g. between the report and power bi controls (zoom, page selection): Command + F6
- Move focus backwards between sections: Shift + Command + F6
- Show keyboard shortcuts: Shift + ?
On a single visual – e.g. chart, graph, slicer
- Move focus to visual menu: Option + Shift + F10
- Show visual as a table: Option + Shift + F11
- Enter a visual or layer: Enter
- Exit a layer or visual: Esc
- Select or unselect data point: Space
- Multi-select data points: Command + H
- Clear data selection: Ctrl + Shift + C
- Open Link within Visual: Command + Option + O
- Apply all slicers: Ctrl + Shift + Down arrow
Windows
Across the product
- Move focus between sections e.g. between the report and power bi controls (zoom, page selection): Ctrl + F6
- Move focus backwards between sections: Shift + Ctrl+ F6
- Show keyboard shortcuts: Shift + ?
On a single visual – e.g. chart, graph, slicer
- Move focus to visual menu: Alt+ Shift + F10
- Show visual as a table: Alt+ Shift + F11
- Enter a visual or layer: Enter
- Exit a layer or visual: Esc
- Select or unselect data point: Space
- Multi-select data points: Ctrl + H
- Clear data selection: Ctrl + Shift + C
- Open Link within Visual: Ctrl + Alt + O
- Apply all slicers: Ctrl + Shift + Down arrow
Report Structure
Power Bi is a data visualization tool, the reports are made up of independent visuals which include text boxes, slicers/filters, bar charts, graphs, pie charts, and other types of data visualizations. With the exception of textboxes, all Power Bi visuals are interactive, which means you select individual data points and filter all other visuals on the page. For example, on a bar chart that shows the average cost of a course by department, you can select a single department on the chart and all other visuals on the page will be filtered to show only data from that department.
Every page in this report begins with the title of the page. Next there are two slicers. Slicers are filters that are on the page with the visuals. There is a College/School slicer that lets you choose which colleges to see data from (e.g. College of Arts and Sciences, College of Design, etc) and a Term filter that lets you select one or more terms. The slicers are linked so if you make a selection on one page it will remain selected for all pages until you change it. The last element on every page is the UO libraries logo which has a link to the OER website.
Navigating Visuals
Use the tab key to navigate between visuals, screen readers will read out the title of the visual, the visual type, and alt text associated with the visual. Once on a visual, use the enter key to interact with elements within the visual. If the visual has an axis, legend, and/or some kind of chart component, you’ll be able to tab between those elements. Use the enter key to move to the next layer – for example to read individual points on an axis or to read the values in a chart. Use the Enter key or Space key to select a data point and filter other visuals on the page. Use the Esc key to exit a visual layer so you can tab to other sections of the visual or other visuals on the page.
Every visual has its own menu. Visual menus include: pin visual (to another power bi dashboard), copy visual, see filters affecting the visual, share the visual, show the visual as a table (which will allow you to interact with the data in the chart you’ve selected in a table format), and sort axis which allows you to choose which field the axis is sorted on. To access the visual menu, select a visual and then press “Option + Shift + F10” on mac or “Alt + Shift + F10” on Windows. To quickly enter table view select “Option + Shift + F11” on mac or “Alt + Shift + F11.”
General Power Bi Navigation
If you ever find that you’re caught in a keyboard trap, use the Esc key to exist the visual layer you’re in or use Command + F6 or Ctrl + F6 to navigate back to the report or into other Power Bi controls like Zoom and page navigation. See additional keyboard shortcuts above and select ‘Shift + ?’ to access a list of Power Bi shortcuts when navigating a report.
Description of pages and visuals
Page one: About
Header:
Title: Course Material Costs at UO
Slicer: College/School: select one or more colleges. Colleges: American English Institute, Clark Honors College, College of Arts and Sciences, College of Design, College of Education, Lundquist College of Business, School of Journalism and Communication, School of Law, School of Music and Dance, Supplementary Academic Programming.
Slicer: Term: Fall 2022, Winter 2023, Spring 2023, Summer 2023, Fall 2023
The slicers are linked so if you make a selection on one page it will remain selected for all pages until you change it. The default is all colleges/schools and all terms selected.
About the Report – Textbox:
As part of UO Libraries's effort to decrease student spending on course materials, we are also increasing our data collection and transparency about what UO students are currently spending on their required books and materials. This report explores student spending and celebrates instructors' efforts to lower course material costs.
Where did we get this data?
Each term, instructors report their course materials to the Duck Store, the Duck Store provides that data back to us with cost estimates for all materials.
What counts as "course materials"?
You'll see the term "course material" used throughout this report. It refers to any books, course supplies (like iClickers), homework systems, films, etc. Any material students are expected to engage with that isn't an instructor lecture. Course materials do not include course fees like Studio supplies or art kits.
How can you filter the data?
Use the drop-down filters at the top of the report to filter all the data on the page by College/School and/or by term.
Notice an Error?
If you notice an error in the data or in the report, please contact the OER specialist (aservice@uoregon.edu)
Percent of Sections Reporting – Textbox
This report is only as accurate as the underlying data. The chart above shows you what percent of course sections from each college reported the course materials they use to the Duck store. Overall, instructors reported course materials for about 70% of all course sections. Due to this under reporting, and some misreporting, it is very likely that more course sections use no-cost materials than were reported.
Percent of Sections Reporting their Course Materials to the Duck Store – 100% Stacked bar chart
Key takeaway
The college of arts and sciences, Lundquist college of business, and the school of law have 75-80% of course sections reporting their materials to the duck store. The other colleges have lower reporting rates, between 30 and 70%. The College of Design has the third highest number of course sections but only about 43% of sections reporting.
Description
Y-axis is College/School, sorted by number of total sections (descending)
X axis: 100% bars where 100% is the total number of sections for that college/school and bars show percentage of course sections reporting divided into Reporting is “yes” and Reporting is “No”
Legend: Reporting: “Yes”, “No”
Download Summarized Data Table
Term is: Fall 2022 through Fall 2023
Page two: Student Spending
Header
Title: Student Spending
Slicer: College/School: select one or more colleges. Colleges: American English Institute, Clark Honors College, College of Arts and Sciences, College of Design, College of Education, Lundquist College of Business, School of Journalism and Communication, School of Law, School of Music and Dance, Supplementary Academic Programming.
Slicer: Term: Fall 2022, Winter 2023, Spring 2023, Summer 2023, Fall 2023
The slicers are linked so if you make a selection on one page it will remain selected for all pages until you change it. The default is all colleges/schools and all terms selected.
Course Type: by percentage of total enrollment—bar chart
Key Takeaway:
34% of all enrollment spots are in high-cost course, no course material required courses are the next highest, representing 32% of total enrollment. Low-cost Courses ($50 or less) represent 19% of enrollment spots, and no cost courses just 5.75%. Between high cost and low-cost courses, over 50% of enrollment spots are in paid courses.
Description:
Y axis: course type
X axis: number of course sections by percentage of total course sections.
Download Data Table
Info Button – Course Type
- High-Cost Course: Course materials for these courses total over $50.
- Low-Cost Course: Course materials for these courses total $50 or less.
- No Course Materials Required: courses don’t use any course materials.
- No Cost Course: these courses use only no cost resources like OER, Library readings and Canvas readings.
- Unknown: the Duck Store cannot provide a price estimate on material for these courses.
- Optional/Recommended Only: these courses have no required materials, only optional and/or recommended materials.
Percentage of Sections Reporting Materials to the Duck Store – pie chart
70% (9546) of all course sections have reported their materials to the duck store, 30% (4198) have not reported.
Info Button -- % of sections reporting
This report is only as accurate as the underlying data, this data is reported by instructors each term to the Duck Store and then shared with the Library. This chart shows you the percent of courses sections that reported their materials to the Duck Store. Keep in mind that there is a significant amount of missing data.
Combined Textboxes and Cards:
This section of the report contains two textboxes and three cards (which each display a single value). They are intended to be read together:
On average, students taking 4 courses are required to pay: $42.23 per course, $168.93 per term, $506.8 per year. Textbook costs are unpredictable and distributed unevenly, some students pay as must as $336 per course. Approximately 84% of student spending is driven by high-cost courses: If every student bought their required textbooks, they would spend: $9,706,676.
Bar Chart
Key Takeaway:
About 80% ($7.7 million) of student spending on textbooks is on books for high-cost courses, just 20% ($1.4 million) of student spending is driven by low-cost courses. However low-cost courses make up 43% of paid course sections.
Description:
The bar chart shows a single bar split into two highlighted sections. The total value of the bar is total student spending on textbooks (9.7 million dollars). This total spending is split into spending in High-Cost courses ($7.7 million) and spending in Low cost courses ($1.4 million). The tooltip shows that there are 1677 (67%) high-cost course sections and 1317 (43%) low-cost course sections.
The Digital Rental Model: High Prices and Expiration Dates – Textbox
Textbook publishers are shifting to a digital rental model. Students rent books for pro-rated prices instead of buying them. But rental prices remain high, students often pay $50-$100 for 18-week access. This. Model forces students to rent directly from publishers and destroys the book lending and used book market by inflating print prices and disincentivizing book purchasing. After paying high prices, students lose access to their materials.
Major Publishers Primarily Using the Digital Rental Model – comparative/clustered bar chart
Key Takeaway
A single book/material from a publisher that uses the digital-rental model costs on average $191 - $44. Vista higher learning is the most expensive ($191), Cengage, McGraw Hill, and Pearson all cost $70-$90 each on average. MPS and Norton average around $45.
Description:
A clustered bar chart, the y axis has six major publishers, for each publisher there is one bar that shows that average cost of a single material from that publisher, and a bar that shows how many books from that publisher are required in UO courses.
Download Data Table
Page three: Cost Avoidance
Header
Title: Student Spending
Slicer: College/School: select one or more colleges. Colleges: American English Institute, Clark Honors College, College of Arts and Sciences, College of Design, College of Education, Lundquist College of Business, School of Journalism and Communication, School of Law, School of Music and Dance, Supplementary Academic Programming.
Slicer: Term: Fall 2022, Winter 2023, Spring 2023, Summer 2023, Fall 2023
The slicers are linked so if you make a selection on one page it will remain selected for all pages until you change it. The default is all colleges/schools and all terms selected.
What is Cost Avoidance? -- Textbox
Any course that uses a no-cost resource helps students avoid course material costs by replacing a paid textbook/material with a free alternative. No-cost resources include Open Educational Resources (OER), Canvas readings, and Library Readings
Why "Cost Avoidance"?
We use the term "cost avoidance" because, realistically, not every student buys their required textbooks. When textbooks are prohibitively expensive, students make hard choices including skipping textbook purchases. However, when we calculate "cost avoidance" we assume that every enrolled student will purchase the textbook, because ideally every student should have textbook access. We DO NOT include courses that do not require any course materials in our cost avoidance calculations, even though they are also effectively no cost courses.
Calculating Cost Avoidance
We multiply the total enrollment of each course that uses a no-cost resource by a standard average textbook price ($75).
Total Student Cost Avoidance – Card
$1,397,100
Total Student Cost Avoidance – donut chart
Total student cost avoidance ($1,397,100) split into 3 sections – Canvas readings ($612,300, 43.8%), OER ($747,225, 53.48%) and Library readings ($37,575, 2.69%).
Want to Learn More About No Cost Resources?
Visit the OER and Textbook Affordability libguide to learn more about finding, using, and creating Open Educational Resources (OER).
Average Total Class Cost by level – bar chart
Key Takeaway:
200 level courses are the most expensive courses on average (~$57 per course). All other course levels cost less than $50 per course on average. Upper-level courses are the least expensive.
Description:
The x-axis shows course level (100, 200, 300...), the y-axis shows the average course section cost per student. For each level, a bar shows the average cost per student.
Download Data Table
Average course cost -- Textbox
No cost courses aren't the only way instructors can help lower student costs. Some courses will always require paid materials, but keeping those costs as low as possible makes a difference. Students pay less than $50 per course on average for all courses except 200 level courses. And course materials costs decline significantly in upper level and graduate courses.