Welcome the Excel and Power BI getting started series.
Today we're starting with the first step of the data analysis process: Discover and Get Data.
Power Query allows you to easily discover and connect to data from public and corporate data sources. This includes new data search capabilities to facilitate discovery, as well as capabilities to easily transform and merge data from multiple data sources, so you can analyze the data in Excel.
In the following video you'll learn how to:
very good demo.
Excellent...I suppose none of this works with Excell 2010. I really want to use some BI against the SCOM DB's.
Check out this blog: Analyzing Facebook Data using Power BI