The Algebra Teacher Powers to B.I.

According to The Old Farmers Almanac , a "full moon on Halloween only occurs roughly once every 19 years. If the full moons are calculated using Greenwich Mean Time, that translates to approximately three to four times per century." And on the day I am writing this post, October 31 st of the year 2020, there is a full moon.   Spooky, huh?   Frightening? Maybe. But not as scary as having too many calculated measures in your Power BI reports! <Ba dum tss> Okay, so maybe the full moon and candy are getting to me.   If you have made calculated measures for your reports, you know that they can quickly become quite numerous.   Also, if you are not aware yet a measure only gets run when brought into a visual and a measure is dynamic.   This means that a measure does not need to be housed/located on a specific table in order to function.   So the question becomes where should I put my measures.   There are a few ways to organize these.   1)    No organization plan at al

Last week in my blog and video I discussed how Power BI could have made my life as a teacher much easier.  It is not that Power BI can do things that I could not on my own.  It is the fact that Power BI could have saved me so much time.   This led me to some thoughts and questions.   How could I have impacted the students more in the classroom with this extra time?  Would teachers who were not analyzing student data due to time constraints now start?  How can I make the data tell my students a story that gives them an accurate picture of their progress?   That last question is what leads to this week’s blog.   Many times the metrics (which is just a fancy word for "numbers") of what we want to show are easy to do by hand with a basic math background.  Although easy, it can be very time consuming when dealing with different groups of data: like 6 periods of students instead of 1 period. When we want to do these calculations quickly with minimal effort in Power BI it is not