Тёмный

Import Large and Compression in Power Pivot | Reduce File Size using Power Pivot 

Innozant
Подписаться 148 тыс.
Просмотров 16 тыс.
50% 1

Import Large and Compression in Power Pivot | Reduce File Size using 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 #powerpivotdatamodel #importlargedat#powerpivottricks

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

 

30 июн 2021

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 79   
@mdrashid0772
@mdrashid0772 2 года назад
Osmm sir..best teacher in excell
@Innozant
@Innozant 2 года назад
♥️♥️
@rajivranjan-mf6zu
@rajivranjan-mf6zu 3 года назад
Great approach to handle heavy files....Thank you sir...
@Innozant
@Innozant 3 года назад
Thanks dear ❤️🙏
@princemjprasanth8954
@princemjprasanth8954 3 года назад
Thanks for the helpful video Sir. Your lessons and your teaching method are very interesting. Keep posting such kind of helpful videos. Thanks a lot.
@Innozant
@Innozant 3 года назад
Thanks Prince ❤️❤️❤️
@shrikantbadge3978
@shrikantbadge3978 Год назад
Amazing and helpful. THanks sir.
@ranvir0392
@ranvir0392 3 года назад
What a video sir,......please upload more videos of power pivot frequently......you are best teacher ....hat's off to you sir
@Innozant
@Innozant 3 года назад
Thanks Ranvir for your valuable appreciation ❤️🙏
@jayantabhattacharyya628
@jayantabhattacharyya628 3 года назад
Dear Sir Very useful tricks to reduce heavy excel file size in power pivot. It's a new trick and I don't know before watching this. This will definitely help me. Sir kindly upload a video on dax and measure. I want to learn these. Thanks & Regards Jayanta Bhattacharyya
@Innozant
@Innozant 3 года назад
Thanks Jayanta..Soon DAX and measures is going to start in power pivot series.. Thanks for being part of Innoznat family ❤️❤️
@satishojha6240
@satishojha6240 3 года назад
Very effective video sir 🙏🙏🙏🙏. good night sir
@Innozant
@Innozant 3 года назад
Thanks Satish Ji .Good Night
@VimalKumar-ih6ik
@VimalKumar-ih6ik 7 месяцев назад
Amazing dear sir...
@dhakafady774
@dhakafady774 Год назад
thanks a lot sir i am from Bangladesh
@pnadig
@pnadig 3 года назад
Buddy, you are too good in teaching. Keep it up.
@Innozant
@Innozant 3 года назад
Thanks Praveen Ji🙏🙏❤️
@Ann_2208
@Ann_2208 2 года назад
wah sir new knowledge to share always
@Innozant
@Innozant 2 года назад
Thanks dear
@kishorpanara4191
@kishorpanara4191 3 года назад
I like this topic and thank you sir
@Innozant
@Innozant 3 года назад
Thanks Kishor ji
@neerajjain230
@neerajjain230 3 года назад
never seen before, excellent
@Innozant
@Innozant 3 года назад
Thanks Neeraj Ji.Happy Learning ❤️🙏
@createyour6681
@createyour6681 3 года назад
Very great sir
@Innozant
@Innozant 3 года назад
Thanks 🙏❤️
@Innozant
@Innozant 3 года назад
❤️❤️
@durgeshrai8938
@durgeshrai8938 3 года назад
Sir bahut badiya
@Innozant
@Innozant 3 года назад
Thanks Durgesh Ji❤️
@gauravbanerjee7891
@gauravbanerjee7891 3 года назад
Happy learning.....very good video...sir power bi bhi sikhna hai🙏
@Innozant
@Innozant 3 года назад
Bht Jald aayega Gaurav Ji
@gauravbanerjee7891
@gauravbanerjee7891 3 года назад
@@Innozant thank you sir 🙏
@hsgusain2054
@hsgusain2054 3 года назад
Excellent Sir 👌👌
@Innozant
@Innozant 3 года назад
Thanks dear
@arunkumarsinghark3024
@arunkumarsinghark3024 Год назад
अति सुंदर सर 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
@prajwalshetty2047
@prajwalshetty2047 2 года назад
Nice 👍
@uniquemobiletipstricks7714
@uniquemobiletipstricks7714 10 месяцев назад
Nice
@aqeelahmadengr3
@aqeelahmadengr3 3 года назад
Like enhanced system excel good work hard work, work and work, aik qadam agay, conditional formatting
@Innozant
@Innozant 3 года назад
Thanks ❤️❤️
@hsgusain2054
@hsgusain2054 3 года назад
Very useful sir because huge filles irritates while working on it
@Innozant
@Innozant 3 года назад
Thanks dear❤️🙏
@prajwalshetty2047
@prajwalshetty2047 2 года назад
Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.
@ashusharma9439
@ashusharma9439 3 года назад
👌
@12dineshgupta
@12dineshgupta Год назад
if we delete the master file which is uploaded, will it impact the compressed file
@RahulRoy-po9ct
@RahulRoy-po9ct Год назад
🙏
@SasV276
@SasV276 5 месяцев назад
Where is that video where you have explained about compression algorithm of power pivot?
@deepakverma-qo3oj
@deepakverma-qo3oj 2 года назад
Sir mere pass data 5000 ke karib hai aur usme extract unique list ka formula lagane ke bad file slow work kar raha hai, kya power pivot me kam karne se fayda hoga ?
@manojkumarsingh3385
@manojkumarsingh3385 3 года назад
🙏🙏🙏
@Innozant
@Innozant 3 года назад
❤️❤️
@himaloyshadhin9958
@himaloyshadhin9958 3 года назад
Could you pls explain difference between power query and power bi including power pivot. I have never seen your power query ans power pivot videos.
@Innozant
@Innozant 3 года назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tkFv2UTDzaI.html Kindly watch this video
@ahmedshahzad9402
@ahmedshahzad9402 5 месяцев назад
Waiting for more dax
@RahulChauhan-ll9pu
@RahulChauhan-ll9pu 3 года назад
🙏🙏🙏🙏🙏🙏
@Innozant
@Innozant 3 года назад
❤️❤️
@user-hz8lz9ir6l
@user-hz8lz9ir6l Год назад
yes kar sakte hain
@PassRaheAsmanPRA
@PassRaheAsmanPRA Год назад
Sir Main 367 mb data ka upar practice kar rahe the but compress nahi ho raha hain...file automatic close ho raha hain....Please help...Prasit Pramanick
@gauravbhatia7987
@gauravbhatia7987 3 года назад
Thnq sir sir koi aur bhi treeka hai file ka size gatane ka
@Innozant
@Innozant 3 года назад
Haan excel se bhi ho jayega dear
@rakeshmlearningentertainme6099
@rakeshmlearningentertainme6099 2 года назад
aswesome
@Innozant
@Innozant 2 года назад
Thanks Rakesh Ji
@sunilkumar3209
@sunilkumar3209 3 года назад
hello sir you uploaded a video in which you use substitute nine time to extract the alphabets from number pls sir share link of that video or tell me name of that. i am very thankfull to you
@Innozant
@Innozant 3 года назад
Search kra hoga..mis interview cracker ke kisi episode me hai dear
@hussainmeghani4809
@hussainmeghani4809 3 года назад
Sir, pls start to teach as power bi and power query plsssssss
@Innozant
@Innozant 3 года назад
Its already running dear
@hussainmeghani4809
@hussainmeghani4809 3 года назад
@@Innozant pls share link...thks..and you have excellent communication skill...despite pro in excel...you are very down to earth
@Innozant
@Innozant 3 года назад
Thanks bHussain sahab❤️❤️🙏 Goto Playlist..Seprate playlist for Excel power query and Powrr Pivot are there
@AshishKumar-hc3km
@AshishKumar-hc3km 3 года назад
Sir ye excel 2016me ho jayega kya
@Innozant
@Innozant 3 года назад
Haan 2016 me h already power pivot..ye to alt dp se kisi vhi version me ho jayega
@deepakkandpal2602
@deepakkandpal2602 Год назад
Hello sir. Sir mene power pivot se dax k through 1 formula lga k 1 field creat kia apni pivot k lie. but ab muje us data par % nikalna hai amount ka but mere excel mai calculated field highlight nhi ho rha hai. and muje power pivot se % nikalne ka formula nhi aa rha. please sir help kr deejiye.🙏🙏
@deepakkandpal2602
@deepakkandpal2602 Год назад
Hello sir. Please meri ye query solve kr deejiye.
@jyotiramsuryawanshi211
@jyotiramsuryawanshi211 2 года назад
Power pivot work in 2007 excel
@Innozant
@Innozant 2 года назад
With extension
@hrhelpteam
@hrhelpteam 3 года назад
Power pivot main to folder se upload karne ka koi option nahi hai sir, power query se upload karke add to data model main karna padega. Ek question hai sir jab power query se folder upload karte hai to kind default header main ek hi sheet ka 2 format banta hai. ek Table ka, ek sheet ka dono main kaun sa choose karna chahiye humko, kya benefit hai ye dono kyon generate hota hai, isko disable bhi kiya ja sakta hai sir.
@Innozant
@Innozant 3 года назад
Veey good..Right answer Kumar Gaurav ji...
@Innozant
@Innozant 3 года назад
Table lenge na data set me dear
@manishjonwal1144
@manishjonwal1144 Год назад
Power bi ke data ko excel me kaise convert kare sir
@Innozant
@Innozant Год назад
Convert kyu karna .direct copy ho jata hai wahanse
@rahulchakrawarti3547
@rahulchakrawarti3547 3 года назад
Compress file ko mail krenge aur client nhi janta to is bare me to koi option h ki compress file ko excel me show kre?
@Innozant
@Innozant 3 года назад
Utna jyada data hoga to excel me waise hi show nhi ho payega..tab bhi to data model me hi rakhna hoga na dea Rahul
@rahulchakrawarti3547
@rahulchakrawarti3547 3 года назад
@@Innozant yes sir
Далее
Merge Tables Using Power Query | Vlookup Alternative
13:43
How Many Balloons Does It Take To Fly?
00:18
Просмотров 15 млн
How to use Power Pivot in Excel | Full Tutorial
30:38