Introduction to Power Pivot for Excel

Подписаться 149 тыс.

Просмотров 56 тыс.

50% 1

Learn how to connect, analyze & visualize massive amounts of data from familiar interface of Excel | Advanced DAX formulas, measure patterns, custom calendars, performance optimization and tricks
Go for Power Pivot if you are,
1. Very good with Excel
2. Work as a data analyst or manager
3. Responsible for reporting, analysis or visualization
4. Have lots of data
5. Create dashboards or MIS reports
6. Keen to master Power Pivot
Excel Power Pivot Playlist Link- • Excel Power Pivot
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#powerpivot #powerpivotinexcel#Innozant #msexcel#powerpivotutorial

Опубликовано:

20 янв 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 155

@kaashiffurrahman443 3 месяца назад

Your content and explanation is simple and easy to understand. Thank you for your contribution sir.😊

@techyfighterbyAftab 3 года назад

Tq u sir bht din SE wait Kar rha tha power pivot Ka...thank u very much sir.👍

@Innozant 3 года назад

Thanks Aftab ji🙏❤

@sufiyan874 Год назад

Very informative... Thank you sir

@SasV276 5 месяцев назад

Thanks for this whole playlist ❤

@happylearning-gp Год назад

Hi is there any that we can query power pivot data like sql query and place the data in excel. If possible, could you please make a video for that

@pawankumar-ld6jq 3 года назад

I would like to thank to innozant chenal and too innozant family, cause I m graceful of you sir. Love you sir, 🙏

@Innozant 3 года назад

Thanks Pawan for your respect,love and support dear..really mean a lot to me

@deepraazshaw7369 3 года назад

Sir Main apka fan ho Gaya hu. Aap meri life change kr de rahe hai. Thank you sir itani a6i Tarah se video banane ke kiye. Apko Mera bahut bahut dhanyabad

@Innozant 3 года назад

Thanks Deepraaz..Happy Learning. God bless you dear

@shrikantbadge3978 3 года назад

आप हमारे जिंदगी मे आये उजाले की तरह to give us right direction सर.

@Innozant 3 года назад

Thanks Shrikant Ji for such a lovely appreciation..God Bless you dear.❤🙏

@ArmaanKing17 3 месяца назад

Zabardast video once again Sir. Thank you

@inrahuljha Год назад

Bahut accha explaination

@roadtomppsc1490 2 года назад

Sir way u present the things connect masses.Keep it up.

@saurabhdabas4440 Год назад

Apse seekhne m bhot maaja aata hai , you give lessons also and explain things very lighly

@Innozant Год назад

Thanks dear

@aabhishekhrai Год назад

Hello…I have PDF file which have some coloured text can I get the data in word or excel with the colour?? Please help.

@AnupKumar-oe2jb 3 года назад

Great Sir, I am very excited to know about it.. excellent explanation.. Sir

@Innozant 3 года назад

Thanks Anup ji❤🙏

@hemantsingh9966 Год назад

Great Gurujii 🙏🙏🙏

@satishojha6240 3 года назад

Thanku sir for power pivot explanation.sir humko machine nahi banna hai knowledgeable banna Hai jo aapki video se ho jaye ga.good night 👌👌👌

@Innozant 3 года назад

Thanks Satish Ji.Happy learning dear.

@manish9613 2 года назад

sir advanced power pivot aur dax ka content youtube pe nahi hai aisa kyo

@situsahoo2482 3 года назад

Sir sach bole toh.hungry to grab to learn.come soon sir.❤️

@Innozant 3 года назад

Sure Situ..Soon dear ..gn..tc.

@shrikantbadge3978 Год назад

आपके बोलने का अंदाज बोहोत जबरदस्त हैं सर. that's why I am your fan.

@Innozant Год назад

Thanks Shrikant Ji .Happy Learning

@razamoulvi8801 3 года назад

Great yaar itna detail me bohot hi kam log shikhate hai..Appreciated Sir👌👌👏👏

@Innozant 3 года назад

Thanks Raza...Aisw hi complete course tutotual learn krenge humlog dear

@razamoulvi8801 3 года назад

@@Innozant zaroor👌👌😊

@pawanverma7220 3 года назад

Awesome Class As Always

@Innozant 3 года назад

Thanks dear

@hemantgusain1260 3 года назад

Great explanation sir,

@Innozant 3 года назад

Thanks Hemant ji

@Darkhunterzzzz Год назад

Hats off bare Vai, Love from Bangladesh

@Innozant Год назад

Thanks dear

@chandrashekharmishra9521 2 года назад

