Introduction to Power Pivot for Excel

Рет қаралды 55,081

3 жыл бұрын

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

Пікірлер: 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🙏❤

@shrikantbadge3978 3 жыл бұрын

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

@Innozant 3 жыл бұрын

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

@SasV276 5 ай бұрын

Thanks for this whole playlist ❤

@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.

@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.

@sufiyan874 Жыл бұрын

Very informative... Thank you sir

@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

@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

@shrikantbadge3978 Жыл бұрын

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

@Innozant Жыл бұрын

Thanks Shrikant Ji .Happy Learning

@roadtomppsc1490 2 жыл бұрын

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

@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👌👌😊

@saurabhdabas4440 Жыл бұрын

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

@Innozant Жыл бұрын

Thanks dear

@pawanverma7220 3 жыл бұрын

Awesome Class As Always

@Innozant 3 жыл бұрын

Thanks dear

@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

@AnupKumar-oe2jb 3 жыл бұрын

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

@Innozant 3 жыл бұрын

Thanks Anup ji❤🙏

@hemantgusain1260 3 жыл бұрын

Great explanation sir,

@Innozant 3 жыл бұрын

Thanks Hemant ji

@SahilKhan-sx3rj 3 жыл бұрын

Again first like nd comment

@Innozant 3 жыл бұрын

Thanks Sahil🙏❤

@hemantsingh9966 Жыл бұрын

Great Gurujii 🙏🙏🙏

@inrahuljha Жыл бұрын

Bahut accha explaination

@The-Fronted 3 жыл бұрын

Thank you so much.

@Innozant 3 жыл бұрын

Thanks Arif ji

@The-Fronted 3 жыл бұрын

Great 👌

@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

@tejpalsain1507 3 жыл бұрын

Thank you for power pivot.

@Innozant 3 жыл бұрын

Thanks Tejpal

@ArmaanKing17 3 ай бұрын

Zabardast video once again Sir. Thank you

@Darkhunterzzzz Жыл бұрын

Hats off bare Vai, Love from Bangladesh

@Innozant Жыл бұрын

Thanks dear

@VimalKumar-ih6ik 7 ай бұрын

Thank You Sir

@rakeshmlearningentertainme6099 2 жыл бұрын

nice video

@vinayvemul8456 2 жыл бұрын

Great learning 👌👍

@Innozant 2 жыл бұрын

Thanks

@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🙏❤

@situsahoo2482 3 жыл бұрын

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

@Innozant 3 жыл бұрын

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

@avnishmishra8378 2 жыл бұрын

Very nice sir

@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.

@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👍❤️

@manish9613 2 жыл бұрын

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

@nirmalraj25 Жыл бұрын

Nice Sir😊

@amansinha19891 3 жыл бұрын

Thanks sir...

@Innozant 3 жыл бұрын

Thanks Aman ji..Happy learning..gn

@x-lookup 11 ай бұрын

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

@chandannekesh 3 жыл бұрын

It's helpful

@Innozant 3 жыл бұрын

Thanks Chandan❤️🙏

@badalsingh2050 3 жыл бұрын

Very nice sir!!

@Innozant 3 жыл бұрын

Thanks Badal..Gn.tc

@yogeshahire1823 3 жыл бұрын

Interesting and likely to learn sirji 👍

@Innozant 3 жыл бұрын

Thanks Yogesh

@theabhishekmittal 10 ай бұрын

all 10 videos cover power pivot and advanced power pivot?

@allnewmovies4564 3 жыл бұрын

Thanks sir

@Innozant 3 жыл бұрын

Thanks dear

@chandrashekharmishra9521 2 жыл бұрын

Sir 2007 me power query avelble nhi h kya ?

@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.

@saahilsaahil5912 3 жыл бұрын

Awaiting for your next video sir on PP

@Innozant 3 жыл бұрын

sure soon

@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

@sunilchapra1044 3 жыл бұрын

Good video

@Innozant 3 жыл бұрын

Thanks Sunil Ji

@puransingh-sx2tk 3 жыл бұрын

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

@Innozant 3 жыл бұрын

👍🙏❤😀

@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

@ASIFANSARI-ql6bq 3 жыл бұрын

Nice

@Innozant 3 жыл бұрын

Thanks Asif sahab💖🙏

@gauravbhatia7987 3 жыл бұрын

Thnq sir 🙏🙏

@Innozant 3 жыл бұрын

❤🙏

@smrutiranjanrout3414 2 жыл бұрын

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

@ramanmangat3320 3 жыл бұрын

Guru jii🙏

@Innozant 3 жыл бұрын

Thanks Raman Ji..Happy Learning dear

@AshishKumar-hc3km Жыл бұрын

sir mere paas 2016 standard hai usem nhi aa rha hai

@adhishratan6208 3 жыл бұрын

❤️❤️❤️

@adhishratan6208 3 жыл бұрын

please help solve the problem

@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 KZfaq 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

@Ann_2208 2 жыл бұрын

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

@pawanverma7220 3 жыл бұрын

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

@Innozant 3 жыл бұрын

good

@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

@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

@mohitchauhan7808 3 жыл бұрын

👍👍👍👍👍

@shahidamanzoor9294 2 жыл бұрын

Sir you haven't uploaded macros series yet.

@Innozant 2 жыл бұрын

Yes Shahida..Will upload soon

@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😂😂😂

@kuldeeppoorwa8914 Жыл бұрын

😊😊😊😊😊😊

@hanifuddin3591 8 ай бұрын

Not Understand [@SalesRep] Plz Explain

@Innozant 8 ай бұрын

Query?

@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

@allnewmovies4564 3 жыл бұрын

When will next part release

@Innozant 3 жыл бұрын

soon

@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

@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

@rushalikhatale4252 3 жыл бұрын

Hi sir

@umeshgautam3039 3 жыл бұрын

Sir Google in scripting per video banana

@Innozant 3 жыл бұрын

Acha Kuch time baad dear.

@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

@anwarhusain1769 22 күн бұрын

high music

@Innozant 22 күн бұрын

Noted...will work in next video

@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

@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.😊

@brajasundar8535 28 күн бұрын

you talk much sir

@sucmitra 2 жыл бұрын

If you can stop blabbering, It could have made sense

@farrukhalibutt1773 5 ай бұрын

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.

@VimalKumar-ih6ik 7 ай бұрын

Thank You Sir

@adhishratan6208 3 жыл бұрын

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

@adhishratan6208 3 жыл бұрын

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

@Innozant 3 жыл бұрын

whats Problem while creating this list..you wang combined list i hope .

@adhishratan6208 3 жыл бұрын

sir combined nhi Hoga Kya ye