Power View alone is a wonderful tool for analyzing data in both visual and written form. However, it is good to know how to harness all of its power by using all of its functionality with best practices in mind. PowerPivot too, is very powerful, but now add on Power Query, and you have so much freedom to analyze any type of data, that its important to know all these capabilities exist so you can be ready to answer your business’ questions when the time comes. In this session, we’ll take typical business cases that you may originally thought required the help of a SQL person or IT developer, but in reality, you can handle all by yourself in Excel. Whether your scraping data off the web, loading flat files, or connecting to databases, this session will have something for you.