Sir 2007 me power query avelble nhi h kya ?

@deepaksharma-gj5ru 2 года назад

I wish I watched your videos WHEN YOU UPLOADED IT I WAS IN THE GOOD COMPANY RIGHT NOW

@Innozant 2 года назад

You are not late dear..start your learning journey now.

@PavanKumar-cm2sz 3 года назад

Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Must awaited Series😀😃🤗🤩🥰😘😍🙏🙏🙏

@Innozant 3 года назад

Love you Pavan Ji for this much respect and love dear🙏❤

@jayantabhattacharyya628 3 года назад

Dear Sir It makes me very happy that much awaited power pivot series is about to start. In power pivot intro tutorial your way of teaching really impressed me. I wish every success of your channel. Thanks Jayanta Bhattacharyya

@Innozant 3 года назад

Thanks Jayanta for your love and support..Good night..tc.

@The-Fronted 3 года назад

Great 👌

@vinayvemul8456 2 года назад

Great learning 👌👍

@Innozant 2 года назад

Thanks

@VimalKumar-ih6ik 7 месяцев назад

Thank You Sir

@The-Fronted 3 года назад

Thank you so much.

@Innozant 3 года назад

Thanks Arif ji

@SahilKhan-sx3rj 3 года назад

Again first like nd comment

@Innozant 3 года назад

Thanks Sahil🙏❤

@avnishmishra8378 2 года назад

Very nice sir

@x-lookup Год назад

Hello sir mai apka regular viewer hoo aur mera kaam Google Sheets pe hota hai jo ki bahut hang hota hai to kripya is topic per bhi vidio banaye sir

@tejpalsain1507 3 года назад

Thank you for power pivot.

@Innozant 3 года назад

Thanks Tejpal

@theabhishekmittal 11 месяцев назад

all 10 videos cover power pivot and advanced power pivot?

@nirmalraj25 Год назад

Nice Sir😊

@AshishKumar-hc3km Год назад

sir mere paas 2016 standard hai usem nhi aa rha hai

@yogeshahire1823 3 года назад

Interesting and likely to learn sirji 👍

@Innozant 3 года назад

Thanks Yogesh

@rakeshmlearningentertainme6099 2 года назад

nice video

@amansinha19891 3 года назад

Thanks sir...

@Innozant 3 года назад

Thanks Aman ji..Happy learning..gn

@chandannekesh 3 года назад

It's helpful

@Innozant 3 года назад

Thanks Chandan❤️🙏

@bhawanimurariya8934 Год назад

Sir aapki wjh se humara ghar chal rha hai 👏🏻

@Innozant Год назад

Nahi dear ..Wo aapne mehnat kiya hai.. Koshish kariye khud ki skills itne ache se improve krenge ki aapki wajahse aur logon ka Ghar chal sake👍❤️

@ajaysaroha2539 3 года назад

Sir, awesome pls continue it daily power series

@Innozant 3 года назад

Weekly.daily me aur kai saare playlist ek saath chal re h dear

@ajaysaroha2539 3 года назад

I hope nothing else

@badalsingh2050 3 года назад

Very nice sir!!

@Innozant 3 года назад

Thanks Badal..Gn.tc

@allnewmovies4564 3 года назад

Thanks sir

@Innozant 3 года назад

Thanks dear

@Ann_2208 2 года назад

Sir ageing report bhi bata dijiye please formule se bahut hard or time taking lag rahi hai

@jkyadav77 2 года назад

Using pivot table find Total any no ODR ID Count AND Total Unique no is repeated and some are unique ODR ID COUNT no are duplicate 2 or 3 time and some are unique Mobile No wise in the Same Pivot Table i have use dis . count but not possible

@harjeetsinghkhalsa9977 2 года назад

Hello sir, Just saw your introduction to power pivot video and its really great. Can i find all the videos related to power pivot and power query in your channel.

@Innozant 2 года назад

Yes dear . please find seprate Playlist for both

@smrutiranjanrout3414 3 года назад

Thanks sir, I have learnt alot from you.. but I hv 1 problem. How can I calculate cumulative achievement % in a pivot table. How to do field calculation for that.

@Innozant 2 года назад

Sharw data sheet for the same

@adhishratan6208 3 года назад

please help solve the problem

@sunilchapra1044 3 года назад

Good video

@Innozant 3 года назад

Thanks Sunil Ji

@saahilsaahil5912 3 года назад

Awaiting for your next video sir on PP

@Innozant 3 года назад

sure soon

@ASIFANSARI-ql6bq 3 года назад

Nice

@Innozant 3 года назад

Thanks Asif sahab💖🙏

