Part 1 — Building Basic Data Analysis with Excel Power Tools
When getting data from the web, a lot of sites provide the ability to DOWNLOAD a csv formatted file of the data.
Rather than download it though, you can simply connect to it and import the data using PowerQuery.
Why import? Because the data can be refreshed and updated anytime the underlying source on the web changes!
One of my favorite small datasets that I use for training is a listing of banks that have failed (closed or been acquired).FDIC Failed Bank List – Comma Separated Values File – Data.govbanklist.csvcatalog.data.gov
In this video, I walk through importing the data from the web via connecting to the csv rather than downloading the csv file.
Have you used this approach? If not, give it a try!https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F8SUsdogETJQ%3Ffeature%3Doembed&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D8SUsdogETJQ&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F8SUsdogETJQ%2Fhqdefault.jpg&key=a19fcc184b9711e1b4764040d3dc5c07&type=text%2Fhtml&schema=youtube
In Part 2, I will review creating a dynamic Date Dimension query which updates from the core data query.
Continuing to build out the analysis…
About Author: Don tomoff
Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.
It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics