Who is this course designed for?
This course is for data managers and aspiring data managers. The people who take this course will include data managers themselves, SIMS managers, senior leaders, exams officers, adminstrators etc. Broadly, it's suitable for anyone who wants to understand Power BI using pupil data.
What prerequisites are there for taking this course?
If you have completed the Power BI Skills course and want to continue to learn more skills, this is the course for you. Alternatively if you have been using Power BI for a few months and you can do the basics this course will enable you to progress on to the more complex areas of Power BI knowledge.
What you will get out of this course
By the end of this course you will be a confident user of Power BI with your school's data. You will understand how to use all the main areas of Power BI (Power Query Editor, Power BI Desktop and the Power BI Service) and you will have a working knowledge of DAX, the computer language that underpins Power BI.
Format of the course
This will be a weekly course. Content will be released week-by-week, starting from wb 25th May. The course will start in late May 2020 and finish in early July. Once the course is finished you will continue to have access to all the course content.
Weekly webinars on Microsoft Teams
While the course is running I'll schedule weekly webinars in Microsoft Teams. The content of the webinars is up to you - you can bring your own questions, suggestions and examples and I'll try to answer as many as possible.
What if you miss the start of the course?
Don't worry, if you miss the start of the course you can join anytime, everything will be recorded.
What if you can't access the course each week?
Although the live aspect of the course will finish by the beginning of July you will have lifetime access to the course content, including the recordings of the weekly meetups. So if you can't make it, don't worry you can catch up whenever is convenient for you.
Pay via invoice or card
You can pay by invoice (send your invoice to [email protected]) or use the online checkout and get immediate access to the course content.
At the end of the course you will be able to claim a certificate of completion.
Content of the Course
Below is a provisional curriculum. The final curriculum might be slightly different as I want to be able to respond to questions from the students.
The course will be released weekly from the end of May onwards. We'll break the course content down into small modules that you can study whenever you like.
How long will the course last?
Although the live aspect of the course will last until the start of July, you will have lifetime access to all the course content.
Not what you want? Email me within 30 days of enrolling and I will arrange a full refund.
Email me at [email protected]
- 1.00 Before we start - deselect auto date and auto relationships (2:42)
- 1.01 What is DAX? (2:23)
- 1.02 We've already used DAX before (1:37)
- 1.03 Setting up a new report file - without the auto relationships (5:09)
- 1.04 Create a measure to count pupils (7:36)
- 1.05 Two measures to show the earliest and latest birthday (6:29)
- 1.06 Sum and average minutes late (9:38)
- 1.07 Understanding measures using a simple table - and introducing 'context' (10:09)
- 1.08 Creating a measures table help organise your measures (4:45)
- 1.09 Using a calculated column to calculate percentage attendance (7:18)
- 1.10 Using a calculated column for persistent absentees (3:43)
- 1.11 A tip for working with measures and calculated columns (7:45)
- 1.12 Why measures are essential to calculate average percentage attendance (5:34)
- 1.13 Calculated column or measure? A guide. (3:09)
- 1.14 Counting boys and girls (8:11)
- 1.15 Pupils in multiple categories (5:15)
- Appendix 1: Resources for this section of the course
- Appendix 2: May 29th webinar recording (48:04)
- Importing DFE performance data as an excel file (5:42)
- Using OneDrive for Business to host your data files (6:52)
- Extracting data from tables on webpages (2:55)
- Extract pupil data from SIMS (11:28)
- Save your SIMS report for next time (2:17)
- Cleaning up pupil data in the Power Query Editor (16:56)
- Merging two columns together (forename and surname) (3:23)
- Extracting pupil photographs from SIMS (5:56)
- Importing and using pupil photos in a pupil dashboard (10:09)
- Adding tooltips to a table or chart (8:51)
- Creating a year group index column (7:58)
- Using Bromcom with Power BI (3:08)
- Adding a column to the SIMS extract report (5:56)
- Webinar 5th June 2020
- Duplicating tables and merging two tables together (14:14)
- Exporting from SIMS
- Using Power Query Editor to further process the assessment data
- Analysing classes in SIMS
- Using DAX to analyse grades
- Target v actual grades
- Analysing A8 and P8 via SIMS Key Stage 4 resources
- Including national comparative data
- Using DAX to calculate the average grade
- Using DAX to calculate the number of grades at 4+ etc
- Conditional formatting
Microsoft Teams webinar schedule May to July 2020
At the end of each week I'll be hosting a webinar for everyone taking the course. The webinars will last for an hour and will allow you to ask questions and/or request further explanation.
Week 1: Friday 29th May at 10.00am
Week 2: Friday 5th June at 10.00am
Week 3: Friday 12th June at 10.00am
Week 4: Friday 18th June at 10.00am
Week 5: Friday 25th June at 10.00am
Week 6: Friday 3rd July at 10.00am
Week 7: Friday 10th July at 10.00am
The webinars will be hosted via Microsoft Teams - so please check that your school network allows access. This is a provisional schedule - it might be necessary to change some of the times and dates.
I'm an independent SIMS and Power BI consultant working with primarily with SIMS for nearly 10 years. I spend lots of time in different schools, talking about the best ways to use SIMS and Power BI and creating effective assessment and analysis systems. I run a popular blog full of tips and tricks for data managers in schools. You can email me at [email protected]