@adhishratan6208 3 года назад

❤️❤️❤️

@gauravbhatia7987 3 года назад

Thnq sir 🙏🙏

@Innozant 3 года назад

❤🙏

@puransingh-sx2tk 3 года назад

Aaj he CV main update karne ja raha hoon advance power Pivot 😂😂😂😂 dil se

@Innozant 3 года назад

👍🙏❤😀

@rushalikhatale4252 3 года назад

Hi sir.you teach excel at advance level.thanks for that.i have just one query is it any need to join your courses.because you already teaching deeply on RU-vid and gives us training.please suggest.

@Innozant 3 года назад

speaking honestly you dont need to invest your money in our course if you are thoroughly able to understand every thing taught in the virtual training .but, if you want one on one attention then u are surely welcome to our institute its always open for you . so you dont need to worry about anything and all the best for the future

@rushalikhatale4252 3 года назад

Thank you so much sir.you are inspiration for all of those who want to succeed in their life.🙏👍

@Innozant 3 года назад

thanks rushali for the wishes may god bless you and the whole innozant family's best wishes are with you . best of luck for the rest of your career

@ramanmangat3320 3 года назад

Guru jii🙏

@Innozant 3 года назад

Thanks Raman Ji..Happy Learning dear

@pawanverma7220 3 года назад

Mai Toh Sikhne Ke Liye Interested Rahta Hu Humesha, Kyoki Mujhe Khud Se Behtar Hona Hai.

@Innozant 3 года назад

good

@neerajjain230 2 года назад

Sir, today I contact innozant but, there was some another guy named Dilip Jha. Confuse. Pls let me know. Thanks

@Innozant 2 года назад

Hahahaha..There is only one guy...why you confused ?😊❤️

@abhilashkumar5697 2 года назад

gangadhar hi shaktimaan hai😂😂😂

@shahidamanzoor9294 2 года назад

Sir you haven't uploaded macros series yet.

@Innozant 2 года назад

Yes Shahida..Will upload soon

@manojsingh-mf1lg 3 года назад

Power query and power pivot m kya difference hai ??

@Innozant 3 года назад

aane wale videos me saare doubt clear hote jayenge..Have patience dear

@akshatgoyal2473 3 года назад

Please complete power pivot table series

@Innozant 3 года назад

Pehle power query finish kar dete hain phir jal krate hain power pivot

@akshatgoyal2473 3 года назад

@@Innozant Please Sir, kindly do I am eagerly waiting for the power pivot series Please share when will be series coming, if possible

@allnewmovies4564 3 года назад

When will next part release

@Innozant 3 года назад

soon

@hanifuddin3591 8 месяцев назад

Not Understand [@SalesRep] Plz Explain

@Innozant 8 месяцев назад

Query?

@mohitchauhan7808 3 года назад

👍👍👍👍👍

@ishaa31 2 года назад

sir. ur all videos are very helpful. but please remove background music. this wasnt there in vlookup Playlist. this background music is irritating

@Innozant 2 года назад

Thanks Isha for your valuable suggestions...Wo edit krte time sound jyada reh gya tha background ka..ok let me try to reduce voice of possible

@parminderkumar7612 3 года назад

Sir aap vba kab suru karege???

@Innozant 3 года назад

Kuch time baad..kai saare playlist chal re hain ek saath itna manage nhi ho payega..thts why

@parminderkumar7612 3 года назад

@@Innozant ok sir

@kuldeeppoorwa8914 Год назад

😊😊😊😊😊😊

@ishutiwari5567 3 года назад

sir i eagerly waiting for this series. thank you so much. but i have some problems with my excel software.whenever i transfer data or use something in power query,it always shows unexpected error code 0xFFFFFFFF.And this happends not only with huge data but also for small data with only 10 rows.And i know power query is important for power pivot.if you don't mind,can you please send me thr download link of your excel latest version (i mean 2019)?because i think there is something error with my version.mene google and youtube pe search kiya ye problem but koi solution nhi mila.baki functions to perfectly work kr rhe h bs power query and power pivot me kuch error ara h.data transform hi nhi hora.file select krte hi loading hoti h and unexpected error.please help me sir if you can🙏

@Innozant 3 года назад

thats means last example of pivot table where i use power query not done ? First try to implement that with power query still the same prob you may found then it may be your excel us currupted or some other reason.Aur saare function yadi work kar rhe hain phir ye bhi chalna chaiye..connction check ktke dekhna db ka wo create kr pata hai ya nhi

@ishutiwari5567 3 года назад

