Kev txawj ntse ua lag luam hauv Microsoft Excel
PowerPivot rau Excel yog ib qho ntxiv rau Microsoft Excel . Nws cia cov neeg siv coj ua lag luam txawj ntse (BI) hauv cheeb tsam uas paub zoo.
PowerPivot yog ib qho dawb los ntawm Microsoft thiab tso cai rau cov neeg siv ua haujlwm nrog cov ntaub ntawv teev cov ntaub ntawv loj heev. Ua ntej PowerPivot, qhov kev soj ntsuam no tsuas siv rau cov khoom siv cuab yeej BI xws li SAS thiab Cov Khoom Lag Luam.
PowerPivot siv lub cim-hauv cav hu ua VertiPaq. Lub cav SSAS no siv sijhawm ntau dua ntawm RAM ntxiv rau hauv cov kev siv computers feem ntau hnub no.
Ntaus NWS feem ntau yog cov kev sib tw nrog cov kev pabcuam uas tsim nyog los tsim kom tau tawm ntawm cov chaw haujlwm BI. PowerPivot txav ib co ntawm txoj haujlwm no los ze zog rau cov neeg lag luam. Thaum muaj ntau yam hauv PowerPivot rau Excel, peb tau xaiv tsib tias peb xav tias yog lub caij txias.
Ntsis: Koj tuaj yeem tau PowerPivot ntawm no. Saib seb koj 're siv 32-ntsis lossis 64-ntsis version ntawm lub qhov rais yog tias koj' re tsis meej uas download txuas mus de ntawm Microsoft lub website. Microsoft muaj ib qho kev li cas-rau kev txhim kho PowerPivot yog tias koj muaj teeb meem.
Ceeb toom: PowerPivot cov ntaub ntawv yuav tsuas tau rua hauv workbooks uas siv cov XLSX , XLSM , los yog XLSB cov ntaub ntawv txuas ntxiv.
01 ntawm 05
Ua Hauj Lwm Nrog Cov Ntaub Ntawv Loj Heev
Hauv Microsoft Excel, yog tias koj tsiv mus rau sab hauv qab ntawm daim ntawv ua haujlwm, koj yuav pom tau tias qhov siab tshaj plaws ntawm cov kab no yog 1,048,576. Qhov no sawv cev ib ncig ntawm ib lab kab lus ntawm cov ntaub ntawv.
Nrog PowerPivot rau Excel, tsis muaj kev txwv ntawm cov lej ntawm cov ntaub ntawv. Thaum qhov no yog ib nqe lus tseeb, qhov kev txwv yog raws li version Microsoft Excel koj khiav thiab seb koj yuav luam tawm koj daim ntawv khom nqi rau SharePoint 2010.
Yog hais tias koj nyob nraum khiav 64-ntsis version of Excel, PowerPivot tau tshaj tawm txog 2 GB ntawm cov ntaub ntawv, tab sis koj kuj yuav tsum muaj txaus RAM ua qhov hauj lwm ntseeg nkaws. Yog tias koj npaj yuav luam tawm koj PowerPivot raws li Excel spreadsheet rau SharePoint 2010, daim ntawv loj me me kuj yog 2 GB.
Cov kab hauv qab no yog qhov PowerPivot for Excel thiaj lis haujlwm tau ntau lab ntawm cov ntaub ntawv. Yog tias koj ntaus lub siab tshaj plaws, koj yuav tau txais kev nco yuam kev.
Yog tias koj xav mus ua si nrog PowerPivot rau Excel siv tsheej lab ntawm cov ntaub ntawv, download tau PowerPivot rau Excel Phau Ntawv Qhia Cov Ntaub Ntawv (txog 2.3 lab cov ntaub ntawv) uas muaj cov ntaub ntawv koj xav tau ntawm PowerPivot Workbook nyeem.
02 ntawm 05
Muab Cov Ntaub Ntawv Sib Txawv Los Sib Txawv
Qhov no tau ua ib qho tseem ceeb tshaj plaws hauv PowerPivot for Excel. Excel yeej ib txwm muaj peev xwm tswj xyuas cov ntaub ntawv sib txawv xws li SQL neeg rau zaub mov , XML, Microsoft Access thiab txawm tias cov web based cov ntaub ntawv. Qhov teeb meem los thaum koj xav tsim kev sib raug zoo ntawm cov ntaub ntawv sib txawv.
Muaj 3 tog cov khoom siv los pab nrog qhov no, thiab koj tuaj yeem siv Excel functions xws li VLOOKUP los "koom nrog" cov ntaub ntawv, cov hau kev no yog cov tsis zoo rau cov ntaub ntawv loj. PowerPivot rau Excel yog ua kom tiav txoj hauj lwm no.
Tsis pub dhau PowerPivot, koj tuaj yeem nqus cov ntaub ntawv los ntawm cov ntaub ntawv tau zoo. Kuv tau pom tias ib qho ntawm cov ntaub ntawv tseem ceeb tshaj plaws yog ib qho SharePoint Sau. Kuv tau siv PowerPivot rau Excel los ua ke cov ntaub ntawv los ntawm SQL neeg rau zaub mov thiab ib daim ntawv teev los ntawm SharePoint.
Lus Cim: Koj yuav tsum SharePoint 2010 ua qhov hauj lwm, nrog rau ADO.Net runtime nruab rau hauv SharePoint ib puag ncig.
Thaum koj txuas PowerPivot mus rau ib daim ntawv teev npe SharePoint, koj tabtom raug txuas mus rau Txoj Kev Pabcuam. Txhawm rau tsim Kev Tshaj Tawm los ntawm ib daim ntawv teev npe ntawm SharePoint, qhib lub npe thiab nyem rau ntawm Daim Ntawv Ribbon. Ces nias rau Export ua cov ntaub ntawv pub thiab txuag nws.
Tus pub yog muaj raws li URL hauv PowerPivot for Excel. Kos rau ntawm daim ntawv dawb Siv SharePoint Sau Cov Ntaub Ntawv hauv PowerPivot (nws yog MS Word DOCX cov ntaub ntawv) kom paub ntxiv txog kev siv SharePoint raws li cov ntaub ntawv siv PowerPivot.
03 ntawm 05
Tsim kom muaj kev soj ntsuam txog kev pom tseeb
PowerPivot rau Excel cia koj tso ntau hom kev qhia rau koj cov ntawv ua haujlwm Excel. Koj tuaj yeem rov qab tau cov ntaub ntawv hauv PivotTable, PivotChart, Daim Ntawv Qhia thiab Cov Ntaub Ntawv (kab rov tav thiab ntsug), Ob Kab (kab rov tav thiab ntsug), Plaub Kab Cim, thiab Tus PivotTable Flattened.
Lub hwj chim los thaum koj tsim cov ntawv ua haujlwm uas muaj ntau yam tawm. Qhov no muab ib qho kev saib dashboard ntawm cov ntaub ntawv uas ua rau kev tsom xam yooj yim tiag tiag. Txawm tias koj cov tswj yuav tsum muaj peev xwm cuam tshuam nrog koj daim ntawv khom nqi yog tias koj tsim nws kom raug.
Slicers, uas xa nrog Excel 2010, ua kom yooj yim rau cov ntaub ntawv visually.
04 ntawm 05
Siv DAX los Tsim Tsim Cov Kab Zauv rau Cov Ntawv Qhia Kev Tawm thiab Kev Dicing
DAX (Kev Txheeb Xyuas Cov Ntawv Qhia) yog cov lus hais hauv formula PowerPivot, feem ntau hauv kev tsim txhua kab ntawv. Kos rau TechNet DAX Daim Ntawv Qhia rau kev siv tiav.
Kuv feem ntau siv DAX hnub tso cai ua kom muaj hnub nyoog dua. Hauv Pivot Cov Ncauj Lus hauv Excel uas tau muaj cov qauv hnub uas muaj hnub nyoog zoo, koj tuaj yeem siv cov pawg ua ke nrog kev muaj peev xwm los lim lossis pab pawg ua ntej, lub hlis, lub hli thiab nruab hnub.
Nyob rau hauv PowerPivot, koj yuav tsum tsim cov no raws li tau txheeb kom tiav tib qho khoom. Ntxiv ib kem rau txhua txoj kev uas koj xav tau lim lossis pawg cov ntaub ntawv hauv koj lub rooj Pivot. Muaj ntau lub hnub ua haujlwm nyob hauv DAX yog tib yam li Excel qauv, uas ua rau qhov no yog ib qho SNAP.
Piv txwv, siv YEAR ([ hnub sab ]) hauv ib kem tshiab ntxiv rau xyoo ntxiv rau koj cov ntaub ntawv teev hauv PowerPivot. Tom qab koj tuaj yeem siv daim teb XYOO tshiab no los ua ib qho slicer lossis ib pawg hauv koj lub rooj Pivot.
05 ntawm 05
Luam tawm Dashboards rau SharePoint 2010
Yog tias koj lub tuam txhab zoo li mine, dashboard tseem yog qhov haujlwm ntawm koj pawg IT. PowerPivot, thaum ua ke nrog SharePoint 2010, txo nws hwj lub zog ntawm cov dashboards rau hauv koj txhais tes ntawm koj cov neeg siv.
Yog ib qho ntawm lub luam tawm PowerPivot cov kab kos thiab cov qauv rau SharePoint 2010 yog qhov kev siv PowerPivot rau SharePoint nyob rau koj qhov SharePoint 2010 ua liaj ua teb.
Xyuas PowerPivot rau SharePoint hauv MSDN. Koj pab neeg I yuav tau ua qhov no.