Thank you for your kind words! I'm glad you found the tutorial helpful and learned some new things from it. Keep exploring and learning! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Found this in YT since i'm currently working as data analyst. This open my brain a lot that i could use this with our data that im working with. Thank you so much!
Glad it was helpful! We have additional free tutorials for various data analysis tools and services here 👉 ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
I'm glad you found this video helpful! Power Query and Power Pivot are definitely essential tools for anyone working with data analysis. Keep exploring and learning, and you'll become a pro in no time! 🙂 We have additional free tutorials for various data analysis tools and services here 👉 ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Wow, this tutorial was so easy to follow. Your instructions are so clear. I have been watching other power query and power pivot tutorials and I would get lost because they wouldn't explain certain things or would go too fast. Thank you!!
hey... I'm sure you are a Nigerian, I guess you are a data analyst or hoping to go into data analysis. I just graduated from unilag and trying to go in data analysis. I just started my journey on the data analysis. what opportunity do I have as data analyst in Nigeria?
This is the second tutorial I have had with you and I find it very easy to follow. Others seem to be very good but move to fast. Others tend to skip some steps and get me lost. Your speed and organization is perfect. Thank you for that.
Thank you so much for this tutorial. Though I'm an Excel expert at my workplace, and most of the topics you have presented I'm familiar with, you showed then in an organized and simple way so I could refresh my knowledge and learn few things how to pass this to my colleagues in my Excel class. Good work :)
Thank you so much for watching! We're glad you found the tutorial easy to follow. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Thank you for you effort to make this video. I have learned lot from this and it may help on my career as well. I like to learn more from you. Great wishes...
Thank you very much for this video tutorial it has helped me a lot.....Please can I get those dataset which you used that combines 2017 and 2016 dataset???. And also I want to ask a question................in creating relationships with different dataset when can we use "INDEX-MATCH" to create relationships with other dataset.....and also when can we use "power pivot options (view data in diagram)", to create relationships with other dataset. Thanks
So nice of you 😊 If you haven't already seen it, additional free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Great video. Can you provide any comments and/or resources on how to update queries or the source data with updated data and still be able to use the same measures that were initially created.
29:00 I don't think you needed Power Query for the tables already in Excel. You can just import them to Power Pivot by pressing "Add to Data Model" in the Power Pivot contextual menu. Great tutorial 👍
Very nice explanation of Power Pivot and its features. I would like to get other files by years which you used for practice. Please share those files which was used in the video for connection purpose in power pivot.
Thanks for the super useful tutorial. I tried to follow up the steps, but I noticed that my source data file is not a csv file and after I import and make the connection to the data file and select add this data to the Data Model, no Data model can be found when I start creating the pivot table. How can I solve this please?
Great training, thank you! If you want to show/compare data from your 2017 Sales Table and data from your 2018 Sales Table in your Power Pivot Table, how are you able to decipher between each year after the files have been ‘combined’ together?
Is there a way to get the same result as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
The easiest way to create a table is to click into any cell except the header and just press ctrl +t and your data will be changed to a table. Shortcut to name a table is Alt, J,T,A. Shortcut to create a pivot table is Alt, N, V, T
If you add a 'Sales 2021.xlsx' file to the Sales folder, would the power pivot table and chart update automatically, you you need to add it from the beginning?
Thank you for this tutorial. The sales data for the power part of the course is not available for download. So I can't really follow along. But you have made power pivot look a lot less daunting!
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
To download the data files used in this video and follow along, go here: www.simonsezit.com/article/introduction-to-power-pivot-power-query-in-excel/
Any chance to get the two additional sales data files which you use on the webiner?
Where are the two sales_2017.csv & sales_2018.csv? Kindly share them as well.
@@oldschool4714 did you get them?
Great video. Can I download the 2 sales data files "sales_2017.csv" & "sales_2018.csv" as well? Thanks.
Indian Excel trainers do not such kind of bad activities. But British people are famous for it.
you make things so simple when you smile, i think it ease some burden in going through an hour of such a lesson ; thank you
Our pleasure 😊
Amazing tutorial!
Thank you So much for this amazing tutorial it was very knowledgeable and informative I learnt so many new things from this single video 🌞🤗
Thank you for your kind words! I'm glad you found the tutorial helpful and learned some new things from it. Keep exploring and learning! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Found this in YT since i'm currently working as data analyst. This open my brain a lot that i could use this with our data that im working with. Thank you so much!
Glad it was helpful! We have additional free tutorials for various data analysis tools and services here 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
I am sure Deb is a great woman to live with
This is very basic that nobody should not skip about power query and power pivot. Thanks deb.
I'm glad you found this video helpful! Power Query and Power Pivot are definitely essential tools for anyone working with data analysis. Keep exploring and learning, and you'll become a pro in no time! 🙂
We have additional free tutorials for various data analysis tools and services here 👉
ruclips.net/p/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Wow, this tutorial was so easy to follow. Your instructions are so clear. I have been watching other power query and power pivot tutorials and I would get lost because they wouldn't explain certain things or would go too fast. Thank you!!
Thank you for the excellent work Mrs. Ashby.
Very easy to follow and understand, I like it!, even the mood and articulative voice of Mrs. Ashby was incredible, thanks indeed
Did you manage to secure the 2017 and 2018 Sales files?
Wow, Deb, What quality of instructor you are... Congrats!....Very well explained every subject.
Regards from Mexico
Thank you, Jorge for the kind comments! 😃
Awesome tutorial! Clear, concise and straight to the point. I learnt about Power Pivot and creating model relationships. Thank you.
We're so glad!
hey... I'm sure you are a Nigerian, I guess you are a data analyst or hoping to go into data analysis. I just graduated from unilag and trying to go in data analysis. I just started my journey on the data analysis. what opportunity do I have as data analyst in Nigeria?
This is awesome. I like the clarity and flow in her presentation. Thanks a lot
thank you very much from israel !
amazing lesson , thank you for your clear tutorial, i can understand the basic as a whole
I have watched a lot of videos and believed you are the best.
Thank you so much 😀
Thank you Deb for the tutorial, learned soooo much.
Thank you for watching, I’m pleased to hear that this has helped you.
Thank you. It was pretty useful an hour for understanding Power Pivot for a beginner like me ..
Glad it helped!
Very good introduction to Power Pivot and Power Query. Thank you
English is always English, not American English. I am from Taiwan and I love your video, teaching me both software techniques and graceful English.
Thank you! 😃
This is the second tutorial I have had with you and I find it very easy to follow. Others seem to be very good but move to fast.
Others tend to skip some steps and get me lost. Your speed and organization is perfect. Thank you for that.
You are so welcome! Thanks for the great feedback
meowed
Wow. Simple and easy to understand. Am a happy soul being a beginner with the 2.. definitely subscribing
Thanks Mercy!!
Thanks Deb ...I enjoyed every bit of this video...appreciate your awesome explanation!
Thank you so much for this tutorial. Though I'm an Excel expert at my workplace, and most of the topics you have presented I'm familiar with, you showed then in an organized and simple way so I could refresh my knowledge and learn few things how to pass this to my colleagues in my Excel class. Good work :)
Thank you Przemyslaw!
Nice tutorial ! Easy to follow.
Thank you so much for watching! We're glad you found the tutorial easy to follow. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Thank you so much. The tutorial is so easy to understand - i feel it saves me a lot of time. Will follow your work
Glad it was helpful!
@@SimonSezIT May you please share the Sales files used in this tutorial
Wonderful and easy to understand.
Thank you for your information awareness for better work life experience exploring Excel power pivot. Thank you indeed for your love and sacrifice!
Thank you for the kind words! 😊
Awesome teaching. Thank you!
Glad it was helpful! 🙂
Thank you so much Deb, great job!
Thanks! Delighted to hear that you've enjoyed the tutorial!
Thank you for you effort to make this video. I have learned lot from this and it may help on my career as well. I like to learn more from you.
Great wishes...
You're very welcome!
Very helpful. Thanks for the video, Simon.
Much appreciated! Thanks for the visit 👊
@@SimonSezIT Files please
Great session, It taught me a lot. Thanks very much
Glad it helped! 😊
Ashby's teachings 🔥 🙌🙌🙌
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Been trying to teach myself power query & you have just helped me so much ..... amazing 😍
Brilliantly clear training module 🙏👍
Happy to help Sarah!
Nice Introductory Tutorial Thank You Deb :)
I'm glad to hear that you enjoyed it Darryl
Thank you very much for this video tutorial it has helped me a lot.....Please can I get those dataset which you used that combines 2017 and 2016 dataset???.
And also I want to ask a question................in creating relationships with different dataset when can we use "INDEX-MATCH" to create relationships with other dataset.....and also when can we use "power pivot options (view data in diagram)", to create relationships with other dataset. Thanks
This just blew my mind... It is amazing, thank you!
Wow, thank you!
Really fantastic and helpful tutorial for excel learners. Thanks a lot.
Glad you liked it
@@SimonSezIT Where are the 2017 and 2018 Sales files
This was great, thank you!
Thank you!!!
V good explanation, Plz provide link to other two workbooks u have used..
I can't thank you enough for this amazing knowledge
So nice of you 😊 If you haven't already seen it, additional free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
really amazing!!!! thank you so much!!!!
Happy that it helped Marcelo!
Great work. So easy. Thank u
Most welcome 😊
The sales data for the two different year are not available online here, pls can I get it for practice
could you get them?
Thanks for sharing 👏👏👏👍👍👍
Glad you enjoyed it chow
Hi! Thank you for your works, those are very usefull. How can I access the two sample sales file?
Deborah Ashby Excellent . thanks.
Thanks for listening Saleh!
Great video!
Thanks Prajwal!
Fantastic explaination.
Glad you liked it
Wow.. What a great and useful tutorial is this one. Thanks for sharing your knowledge. Regards!
Delighted that you've found the tutorial useful! Enjoy your weekend!
@@SimonSezIT you do the same! Blessings 😊
This is a GREAT video!!
Glad you think so, Gordon. Thanks for watching!
Excellent guys 👍
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Well done. Nice presentation
Thanks Sunil, glad you enjoyed it!
very good explanation.... thank you
Glad we could help!
Great so easily explained
Glad you think so!
Waoo, so knowledgeable video Thank you mam .
Glad you enjoyed it. Thanks for watching! 😃
wonderful; great work and easy to understand. thank you
Great video. Can you provide any comments and/or resources on how to update queries or the source data with updated data and still be able to use the same measures that were initially created.
Thank u so much I have learnt so much
Glad to hear that!
it is 2022 and this still do its magic
Deb, could you please show how we read Excel files from a folder in Sharepoint?
Very nice class but I could not find the other two files and so was not able to finish the class.
Thanks for great share.
Thanks for visiting
Thanks !!! Excellent
You are welcome! Thanks for watching ;-)
29:00 I don't think you needed Power Query for the tables already in Excel. You can just import them to Power Pivot by pressing "Add to Data Model" in the Power Pivot contextual menu.
Great tutorial 👍
Great work guys ☺️ thanks
Our pleasure!
thankyou ofra wondr ful vedios ona powr ful query.
You're welcome Vikram, So pleased you've enjoyed the tutorial!
is it not possible to create calculated fields when using power query for pivot tables? :S
Very nice explanation of Power Pivot and its features. I would like to get other files by years which you used for practice. Please share those files which was used in the video for connection purpose in power pivot.
Did you ever manage to secure these?
Thank you so much for this tutorial. I learned a lot.
Glad to hear that!
Sales data files are missing in your blog.
Could you upload them ?
Thank you for your awesome presentation
You are so good.
Many Thanks!
Thank you!
Glad it helped! Thanks for stopping by :-)
Excellent
Thank you so much 😀
Thanks for the super useful tutorial. I tried to follow up the steps, but I noticed that my source data file is not a csv file and after I import and make the connection to the data file and select add this data to the Data Model, no Data model can be found when I start creating the pivot table. How can I solve this please?
Hello!
How do we sort by date?
Hi, great video please can you advise,where are the csv files
i found gems, thanks a lott ❤
Glad you liked it!🙂 You can get additional Excel training here ➡️
ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
hi where can I download the two sales csv files? I can't find it in the download link. Thanks.
How to get the sales_2017 and sales_2018 csv tables?
Great training, thank you!
If you want to show/compare data from your 2017 Sales Table and data from your 2018 Sales Table in your Power Pivot Table, how are you able to decipher between each year after the files have been ‘combined’ together?
Use conditional formating or create a column with the IF and Text Functions to create unique Identifiers
Is there a way to get the same result as a Vlookup function? So combine fields from different tables, e.g see what type of article each customer had ordered or these kind of info? Or is only possible to have aggregate measures like Total Sales per customers so measures like Sum, Count etc?
Great tutorial
Thanks 👍🏻
Happy to help 👍
The easiest way to create a table is to click into any cell except the header and just press ctrl +t and your data will be changed to a table. Shortcut to name a table is Alt, J,T,A.
Shortcut to create a pivot table is Alt, N, V, T
Can you create a power pivot from multiple worksheets within a workbook?
@Simon Sez IT how can i get the other 2 excel files?
If you add a 'Sales 2021.xlsx' file to the Sales folder, would the power pivot table and chart update automatically, you you need to add it from the beginning?
Where can I download the 2017 & 2018 sales data csv file to follow along? Thank you
Thanks for the video, but how can we get the sales data????
excel is only letting me pull in one file at a time, how do i combine them together after I upload them seperatly?
the topic has been explained quite nicely ,great tutorial!
Glad you liked it!
Hi ,can we process power query without creation of table Ctrl + tT
Thanks mam very helpful video
Most welcome 😊
In which version was the Analyze added to Excel ?
I just can't find it anywhere.
It was very good but I don't understand what the point was in having the tbl_trip_code table. It didn't contain anything that wasn't in sales data.
hi there, cant find sales 2017 and 2018 files
Thank you so much
Thank you for this tutorial. The sales data for the power part of the course is not available for download. So I can't really follow along. But you have made power pivot look a lot less daunting!
Thank you for sharing link. I appreciate if possible to get sales_2017 and sales_2018 excel files which is used in the video.