Excel A: Introduction to Power Query by Importing from Webpage
From ITEP Team
Use of this service constitutes agreement with the terms of NAU's Acceptable Use Policies found on this site: https://nau.edu/its/policies/
This very short demonstration shows how to create a query that automatically goes to the EPA AQS air data codes database online, queries their website and filters parameters including just ozone and PM10, and then produces an excel table with just these parameters. The source data is an online file updated almost weekly by the USEPA, at https://mediaspace.nau.edu/media/Excel+AA+Introduction+to+Power+Query/1_n4d0uqwq/294748782. This is just a quick demo of how excel power query can help assure data integrity, reproducibility, keep your file sizes small, and help you not pull out your hair recreating the same report but with different data every month or quarter.