Use DAX to create a calculated column for percentage attendance

Power BI Skills

Day 1 - Installing Power BI and Basic End-User Techniques

Day 2 - Create a really simple report

Objectives for Day 2 (0:58)
Export some basic pupil data from SIMS (14:54)
Check you have the latest Power BI ribbon (Spring 2020) (1:42)
Create your first Power BI report (19:06)
Homework

Day 3 - The Power BI Service

Objectives for Day 3 (2:09)
The free Power BI Service (14:13)
Dashboards and one more reason to use the Power BI service (6:31)
Sharing reports with the paid-for Power BI Service Pro (9:57)
Quiz

Day 4 - More about SIMS reports and introducing the Power Query Editor

Objectives for day 4 (2:06)
Admission numbers, UPNs and external IDs (4:10)
Third party reporting in SIMS (1:24)
Create a new SIMS report for PupilData.csv (13:54)
Power Query Editor (10:37)
Create a new Power BI report file (pbix) (12:26)

Day 5 - Intro to bar charts, cards, pie charts, maps and treemaps

Objectives for day 5 (1:06)
Familiarize yourself with the Power BI screen (4:11)
A card visualization to show pupils on roll (5:04)
Pie charts for gender graphs (3:52)
Create an ethnicity treemap (2:59)
Map visualization (2:36)
Pupil premium bar chart (5:04)
Quiz

Day 6 - Using the Power Query Editor to transform and add to your data

Objectives for day 6 (1:48)
Tidying up our CSV using Power Query Editor (13:03)
Tip Moving your csv file (1:48)
Tip: Adding columns to the original csv file (2:07)
Add a Surname & Forename column (4:16)

Day 7 - Using and applying filters

Day 8 - design principles (and drill down)

Day 9 - slicers

Day 10 - A bit of revision and homework

Day 11 - Attendance data and relationships

Exporting attendance statistics from SIMS (8:56)
Getting the attendance data into Power BI - and an introduction to relationships (8:28)
Authorised and unauthorised absences (9:08)
Appendix: A copy of my attendance.csv for those without access to SIMS

Day 12 - year groups or registration groups in the wrong order? Here's why...

Day 13 - Understanding attendance statistics, matrix and table visualizations

Day 14 - Calculated columns and conditional formatting

Objectives for day 14 (1:17)
Use DAX to create a calculated column for percentage attendance (10:13)
Using a table and matrix visualization with the percentage attendance column (6:59)
Adding a guage visualization (5:54)
Conditional formatting to add red-amber-green colours (7:50)
Conditional formatting with matrix visualizations (5:40)

Day 15 - Finishing off with Behaviour analyses

Introduction to day 15 (0:42)
Exporting behaviour data from SIMS (13:49)
A simple behaviour points graph (8:40)
Date hierarchies and drill downs (4:42)
Date slicers - between two dates and relative to today's date (3:43)
Three more graphs in three minutes... (4:01)
Finish off with more slicers and a table (7:14)
Appendix - a copy of the behaviour csv file used in these lectures

Your next Power BI course...

Lesson content locked

If you're already enrolled, you'll need to login.