PP01: Introduction to Power Pivot. What is it? Why you should use? and how to activate? Incl Example
ฝัง
- เผยแพร่เมื่อ 15 มิ.ย. 2024
- Chapters:
------------------------------------------------------------------------------------------------
Intro: 0:00
1- What is power pivot (1:00)
2- What are power pivot uses: (4:34)
3- How to activate power pivot: (8:06)
4- One to Many relations - tart of the practical example: (10:47)
5- Trigger data model directly by creating a pivot table: (19:16)
6- Trigger data model using the power pivot ribbon: (21:32)
7- Add Calculated Column: (23:17)
8- Calculate Average Price using Dax Measure: (28:25)
9- Add number formatting to a Dax Measure: (33:31)
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
To download the excel file:
drive.google.com/file/d/1Tj6C...
To subscribe:
/ @aaaexcel
To follow on Facebook:
/ excelispower
To follow on linkedIn:
/ amratef
This is the best introductory video to PP I have seen. Many thanks.
Most welcome, happy that you found it helpful
I helped me solve the problem that had been bothering me for quite a while. Awesome video!
Happy to hear so, thank you 🙏
An amazing introduction to Power Pivot... Thank you sir for such a wonderful efforts.
Thank you 🙏
Brilliant content. Loved the way its was explained. Very easy to consume.
Thank you so much for preparing such valuable content
So nice of you
Very Useful.Thanks for your support
My pleasure
Thank you very much for simplifying the very difficult topics. Been trying to learn this for quite a while but I couldn't advance my pace due to lack of foundational knowledge.... Now I can proceed with good comprehension.... More power to you, Sir....
Thank you for your nice words and happy that you find it helpful
Keep doing.....your way of teaching is awesome😊please bring more content in english
Thank you so much, will do my best 😊😊
Great as usual, Thanks a million
Thank you 🙏
Thank you
Very useful and clear
My pleasure 🙏
VERY helpful! Thanks!!!
Most welcome 🙏
Great...please keep doing the good work..Power pivot really needs a good trainer :) I am sure you will nail it in your upcoming tutorial videos on PP
Thank you so much, I am working on Video 2, stay tuned and wish me luck 🙏🙏
@@AAAExcel All the best 👍
Thank you 🙏
@@AAAExcel Hello, is video 2 already available? Hope to see it soon :)
Not yet, a bit, but will work on it soon
Very Useful Class ✌
Happy to hear, thanks for you comment
Salaam alaikum you are doing great love Egyptian....make AI in excel you save more time and get more people InshAllah
I will try my best
thanks a lot , great work.
My pleasure, thank you 🙏
very informative video.
thank you :)
Thabk you alot for this lovely videos. You are an underated channel interms of number of subscribers but believe me. You must be the number one in the world. Mist of excel intructors give u some info u explain everything. How can someone donate for ur channel
Thank you so much for your nice words, actually you be a member with a small monthly fee, but to be honest, the content available for members are all in Arabic, so it won’t be of a great value to you, thank you once again
@@AAAExcel Thank you for ur swift response. I am lebanese so i totally undestand arabic.
Excellent, so you can be a member if you want, use the link below, and select “serious learner” level
th-cam.com/channels/qwLHNFtrOjrOC3CnvviS1g.htmljoin
Thank you!!
Most welcome o
I like it and thanks sir
Thank you Kishor 🙏
Hi sir, Thank you very much. next Video please
Hi dear, actually there are 5 videos next to this one, please check the playlist.
Link: th-cam.com/play/PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv.html
@@AAAExcel thank you sir.
My pleasure
رائع كالعاده
شكرا جدا
Hi Sir,
Your teaching is best, Could you please translate all power pivot and DAX videos into English. We can't understand arabic.
It will be gr8 to listen in English. Thanks
Hello dear, I already did so for 4 videos, please check the following playlist
th-cam.com/play/PL5NlUYOM2iOjGP2BI0MYQMjLb6ZB4gxWv.html
The rest to come one by one
@@AAAExcel i am really enjoying please keep posting new videos in English. Thanks a lot
Nice videos... why are you not changing your old method into Ai in excel wating for your Al in excel
Thank you, will consider
السلام عليكم يا باشمهندس
عند ربط الاكسيل بالسيكوال لعمل تقارير ديناميكيه
فهذا يستلزم وضع التفاصيل الخاصه بالسيرفر من اسم قاعده البيانات ويوزر السيكوال والباسورد(Connection String)
فهل يمكن اخفاء هذه البيانات من الاكسيل عند ارساله الى الموظفين ؟؟
شكرا
وعليكم السلام .. للاسف انا مش خبير في الموضوع ده
Sr, is this complete tutorial of Power Pivot ?
sorry for the late reply, yes it is, it contains 7 videos so far, i am working on the rest
ممكن رقم للتواصل للسنتر
انا معنديش سنتر .. للتواصل ابعت إيميل او رسالة علي صفحة فيسبوك.. شكرا جدا
رائع كالعاده
شكرا جزيلا 🤩