Reasons to learn Power Query , Power Pivot & Power BI?

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

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

50% 1

Why we need these excel Power tools(Power Query | Power Pivot | Power BI) to anaylize data , reporting and data visualization purpose.
If you analyze a lot of data, these tools make your life a lot easier also if your data is from different sources, they will simplify the reporting process.
Career Guide - Playlist Link - • Career Guide-सिफर से श...
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
#powerquery#powerpivot#Innozant #powerbi#msexcel

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

1 мар 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

You are doing fabulous work.

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

Waiting for Power BI classes ...... plz start soon

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

soon

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

Sir most welcome to your next step in all life. Thank you so much Sir... waiting....

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

Thanks Jitendra ji

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

THankx for these videos.....🙏🙏🙏

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

Thanks dear

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

Thanks for your help.

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

Thanks dear

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

Dear Sir Thanks for starting tutorials on power query, power pivot. Besides these power bi is a strong business analytics tool which every person should learn. Thanks again for taking initiatives so that we can learn easily from your tutorials. Thanks Jayanta Bhattacharyya

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

Thanks Jayanta...Happy learning dear..

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

Good morning sir i learn powerbi only your playlists thanku to guide for a next step after excel have a nice day sir.👌

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

thanks dear

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

tq sir powe query topic class start krne le liye 👍🏻mein aapke or mr mike sabhi education topic class enjoy krta hoon

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

Thanks Vijay ji

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

Sir thank you very much for starting power query,pivot,bi because Mai aapki rah per chalnewala Hu ,so congratulations to start power bi tools of excel I await .

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

Thanks Pramod ji

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

jee sir aap always steps by step batate hai...thank you sir🙏😊

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

thanks sandeep

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

Hi , After watching lot's video I come across the video are so amazing including training skill is superb.

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

Thanks Alpesh, Really means a lot to me dear❤️

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

Thanks Sir

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

Superb video, really helps professionals like us to upgrade skills. Will follow your power query videos soon.

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

Thanks Kavita..Happy learning dear♥️

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

thank you sir very informative video

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

Thanks Arman sahab

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

sir, I work well on the Power query. Do I need to learn the M language as well? I am preparing for data analyst job.

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

Innozant makes life easier 👌👌👌

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

Thanks Sahil Ji..Tc..God bless you dear

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

Powerful vedio.

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

Thanks

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

Sir keep going i m sharing your all video's in my whatsapp status sharing all friends ... Yr videos are really helpful. Sara RU-vid chhaan mara but jo chiz apki videos me hai vo to mere institute bhi nhi padhata

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

Love you dear...M really happy to listen these words..really means a lot..Lagta hai main jis maqsad se youtube platform se juda wo safal hone lga hai

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

Very clear ji!

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

Thanks Mira..Will start uploading both power query and power pivot parallel soon

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

@@Innozant I am so excited

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

Sir I am excited for power pivot and power Bi video. Sir pls jaldi se sikhaye

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

Sure ..jald and lgenge video

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

Thanks a lot sir.

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

Thanks Shrikant ji..Hope this help

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

Thanks you sir you are so great right information thank you sir

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

Thanks Shiva

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

Dear Sir I want to learn Complete Power BI please help for the same

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

Since longtime,no lecture on power pivot,power query. Pls continue it

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

M busy these days.. Will start uploading soon

@RakeshSingh-qo5nd 3 года назад

Sir aap sabka dhyan rakhte ho mai iss video ka wait kar rha tha

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

Thanks Rakesh ji..yaad tha mujhe ye

@upanshukumar7472 Год назад

Sir apki power bi ki playlist kaha milengi kahi mil nhi rahi

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

Thnq sir

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

Thanks Gaurav

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

Nycc sirr...gbu😊

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

Thanks Raman

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

@@Innozant sir mujje proquest8 milla ni abhi tk😔

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

Sir can we use isodd fuction with array bcoz I'm trying but I'm getting fail Sum(if(isodd(a1:a15),1,"")*(a1:a15))

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

ye galat paas Kiya hai aise nhi

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

Hello Sir, muze mere team ka daily performance ka report generate karna hai from my daily status report without pivot table. Please let me know which function to be used?

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

aap requirements batayenge tbhi bata payenge na ki sheet me kaunsa function use krnege

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

@@Innozant Muze ek table me Date wise Completed counts and achieved daily metric. 2nd table me member wise Average metric dekhana hai. Condition:- Dono Table me Inspection number and Attribute name wise dikhana hai. I have shared my input data through your email ID.

@GaganDeep-rx5zx 3 года назад

Can't wait for power bi🧐

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

🙂❤🙏

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

Same comment sir, please make videos शक्ति BI

@mohitsharma-ym3km 3 года назад

