What are the differences between Power Query, Power Pivot, Power BI?

2

I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and unfortunately are little known and exploited by many and can be very useful in our widely used automation and reporting work today in Business Intelligence because it allows you to analyze large volumes of data in our well-known Microsoft Excel and is more intuitive for those who are not familiar with the VBA "macros."

I hope over time the powerquery , powerbi and powerpivot labels will be populated with questions for the use of M and DAX .

Note: I am learning to speak Portuguese, feel free to edit this post if you need to.

    
asked by anonymous 31.01.2018 / 23:57

1 answer

3

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

    
01.02.2018 / 00:01