@BI4Schools by RSIC
RSIC | Demo

Power BI for Schools

Posts

  • Filtering with multiple fact tables
  • The Power Automate Visual
  • Calculation Groups
  • Monitor Attendance Changes
  • 5 Reasons to use variables in your DAX Code
  • AAB with 2 in Facilitating Subjects
  • SQL - P8 estimates from the right year or latest available
  • Data modelling for a large MAT
  • Nan, Infinity and the healing power of DIVIDE
  • Covid-19 Monitoring
  • Get Covid19 Data from the Public Health England API
  • Using BLANK() to Filter Tables and Matrices
  • Power BI New Features
  • DFE Data
  • Contextual Groups Table
  • More fun with Scatter Plots
  • Scatter Plot with National Data
  • Tips for working with national attendance data
  • Historical Memberships 2
  • Power BI Licensing and Permissions
  • Attainment 8 in BI - part 2
  • Attainment 8 in BI - Part 1
  • The kids behind the numbers
  • Useful Date Functions
  • Subject - Class - Pupil Table
  • Dashboard Control Tips and Tricks
  • Visuals and the wonderful mysteries of the CALCULATE function
  • Looking back in time: Historical Group Membership

Syntax Libraries

  • DAX function reference
  • Power Query M function reference

External Tools

  • DAX Studio
  • Tabular Editor