March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
04-22-2023 07:51 AM - last edited 07-25-2023 18:06 PM
BACKGROUND
Attendance is vital to learning, however the abundance of noise contained within attendance data can make it difficult for school administrators to find the information they need to tell a clear concise story, especially if they are tracking across many different teachers, classes, and schools.
Improved technology can help administrators turn this daunting chaotic data into meaningful information. Under older technology systems it was difficult to share current up-to-date data in a way that anyone can use. Now, institutions are empowered to share data through Microsoft’s Power BI Dashboards. The following is an elegant and clear example of how complicated data from many different class rooms, teachers, and schools can be organized into a simple dashboard.
DATA STORY
Research shows more conversations between students and teachers can lead to increased attendance. Therefore, we designed this dashboard to drive more conversations, and increased engagement, between administrators, teachers, and students. This dashboard will identify important conversations from the district level down to each individual teacher.
FLOW
The District Status section provides district administrators with a high-level understanding of attendance trends and goals. The line chart shows actuals compared to target over time and gives a predicted range for future months.
The Opportunities by School section will help district administrators target the most important schools to work with. Most important is defined as having the highest opportunity for Absence Reduction.
The Conversation Topics section will help school administrators as they reach out to teachers on an individual basis. This sections provides relevant information such as subject, course, period, and day of the week.
INTERACTIONS
We gave special attention to interactions within Power BI. Using insights gained from each section, the next section can be filtered to target areas of interested or concern.
First use the Opportunities by School section to multi-select schools that are most important to target
For example, the user may wish to select “high schools” only.
This will result in a comparison of “high schools” that contain the highest opportunity for absence reduction. This section of the dashboard shows the ‘Absence Percentage’ distributed by Subject. This is helpful for school administrations to create strategies to decrease absences.
Next, within the Conversation Topics section, select a subject such as “math”. This gives school administrators the insights by individual teacher. Finally, further information about an individual teacher’s classes can be used to help facilitate relevant conversations.
SUMMARY
One of the most valuable aspects of growing in digital maturity, is to use data to provide insights into our area of influence. The use of Power BI to build this Absence Reduction Report is a powerful example of how new technology has transformed a school administrations’ ability to track their student’s attendance and identify strategies for reducing absences for schools, teachers, or by subject.
By Evan Schmidt, Ed Meyer, Tully Lanter, Jared Knutzen, and Casey McBreen
eyJrIjoiNmIzOWVjYzgtNmYzNC00Yzg0LWFhZWYtOTE5MThkYzUwNTkwIiwidCI6IjdlY2M4YWEwLTgzMGUtNGQ4Ni1hZjc4LTgzYTNkY2MyNjIzOCIsImMiOjZ9
Informative dashboard
informative dashboard
easy to visualize data
Great dashboard!
Hello, this is super dashboard, great job! Would it be possible to share this amazing pbix file with me at nnelnoven@gmail.com? I'm just learning Power BI and this example would add much to my learning.
Hello, I am new to PB and looking to see how it might support our school use of data. Your attendence dashboard looks helpful, can you please share the pbix file? My email is michael.ferland@mausd.org. Thank you.
Hi,
It's very nice.
Can you please share the pbix file? stars889@outlook.com
Great work. if possible please can you share it.
My e-mail diegoalex-z@hotmail.com
Thanks.
Superb report - would love a copy of the bix if possible?
My email address is squeakeasy@gmail.com
Many thanks in advance.
Les
Can you share the pbix file with me? my email address is yyycara@21cn.com
Thank you so much!
Great!!.
Could you please share .pbix file with me?
carlos.villarroel@atlantisparadise.com
Can you share the pbix file with me? my email address is andresmorelo1@gmail.com
thank you so much.
Can you please share the pbix file with me?
Great work. if possible please can you share
Great work. if possible please can you share it
Wonderful.
If there any possible to share the pbix file
Thank you!
Found this as one of the best Attendance Dashboard, Kindly please share this power .PBIX
Great work. if possible please can you share it
Thanks.
One of the best Dashboard i have seen in Power BI
Wonderful project looking quite good. I am a student practicing Power BI please do share .pbix file
Nice work! Can I get PBIX file. Thank you~
Nice work! Can I get PBIX file. Thank you~