Це відео не доступне.
Перепрошуємо.
Advanced Power Query Tutorial | Complete End-To-End CASE STUDY | Practical guide with Dataset
Вставка
- Опубліковано 16 сер 2024
- ▶ Dataset Excel file for practice
bit.ly/3HdnZGA
▶ Evaluate yourself if you can become a Business Analyst
topmate.io/ana...
In this video, I will walk you through 5 Business Case studies using POWER QUERY. If you're interested in becoming a Data/Business Analyst, then this video will be very important for you.
▶What is Power Query? (Microsoft Definition)
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Power Query helps you to automate your tasks, so that you never have to repeat the same steps.
After watching this video, I can assure you that you'll learn a lot about Power Query and its practical use case.
▶ TIMESTAMPS:
00:00 What is Power Query?
01:10 Scope of this Video
02:08 CASE STUDY1 | Employee Expenses vs Allowance (Tracker)
14:14 CASE STUDY2 | Analyst Revenue Contribution
29:20 CASE STUDY3 | TARGET vs ACHIEVEMENT Sales
38:00 CASE STUDY4 | Cleaning FINANCIAL DATA
46:40 CASE STUDY5 | WEB SCRAPING (Pulling data from Web)
💡 END-TO-END POWER BI DASHBOARD
========================
End-To-End Power BI Dashboard Tutorial for everyone | Data Storytelling in 2023 | Data Visualization
www.youtube.co....
📁 Data Analyst Resume:
================
Data Analyst Resume with No Work Experience | Step by Step Guide | Templates + Tips + Examples
bit.ly/3TZIKtG
🛑Data Analyst Journey:
=====================
How I would Study Data Analytics in 2023 (If I had to start over) | Schedule | Salaries | Skill Set?
www.youtube.co....
Timetable And Efficient Strategy to Learn Data Analytics while Working | Improve Productivity
www.youtube.co....
💡 LEARN MORE
========================
▶ Power BI Playlist -- bit.ly/3U3NVts
▶ Data Analytics Projects -- bit.ly/3hb84zd
▶ Excel Training - bit.ly/3WvCUTs
💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!
bit.ly/3DB03ex
▶ Data Visualization using Power BI in 2023
▶Data Storytelling in Power BI using various graphs
▶Generate insights from the raw data
#powerbi #powerbitutorial
Before watching this video,using power query was a real nightmare for me 😢.But I got enough confidence to use it after watching your videos .Learning with case studies is the best approach to master power query .I highly appreciate your work .Thank you so much for your valuable content ❤
Thanks fermion, glad you liked it. :)
This video will help you understand the practical aspect of POWER QUERY… watch till the end to get all the insights.
Dataset shared for your practice.
🙏🙏🙏🙏
The dataset link are not open. plz paste correct link
Best watched more than 10 videos of power query- I can say this is the most helpful video
I’m glad this video helped 🙏👍 let me know if you need clarification on any other topic…
True 100%
@@kristennaa Thanks for your support.
It's an outstanding explanation, primarily when you teach us how we will do it in Excel and then the Power Query method. Awesome.
Thank you Ajit 🙏
Very kool tutorial. All the Power Query tutorials videos I've watched deal with getting tables or files from a folder and combining and transforming. Your tutorial goes way beyond that with the practical cases. They provide useful templates for dealing with similar cases in the future. Thanks so much for such a comprehensive tutorial. I note that you also have a tutorial on PBI. I will watch that later.🥇🏆
Thanks for this video, it really helped me in my real time project where I was struggling to unpivot and transpose 🙂
Great effort bro, keep it up 🤝
Thanks Sanju, I’m glad it helped you 🙏
Very helpful. Thank you 🙌
@@nazlcelikbilek1360 I’m glad it was helpful :)
Great tutorial. Teaching using case studies is so much more informative - thank you so much.
I’m glad you found this video informative. 🙌
This is completely best video that i have watched till now.
Thanks for the appreciation mate!
Thank you for the great video on power query. I had some coffee and really enjoyed following along with your lesson. I just subscribed and really look forward to learning with you.
You are just awesome to make such kind of real situation in Power BI. I am unable to click like button due to not visible. But excellent thought.
I’m glad you liked it 🙌
Thank you sir
you're welcome :)
such a useful video. thank you so much for providing a thorough and intuitive introduction to power query.
You’re welcome. czech
Best explanation how to clean the data, wonderful.
I am glad it was useful to you. Thank you 🙏
Good Noon, nice work and nice way to explain, and got much knowledge in the 5 cases...
Glad you liked it
Very wonderful, thank you so much
Hi Magda, I am glad you found this video helpful.. Could you please tell me what was the best insight from this video? and would you like to make a video on some other topic?
Dear sir, your video is really helpful. Thanks for uploading this. Your knowledge & teaching style is really at different level. Please upload more case studies.
Thanks Manoj for your kind words. I’ll be uploading more case studies related to Power Query, Power BI, SQL, Python etc in coming days.
Sir waiting for your more case studies on power BI @@analyticalguy
@@manojchavan8688 Soon I will be uploading more.
Thank you so much for this video. Its very helpful.
You're welcome Anjali. :)
Great content 👍
Thanks Govind for your kind words 🙏
great sir
You’re welcome Khalid.
Thank you! This is very good
I’m glad you liked it, Orlando 👍
Great tutorial 👍
Thank you Kevin 🙏
Ammmazing Sir. Can I have the slides for this and previous power query video, please.
Hi Qasim, I have added the dataset on which I have done all the steps, it’s better to download the dataset and practice yourself for better results.
Sir I have downloaded the dataset but I am making collection of all the scenarios so I can refer it later on.
@@qasimjan5258 Qasim, pls mail me on analyticalguys@gmail.com
I’ll share the ppt on your email id. 👍
Qasim, Hope you have received the file.
@@analyticalguy yes Sir thank you very much. Please also share the future power query files with me Sir. Once again thank you very much Sir.
Hi, I am starting my own business of FMCG product as a manufacturer. I need your help to please make a video where I want to know how much profit margin should I provide to my Distributor and Retailers. As your calculations are best so that video would b help full for me to let them also understand the margins
Hi Bisma, You can share the product description, place of business, pricing that you have set. Once you share the details, I can suggest you.
You can mail me at analyticalguys@gmail.com