Forum

Proper Sequence of ...
 
Notifications
Clear all

Proper Sequence of use of Power Pivot and Power Query

3 Posts
2 Users
0 Reactions
74 Views
(@irvmolina2373gmail-com)
Posts: 4
Active Member
Topic starter
 

Hello group,

I am new to both Power Pivot and Query.  Just started using them within the last 5 days.  I am trying to understand which training/practice videos I should learn and sequence my work with first.  In real world use, would I be performing queries on my data first then use power pivot after or vice versa?  It seems practical to me, but I don't get that understanding anywhere and would like to learn in the order of the sequence I would be using these tools.

 

Thank you,

Irving

 
Posted : 05/10/2016 9:21 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Irving,

Great to see you're tackling the Power tools 🙂

Power Query is all about getting and cleaning data. Power Pivot is all about modelling and analysing that data. So yes, Power Query comes first, then Power Pivot.

Mynda

 
Posted : 06/10/2016 1:20 am
(@irvmolina2373gmail-com)
Posts: 4
Active Member
Topic starter
 

Thank you Mynda.

 
Posted : 06/10/2016 8:29 am
Share: