Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SIMS + Power BI: Intermediate Skills
Useful information about this course
Facebook group and comments
May 2020 Update - please read this
Exporting data from SIMS
Download Power BI and set up a directory to hold your data
Grant yourself 'third party report' options in SIMS (1:54)
Using SIMS Report to extract basic pupil data (11:23)
Using SIMS Report to extract attendance data (9:22)
Using SIMS Reports to extract behaviour data (4:31)
Using SIMS Report to extract achievement data (3:25)
Extracting termly tracking grades from your school assessment system (6:38)
Using the KS4 Resources with Power BI (4:52)
Using SIMS reports to extract KS2 prior attainment data (7:44)
Using SIMS reports to extract A8/P8 data from the KS4 resources (7:04)
Extracting the KS4 'Measures' from SIMS (6:28)
Introducing our first Power BI visualisation (6:00)
Appendix 1: A copy of the SIMS reports created in this module
Appendix 2: A copy of the CSV files created in this module
Basic Visualizations, the Data Model and Power BI measures
The contents of the CSV files (1:33)
Loading data into the data model (7:24)
Creating our first bar chart - values and axis (7:03)
Formatting our visualizations and why it's important to get it right (3:16)
Filters and themes (3:28)
Create a pie chart to show number of boys compared to girls (6:38)
SEN and Ethnicity graphs (8:27)
Pupil premium and EAL graphs (2:57)
Updating the data model to improve our visualizations (7:39)
Renaming columns in the power query editor (4:21)
Using power query editor to replace blanks in our data (2:30)
Using power query editor to add a conditional column (2:06)
Merging two columns together using power query editor (3:32)
Importing attendance data - and relationships (4:19)
Reviewing attendance data - what have we got? (2:42)
Graphing the attendance data - count, average, sum (5:08)
Using a table to show how Power BI deals with text vs numbers (5:17)
Introducing calculated columns - and be careful with percentages! (7:00)
Introducing Power BI measures - a measure to calculate percentage attendance (4:16)
Creating a guage and a bar chart to show attendance (3:57)
Auto detecting column headers and relationships (6:01)
Loading tables into the data model (3:27)
Attendance and assessment visualisations, slicers and more
Using a calculated column to indicate if a pupil is a persistent absentee (2:03)
Creating percentage attendance gauges for vulnerable groups within school (6:19)
Changing the gauge range and using the format painter to apply the changes (2:10)
Adding the names of persistent absentees (4:16)
Choosing different bar chart styles to show persistent absence by year group (3:00)
Introducing slicers (2:06)
Adding a slicer to choose year groups (2:29)
Filters and slicers - pros and cons (6:42)
Ordering year groups nursery to yr 6 (11:24)
Using 'drill down' on a bar chart (4:03)
Creating our first KS4 assessment visualization (3:22)
Creating a bar chart of all subjects - slicing and filtering (7:41)
Convert our graph to a 100% stacked bar chart (3:56)
Finishing off our assessment bar chart (3:51)
External exam results - how they are stored in SIMS (6:31)
Exporting exam results from SIMS (9:16)
Appendix: DAX Crib Sheet
Power BI measures
Creating a data visualization of our exam results (10:39)
Using the KS4 Resources with your exam results (11:26)
Using the KS4 resources with Power BI - a reminder of what we have (3:42)
Exporting exam results into Power BI from the KS4 resources (4:41)
Why we need measures in Power BI (2:35)
A measure to count the total number of pupils (4:40)
A measure to Count of Boys and Girls (4:44)
Adding measures to count SEN, EAL and PP pupils (11:02)
Conditional formatting in tables and matrices (5:13)
Creating measures to calculate percentages (8:57)
Setting up a visualization to analyse the grades per subject (3:46)
A measure to calculate an average grade (2:39)
Using measures to calculate the average grade for EAL, Pupil Premium pupils etc (3:30)
Creating a measure to calculate the percentage of grades 4 and above (6:56)
Creating a level 5+ measure - and conditional formating in action (6:40)
Automating the Power BI reports using CommandReporter
Adding extra columns to a CSV file (3:15)
Automating our csv files part 1 (4:44)
Automating our csv files part 2 (19:48)
Automating our csv files part 3 (12:28)
Refreshing our Power BI report with the updated csv file data (3:59)
Analysing by class
Visualising subjects by class part 1 (7:46)
Visualising subjects by class part 2 (9:12)
Tips for effective class and subject visualisations (5:14)
The Power BI Service
10 Pros and cons of sharing your PBIX file - and the locations of your csv files (4:18)
11 Saving to PDF and printing your report (1:25)
12 Publishing our report to the online Power BI service (4:45)
13 Workspaces, reports and datasets in the Power BI service (4:27)
14 Creating PowerPoint files and sharing your reports with colleagues (5:16)
15 Subscribing to email updates via the Power BI service (2:21)
16 Power BI service embedding, downloading, QR codes and save to web options (3:03)
17 Setting and using bookmarks in the Power BI service (2:20)
18 Creating a school data dashboard (4:17)
00 Using the Power BI gateway to connect the report in the cloud with your desktop data (8:36)
Comparing target and actual grades, KS2 prior attainment, designing report pages, grade breakdowns and more.
Importing actual and target grades in our csv file (5:06)
Identifying the aspects for export (3:47)
Designing a full page in Power BI - bringing together all we have learned so far... (3:41)
Designing a page - tips and considerations (9:44)
Adding instructions, average grade cards and a list of pupils (9:15)
Comparing average result and average target, by grade (8:17)
Grade breakdown by subject, class and individual pupil (5:33)
Grade breakdown by subject, pupil premium and student (4:20)
Using aliging and distribute to keep our visualisations neat and tidy (2:39)
Adding a 'target difference' column using power query editor (pros and cons) (5:06)
Target difference graphs by EAL, gender and pupil premium (7:44)
Identifying HML KS2 prior attainment using a DAX formula to create a column (11:39)
Using a matrix visualisation to create a KS2 HML prior attainment grade analysis (4:05)
Finishing off - page filters (4:12)
Create 'reset' button using bookmarks to remove all the filters and slicers (5:31)
Line graphs to show progress, appending queries, SWITCH command tips
A line graph to show average grade over time - and how to edit interactions between graphs (5:41)
Creating the 'ultimate' subject data file - introduction (1:52)
Replicating SIMS reports to create the inputs to our ultimate subject file (3:48)
Using power query editor's 'append query' to add other subjects to our maths table (11:01)
Adjusting the page filter to ensure we only see maths results on the maths page - and hiding the oth (2:35)
Easily duplicate the maths page and create a geography targets report in less than a minute (2:53)
Revision create a set of measure to calculate grade 4+ percentage (7:47)
Using the SWITCH command to convert grades to marks (and marks to grades) - eg UCAS points (7:27)
Using groups to manage queries on Power Query Editor (1:13)
Speed up your queries by disabling load in power query editor (2:13)
Adding traffic lights conditional formatting to attendance guages - red, amber, green (4:13)
Highligting pupils above, on and below target using traffic light icons (4:10)
A mobile phone view of our reports (0:52)
Create a mobile phone view (4:29)
Using aliging and distribute to keep our visualisations neat and tidy
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock