Kodi mwasankha chiyani?
Nthawi zambiri, kugwiritsa ntchito makina okwera mtengo komanso ovuta a BI amatha kusinthidwa ndi zida zosavuta komanso zotsika mtengo, koma zowunikira. Mukawerenga nkhaniyi, mudzatha kuwunika zomwe mukufuna kusanthula bizinesi yanu ndikumvetsetsa kuti ndi njira iti yomwe ili yabwino kwambiri pabizinesi yanu.
Zachidziwikire, makina onse a BI ali ndi zomanga zovuta kwambiri ndipo kukhazikitsidwa kwawo mukampani si ntchito yophweka, yomwe imafunikira ndalama zambiri kuti ithetse yankho komanso ophatikiza oyenereradi. Muyenera kubwereza mobwerezabwereza ntchito zawo, chifukwa zonse sizidzatha ndi kukhazikitsa ndi kutumiza - m'tsogolomu zidzakhala zofunikira kukonzanso magwiridwe antchito, kupanga malipoti atsopano ndi zizindikiro. Ziyenera kuganiziridwa kuti ngati dongosololi likuyenda bwino, mudzafuna antchito ambiri kuti azigwira ntchito, ndipo izi zikutanthauza kugula zilolezo zowonjezera zowonjezera.
Chinthu chinanso chofunikira pamakina apamwamba anzeru zamabizinesi ndi ntchito zazikulu kwambiri, zambiri zomwe simudzazigwiritsa ntchito, koma zipitiliza kuzilipira nthawi iliyonse mukakonzanso ziphaso zanu.
Zomwe zili pamwambazi za machitidwe a BI zimakupangitsani kuganiza zosankha njira ina. Kenako, ndikulingalira kufanizitsa yankho ku gulu lokhazikika la ntchito pokonzekera malipoti pogwiritsa ntchito Power BI ndi Excel.
Power BI kapena Excel?
Monga lamulo, kuti apange lipoti la malonda a kotala, wofufuza amatsitsa deta kuchokera ku machitidwe owerengera ndalama, akufanizira ndi zolemba zake ndikuzisonkhanitsa pogwiritsa ntchito ntchito ya VLOOKUP mu tebulo limodzi, pamaziko omwe lipotilo likumangidwa.
Kodi vutoli limathetsedwa bwanji pogwiritsa ntchito Power BI?
Deta yochokera kumagwero imalowetsedwa mudongosolo ndikukonzedwa kuti iwunikidwe: imagawidwa m'matebulo, yotsukidwa ndikufananizidwa. Pambuyo pa izi, chitsanzo cha bizinesi chimapangidwa: matebulo amalumikizidwa wina ndi mzake, zizindikiro zimatanthauzidwa, ndipo machitidwe ovomerezeka amapangidwa. Gawo lotsatira ndikuwonera. Apa, pongokoka ndikugwetsa zowongolera ndi ma widget, dashboard yolumikizana imapangidwa. Zinthu zonse zimalumikizidwa kudzera mumtundu wa data. Mukasanthula, izi zimakuthandizani kuti muyang'ane pazambiri zofunika, kuzisefa m'mawonedwe onse ndikudina kumodzi pa chinthu chilichonse cha dashboard.
Ndi maubwino ati ogwiritsira ntchito Power BI poyerekeza ndi njira yachikhalidwe yomwe tingawone mu chitsanzo pamwambapa?
1 - Kudzipangira nokha njira yopezera deta ndikuikonzekera kuti iwunikenso.
2 - Kumanga chitsanzo cha bizinesi.
3 - Zowoneka bwino.
4 - Olekanitsidwa kupeza malipoti.
Tsopano tiyeni tione mfundo iliyonse payokha.
1 - Kukonzekera deta yopangira lipoti, muyenera kufotokozera ndondomeko yomwe imagwirizanitsa ndi deta ndikuyikonza, ndipo nthawi iliyonse yomwe mukufuna kupeza lipoti la nthawi yosiyana, Power BI idzadutsa deta kudzera mu ndondomeko yomwe idapangidwa. . Izi zimagwiritsa ntchito ntchito zambiri zomwe zimakhudzidwa pokonzekera deta kuti iwunike. Koma chowonadi ndichakuti Power BI imachita njira yokonzekera deta pogwiritsa ntchito chida chomwe chimapezeka mu mtundu wakale wa Excel, ndipo chimatchedwa. . Zimakuthandizani kuti mumalize ntchito mu Excel chimodzimodzi.
2 - Zomwe zililinso pano. Chida cha Power BI chomangira mtundu wamabizinesi chimapezekanso ku Excel - izi .
3 - Monga momwe mumaganizira kale, ndikuwona momwe zinthu zilili ndizofanana: Kukulitsa kwa Excel - amalimbana ndi ntchitoyi mwachangu.
4 - Zimatsalira kupeza mwayi wopeza malipoti. Zinthu sizili bwino kuno. Chowonadi ndi chakuti Power BI ndi ntchito yamtambo yomwe imapezeka kudzera mu akaunti yanu. Woyang'anira ntchito amagawa ogwiritsa ntchito m'magulu ndikuyika magawo osiyanasiyana ofikira malipoti amaguluwa. Izi zimakwaniritsa kusiyanitsa kwa ufulu wopezeka pakati pa ogwira ntchito pakampani. Chifukwa chake, akatswiri, oyang'anira ndi owongolera, akafika patsamba lomwelo, awona lipotilo kuti liwonekere kwa iwo. Kufikira kutha kungokhala pagulu linalake la data, kapena lipoti lonse. Komabe, ngati lipotilo liri mu fayilo ya Excel, ndiye kuti kupyolera mu kuyesetsa kwa woyang'anira dongosolo mukhoza kuyesa kuthetsa vutoli ndi kupeza, koma izi sizidzakhala zofanana. Ndibwerera ku ntchito iyi ndikafotokoza mawonekedwe a portal yamakampani.
Ndikoyenera kudziwa kuti, monga lamulo, kufunikira kwa kampani kwa dashboards yovuta komanso yokongola sikuli kwakukulu ndipo nthawi zambiri, kusanthula deta mu Excel, mutamanga chitsanzo cha bizinesi, sagwiritsa ntchito mphamvu za Power View, koma gwiritsani ntchito pivot. matebulo. Amapereka magwiridwe antchito a OLAP omwe ndi okwanira kuthana ndi zovuta zambiri zamabizinesi.
Chifukwa chake, kusankha kusanthula bizinesi ku Excel kumatha kukwaniritsa zosowa zamakampani omwe ali ndi antchito ochepa omwe amafunikira malipoti. Komabe, ngati zosowa za kampani yanu zili zolakalaka kwambiri, musathamangire kugwiritsa ntchito zida zomwe zingathetsere zonse nthawi imodzi.
Ndikukufotokozerani njira yaukadaulo, yomwe mungagwiritse ntchito kuti mulandire yanu, yoyendetsedwa bwino, makina opangira makina opangira malipoti owunikira bizinesi osawapeza pang'ono.
ETL ndi DWH
M'njira zomwe takambirana kale zomangira malipoti abizinesi, kutsitsa ndikukonzekera deta yowunikira kunachitika pogwiritsa ntchito ukadaulo wa Power Query. Njirayi imakhalabe yolondola komanso yothandiza malinga ngati palibe magwero ambiri a data: njira imodzi yowerengera ndalama ndi mabuku ofotokozera kuchokera kumatebulo a Excel. Komabe, ndi kuchuluka kwa machitidwe owerengera ndalama, kuthetsa vutoli pogwiritsa ntchito Power Query kumakhala kovuta kwambiri komanso kovuta kusunga ndikukula. Zikatero, zida za ETL zimabwera kudzapulumutsa.
Ndi chithandizo chawo, deta imatsitsidwa kuchokera ku magwero (Kutulutsa), kusinthidwa (Sinthani), zomwe zikutanthawuza kuyeretsa ndi kufananitsa, ndikulowetsedwa mu malo osungiramo deta (Katundu). Malo osungiramo deta (DWH - Data Warehouse) ndi, monga lamulo, malo osungiramo maubale omwe ali pa seva. Tsambali lili ndi deta yoyenera kusanthula. Dongosolo la ETL limakhazikitsidwa molingana ndi ndandanda, yomwe imasinthiratu zosungiramo zinthu zatsopano. Mwa njira, khitchini yonseyi imatumikiridwa bwino ndi Integration Services, yomwe ndi gawo la MS SQL Server.
Kupitilira apo, monga kale, mutha kugwiritsa ntchito Excel, Power BI, kapena zida zina zowunikira monga Tableau kapena Qlik Sense kuti mupange mtundu wamabizinesi wa data ndi zowonera. Koma choyamba, ndikufuna ndikuwonetseni mwayi winanso womwe mwina simungaudziwe, ngakhale kuti wakhalapo kwa nthawi yayitali. Tikukamba za kumanga mabizinesi pogwiritsa ntchito MS SQL Server analytical services, yomwe ndi Analysis Services.
Mitundu ya data mu MS Analysis Services
Gawo ili la nkhaniyi likhala losangalatsa kwambiri kwa iwo omwe amagwiritsa ntchito kale MS SQL Server pakampani yawo.
Analysis Services panopa amapereka mitundu iwiri ya zitsanzo deta: multidimensional ndi tabular zitsanzo. Kuphatikiza pa mfundo yoti zomwe zili mumitundu iyi zimalumikizidwa, mayendedwe azizindikiro amasonkhanitsidwa ndikusungidwa m'maselo a OLAP, omwe amafikiridwa ndi mafunso a MDX kapena DAX. Chifukwa cha kamangidwe kameneka kakusungirako deta, funso lomwe limafikira ma rekodi mamiliyoni ambiri limabwezedwa mumasekondi. Njira iyi yopezera deta ndiyofunikira kwa makampani omwe matebulo awo ogwiritsira ntchito ali ndi zolemba zoposa milioni (malire apamwamba sali ochepa).
Excel, Power BI ndi zida zina zambiri "zodziwika" zimatha kulumikizana ndi mitundu yotere ndikuwonera deta kuchokera kumapangidwe awo.
Ngati mwatenga njira "yotsogola": mwasintha njira ya ETL ndikumanga mabizinesi pogwiritsa ntchito ntchito za MS SQL Server, ndiye kuti mukuyenera kukhala ndi tsamba lanu lakampani.
Corporate portal
Kupyolera mu izi, olamulira adzayang'anira ndi kuyang'anira ndondomeko ya malipoti. Kukhalapo kwa portal kupangitsa kuti zitheke kugwirizanitsa maupangiri amakampani: zambiri zamakasitomala, malonda, mamanejala, ogulitsa azipezeka kuti afananize, kusintha ndikutsitsa m'malo amodzi kwa aliyense amene amagwiritsa ntchito. Pa portal, mutha kugwiritsa ntchito ntchito zosiyanasiyana zosinthira ma data muma accounting system, mwachitsanzo, kuyang'anira kubwereza kwa data. Ndipo chofunika kwambiri, mothandizidwa ndi portal, vuto lakukonzekera mwayi wosiyana wa malipoti limathetsedwa bwino - ogwira ntchito adzawona malipoti okhawo omwe adakonzedwa payekha kwa madipatimenti awo mu mawonekedwe omwe amawafunira.
Komabe, sizikudziwikabe momwe kuwonetsera kwa malipoti patsamba la portal kudzakonzedwa. Kuti muyankhe funsoli, choyamba muyenera kusankha pa teknoloji yomwe portal idzamangidwe. Ndikupangira kugwiritsa ntchito imodzi mwazinthuzo monga maziko: ASP.NET MVC/Web Forms/Core, kapena Microsoft SharePoint. Ngati kampani yanu ili ndi NET developer imodzi, ndiye kusankha sikudzakhala kovuta. Tsopano mutha kusankha kasitomala wa OLAP yemwe angalumikizane ndi Analysis Services multidimensional kapena tabular.
Kusankha kasitomala wa OLAP kuti muwoneke
Tiyeni tifanizire zida zingapo kutengera kuchuluka kwa zovuta zoyika, magwiridwe antchito ndi mtengo: Mphamvu BI, Telerik UI ya zigawo za ASP.NET MVC ndi RadarCube ASP.NET MVC zigawo.
Mphamvu BI
Kuti mukonzekere mwayi wa ogwira nawo ntchito ku Power BI malipoti patsamba lanu la portal, muyenera kugwiritsa ntchito ntchitoyi .
Ndiroleni ndikuuzeni nthawi yomweyo kuti mudzafunika laisensi ya Power BI Premium ndi mphamvu zina zodzipatulira. Kukhala ndi mphamvu zodzipatulira kumakupatsani mwayi wofalitsa ma dashboard ndi malipoti kwa ogwiritsa ntchito m'bungwe lanu popanda kuwagulira zilolezo.
Choyamba, lipoti lopangidwa mu Power BI Desktop limasindikizidwa pa Power BI portal ndiyeno, mothandizidwa ndi masinthidwe osavuta, limayikidwa patsamba la pulogalamu yapaintaneti.
Katswiri atha kuthana ndi njira yopangira lipoti losavuta ndikulisindikiza, koma zovuta zazikulu zitha kubuka pakuyika. Zimakhalanso zovuta kwambiri kumvetsetsa njira yogwiritsira ntchito chida ichi: chiwerengero chachikulu cha makonzedwe a utumiki wamtambo, zolembetsa zambiri, malayisensi, ndi mphamvu zimawonjezera kwambiri kufunikira kwa mlingo wa maphunziro a akatswiri. Chifukwa chake ndikwabwino kuyika ntchitoyi kwa katswiri wa IT.
Telerik ndi RadarCube zigawo
Kuti muphatikize zigawo za Telerik ndi RadarCube, ndizokwanira kukhala ndi gawo loyambira laukadaulo wamapulogalamu. Chifukwa chake, luso laukadaulo la wopanga mapulogalamu kuchokera ku dipatimenti ya IT likhala lokwanira. Zomwe muyenera kuchita ndikuyika gawolo patsamba lawebusayiti ndikulisintha kuti ligwirizane ndi zosowa zanu.
Chothandizira kuchokera ku Telerik UI ya ASP.NET MVC suite imayikidwa patsamba mokoma mtima ndi Razor ndipo imapereka ntchito zofunika kwambiri za OLAP. Komabe, ngati mukufuna makonda osinthika mawonekedwe ndi magwiridwe antchito apamwamba, ndiye kuti ndibwino kugwiritsa ntchito zigawo . Zosintha zambiri, magwiridwe antchito olemera omwe amatha kutanthauziranso ndikukulitsa, zimakupatsani mwayi wopanga lipoti la OLAP lazovuta zilizonse.
Pansipa pali tebulo lofananiza mawonekedwe a zida zomwe zikuganiziridwa pamlingo wa Low-Medium-High.
Mphamvu BI
Telerik UI ya ASP.NET MVC
RadarCube ASP.NET MVC
Kuwonetseratu
Pamwamba
Low
Zamkatimu
Gulu la ntchito za OLAP
Pamwamba
Low
Pamwamba
Kusinthasintha kwa makonda
Pamwamba
Pamwamba
Pamwamba
Kuthekera kwa ntchito zowonjezera
-
-
+
Mapulogalamu mwamakonda
-
-
+
Mulingo wazovuta za kuyika ndi kasinthidwe
Pamwamba
Low
Zamkatimu
Mtengo wocheperako
Mphamvu BI umafunika EM3
190 rub / pamwezi
Single developer license
90 000 rubles.
Single developer license
25 000 rubles.
Tsopano mutha kupitilira kufotokozera zofunikira pakusankha chida chowunikira.
Zosankha za Power BI
- Mukuchita chidwi ndi malipoti omwe ali ndi ma metrics osiyanasiyana komanso zokhudzana ndi data.
- Mukufuna antchito omwe akugwira ntchito ndi malipoti kuti athe kupeza mayankho mosavuta komanso mwachangu kumavuto awo azamalonda m'njira yodziwika bwino.
- Kampaniyo ili ndi katswiri wa IT yemwe ali ndi luso lachitukuko cha BI.
- Bajeti ya kampaniyi imaphatikizapo ndalama zambiri zolipirira pamwezi pazantchito zamabizinesi amtambo.
Zoyenera kusankha zigawo za Telerik
- Tikufuna kasitomala wosavuta wa OLAP pakuwunika kwa Ad hock.
- Kampaniyo ili ndi oyambitsa NET.
- Bajeti yaying'ono yogulira laisensi kamodzi kokha ndikukonzansonso ndi kuchotsera kochepera 20%.
Zoyenera kusankha zigawo za RadarCube
- Mufunika multifunctional OLAP kasitomala ndi luso makonda mawonekedwe, komanso amene amathandiza embedding anu ntchito.
- Kampaniyo ili ndi okonza NET apakati pa antchito. Ngati sizili choncho, ndiye kuti omanga chigawocho adzapereka ntchito zawo mokoma mtima, koma pamtengo wowonjezera wosapitirira mlingo wa malipiro a pulogalamu yanthawi zonse.
- Bajeti yaying'ono yogulira laisensi kamodzi kokha ndikukonzansonso ndi kuchotsera kwa 60%.
Pomaliza
Kusankha chida choyenera pakuwunikira bizinesi kukulolani kuti musiye malipoti mu Excel. Kampani yanu idzatha kusuntha pang'onopang'ono komanso mopanda ululu kuti igwiritse ntchito matekinoloje apamwamba pagawo la BI ndikusinthiratu ntchito ya akatswiri m'madipatimenti onse.
Source: www.habr.com