Malonda a zamalonda ku Microsoft Excel
PowerPivot ya Excel ndi kuwonjezera kwa Microsoft Excel . Amalola ogwiritsa ntchito maluso amphamvu a bizinesi (BI) pamalo omwe amadziwika bwino.
PowerPivot ndiwotsitsa kwaulere kuchokera ku Microsoft ndipo imalola ogwiritsa ntchito kugwira ntchito ndi ma data aakulu kwambiri. Pambuyo pa PowerPivot, kusanthula kwa mtundu umenewu kunali kokha kumagwiritsidwe ntchito a BI monga SAS ndi Business Objects.
PowerPivot imagwiritsa ntchito injini yamakono yotchedwa VertiPaq. Injini iyi ya SSAS imapindula ndi kuwonjezeka kwa RAM komwe kumapezeka makompyuta ambiri lero.
Makasitomala ambiri a IT amatsutsidwa ndi zofunika zowonjezera malonda a BI. PowerPivot imasuntha zina mwa ntchitoyi pafupi ndi wogwiritsa ntchito malonda. Ngakhale pali zambiri mu PowerPivot kwa Excel, tasankha zisanu zomwe timaganiza kuti ndizizizira kwambiri.
Langizo: Mungathe kukopera PowerPivot apa. Onani ngati mukugwiritsa ntchito mawindo a 32-bit kapena 64-bit ngati mulibe chitsimikizo chomwe mungasankhe kuchokera ku webusaiti ya Microsoft. Microsoft imakhala ndi momwe angakhalire pakuika PowerPivot ngati muli ndi mavuto.
Dziwani: Deta ya PowerPivot ikhoza kupulumutsidwa m'mabuku ogwiritsira ntchito XLSX , XLSM , kapena XLSB .
01 ya 05
Gwiritsani Ntchito Zambiri Zambiri Zosasintha
Mu Microsoft Excel, ngati mutasunthira pansi pamunsi pa tsamba, mudzawona kuti chiwerengero chachikulu cha mizere ndi 1,048,576. Izi zikuyimira pafupi mizera miliyoni ya deta.
Ndi PowerPivot ya Excel, palibe malire pa chiwerengero cha mizere ya deta. Ngakhale kuti izi ndizowona, malire enieniwo amachokera ku Microsoft Excel yomwe mukuyendetsa komanso ngati mukufuna kufalitsa spreadsheet yanu ku SharePoint 2010.
Ngati mukugwiritsira ntchito Excel 64-bit ya Excel, PowerPivot ingathe kuthana ndi 2 GB ya deta, koma inunso muyenera kukhala ndi RAM yokwanira kuti mugwire bwino ntchitoyi. Ngati mukufuna kukatulutsa Excel spreadsheet yanu yochokera ku PowerPivint ku SharePoint 2010, kukula kwa fayilo kukula ndi 2 GB.
Mfundo yaikulu ndi yakuti PowerPivot ya Excel ikhoza kugwiritsira ntchito ma record ambiri. Ngati mutagwira pazitali, mudzalandira cholakwika cha kukumbukira.
Ngati mukufuna kusewera ndi PowerPivot kwa Excel pogwiritsira ntchito zolemba zambiri, koperani PowerPivot kwa Excel Tutorial Sample Data (pafupifupi madola 2.3 miliyoni) omwe ali ndi deta yomwe mukusowa ku PowerPivot Workbook Tutorial.
02 ya 05
Gwirizanitsani Chidwi Kuchokera M'zinthu Zina
Izi ziyenera kukhala chimodzi mwa zinthu zofunika kwambiri pa PowerPivot kwa Excel. Excel nthawizonse yatha kuthana ndi magwero osiyanasiyana a data monga SQL Server , XML, Microsoft Access komanso deta yolongosoka. Vuto limabwera pamene mukufunika kulenga maubwenzi pakati pa magwero osiyana siyana.
Pali katundu wa chipani chachitatu omwe akuthandizira ndi izi, ndipo mungagwiritse ntchito Excel ntchito monga VLOOKUP kuti "adzilumikize" deta, njirazi sizothandiza kwa ma data aakulu. PowerPivot ya Excel yamangidwira kukwaniritsa ntchitoyi.
Pogwiritsa ntchito PowerPivot, mukhoza kutumiza deta kuchokera pafupi ndi deta iliyonse. Ndapeza kuti imodzi mwazinthu zopezeka pa data ndi Gawo la SharePoint. Ndagwiritsa ntchito PowerPivot ku Excel kuti ndiphatikize data kuchokera ku SQL Server ndi mndandanda wochokera ku SharePoint.
Zindikirani: Mukufunikira SharePoint 2010 kuti mupange ntchitoyi, pamodzi ndi ADO.Net nthawi yomaliza yoikidwa pa malo a SharePoint.
Mukamagwirizanitsa PowerPivot ku mndandandanda wa SharePoint, mukugwirizanitsa ndi Kudya kwa Deta. Pofuna Kudyetsa Deta ku Gawo la SharePoint, tsegulani mndandanda ndipo dinani pa Luboni. Kenaka dinani pa Export monga Dongosolo la Data ndi kulisunga.
Zakudya zilipo ngati URL mu PowerPivot kwa Excel. Onani pepala loyera Pogwiritsa Ntchito Zowonjezera List List mu PowerPivot (ndi MS Word DOCX file) kuti mudziwe zambiri pogwiritsa ntchito SharePoint monga chinsinsi cha PowerPivot.
03 a 05
Pangani Zithunzi Zojambula Zowonekera
PowerPivot ya Excel imakulolani kuti muwonetsetse deta zosiyanasiyana zojambula pa tsamba lanu la Excel. Mukhoza kubwezeretsa deta mu PivotTable, PivotChart, Chart ndi Table (yopingasa ndi yowoneka), Mapepala Awiri (osakanikirana ndi ofukula), Zolemba Zinayi, ndi Zowonjezera Zowonjezera.
Mphamvu imabwera pamene mukupanga tsamba lomwe likuphatikizapo zotsatira zambiri. Izi zimapereka mawonedwe a dashboard a deta yomwe imapangitsa kufufuza kumakhala kosavuta kwenikweni. Ngakhale abwanamkubwa anu ayenera kuyanjana ndi tsamba lanu la ntchito ngati mukulikonza molondola.
Zolemba, zomwe zimatumizidwa ndi Excel 2010, zimapangitsa kuti zikhale zosavuta pazithunzi zojambulidwa.
04 ya 05
Gwiritsani ntchito DAX kuti Pangani Masamba Owerengetsera Slicing ndi Dicing Data
DAX (Mafotokozedwe Owonetsera Deta) ndilo chilankhulo chomwe chimagwiritsidwa ntchito mu matebulo a PowerPivot, makamaka popanga maulendo owerengetsera. Onani TechNet DAX Reference kuti muwerenge kwathunthu.
Nthawi zambiri ndimagwiritsa ntchito masiku a DAX kuti tsiku lamasamba likhale lothandiza kwambiri. Mu Pivot Table Yomweyi ku Excel yomwe imaphatikizapo dera lasukumodzinso lokonzedwa bwino, mungagwiritse ntchito magulu kuti mukhale okhoza kufuta kapena gulu pagulu, kotala, mwezi ndi tsiku.
Mu PowerPivot, mukufunikira kupanga izi monga mazenera owerengetsera kuti achite chinthu chomwecho. Onjezerani ndondomeko ya njira iliyonse yomwe mukufunika kuyisankhira kapena deta yanu mu Pivot Table yanu. Zambiri zamtunduwu zomwe zikuchitika mu DAX ndizofanana ndi ma Excel ma formula, zomwe zimapangitsa kuti izi zisinthe.
Mwachitsanzo, gwiritsani ntchito = YEAR ([ tsiku la kalata ]) m'kalembedwe yatsopano yowonjezerapo kuti muwonjezere chaka ku deta yanu mu PowerPivot. Mutha kugwiritsa ntchito munda watsopano wa YEAR ngati slicer kapena gulu mu Pivot Table yanu.
05 ya 05
Sindikizani Mabodibodi ku Gawo la 2010
Ngati kampani yanu ili ngati yanga, dashboard akadali ntchito ya timu yanu IT. PowerPivot, palimodzi ndi SharePoint 2010, imapereka mphamvu zamabankidi m'manja mwa ogwiritsa ntchito.
Chimodzi mwa zofunikira zoyenera kutsatsa ndondomeko zotsatiridwa ndi PowerPivot kuti zikhale ndi SharePoint 2010 ndi kugwiritsa ntchito PowerPivot kwa SharePoint pa gawo lanu la SharePoint 2010.
Onani PowerPivot for SharePoint pa MSDN. Gulu lanu la IT liyenera kuchita gawo ili.