In the relational database world you can use a simple JOIN clause but it’s not so simple when your data is coming from disparate systems (ex: I have a monthly report I create which connects Multiple SQL Servers, Oracle, Excel and AD). A common need for any analyst is the need to join data from multiple sources into a useable single view. In this module I will discuss the “Merge” feature.
Read through the following Article to gain some crucial foundational information on Power Query for Excel. Power Query has several simple DIY Business Intelligence features as well as several advanced features.
Microsoft Power Query for Excel is a free add-on program, downloadable here (minimum install requirements list also found there).
0 kommentar(er)
