Kasuwancin kasuwanci a Microsoft Excel
PowerPivot don Excel shi ne ƙara-kan don Microsoft Excel . Yana ba masu amfani amfani da basirar kasuwanci (BI) a cikin yanayin da ya saba.
PowerPivot shi ne saukewa kyauta daga Microsoft kuma ya ba masu amfani damar aiki tare da manyan bayanai. Kafin PowerPivot, irin wannan bincike ya iyakance ga kayan aiki na BI kamar SAS da Kasuwancin Kasuwanci.
PowerPivot yana amfani da na'urar ƙwaƙwalwar ajiyar da ake kira VertiPaq. Wannan injiniyar SSAS tana amfani da RAM ta karuwa a cikin yawancin kwakwalwa na yau.
Yawancin shaguna na Kasuwanci suna kalubalanci da albarkatun da ake buƙatar gina wata hanyar BI. PowerPivot yana motsa wasu ayyukan nan kusa da mai amfani da kasuwanci. Duk da yake akwai fasaloli masu yawa a cikin PowerPivot don Excel, mun zabi biyar da muke la'akari da su sun zama mafi sanyaya.
Tip: Za ka iya sauke PowerPivot a nan. Ganin ko kana amfani da 32-bit ko 64-bit version of Windows idan ba ka tabbatar da abin da download link to sama daga shafin yanar gizon Microsoft. Microsoft yana da yadda za a shigar da PowerPivot idan kuna da matsaloli.
Lura: Ana iya adana bayanan PowerPivot a cikin littattafai waɗanda suke amfani da kariyar fayilolin XLSX , XLSM , ko XLSB .
01 na 05
Aiki tare da Manyan Bayanin Kayayyaki
A cikin Microsoft Excel, idan kun matsa zuwa ƙasa sosai na takardun aiki, zaku ga cewa yawan adadin layuka shine 1,048,576. Wannan yana wakiltar kimanin layuka na bayanai.
Tare da PowerPivot don Excel, babu iyaka akan yawan layuka na bayanai. Duk da yake wannan sanarwa ne na ainihi, ainihin ƙayyade yana dogara ne akan fasalin Microsoft Excel kuna gudana kuma kuna shirin buga rubutun kuɗin zuwa SharePoint 2010.
Idan kuna aiki da fassarar 64-bit na Excel, PowerPivot zai iya ɗauka game da kimanin 2 GB na bayanai, amma dole ne ku sami ƙimar RAM don yin wannan aikin sannu-sannu. Idan kun shirya buga rubutattun Fayil na Excel na PowerPivot zuwa SharePoint 2010, girman girman fayil ɗin shine 2 GB.
Ƙasa ita ce PowerPivot don Excel na iya ɗaukar miliyoyin records. Idan ka buga matsakaicin, zaku sami kuskuren ƙwaƙwalwa.
Idan kana so ka yi wasa tare da PowerPivot don Excel ta amfani da miliyoyin rikodin, sauke PowerPivot don Takaddun Sample Sample (kimanin kimanin miliyan 2.3) wanda ke da bayanan da kake buƙatar Wutar Lantarki na PowerPivot.
02 na 05
Haɗa Bayanan Daga Bayanan Daban
Wannan ya zama ɗaya daga cikin muhimman fasali a PowerPivot don Excel. Excel ya taɓa yin amfani da su daban-daban bayanai irin su SQL Server , XML, Microsoft Access, har ma da bayanan yanar gizo. Matsalar ta zo lokacin da kake buƙatar ƙirƙirar dangantaka tsakanin asusun bayanai daban-daban.
Akwai samfurori na uku da aka samo don taimakawa tare da wannan, kuma zaka iya amfani da ayyukan Excel kamar VLOOKUP don "shiga" bayanan, waɗannan hanyoyin ba su da tasiri ga manyan bayanai. An gina PowerPivot don Excel don kammala wannan aiki.
A cikin PowerPivot, zaka iya shigo da bayanai daga kusan dukkanin bayanan bayanan. Na gano cewa ɗaya daga cikin samfurori masu amfani shine Shaidar SharePoint. Na yi amfani da PowerPivot don Excel don hada bayanai daga SQL Server da jerin daga SharePoint.
Lura: Kuna buƙatar SharePoint 2010 don yin wannan aikin, tare da lokacin ADO.Net a kan hanyar SharePoint.
Lokacin da ka hada PowerPivot zuwa jerin SharePoint, kana haɗuwa zuwa Data Feed. Don ƙirƙirar Data Feed daga jerin SharePoint, bude jerin kuma danna Rubin Rubis. Sa'an nan kuma danna kan Fitarwa a matsayin Ciyarwar Data kuma ajiye shi.
Ana samun abinci a matsayin URL a cikin PowerPivot don Excel. Bincika takarda mai launi ta amfani da Bayanan SharePoint List a PowerPivot (yana da kalmar MS Word DOCX) don ƙarin bayani game da amfani da SharePoint a matsayin tushen bayanai don PowerPivot.
03 na 05
Ƙirƙirar Abubuwan Daftarin Mahimman Bayanai
PowerPivot don Excel yana baka damar samar da bayanai masu yawa ga takardar aikinku ta Excel. Zaku iya mayar da bayanai a cikin PivotTable, PivotChart, Chart da Table (a kwance da kuma tsaye), Biyu Shafuka (a kwance da tsaye), Hudu Sharuɗa, da PivotTable Flattenable.
Ikon yana zuwa lokacin da ka ƙirƙiri wani aikin aiki wanda ya ƙunshi nau'i nau'i. Wannan yana ba da damar duba bayanai game da bayanan da ke sa bincike yayi sauki. Har ma shugabanninku zasu iya hulɗa tare da aikinku idan kun gina shi daidai.
Slicers, wanda aka shigo tare da Excel 2010, ya sa ya zama mai sauƙi don ganewa bayanai.
04 na 05
Yi amfani da DAX don Ƙirƙirar Ƙungiyoyi don Slicing da Dicing Data
DAX (Ma'anar Tattaunawa na Bayanan Bayanai) shine harshen dabarar da ake amfani dashi a cikin Tables na PowerPivot, da farko a samar da ginshiƙai lissafin. Bincika aikin TechNet DAX don cikakken bayani.
Ina yawan amfani da ayyukan DAX don yin saiti a yau. A cikin Pivot Table a Excel wanda ya haɗa da filin da aka tsara da kyau, zaka iya amfani da haɗin kai don haɗawa da ikon yin tace ko rukuni ta kowace shekara, kwata, wata da rana.
A cikin PowerPivot, kana buƙatar ƙirƙirar waɗannan a matsayin ginshiƙai lissafi don cika wannan abu. Ƙara wani shafi don kowace hanya kana buƙatar tace ko hada bayanai a cikin Pivot Table. Yawancin ayyuka na kwanan wata a cikin DAX sun kasance daidai da siffofin Excel, wanda ya sa wannan ƙira.
Alal misali, amfani = SHEKARA ([ kwanan wata ] a cikin sabon lissafin lissafin don ƙara shekara zuwa bayaninka da aka saita a PowerPivot. Hakanan zaka iya amfani da wannan sabuwar Sashen SHEAR a matsayin slicer ko rukuni a cikin Pivot Table.
05 na 05
Buga Dashboards zuwa SharePoint 2010
Idan kamfanin ku kamar mine, dashboard har yanzu aikin ku na kamfanin IT. PowerPivot, lokacin da aka haɗa tare da SharePoint 2010, yana sanya ikon dashboards a hannun masu amfani.
Ɗaya daga cikin abubuwan da ake bukata na wallafe-wallafe PowerPivot da aka tsara da Tables zuwa SharePoint 2010 shine aiwatar da PowerPivot don SharePoint a kan gonar SharePoint 2010.
Duba PowerPivot don SharePoint akan MSDN. Kungiyar IT naka za su yi wannan bangare.