Chii chaunosarudza?
Kazhinji, kushandiswa kweBI masisitimu anodhura uye akaomarara anogona kutsiviwa neakapusa uye asingadhure, asi anonyatso shanda ekuongorora maturusi. Mushure mekuverenga chinyorwa ichi, iwe unozogona kuongorora bhizinesi rako analytics zvinodiwa uye kunzwisisa kuti ndeipi sarudzo yakanakira bhizinesi rako.
Ehe, ese maBI masisitimu ane akanyanya kuomesesa ekuvaka uye kuita kwavo mukambani harisi basa riri nyore, rinoda mari yakawanda yekugadzirisa uye vanonyatso kwanisa vanobatanidza. Iwe uchafanirwa kudzokorodza kutendeukira kumasevhisi avo, sezvo zvese zvisingapere nekuita uye kutumirwa - mune ramangwana zvichave zvakakosha kunatsiridza mashandiro, kugadzira mishumo mitsva uye zviratidzo. Izvo zvinofanirwa kuverengerwa kuti kana iyo system ikabudirira, iwe uchada kuti vashandi vakawanda vashande mairi, uye izvi zvinoreva kutenga mamwe marezinesi evashandisi.
Chimwe chinhu chakakosha chepamberi bhizinesi rehungwaru masisitimu yakakura kwazvo seti yemabasa, mazhinji ayo ausingazomboshandisa, asi ucharamba uchivabhadhara pese paunovandudza marezinesi ako.
Iwo ari pamusoro maficha eBI masisitimu anoita kuti iwe ufunge nezve kusarudza imwe nzira. Tevere, ini ndinokurudzira kuenzanisa mhinduro kune yakajairwa seti yemabasa pakugadzirira mishumo uchishandisa Power BI uye Excel.
Simba BI kana Excel?
Sezvo mutemo, kuvaka mushumo wekutengesa kwekota, muongorori anodhawunirodha data kubva kune accounting system, anoienzanisa nemadhairekitori ake uye anoiunganidza achishandisa VLOOKUP basa mune imwe tafura, pahwaro iyo iyo ripoti inovakwa.
Dambudziko iri rinogadziriswa sei uchishandisa Power BI?
Dhata kubva kune masosi inoiswa muhurongwa uye inogadzirirwa kuongororwa: yakakamurwa kuita matafura, akacheneswa uye akaenzaniswa. Mushure meizvi, muenzaniso webhizimisi unovakwa: matafura akabatanidzwa kune mumwe nemumwe, zviratidzo zvinotsanangurwa, uye maitiro ehutsika anogadzirwa. Nhanho inotevera ndeyekuona. Pano, nekungodhonza uye kudonhedza zvidzoreso uye majeti, dhibhodhi inopindirana inoumbwa. Zvese zvinhu zvakabatana kuburikidza neiyo data data. Paunenge uchiongorora, izvi zvinokutendera kuti uise pfungwa paruzivo rwunodiwa, uchisefa mumaonero ese nekudzvanya kamwe chete pane chero chinhu chedhibhodhi.
Ndezvipi zvakanakira kushandisa Power BI zvichienzaniswa nemaitiro echinyakare zvinogona kuonekwa mumuenzaniso uri pamusoro?
1 - otomatiki maitiro ekutora data uye kuigadzirira iyo kuongororwa.
2 - Kuvaka bhizinesi modhi.
3 - Zvinoshamisa kuona.
4 - Yakaparadzaniswa kuwana mishumo.
Zvino ngatitarisei pfungwa imwe neimwe zvakasiyana.
1 - Kugadzirira dhata rekuvaka rondedzero, iwe unofanirwa kutsanangura maitiro kamwe chete anobatana nedata uye anoagadzirisa, uye pese paunoda kuwana rondedzero yenguva yakasiyana, Power BI ichapfuura iyo data kuburikidza neyakagadzirwa maitiro. . Izvi zvinogadzirisa zvizhinji zvebasa rinobatanidzwa mukugadzirira data yekuongorora. Asi chokwadi ndechekuti Power BI inoita iyo nzira yekugadzirira data uchishandisa chishandiso chinowanikwa mune yemhando yepamusoro vhezheni yeExcel, uye inonzi. . Iyo inokutendera kuti upedze basa muExcel nenzira imwecheteyo.
2 - Mamiriro acho akafanana pano. Iyo Power BI chishandiso chekuvaka bhizinesi modhi inowanikwawo muExcel - iyi .
3 - Sezvaungave watofungidzira, nekuona mamiriro ezvinhu akafanana: Excel kuwedzera - inobata basa iri nekurova.
4 - Inoramba ichitsvaga kuwana mishumo. Zvinhu hazvina kumira zvakanaka pano. Icho chokwadi ndechekuti Power BI ibasa regore rinowanikwa kuburikidza neakaundi yako pachako. Mutariri webasa anogovera vashandisi mumapoka uye anoseta mazinga akasiyana ekuwana mishumo yemapoka aya. Izvi zvinobudirira kusiyanisa kodzero dzekuwana pakati pevashandi vekambani. Nokudaro, vaongorori, vatungamiri uye vatungamiri, pavanowana peji imwe chete, ona mushumo mukuona kunowanikwa kwavari. Kuwana kunogona kuganhurirwa kune yakatarwa seti yedata, kana kumushumo wese. Nekudaro, kana iyo rondedzero iri muExcel faira, saka kuburikidza nekuedza kweiyo system maneja unogona kuedza kugadzirisa dambudziko nekuwana, asi izvi hazvizove zvakafanana. Ini ndichadzokera kune iri basa pandinotsanangura maitiro eiyo corporate portal.
Zvinokosha kucherechedza kuti, sekutonga, kudiwa kwekambani kune yakaoma uye yakanaka dashboards haisi yakakura uye kazhinji, kuongorora data muExcel, mushure mekuvaka bhizinesi modhi, havashandisi kugona kwePower View, asi shandisa pivot. matafura. Ivo vanopa OLAP mashandiro ayo akakwana kugadzirisa akawanda bhizinesi analytics matambudziko.
Nekudaro, iyo sarudzo yekuitisa bhizinesi ongororo muExcel inogona kunyatso kugutsa zvinodiwa neavhareji kambani ine vashoma vashandi vanoda mishumo. Nekudaro, kana zvinodiwa nekambani yako zvakanyanya kuda, usamhanye kutsvaga maturusi anogadzirisa zvese kamwechete.
Ini ndinounza kwauri imwe nzira yehunyanzvi, uchishandisa iyo iwe yauchagamuchira yako, yakanyatso tarisirwa, otomatiki sisitimu yekugadzira bhizinesi yekuongorora mishumo ine mashoma kuwana kwavari.
ETL uye DWH
Mune yakambokurukurwa nzira dzekuvaka mishumo yebhizinesi, kurodha nekugadzirira data rekuongorora kwakaitwa uchishandisa Power Query tekinoroji. Iyi nzira inoramba yakanyatsokodzera uye inoshanda chero pasina akawanda data masosi: imwe accounting system uye mabhuku ereferenzi kubva kumatafura eExcel. Nekudaro, nekuwedzera kwehuwandu hweakaunzi masisitimu, kugadzirisa dambudziko iri uchishandisa Power Query kunova kwakaoma uye kwakaoma kuchengetedza nekusimudzira. Mumamiriro ezvinhu akadaro, ETL zvishandiso zvinouya kuzonunura.
Nekubatsira kwavo, data inodururwa kubva kune zvinyorwa (Extract), inoshandurwa (Shandura), iyo inoreva kuchenesa nekuenzanisa, uye inotakurwa mudura re data (Mutoro). Imba yekuchengetera data (DWH - Data Warehouse) iri, sekutonga, dhatabhesi rehukama riri pane sevha. Iyi database ine data yakakodzera kuongororwa. Iyo ETL maitiro inotangwa zvinoenderana nehurongwa, iyo inogadziridza iyo yekuchengetedza data kune ichangoburwa. Nenzira, iyi kicheni yese inoshandirwa zvakakwana neIntegration Services, iyo iri chikamu cheMS SQL Server.
Kupfuurirazve, sepakutanga, unogona kushandisa Excel, Power BI, kana mamwe maturusi ekuongorora akadai seTableau kana Qlik Sense kuvaka bhizinesi modhi yedata uye kuona. Asi kutanga, ndinoda kukwevera pfungwa dzako kune imwezve mukana waungasaziva nezvawo, zvisinei nekuti wanga uripo kwauri kwenguva yakareba. Tiri kutaura nezve kuvaka mabhizinesi emhando tichishandisa MS SQL Server analytical services, kureva Analysis Services.
Mhando dze data muMS Analysis Services
Ichi chikamu chechinyorwa chichanyanya kunakidza kune avo vanotoshandisa MS SQL Server mukambani yavo.
Analysis Services parizvino inopa marudzi maviri emhando dzedata: multidimensional uye tabular modhi. Pamusoro pekuti iyo data iri mumamodhi iyi yakabatana, kukosha kweiyo modhi zviratidzo zvakafanounganidzwa uye zvakachengetwa muOLAP cube masero, anowanikwa neMDX kana DAX mibvunzo. Nekuda kwezvivakwa zvekuchengetedza data, mubvunzo unosvika mamirioni emarekodhi unodzoswa mumasekonzi. Iyi nzira yekuwana data inofanirwa kumakambani ane matafura ekutengeserana ane anopfuura miriyoni marekodhi (yepamusoro muganho hauna kuganhurirwa).
Excel, Power BI uye mamwe akawanda "ane mbiri" maturusi anogona kubatana kune akadai mamodheru uye kuona data kubva kune yavo zvimiro.
Kana iwe watora iyo "yepamberi" nzira: iwe wakagadzira iyo ETL maitiro uye wakavaka mabhizinesi emhando uchishandisa MS SQL Server masevhisi, saka iwe unofanirwa kuve neyako yekambani portal.
Corporate portal
Kuburikidza nazvo, vatariri vanozotarisa uye kutonga maitiro ekubika. Kuvapo kweiyo portal kuchaita kuti zvikwanise kubatanidza madhairekitori ekambani: ruzivo nezve vatengi, zvigadzirwa, mamaneja, vatengesi vachavepo kuti vaenzaniswe, kugadzirisa uye kurodha munzvimbo imwechete kune wese anoishandisa. Pane portal, unogona kuita akasiyana mabasa ekuchinja data muma accounting masisitimu, semuenzaniso, kutonga kudzokororwa kwedata. Uye zvinonyanya kukosha, nerubatsiro rweiyo portal, dambudziko rekuronga kwakasiyana-siyana kuwana mishumo rinogadziriswa zvinobudirira - vashandi vanozoona chete iyo mishumo iyo yakagadzirirwa ivo pachavo kumadhipatimendi avo nenzira yavakagadzirirwa ivo.
Nekudaro, hazvisati zvanyatsojeka kuti kuratidzwa kwemishumo pane peji reportal kucharongwa sei. Kuti upindure mubvunzo uyu, iwe unofanirwa kutanga wafunga nezve tekinoroji iyo iyo portal ichavakwa. Ini ndinokurudzira kushandisa imwe yemagadzirirwo sehwaro: ASP.NET MVC/Web Forms/Core, kana Microsoft SharePoint. Kana kambani yako iine imwe .NET developer, saka sarudzo haizove yakaoma. Iwe zvino unogona kusarudza mu-application OLAP mutengi anogona kubatana neAnalysis Services akawanda-emwe kana tabular modhi.
Kusarudza mutengi weOLAP wekuona
Ngatienzanise zvishandiso zvakati wandei zvichibva padanho rekuoma kwekumisikidza, kushanda uye mutengo: Power BI, Telerik UI yeASP.NET MVC zvikamu uye RadarCube ASP.NET MVC zvikamu.
Simba BI
Kuronga kupinda kwevashandi vekambani kune Power BI mishumo pane yako portal peji, unofanirwa kushandisa basa racho .
Rega ndikuudze ipapo kuti iwe uchada Power BI Premium rezinesi uye yakawedzera yakazvitsaurira kugona. Kuve neakazvitsaurira kugona kunobvumidza iwe kushambadza madhibhodhi uye mishumo kune vashandisi vari musangano rako pasina kuvatengera marezinesi.
Chekutanga, chirevo chakagadzirwa muPower BI Desktop chinoburitswa paPower BI portal uyezve, nerubatsiro rwekumwe gadziriso yakapusa, yakanyudzwa mune peji rewebhu rekushandisa.
Muongorori anogona nyore kubata maitiro ekugadzira rondedzero yakapfava nekuiburitsa, asi matambudziko akakomba anogona kumuka nekuisa. Izvo zvakare zvakanyanya kuoma kunzwisisa mashandisiro ekushanda kwechishandiso ichi: huwandu hukuru hwemasevhisi masevhisi egore, kunyoreswa kwakawanda, marezinesi, uye kugona kunowedzera zvakanyanya kudikanwa kweyero yekudzidziswa kwenyanzvi. Saka zviri nani kupa basa iri kune nyanzvi yeIT.
Telerik uye RadarCube zvikamu
Kubatanidza Telerik uye RadarCube zvikamu, zvakakwana kuti uve nedanho rekutanga resoftware tekinoroji. Naizvozvo, hunyanzvi hwehunyanzvi hwemumwe programmer kubva kubazi reIT huchave hwakakwana. Zvese zvaunoda kuti uite kuisa chikamu pane peji rewebhu uye wochigadzirisa kuti chienderane nezvido zvako.
Chinhu kubva kuTelerik UI yeASP.NET MVC suite yakadzikwa mukati mepeji nenzira ine nyasha Razor uye inopa inonyanya kudiwa OLAP mabasa. Nekudaro, kana iwe uchida mamwe anochinjika interface masisitimu uye mashandiro epamberi, saka zviri nani kushandisa zvikamu . Huwandu hukuru hwezvigadziriso, hupfumi hunoshanda nekugona kutsanangura zvakare uye kuwedzera, huchakubvumidza iwe kugadzira iyo OLAP mushumo wechero kuoma.
Pazasi pane tafura inofananidza hunhu hwezviridzwa zviri kutariswa paLow-Medium-High scale.
Simba BI
Telerik UI yeASP.NET MVC
RadarCube ASP.NET MVC
Kufungidzira
High
Low
Medium
Seti yeOLAP mabasa
High
Low
High
Flexibility of customization
High
High
High
Kugona kweanopfuura mabasa
-
-
+
Software customization
-
-
+
Chiyero chekuoma kwekusimbisa uye kugadzirisa
High
Low
Medium
Mari shoma
Simba BI Premium EM3
190 rub./mwedzi
Single developer rezinesi
90 000 rubles.
Single developer rezinesi
25 000 rubles.
Iye zvino unogona kuenderera mberi nekutsanangura maitiro ekusarudza chishandiso chekuongorora.
Simba BI yekusarudza maitiro
- Iwe unofarira mishumo yakapfuma mune akasiyana metrics uye data-inoenderana zvinhu.
- Iwe unoda kuti vashandi vanoshanda nemishumo vagone nyore uye nekukurumidza kuwana mhinduro kumatambudziko ebhizinesi ravo nenzira inonzwisisika.
- Iyo kambani ine IT nyanzvi ine BI budiriro hunyanzvi.
- Iyo bhajeti yekambani inosanganisira huwandu hukuru hwekubhadhara pamwedzi yegore bhizinesi analytics sevhisi.
Mamiriro ekusarudza Telerik zvikamu
- Isu tinoda yakapusa OLAP mutengi yeAd hock ongororo.
- Iyo kambani ine yekupinda-level .NET developer pavashandi.
- Bhajeti diki yekutenga rezinesi renguva imwe chete uyezve kuvandudzwa kwayo nekuderedzwa kwepasi pe20%.
Mamiriro ekusarudza RadarCube zvikamu
- Iwe unoda multifunctional OLAP mutengi ane kugona kugadzirisa iyo interface, pamwe neiyo inotsigira kunyudza yako mabasa.
- Iyo kambani ine yepakati-level .NET developer pavashandi. Kana zvisiri izvo, saka vanogadzira chikamu vanozopa masevhisi avo nemutsa, asi kune imwe mari yekuwedzera isingapfuure muhoro wemuhoro wemugadziri wenguva yakazara.
- Bhajeti diki rekutenga rezinesi renguva imwe uye nekuvandudzwa kwayo ne60% discount.
mhedziso
Kusarudza chishandiso chakakodzera chebhizinesi analytics chinokutendera kuti usiye zvachose kushuma muExcel. Kambani yako inozokwanisa kufamba zvishoma nezvishoma uye zvisingarwadze kuenda kukushandisa tekinoroji yepamusoro mumunda weBI uye otomatiki basa revanoongorora mumadhipatimendi ese.
Source: www.habr.com