Sorry sir but ek doubt aur hai. Power Query and Power pivot toh Power bi me hote hai. Aur Excel ke add in me bhi hote hai. Toh kon sa seekhaoge ?? Kya ye dono same hai ya difference hai kuch??

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

Sharma ji..ek hi hai dear power query alag kyu hoga

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

Hi Sir, Ho much time to learn power pivot power query and power bi. Please suggest....

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

aprox 3 months

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

Thank you much for such a powerful content...❤❤ Sir, i have a doubt when we use "ZZZ" as lookup value in vlookup ,we get the value of range but the same output we are getting with single "Z" even with "X","Y" as well. Main question -why to use triple "Z"?? My logic says as in numerical value the largest value of numeric is 9e+307 is it same in case of alphabet "Z" is the largest value and 3 times "Z" increases it by 3 times.

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

Is my logic right ,sir?

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

@@deepali303 yes u r absolutely right ji

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

@@bishtlokesh1297Thank you for giving confirmation.☺🤨

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

Sir phle kya kre sql ya power bi plz reply

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

Dono me se koi bhi join kar sakte hain..excel finish krke phel sql kar lijiye yadi data analytics ke liye apply kar re hain to sql se jyada ques aayega phir sequence me BI kar lenge.

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

Sir can we get the playlist of power query and power pivot Pleaae share the link

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

Playlist are aleeady there..soon going to upload more videos

@upanshukumar7472 Год назад

Bhai agr kisi koh sir kaa koi dusra channel hai toh bta doh kuki jis power bi ko serious ki sir yaha baat kr rahe hai voh mil nho rahi hai. Practical vedio kaha hai power pivot or power query ki

@RajuKumar-ne1po 3 года назад

Can you give personal training ?

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

Yes ..We are providing Live Classroom training..You may join the same if needed

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

Sir AK video banaa jisme important formula ho only

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

Ok.dear

@MrNiks-li6jn 3 года назад

Hello sir I need your guidance..actually I'm doing MIS EXECUTIVE job and I have just 6 months experience in MIS field and I want to learn power bi and I'm good in advanced Excel but I don't know VBA, I just want to ask that what should I do to grow more ? VBA or power bi ? What should I learn right now ? Please guide me sir.

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

Dear Both are different thing..Power Bi is data visualization tool and vba is use for automation..first proceed with excel ,sql and power bi or Vba as per your interest.

@MrNiks-li6jn 3 года назад

@@Innozant You are right sir, actually my interest is towards data visualization more. So in that condition can I skip vba ? and directly jump on sql and power bi ? to get enter in data visualization field ?

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

Yes you can..if you don't have interest in programming..

@MrNiks-li6jn 3 года назад

@@Innozant Thank you sir for guiding me

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

Sir, I want to learn Power Bi from you. How can i contact. Pls advise

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

Kindly visit Innozant website for more information and contact us for further discussion ❤️

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

formula for 1.3 number to 1 case and 3 bottle in excel

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

didn't get u .

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

Bhai jaldi inke bhi interview questions do na

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

ok dear

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

Kitna salary hai mis job ma

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

It depends dear...and Vary from organization to organization

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

@@Innozant my respect to you sir You don't sell any dream rather you talk practically

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

Sir Aapka office address kaha hai?

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

Delhi..New Ahok Nagar.. Website se address le lein ..but abhi to lockdown ki wjse off😀

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

Power query karvao phele kyu first mai power query ka use hote h then power pivort hota h then power bi hota h

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

Lakesh ji apne video dekha nhi phir ..Maine whi explain Kiya hai tabhi parallel Playlist starts for power query and power bi

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

@@Innozant maine dekhe hai sir

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

@@Innozant sum ke bhi the or power pivort ke bhi or ms word and ms power point ke lookup ke the

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

haan..in saare Playlist ka video aayega ab

@mohitsharma-ym3km 3 года назад

But sir apne MIS career wali video me bataya tha ki Hume pehle "core and Advanced Excel " seekhna hai phir " VBA and SQL". Uske baad hi "Power Bi". Isliye me ab VBA start Karne ki soch Raha tha but is video ke baad thoda confuse ho Gaya. So please kindly solve it. what's Next after Advanced Excel? VBA and SQL or Power Query,Power Pivot and Power Bi.

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

Sharma ji itna confusion kyu.. VBA automation ke liye hota hai aur Sql large amount data storage aur retrieving ke liye.Vba pehle bhi Karen tab bhi power query aur pivot to excel ka hi Hissa hai aur aana chaiye jab large data ko Annalise krna hai to. Rahi baat power bi ya Tableau wo data visualization tool hai Kul milake kehne ka Matlab ye gai ki jitna seekh lo wo kam hai😀😀isliye seekhte rhiye ..nayi nayi technologies