Just a brief word on what we mean when we use the term query. The basic definition of query is a question, especially, one addressed to an organization. Add in the technology element and we have a question, specifically addressed to a database, application, website, or file. In the AP Information data we've been working with in the Power BI Desktop, we've queried vendor information. We also queried the music we like on Facebook. We queried the Manhattan businesses with URLs from the NYC Open Data website. And, finally, we queried AP transactions from GP. Four queries, all within the same file.
We'll use the Query Editor in Power BI to clean this data up and link some of it together. This will make obtaining more meaningful visuals easier and faster. Who doesn't want easier and faster? The best part is that you can think like a user, not a developer.