I just started doing accounts receivable in my new job. I noticed that nobody at my office was using software tools to automate anything (a lot of trades folks who can't type more than 35wpm). This series has EASILY been the most comprehensive & informative guide to using power query to actually achieve anything. There doesn't seem to be anything else I've found on RUclips that makes sense of what you can do with Excel/Power Query. Even with rudimentary Excel experience, I have an exponential increase in my confidence to making a worksheet to track outstanding payments at work. Great work in the series! Sub'd
Thank you David! I am following this series keenly and already seeing the benefit in improving my understanding in both data wrangling and advanced analytics! Cheers! 😊👍
I have a winch position column and I want to do a velocity and a acceleration column. Can I do this with power query? I have too many lines for adding this formula on excel.
@@DaveOnData Thanks for the reply Dave! I have a column for object position overtime on a csv file. I want to create 2 new columns, one for velocity and another for aceleration. For this I need to create a new column for which the values are the variation of the older column. Can M code help me with this? Do you have any tip for video or material on this subject?
I just started doing accounts receivable in my new job. I noticed that nobody at my office was using software tools to automate anything (a lot of trades folks who can't type more than 35wpm).
This series has EASILY been the most comprehensive & informative guide to using power query to actually achieve anything. There doesn't seem to be anything else I've found on RUclips that makes sense of what you can do with Excel/Power Query.
Even with rudimentary Excel experience, I have an exponential increase in my confidence to making a worksheet to track outstanding payments at work.
Great work in the series! Sub'd
quit glazing him
David - wouldn't having a family size column show an inflated number, as each of the other family members are distinctly listed in the data as well?
Thank you David! I am following this series keenly and already seeing the benefit in improving my understanding in both data wrangling and advanced analytics! Cheers! 😊👍
Yes! Power Query has been a top request for my channel. Going forward, there will be a new tutorial video each Thursday morning US time.
I see you never change the Data type. For example the "Family size". Is it ok? Thanks
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ruclips.net/video/xIXymabyFIM/видео.html
Thanks David - I like your style 😎
Like button smashed ;)
Woohoo! Glad you enjoyed the video.
Thank you Sir, very informative tutorial
I have a winch position column and I want to do a velocity and a acceleration column. Can I do this with power query? I have too many lines for adding this formula on excel.
If I understand your situation correctly, you should be able to write M code to perform the calculations.
@@DaveOnData Thanks for the reply Dave!
I have a column for object position overtime on a csv file. I want to create 2 new columns, one for velocity and another for aceleration. For this I need to create a new column for which the values are the variation of the older column. Can M code help me with this? Do you have any tip for video or material on this subject?
Is it possible to create a column that references another table? I want a simple indicator that the identifer exists in another table. Thanks
I need a blank column
Literally skip to 6:50 for context..