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...

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...