Ubulumko boshishino kwi-Microsoft Excel
I-PowerPivot ye-Excel yongeza kwi- Microsoft Excel . Ivumela abasebenzisi ukuqhuba ingqiqo-bulumko yoshishino (BI) kwindawo eyaziwayo.
I-PowerPivot ikhuphela mahala kwiMicrosoft kwaye ivumela abasebenzisi ukuba basebenze ngeeseti zeenkcukacha ezinkulu kakhulu. Ngaphambi kwePowerPivot, olu hlobo lokuhlalutya lucaciswe kwizinto ze-BI zixhobo ezifana ne-SAS kunye ne-Business Objects.
I-PowerPivot isebenzisa injini yememori ebizwa ngokuba nguVertiPaq. Le injini ye-SSAS iyasebenzisa i- RAM eyandisiweyo kwiikhompyutha ezininzi.
Uninzi lwezitolo ze-IT zicelomngeni kunye nezixhobo ezifunekayo ukwakha indawo ye-BI yemo. I-PowerPivot ihambisa enye yale misebenzi kufuphi nomsebenzisi wezoshishino. Nangona kukho iinkalo ezininzi kwi-PowerPivot ye-Excel, siye sakhetha ezintlanu esicinga ukuba zipholile kakhulu.
Iphulo: Ungalanda iWindowsPivot apha. Bona ukuba usebenzisa i- 32-bit okanye i-64-bit version ye-Windows ukuba awuqinisekanga ukuba yiyiphi ikhonkco lokukhuphela ukukhetha kwiwebhusayithi yeMicrosoft. UMicrosoft unendlela yokufaka i-PowerPivot xa unengxaki.
Qaphela: Idatha yePowerPivot inokugcinwa kuphela kwiincwadi zokusebenzela ezisisebenzisa i- XLSX , XLSM , okanye i- XLSB fayile.
01 ngo 05
Sebenza Ngezixhobo Zeenkcukacha Ezinkulu kakhulu
KwiMicrosoft Excel, ukuba uhambela ngaphantsi kwiphepha lokusebenzela, uza kubona ukuba inani eliphezulu lemiqolo li-1,048,576. Oku kubhekiselele kwimigca yesigidi yedatha.
Nge-PowerPivot ye-Excel, akukho mda kwinqanaba leedatha. Nangona le ngxelo yinyani, imingcele yangempela isekelwe kwinguqu ye-Microsoft Excel osebenzayo nokuba uya kushicilela ispredishithi sakho ku-SharePoint 2010.
Ukuba usebenzisa i- 64-bit version ye-Excel, i-PowerPivot inokuthi ibambe malunga ne-2 GB yedatha, kodwa kufuneka ube ne-RAM enokwaneleyo ukwenza lo msebenzi ngokufanelekileyo. Ukuba uceba ukushicilela i-Excel spreadsheet yakho ye-PowerPivot kwi-SharePoint 2010, ukwandisa ubungakanani befayile buyi-2 GB.
Umgca wecala kukuba i-PowerPivot ye-Excel inokusingatha izigidi zeerekhodi. Ukuba uthayatha ubuninzi, uya kufumana impazamo yememori.
Ukuba ufuna ukudlala nge-PowerPivot ye-Excel usebenzisa izigidi zeerekhodi, khuphela i-PowerPivot ye-Excel Tutorial Sample Data (malunga neeirekhodi ezigidi ezingama-2.3) ene nedatha oyifunayo kwi-PowerPivot Workbook Tutorial.
02 we 05
Hlanganisa idatha evela kwimithombo eyahlukileyo
Oku kufuneka kube yenye yezinto ezibaluleke kakhulu kwi-PowerPivot ye-Excel. I-Excel isoloko ikwazi ukulawula imithombo yolwazi efana ne- SQL Server , i-XML, iMicrosoft Access kunye ne-data esekelwe kwiwebhu. Ingxaki ifika xa ufuna ukudala ubudlelwane phakathi kwemithombo yolwazi eyahlukeneyo.
Kukho iimveliso zenkampani yesithathu ezikhoyo ukukunceda, kwaye ungasebenzisa imisebenzi ye-Excel njengeVLOOKUP ukuba "udibanise" idatha, ezi ndlela zingenakwenzeka kwiisethi ezinkulu zeenkcukacha. I-PowerPivot ye-Excel yakhiwe ukufeza lo msebenzi.
Ngaphakathi kwePowerPivot, ungangenisa idatha ukusuka kuyo nayiphina imithombo yedatha. Ndifumene ukuba enye yemithombo yolwazi efanelekileyo kunayo yonke iLohlu lweSahlulo seSabelo. Ndisebenzise i-PowerPivot ye-Excel ukudibanisa idatha esuka kwi-SQL Server kunye nohlu oluvela kwi-SharePoint.
Qaphela: Udinga i-SharePoint 2010 ukwenza lo msebenzi, kunye ne-ADO.Net yokusebenza ngexesha elifakwe kwi-SharePoint.
Xa udibanisa i-PowerPivot kwisihlomelo seSahlulo seSabelo, ngokuqinisekileyo uxhuma kwiNgcaciso yeDatha. Ukudala I-Feed Feed kwi-SharePoint uluhlu, vula uluhlu uze uqakraze kwiLibhoni yoluhlu . Emva koko cofa kwi- Export njenge-Data Feed kwaye uyilondoloze.
Isondlo sitholakala njenge-URL kwi-PowerPivot ye-Excel. Khangela iphepha elimhlophe usebenzisa i-SharePoint List Data kwi-PowerPivot (yi-MS Word DOCX ifayile) ngolwazi olungakumbi malunga nokusebenzisa i-SharePoint njengomthombo wedatha we-PowerPivot.
03 we 05
Yenza iimodeli zokuhlaziya ezibonakalayo ezibonakalayo
I-PowerPivot ye-Excel ikuvumela ukuba uvelise iinkcukacha ezahlukeneyo kwi-Excel sheet yephepha. Unokubuyisa idatha kwi-PivotTable, PivotChart, iTrart kunye neTable (ejikelezayo kunye nentshukumo), iiSatifiketi ezimbini (ezisezantsi kunye nezicatshulwa), iiSatifiketi ezine, kunye nePivotTable epheleleyo.
Amandla afika xa udala iphepha lokusebenzela elibandakanya iziphumo ezininzi. Oku kunika umbono wedeshibhodi yedatha eyenza uhlalutyo lulula. Kwaye nabaphathi bakho kufuneka bakwazi ukusebenzisana nephepha lakho lokusebenzela ukuba uyakha ngokuchanekileyo.
Ii-Slicers, ezithunyelwa nge-Excel 2010, yenza kube lula kwi-data ecocekileyo.
04 we 05
Sebenzisa i-DAX ekwakheni iZimu ezithengisiweyo zokuCoca kunye neDicing Data
I-DAX (Iinkcazo zoHlolo lweDatha) yilwimi yefomula esetyenzisiweyo kumatafula e-PowerPivot, ngokukodwa ekudaleni iikholomu ezibalwayo. Khangela i-TechNet DAX Reference yesalathiso epheleleyo.
Ngokuqhelekileyo ndisebenzisa imisebenzi yosuku lwe-DAX ukwenza iindawo zomhla zixhamle ngakumbi. Kwiphepha eliqhelekileyo lePivot kwi-Excel eyabandakanya ifom yexesha elifomathiweyo elifanelekileyo, ungasebenzisa iqoqo ukuquka ukukwazi ukucoca okanye iqela ngonyaka, kwikota, inyanga kunye nosuku.
Kwi-PowerPivot, kufuneka udale ezi zikholomu ezibalwe ukufeza into efanayo. Yongeza ikholomu nganye indlela ofuna ukuyifakraza okanye idatha yeqela kwiPivot Table yakho. Uninzi lwemisebenzi yamaphepha kwi-DAX iyafana neefomula ze-Excel, okwenza kube yi-snap.
Umzekelo, sebenzisa = UNYAKA ([ ikholomu yomhla ]) kwikholamu entsha ebhaliweyo ukuba ungeze unyaka kwisethi yakho yedatha kwi-PowerPivot. Ungasebenzisa le ntsi entsha YE YEAR njenge-slicer okanye iqela kwi-Pivot Table yakho.
05 we 05
Shicilela iDashbhoards kwiSahluko 2010
Ukuba inkampani yakho ifana nam, ideshibhodi yisebe yinkampani yakho ye-IT. I-PowerPivot, xa idibene ne-SharePoint 2010, ibeka amandla eedashbhodi ezandleni zabasebenzisi bakho.
Enye yezinto ezifunekayo zokushicilela iitshathi kunye neetafile ezixhaswayo ze-PowerPivot ku-SharePoint 2010 kukuphunyezwa kwe-PowerPivot yeSabelo kwiSahlulo sakho se-SharePoint 2010.
Khangela i-PowerPivot yeSabelo kwiSMSDN. Ithimba lakho le-IT liya kufuneka lenze le ngxenye.