What is Power Bi?

Power BI is a data visualization and business intelligence tool developed by Microsoft. It allows users to connect to various data sources and create interactive dashboards and reports. Power BI helps users visualize data, discover insights, and view information.

Power BI has now been implemented after a review from the SU LENS campaign in 24-25 noted that some schools with high numbers found viewing the data within SITS hard and admin heavy. Having reviewed this process and from our own experience of Power Bi, we have developed a school/discipline Power Bi report for each academic area.

How do I access Power BI?

It is encouraged that you bookmark your home page when you have gotten access to Power BI. However, you can also access it through ​the M365 Copilot and accessing it by following the steps shown here;

1) 

2)

Power Bi is taking the information held in SITS and student LENS reports and making it easier visually to view and find the data required by schools.

​Access is provided annually, similar to the previous SITS access, via the MS Form circulated – This form is circulated by the disAbility Service and is sent out in July/August.

All staff listed must have completed the mandatory College Data Protection and Cyber Security Training prior to being granted access.

Access cannot be given to all school staff; only the names provided due to the classification of data being provided in the report.

Power Bi License can be requested for free via the IT Service Desk.

How do I open reports within Power BI?

Once you have located Power BI within your apps and you are in the home page, it is very straight forward to begin accessing any reports you have created or have been shared with you. 

1)2)

When viewing End of Year Results, make sure that you have selected the correct year you wish to gain information on as highlighted in the image below;

This will give you a cursory breakdown of the results, including:

• Total of pass-fail – LENS active only, and, only available at the end of each annual exam period summer and supplemental ​
• You can drill down to draw down a list of who these students area​
• You can filter by accommodation type / Course type – PG/UG and the SCE course status 

You can view the results breakdown by School/Faculty. You cancan also drill down to school level and then to student level as needed.