@@Innozant sir i think power query currupted h meri.data tab me new query me jake file select krni hoti h ya fir table select krke query create krni hoti h kisi se bhi work nhi krra.sb kuch try kr liya.data query me load hi nhi hora.aur agr glti se transform.ho bhi jata h to air koi feature apply kro to firse vhi same error ata h. ap apne wale excel ka download link de skte ho kya?apne bhi shyad google se hi download kiya ho?

@Innozant 3 года назад

haan..but yaad nhi hai link Ishu..kisi youtube ke video me link tha description me whin sw kiya tha download..but dahi chal ra hai mera to..wk baar kisi aur link se krke dekhiye ya main kal dekhta hu ek baar aur btata hu link

@ishutiwari5567 3 года назад

@@Innozant ok sir g.then i am waiting.mil jaye to theek na mile to koi bat nhi jyada tension mt lena ap. me to bs isliye puch rhi thi kyoki mobile data se download krna hota h mujhe.aur agr fir se mujhe koi currupted link mil gya to bar bar download krna possible nhi.agr fir bhi nhi chla to kya hi kr skte h.adjust kr lungi me.thank you so much sir🙏

@ishutiwari5567 3 года назад

@Shalu Jain vo sirf old version me hota h.latest versions me inbuilt power query hi chlta h.jo ap bol rhe ho vo excel 2010,2013 versions me chlta h.2016 ke bad se inbuilt power query aa gya excel me.alg se install nhi ho skta

@saahilsaahil5912 3 года назад

Sir I hv mail one query request you to pls revert with solution

@Innozant 3 года назад

OK..Will let you know dear..Time nhu rhta h bikul bhi.

@saahilsaahil5912 3 года назад

@@Innozant okay sir thanks for ur rply

@rushalikhatale4252 3 года назад

Hi sir

@umeshgautam3039 3 года назад

Sir Google in scripting per video banana

@Innozant 3 года назад

Acha Kuch time baad dear.

@adhishratan6208 3 года назад

Find highest and lowest value. TEBAL Highest Lowest 20 44 40 45 60 51 Drop-down list Highest/ Lowest =

@satscoolstyle4210 2 года назад

@3:48 you mistakenly said 1048516 which instead of 1048576

@Innozant 2 года назад

Ohh ..kindly rectify it.. Thanks for notifying us❤️❤️👍

@satscoolstyle4210 2 года назад

@@Innozant its request can you make one video bunch of hidden command in excel which we can add and use in customize tab hope this is good topic and helpful for your subscriber If you had already made please share link

@anwarhusain1769 Месяц назад

high music

@Innozant Месяц назад

Noted...will work in next video

@buckyafitch Год назад

What is your problem man? It is so annoying to focus when you keep moving right to left and left to right ...

@Innozant Год назад

It was old videos dear that time unable to do good editing,Sorry for your inconvenience

@syednaheed8925 2 года назад

Bhai aap itta zyada bolre aur batare bhoot kam, 13 min me hi bata sakte thae magar sirf intro me hi lagadiye aap pura video. Islye skip krna padhra apki video ko.zara kaam krte krte boldiyeto bhi samj jate log.

@Innozant 2 года назад

Ye tips and tricks video channel nhi hai..complete course jab karte hain to bus topic ko touch krke nhi nikal jana hota hai in depth explain karna hota hai..yadi time ki kami hai aapke paas aur jaldi se crash course karna chahte hain uske liye ye phir galat channel hai....aur bht resource hain padhne ke liye wahan kam.time me Seekhiye

@syednaheed8925 2 года назад

@@Innozant Are Sir g aap naraz hojare kaiku, mai bus explanation bada hogaya bol ke bola, aap galat mat smjhiye, mai apku demotivate ya phir nicha dikhane k liye nai bola, agar apku bura laga to usk liye sorry, mai apk videos dekhta hu thode tricks sikha apk hi videos se...actually i was excited to see the trick but there was no content about the power pivot.islye mai kuc zyada boldiya jaisa apku laga shaad.Many Thanks👍

@aakashkumar9961 Год назад

Bhai Kam ki bat kr yr sirf boring kr rha hai😤😤

@Innozant Год назад

Aakash ji ye Jadoo wale tricks video nhi hain ..Is channel par in depth course learning hota hai..Aapse gujarish hai kripya dubara video na dekhen na bore ho.Entertainment nhi educational channel hai ye . Respect your parent and teacher.😊

@farrukhalibutt1773 6 месяцев назад

Why can't you just get to the point you are trying to explain and how about not moving yourself from right to left so the viewer can actually concentrate on the actual topic. Total waste of time.