Business intelligence mu Microsoft Excel
PowerPivot ye Excel inowedzera ye Microsoft Excel . Iko inobvumira vashandi kuti vaite simba rekuchenjera bhizinesi (BI) munzvimbo inowanzozivikanwa.
PowerPivot isingabhadhari kubva kuMicrosoft uye inobvumira vashandi kuti vashande nematafura makuru e data. Pamberi pePowerPivot, rudzi urwu rwekutsvakurudza rwaive rwakawanda kune zvishandiso zveBI zvishandiso seSAS neBusiness Objects.
PowerPivot inoshandisa injini yekuyeuka inonzi VertiPaq. Iyi injini yeSSSAS inoshandisa kushandisa yakawanda RAM inowanika mumakombiyuta akawanda evanhu nhasi.
Zvizhinji zvekutengesa kweT IT zvinorwisana nemari inodiwa yekuvaka bhizimusi BI zvakatipoteredza. PowerPivot inotora zvimwe zvebasa iri pedyo nevanoshandisa bhizinesi. Kunyange zvazvo pane zvakawanda zviri muPowerPivot yeExcel, takasarudza zvishanu zvatinofunga kuti ndiyo inotonhorera.
Zano: Unogona kutora PowerPivot pano. Ona kana uri kushandisa shanduro ye 32-bit kana 64-bit yeWindows kana iwe usina chokwadi chekutsvaga chikwata chaunogona kutora kubva pawebsite yeMicrosoft. Microsoft inofanirwa sei-pane kuisa PowerPivot kana uine matambudziko.
Cherechedza: Data yePowerPivot inogona kungochengetwa mumabhuku ekushanda anoshandisa XLSX , XLSM , kana XLSB mafaira ekuwedzera.
01 ye 05
Shanda Nekapamusoro Zvikuru Zvitsva
MuchiMicrosoft Excel, kana ukaenda kune imwe pasi pasi pebasa, iwe uchaona kuti nhamba yakawanda yemitsetse ndeyei048,576. Izvi zvinomiririra mitsara miriyoni yemedhi.
Ne PowerPivot yeExcel, hapana mhedziso pane nhamba yemigwagwa yedata. Kunyange zvazvo ichi chiri chirevo chechokwadi, kuperevedza chaiyo kunobva pane shanduro yeMicrosoft Excel uri kushanda uye kuti iwe uchazoparadzira spreadsheet yako ku SharePoint 2010.
Kana uri kutamba 64-bit version yeExcel, PowerPivot inogona kushanda ne 2 GB yemadata, asi iwe unofanirwa kunge uine RAM yakakwana yekuita basa iri zvakanaka. Kana ukaronga kuparidzira PowerPivot yako yeExcel spreadsheet ku SharePoint 2010, kukurisa faira yefaira zvakare 2 GB.
Chinokosha ndeyekuti PowerPivot yeExcel inogona kubata mamiriyoni emarekhodi. Kana iwe uchinge warova huwandu, iwe uchagamuchira kukanganwa kwepfungwa.
Kana iwe uchida kutamba ne PowerPivot ye Excel uchishandisa mamiriyoni emarekhodi, teerera PowerPivot yeExcel Tutorial Sample Data (inenge mamiriyoni 2.3 rekodhi) ine dhesi yaunoda yeTowerPivot Workbook Tutorial.
02 of 05
Gadzira Nyaya Dzakasiyana-siyana
Izvi zvinofanira kuva chimwe chezvinhu zvinokosha zvikuru muPowerPivot yeExcel. Excel yakagara ichikwanisa kubata zvinyorwa zvakasiyana-siyana zvakadai seSQL Server , XML, Microsoft Access uye kunyange web data yakagadzirwa. Dambudziko rinouya apo iwe unoda kugadzira ukama pakati pezvinhu zvakasiyana-siyana zvemashoko.
Kune zvikwangwani zvebato rechitatu zviripo kuti zvibatsire neizvi, uye iwe unogona kushandisa Excel mabasa akaita seVLOOKUP kuti "ijoke" data, idzi nzira hadzibatsiri kune huru dzese dze data. PowerPivot yeExcel yakagadzirirwa kuita basa iri.
MuChina PowerPivot, unogona kutumira dheti kubva kunenge chero dhiyabhorosi. Ndakaona kuti chimwe chezvinhu zvakakosha zvikuru zvekushandisa ndeye SharePoint List. Ndakashandisa PowerPivot yeExcel kuti iyananise data kubva kuSQL Server uye urongwa kubva ku SharePoint.
Cherechedza: Unoda SharePoint 2010 kuti uite basa iri, pamwe neAdO.Net runtime yakasikwa munzvimbo ye SharePoint.
Paunounganidza PowerPivot kune SharePoint list, iwe uri kunyatsobatana neData Feed. Kugadzira Data Feed kubva kune SharePoint list, shandisa mazita uye tora paRibhoni Rokutumira. Zvadaro chobva paKutengesa seDirect Feed uye uchengete.
Zvokudya zvinowanikwa se URL mune PowerPivot ye Excel. Chengeta pepa repepuru Pakushandisa SharePoint List Data mu PowerPivot (iri MS Word DOCX file) kuti uwane mamwe mashoko pamusoro pekushandisa SharePoint sechinhu cheDynamPivot.
03 of 05
Ita Mavara Apealing Analytical Models
PowerPivot yeExcel inoita kuti ubudise zvakasiyana-siyana zvekuona dhidhiyo ku Excel worksheet. Iwe unogona kudzorera dhamusi muPivotTable, PivotChart, Chati uye Tetabhenakeri (yakananga uye yakananga), Two Charts (yakananga uye yakananga), Four Charts, uye Flattened PivotTable.
Simba rinouya apo iwe unogadzira pepa rekushandisa iro rinosanganisira zvakawanda zvabuda. Izvi zvinopa dashboard kuona ye data inoita kuti kuongorora kuve nyore nyore. Kunyange vatongi vako vanofanira kukwanisa kuwirirana nebasa rako rekushanda kana iwe uchivaka nenzira yakarurama.
Slicers, iyo inotumirwa neExcel 2010, inoita kuti zvive nyore kune zvakaratidzwa zvakasvibiswa data.
04 of 05
Shandisa DAX kuti Uite Masango Akaenzaniswa Pakutsvaga uye Dicing Data
DAX (Data Inotsanangurwa Zvitsva) ndiwo mutauro wemasaini unoshandiswa mumatafura eWashPivot, zvikurukuru mukusika mazamu akaverengwa. Tarisa kunze kweTechNet DAX Reference yekutarisa zvakakwana.
Ini kazhinji ndinoshandisa DHAX zuva rinoita kuti zuva remasikati rive rakakosha. Mune Pivot Table yakatarwa muExcel iyo yaisanganisira yakarongeka zuva remunda webasa, unogona kushandisa boka kuti uise kukwanisa kusvina kana boka gore, rokutanga, mwedzi nemasikati.
Mune PowerPivot, unofanirwa kuumba idzi semadzorodhe akaenzaniswa kuita chimwe chinhu. Wedzerai korona yega yega yaunoda kufuta kana data yeboka muPivot Table yako. Zvakawanda zvezuva rinoitwa mu DAX zvakafanana neExcel formula, izvo zvinoita kuti izvi zvive nyore.
Semuenzaniso, shandisa = YEAR ([ koromusi yezuva ]) mune imwe korombo yakaverengerwa kuwedzera gore kune deta yako yakagadzirirwa mu PowerPivot. Iwe unokwanisa kushandisa svondo iyi YEYENYIKA semutambo kana kuti boka muPivot Table yako.
05 of 05
Shingai Dashibhodhi kune SharePoint 2010
Kana kambani yako yakafanana neyangu, dashibhodhi inenge iri basa reT team yako. PowerPivot, kana yakabatanidzwa ne SharePoint 2010, inoisa simba remasadhibhodhi mumaoko emavashandisi vako.
Chimwe chezvinodiwa pakudhinda PowerPivot nematafura anotungamirirwa naPowerPivot kuTablePoint 2010 ndekushandiswa kwePowerPivot yePointPoint pabasa rako re SharePoint 2010.
Tarisa PowerPivot yeSharePoint pane MSDN. Iko Titi YAKO ichafanirwa kuita chikamu ichi.