The Algebra Teacher Powers to B.I.

Parameters are a fancy term to me for a variable that you can change the value of any time you wish.  Parameters on a report allow you to change what data you are actually loading and looking at.  If you set up a parameter on a date column you can filter what dates from your data source actually get loaded.  If you decide to set a parameter on a geographical column like state or city, you get to decide what geographical data actually gets loaded. If you set a parameter on a data source you get to decide what source you are pulling your data from.   You might be thinking, can’t I just do all of that in the Power Query editor using filters on a column.   You are correct in your thinking, but I need you to think beyond the desktop application and think about what happens when you publish out to the service.   I need you to think about what your end-user needs to decipher what data they are going to look at. If I have tickled your interest, in what para...

Many people have dates as part of their data sets.  Dates are great to allow us to view our data aggregations in smaller buckets in order to get extra details about our situation.  Sometimes though we are faced with having multiple date columns in one table. The more date columns the better, right?   Well, this can usually lead to two outcomes.  1) Frustration that you can’t view the data based on your 2nd date column 2) Not realizing the data you are looking at is in fact NOT accurate.  I will show you in the video both of these unwanted scenarios.  More importantly, however, I will show you how you can use some fairly simple DAX and modeling relationship techniques to resolve the issue.   Let me set up the scenario in this video for you.  I’ve made a very basic Excel file that tracks sales by what state they occurred in, when the sale occurred, and when the sale shipped out.  So if I want my team to see the number of actual sales tha...

Have you ever connected to a web source to do some data analysis? I am sure it's what everyone does in his or her spare time, right?  Well, I am a nerd (proudly) and definitely have tapped into NFL stats in trying to decide who to play on my Fantasy Football team.  If you ever have, then I bet you were been frustrated with the tables that you can import/transform based on the HTML code.  Do you want to eliminate that frustration and save some time in the Power Query Editor?  If you answered yes to any of the questions, then take a look at this video  of how you can add a table from a website by feeding Power BI some examples of what you want? In this video , I will pull in some NFL stats because I sure hope we have at least a little bit of a season.  With any start of the NFL season comes fantasy football.  With fantasy football comes some crazy data crunchers who do their best to put the odds in their favor.  Luck though sometimes prevails...