SIMS + POWER BI Blog

Get the most out of SIMS Assessment Manager and Microsoft Power BI
TrainingConsultancy
Useful DAX measures for schools

Useful DAX measures for schools

Update: Check out the comments for some more tips on using DAX measures. DAX is the language behind Power BI. If you want to get the most out of Power BI sooner or later you'll need to write some DAX code. The best DAX reference is Microsoft's DAX reference website....

read more
Ordering year groups with Power BI

Ordering year groups with Power BI

If you have been using Power BI to create data visualisations for primary schools, you've probably run in to this problem: you want the x axis of your graph to run from nursery through reception to year 1 and then to year 6, but Power BI insists on alphabetical order...

read more
Primary key stage analysis resources 2019

Primary key stage analysis resources 2019

Primary schools will find these special marksheets and reports incredibly useful when analysing EYFS, KS1 and KS2 results this summer.  Updated January 2019 These resources were updated by Capita in January 2019 to include the changes to the PAG groups and national...

read more
Welcome back to SIMS assessment

Welcome back to SIMS assessment

Over the past few months I've spoken to an increasing number of schools who are starting to use SIMS assessment again, after using third-party assessment products for several years. Talking to these returning schools, it seems there are several drivers behind their...

read more
SIMS and Power BI in ten (yes ten!) minutes

SIMS and Power BI in ten (yes ten!) minutes

If you have access to Capita MyAccount you can now watch a 10 minute demo by John Christian during which he takes you through all the key tasks in setting up the automatic report link from SIMS into Power BI. The resource is part of Capita's 'Customer Success' strand...

read more
SIMS for beginners course

SIMS for beginners course

It always amazes me how many jobs require SIMS experience. Experience in the England and Wales' most popular pupil database is required for jobs in British schools all over the world. That's probably why I get so many emails from people asking how to get SIMS...

read more
Course: SIMS and Power BI for Beginners

Course: SIMS and Power BI for Beginners

If you read my article about the SIMS Consolidated Report utility or if you just want to find out about SIMS and Power BI - I've developed a free course for you. It's aimed at school staff with no previous experience of Power BI although you'll need to have some SIMS...

read more
New Microsoft Power BI Resources for SIMS

New Microsoft Power BI Resources for SIMS

New analyses with Microsoft Power BI Microsoft Power BI is an analysis tool that allows you to create powerful data visualisations - it's like Excel on steroids. The BI stands for Business Intelligence and it's used by many large organisations to help them understand...

read more
Primary Assessment in 2019

Primary Assessment in 2019

I wrote this post before the news that SPTO, one of the main assessment products for primary schools, was to close at the end of December 2019. Perhaps we can expect more consolidation in the assessment marketplace. Ofsted have announced that they will no longer take...

read more
KS4 Resources Update October 2018

KS4 Resources Update October 2018

Capita have just released an update to their KS4 Resources to include the new estimates released by the DfE a few days ago. If you use the KS4 resources now is a good time to log in to MyAccount and download them. For convenience (or if you don't have access to...

read more
SIMS Primary Update October 2018

SIMS Primary Update October 2018

Introduction Last week I met with Graham Cooper and Ben Jones from Capita to talk about progress with SIMS Primary. A few weeks ago I blogged about how quiet progress seemed to be, since the official launch back in January and Graham was keen to update me on recent...

read more
Sign up for the newsletter

If you need a little extra help with your SIMS system I'm here to help. Contact me at david@davidpott.com for consultancy and training. Or you can subscribe to my termly assessment newsletter using the button below.

Sign up