Ukuhlakanipha kwebhizinisi ku-Microsoft Excel
I-PowerPivot ye-Excel i-add-on ye- Microsoft Excel . Ivumela abasebenzisi ukuqhuba ukuhlakanipha kwebhizinisi elinamandla (BI) endaweni ejwayelekile.
I-PowerPivot iyinhlangano yamahhala evela ku-Microsoft futhi ivumela abasebenzisi ukuthi basebenze ngamasethingi wedatha amakhulu kakhulu. Ngaphambi kwe-PowerPivot, lolu hlobo lokuhlaziywa lukhawulelwe kumathuluzi e-BI wamabhizinisi afana ne-SAS kanye neBusiness Business.
I-PowerPivot isebenzisa injini inkumbulo ebizwa nge-VertiPaq. Le injini ye-SSAS isebenzisa ngokunenzuzo i- RAM eyengeziwe etholakalayo kumakhompyutha amaningi athile namuhla.
Izitolo eziningi ze-IT zinselele ngemithombo edingekayo yokwakha imvelo yebhizinisi le-BI. I-PowerPivot idlulisela amanye alo msebenzi eduze komsebenzisi webhizinisi. Nakuba kunezici eziningi ku-PowerPivot ye-Excel, sikhethe ezinhlanu esizicabangela ukuthi zipholile kakhulu.
Ithiphu: Ungalanda i-PowerPivot lapha. Bona ukuthi usebenzisa i- 32-bit noma ingu-64-bit version ye-Windows uma ungaqiniseki ukuthi iyiphi i-link yokulanda okumele uyikhethe kuwebhusayithi ye-Microsoft. I-Microsoft ine-how to to install PowerPivot uma unenkinga.
Qaphela: Idatha ye-PowerPivot ingagcinwa kuphela ezincwadini zokusebenzela ezisebenzisa izandiso zefayela le- XLSX , XLSM , noma i- XLSB .
01 ka 05
Sebenza Ngezimboni Zedatha Ezinkulu kakhulu
Ku-Microsoft Excel, uma uhambisa phansi phansi kweshidi, uzobona ukuthi inani eliphezulu lemigqa liyi-1,048,576. Lokhu kubonisa nxazonke ezigidini zemigqa yedatha.
Nge-PowerPivot ye-Excel, ayikho umkhawulo kunombolo yemigqa yedatha. Nakuba lokhu kuyisitatimende sangempela, ukulinganiselwa kwangempela kusekelwe ku-Microsoft Excel yokusebenza osebenzayo nokuthi ngabe uzoshicilela ispredishithi sakho ku-SharePoint 2010.
Uma uqhuba inguqulo engu-64-bit ye-Excel, i-PowerPivot ingabamba nge-2 GB yedatha, kodwa futhi kufanele ube ne-RAM eyanele ukwenza lo msebenzi kahle. Uma uhlela ukushicilela ispredishithi sakho se-Excel PowerPivot esekelwe ku-SharePoint 2010, ukwandisa usayizi wefayela nakho ku-2 GB.
Okubalulekile ukuthi i-PowerPivot ye-Excel ingasingatha izigidi zamarekhodi. Uma uthinta isiphezulu, uzothola iphutha lememori.
Uma ufuna ukudlala nge-PowerPivot ye-Excel usebenzisa izigidi zamarekhodi, landa i-PowerPivot ye-Excel Tutorial Sample Data (cishe amarekhodi ayizigidi ezingu-2.3) enedatha oyidingayo kwi-PowerPivot Training Book tutorial.
02 ka 05
Hlanganisa Imininingwane Emithonjeni Ehlukile
Lokhu kufanele kube esinye sezici ezibaluleke kakhulu ku-PowerPivot ye-Excel. I-Excel isilokhu ikwazi ukuphatha imithombo ehlukene yedatha efana ne- SQL Server , i-XML, i-Microsoft Access kanye nedatha esekelwe kuwebhu. Inkinga ifika lapho udinga ukudala ubuhlobo phakathi kwemithombo ehlukene yedatha.
Kunemikhiqizo yeqembu lesithathu etholakalayo ukusiza ngalokhu, futhi ungasebenzisa imisebenzi ye-Excel efana ne-VLOOKUP ukuze "ujoyine" idatha, lezi zindlela azinakwenzeka kumaqoqo amakhulu edatha. I-PowerPivot ye-Excel yakhelwe ukufeza lo msebenzi.
Ngaphakathi kwe-PowerPivot, ungangenisa idatha kusuka kunoma imuphi umthombo wedatha. Ngithole ukuthi enye yemithombo ewusizo kakhulu yedatha inguhlu lokwabelana nge-SharePoint. Ngisebenzise i-PowerPivot ye-Excel ukuhlanganisa idatha kusuka ku-SQL Server kanye nohlu oluvela ku-SharePoint.
Qaphela: Udinga i-SharePoint 2010 ukwenza lokhu kusebenze, kanye ne-ADO.Net yokugijima kwesikhathi efakwe kwimvelo ye-SharePoint.
Uma uxhuma i-PowerPivot kuhlu oluyisisekelo se-SharePoint, empeleni uxhumeka ku-Feed Data. Ukwakha Okuphakelayo Kwemininingwane kusuka ohlwini lwe-SharePoint, vula uhlu bese uqhafaza kuLibhoni Lohlu. Bese uchofoza ku- Export njenge-Feed Data bese uyilondoloza.
Ukudla kuyatholakala njenge-URL ku-PowerPivot ye-Excel. Hlola iphepha elimhlophe usebenzisa i-SharePoint List Data ku-PowerPivot (ifayela le-MS Word DOCX) ukuthola ulwazi oluthe xaxa ngokusebenzisa i-SharePoint njengomthombo wedatha we-PowerPivot.
03 ka 05
Yakha Amamodeli Wokuhlaziya Abonakalayo Abonakalayo
I-PowerPivot ye-Excel ikuvumela ukuthi ukhiphe idatha ehlukahlukene ebonwayo kuphepha lakho lokusebenzela le-Excel. Ungabuyisa idatha ku-PivotTable, PivotChart, Ishadi kanye neThebula (enezingqimba futhi eziqondile), Amashadi amabili (ama-horizontal and vertical), Amashadi amane, ne-PivotTable ehlanganisiwe.
Amandla afika lapho udala ishidi lokusebenzela elifaka imiphumela eminingi. Lokhu kunikeza umbono wedeshibhodi wedatha eyenza ukuhlaziywa kube lula kakhulu. Ngisho nabasebenzi bakho kufanele bakwazi ukusebenzisana nephepha lakho lokusebenzela uma uyilungisa kahle.
Ama-slicers, athunyelwe nge-Excel 2010, enza kube lula kumininingwane ebonakalayo ehlungiwe.
04 ka 05
Sebenzisa i-DAX ekwakheni amasimu ahlukanisiwe wokuThatha nokuDicing Data
I-DAX (Ukuboniswa Kwemininingwane Yedatha) yilona ulimi lwefomula elisetshenziselwa amatafula we-PowerPivot, ngokuyinhloko ekudaleni amakholomu athile. Bheka i-TechNet DAX Reference yokubhekisela okuphelele.
Ngivame ukusebenzisa imisebenzi yosuku lwe-DAX ukwenza izinsuku zosuku ziwusizo kakhulu. Ku-Pivot Table ejwayelekile e-Excel efaka insimu yosuku olufomethiwe kahle, ungasebenzisa ukuqoqa ukufaka phakathi ikhono lokuhlunga noma iqembu ngonyaka, ikota, inyanga nosuku.
Ku-PowerPivot, udinga ukudala lezi zikholomu ezibalwe ukuze ufeze into efanayo. Engeza ikholomu ngayinye indlela oyidingayo ukuyihlunga noma idatha yeqembu ku-Pivot Table yakho. Imisebenzi yamanje eminingi ku-DAX ifana namafomu e-Excel, okwenza lokhu kube yi-snap.
Isibonelo, sebenzisa = YEAR ([ ikholomu yosuku ]) kukholomu entsha ebhaliwe yokwengeza unyaka kwisethi yakho yedatha ku-PowerPivot. Ungasebenzisa le nsimu entsha ye- YEAR njenge-slicer noma iqembu ku-Pivot Table yakho.
05 ka 05
Shicilela ama-Dashboards ku-SharePoint 2010
Uma inkampani yakho ifana neyami, ideshibhodi isasebenza umsebenzi wethimba lakho le-IT. I-PowerPivot, uma ihlangene ne-SharePoint 2010, ibeka amandla amabhasibhodi ezandleni zabasebenzisi bakho.
Enye yezinto ezidingekayo zokushicilela amashadi namatafula asebenzayo we-PowerPivot ku-SharePoint 2010 ukuqaliswa kwe-PowerPivot ye-SharePoint epulazini lakho le-SharePoint 2010.
Bheka i-PowerPivot ye-SharePoint ku-MSDN. Ithimba lakho le-IT kuzodingeka lenze le ngxenye.