Power Query This is a add-in developed from the version of Excel 2010 and now by default in the 2016 version as Get & Transform . It is part of Microsoft's proposal to develop the Extract, Transform, Load (Extract, Transform, Upload), very consistent with the situation of the analysis of large volumes of information for any economic sector and social.
PQ Lets you connect Excel with multiple sources of information and intuitively transform them into Query Editor . There are a considerable amount of tools to transform our data, these are stored step by step, giving us full control over the transformation process.
Additionaldisplaysthe language M or Power M for the most advanced is the ability to access line by line or step by step to edit the query and be able to incorporate the rest of the functions they are not in the query editor strong>.
Power Pivot Is another add-on as PQ developed since the 2010 version natively incorporated from the 2013 version. Here we can connect various sources of information or with data already transformed into Power Query. Thanks to its integrated memory technology, you can store millions of records without major problems contrary to our limited Excel sheet.
It introduces the DAX functions that are developed to formulate and extract information from data cubes and allows us to create complex metrics and Key Performance Indicators (KPIs).
It allows us to create our data models in a relational way as we already know in Access and then view them using our tables and dynamic charts dynamically or dynamically with Power View and > Power Maps .
PowerBI is a free software for creating dashboards or dynamic reports, where we can also find the Power Query query editor and the DAX formulas, with these two powerful PowerBI tools allow us to analyze large volumes of information and the possibility of sharing them in our organization, locally or online, depending on the case.
Video tutorial