Kusuka ku-Excel kuye eQlik Sense: Uhambo lwethu lwezibalo embonini yomshwalense

by Aug 19, 2020I-Qlik0 amazwana

Kule posi ekhethekile yebhulogi lezivakashi, UChirag Shukla, iCITO embonini yomshuwalense, Uzoba ngumhlahlandlela wethu kuzo zonke izenzakalo, okutholakele, nezimangaliso inkampani yakhe ehlangabezane nazo ohambweni lwabo lwezibalo.

Sizoqala nge-Excel bese sigcina lapho siya khona ekugcineni, iQlik Sense.

I-Risk Administration Services, Inc. (i-RAS) iyiManaging General Agent (MGA) yezinkampani ezimbili zomshuwalense eSouth Dakota ezinikeza i-Workers 'Compensation Insurance.

Kholwa noma ungakukholelwa, awusoze waba khona umzuzu ofiphele emshuwalense! Futhi, ama-analytics aphakathi kwakho konke, okubandakanya amanani, ukubikezela izimangalo, ukuphathwa kokulahleka futhi - okubaluleke kakhulu - ukunakekela abasebenzi abalimele lapho bedinga usizo kakhulu.

I-Excel ibiyipulatifomu evelele yezibalo kuze kube yilapho siphelelwa isikhathi sokuyisebenzisa kuma-analytics athuthukile, ngakho-ke saqala ukufuna kwethu ukuthola ithuluzi lezibalo elihamba phambili elizofeza umbono wethu wezibalo. Abaningi babheka i- ipulatifomu yezibalo zeselula ngale njongo, ikakhulukazi uma i-Excel ingalawuleki, ngakho-ke wusizo oluwusizo ukukhombisa.

Endleleni, sizohlola ukuthi salithuthukisa kanjani kakhulu ikhono lethu lokuhlinzeka amakhasimende nozakwethu ezindaweni ezilandelayo:

  • Ukuqaphela ubukhona bedatha
  • Ukufinyelela okukhulu kwedatha enengqondo kuzithameli ezibanzi
  • Kwembulwa izindaba ezingemuva kwedatha
  • Ukuqonda ukuthi kungani ngemuva kwezindaba ezitshelwa yidatha
  • Okuhlangenwe nakho kwamakhasimende okungajwayelekile
  • Kwenziwa izinqumo zamasu zesikhathi eside zenkampani

I-Excel, Indawo Yethu Yokuqalwa Kwezibalo

I-Excel ivame ukubizwa, ”ithuluzi lokuqala le-BI,” noma “isingeniso sobuhlakani bebhizinisi.” I-Excel, i-OpenOffice nezinye izinhlelo zespredishithi zitholakala yonke indawo. Ubuhle balawa mathuluzi atholakala kalula ezinhlelweni eziningi zezinkampani futhi ayashesha ukufunda. Kulula ukwenza ukubonwa, ukudala amandla okusika / wokumisa, futhi uxhumane nemithombo ehlukahlukene yedatha nge-Excel. Lokhu kuyenza ithuluzi elihle lokuhlaziya lamasethi wesethi amancane naphakathi nendawo.

Kwa-RAS, i-Excel bekuyindlela yethu yokuhlaziya iminyaka eminingana. Umthombo wethu wedatha bekuyindawo yokugcina idatha ku-SQL Server.

Njalo ekuseni, abasebenzi bethu bezokuphatha babevuselela ama-spreadsheet e-Excel, bese bewathumela nge-imeyili kubaphathi bethu ukuthi babuyekezwe. Lokhu bekulungile futhi kukhona okusebenzisekayo Amathuluzi wokuhlaziya okuhlangene ku-Excel sabona ukukhiqiza okufanele ngamazinga amancane wedatha. Kepha lapho amasethi amakhulu edatha edinga ukuhlaziywa, ukusebenza kwalawa maspredishithi kuyehla. Lokhu kudale ukuthi ukusatshalaliswa kwedatha kube nzima. Amaspredishithi kuthathe isikhathi eside ukuvula. Ukubukwa kuthathe isikhathi eside ukunikezela. Abasebenzisi abanehardware yezimpahla bakuthole kunzima kakhulu ukusebenzisa idatha.

Ngokwengeziwe, abasebenzi bethu bebengazi ngawo wonke amasethi wedatha asendaweni yokugcina imininingwane ye-RAS. Lokhu kuholele ekutheni abasebenzi bethu babuyekeze kuphela ingxenye lendaba. Ukuhlanganisa indaba ebumbene kusetshenziswa amasethi wedatha ahlukahlukene kwaba nzima. Kwakungekho bufakazi bokuthi okunamathiselwe kwesipredishithi kwavulwa. Kwakungekho bufakazi bezinqumo ezithathwa ngokususelwa kulawo maspredishithi, noma.

Okubalulekile ukuthi i-RAS ibisohambweni lokujabulisa amakhasimende ngensizakalo enhle kakhulu. Ukwenza kahle okunjalo kungafinyelelwa kuphela lapho igatsha eliphezulu kanye nabasebenzi abaphambili befinyelela kudathasethi efanayo, ukuqonda okucacile kokuthi idatha isho ukuthini, nokuqonda okujwayelekile kokuthi benzeni ngaleyo datha ukujabulisa amakhasimende.

I-RAS ibiplaza kanye ne-Excel. Bekuyisikhathi sokuthola ithuluzi leBusiness Intelligence (BI) elizosisiza ukuthi sisebenzele kakhulu amakhasimende ethu.

Kungani Sikhethe Umzila weQlik Sense

Kwa-RAS, senze ukutholakala ku-Tableau, Sisense, Qlik Sense kanye ne-TIBCO Spotfire ku-Q1 ka-2018. Inhloso bekuwukuthola ithuluzi elizovumela abasebenzisi ukuthi baqonde idatha ngokushesha. Ijubane lentuthuko nokunikezwa kokubona ngokushesha bekuseqhulwini kithi.

Ukuze i-RAS ibe yinhlangano eqhutshwa kakhulu yidatha futhi yenze idatha itholakale kuzithameli ezibanzi, ithuluzi le-BI elizosifikisa lapho bekufanele lihlangabezane nezidingo ezimbalwa:

  • Ubulula bokusatshalaliswa kwedatha
  • Amandla wamakhasimende ukufinyelela imininingwane yawo
  • Enembile kumakhasimende ukusebenzisa nokuqeqeshwa okuncane

Wonke amathuluzi we-BI esiwahlolile enzelwe ukusitshela ukuthi "Kwenzekani?" kepha bekubaluleke kakhulu kithina ukuthi sibe nethuluzi elenza kube lula ukufuna nokuphendula “Kungani kukhona okwenzekayo? ”. Futhi, iqembu le-IT likhethe ithuluzi elizovumela intuthuko ephindaphindayo nengesabi ngokulawulwa kwenguqulo.

Elinye lamathuluzi esiwahlaziyile alifanele izidingo ezijwayelekile ... udeveli usemininingwane. Sithole amathuluzi ngezimpawu ezihlukene ezingama-25. ISisense neQlik Sense bagqame kwezinye ngokuya ngezimfuneko zethu eziningiliziwe. Womabili la mathuluzi ayeshesha ekwakheni amadeshobhodi futhi ukuxhumana namadeshibhodi awo kwakushesha kakhulu futhi. I-Qlik Sense ekugcineni inqobe i-tiebreaker eseduze ngenxa yezizathu ezimbili:

  1. Ukunikezela okuhlanzekile kumaselula / amaphilisi.
  2. Imodeli yethu yokunikeza amalayisense engapheli.

Ukufinyelela Kwemininingwane Esheshayo Yombani

Esikhathini sanamuhla, ulwazi lungaba ukhiye empumelelweni yamabhizinisi. Ama-dashboard e-Qlik avumele i-RAS ukuthi ikhombise idatha ephathelene nezinqubomgomo, izimangalo, umlando wokulahleka, njll ngokuchofoza okumbalwa. Phambilini, bekudinga ukuvula amaspredishithi amaningana futhi kuhlanganiswa imininingwane. Kwakunjengokuzulazula ngemuvaroadama-spreadsheet nokushintshela ku-interstate ehlelekile lapho lonke ulwazi lwalukhona lapho futhi lufinyeleleka kalula.

Le datha elula ukufinyelela futhi ehlukahlukene kakhulu idale ukuqwashisa nenjabulo kubasebenzi. Ilukuluku laqala ukwakha. Kudingeka ukubukwa kolwazi ezinhlangothini ezahlukahlukene kukhuphukile. Abasebenzi babehlangana ezindleleni zokusiza amakhasimende ngokushesha kunanini ngaphambili!

I-Qlik ayizi nohlelo lokulawula inguqulo eyakhelwe ngaphakathi. I-RAS itshale imali Motioka- Soterre ukulawula inguqulo umkhiqizo owavumela i-IT ukwakha amadeshibhodi ngokungesabi.

Ngaphambi kweQlik, abasebenzi be-IT babejwayele ukusetha imihlangano yokutholwa, idatha ye-curate, bahlaziye ku-Excel bese besetha umhlangano wokulandelela lapho ukuhlelwa kwe-Excel kwakuvame ukuphakanyiswa khona. Manje, abasebenzi be-IT badonsela phezulu i-Qlik ngesikhathi semihlangano futhi bahlela amadeshibhodi ngokubona okukude kakhulu nokulindelwe yizethameli. Ekupheleni komhlangano, akwenzi ama-dashboard kuphela kodwa nedatha iyahlaziywa.

Imihlangano ethatha isonto lonke emuva nangaphandle nabasebenzisi bedatha manje ithatha imizuzu nje kuya emahoreni (okungenani) njengoba abasebenzi beqalile ukuqaphela imininingwane ehlukahlukene abanayo. Ngomkhiqizo osheshayo ovuthayo ongafaka imininingwane kumadeshibhodi anquma izinqumo, i-RAS manje isingaveza lawa madeshibhodi phambi kwamakhasimende futhi ibakhombise ukubonwa abangakuthathela izinyathelo ngokushesha. Ukusebenzisana phakathi kwe-RAS namakhasimende kuqale ukukhumbuleka, futhi nesidingo sokucwaninga kabusha imininingwane njalo saqala ukunyamalala.

Futhi enye inzuzo yavela kumakhono wokuhlunga asheshayo eQlik. Izinkinga zekhwalithi yedatha bekunzima ukuzilandelela. Nge-Qlik, amadolobha anesipelingi esingalungile - ngokwesibonelo - bekunzima ukugeja. Amadolobha anamakhodi we-zip angalungile abanjwe ngokushesha. Lokhu kuveze ukuqwashiswa okungcono mayelana nekhwalithi yedatha futhi sisheshe sakha inqubo nokwenza ukwenziwa kwekhwalithi yedatha.

I-Qlik Ikhuthaza Amasiko "Wedatha Yawo Wonke Umuntu" e-RAS

Ngenkathi i-Excel ifakwa ohlelweni lwabo bonke abasebenzisi, ukufinyelela kuma-analytics wedatha ku-Excel kwakutholakala kuphela kusethi encane yabasebenzisi. Njengoba idatha iqala ukuba nkulu, kanjalo namafayela we-Excel analytics. Abasebenzisi abaningi bebesebenzisa amatheminali amancanyana ngamandla anele wehashi ukusebenzisa izinhlelo ezingeni eliyisisekelo. Ama-analytics amakhulu we-Excel ngeke anikeze ngokushesha ngokwanele kwinani elithile lezinhlelo. Lo mkhawulo awuzange ubonwe kahle kuze kufakwe iQlik. I-Qlik Sense inikeze isipiliyoni sesiphequluli futhi wonke umsebenzisi enkampanini manje usenamandla okufinyelela idatha.

Indlela yokufinyelela idatha ibalulekile futhi. I-Excel analytics yasatshalaliswa nge-imeyili ngaphambi kweQlik Sense. Ngemuva kweQlik Sense, lezi zinyathelo zokuphatha ezingeziwe zokuvuselela amaspredishithi e-Excel noma idatha yokulayisha zisusiwe. I-Qlik Sense iqongelele idatha ngqo kusuka kumasistimu emithombo ngezikhathi ezithile usuku lonke nokubukwa okubuyekeziwe. Kwakulula kakhulu ukushintsha imikhuba. Sibone ukwanda kwabasebenzisi ngokuvakashela ngokuzithandela iQlik Sense. Futhi, ngamamethrikhi wokusebenzisa atholakala ku-Qlik Sense, sikwazile ukufundisa izethameli ezifanele ukuthi zivakashele ideshibhodi efanele ngezizathu ezifanele.

Ngenyanga yokuqala yokuthunyelwa kweQlik Sense, amaphethini ebhizinisini aqala ukuvela abekade efihlwe ngokuhlukile ku-Excel analytics. Ukucwaninga imininingwane kusheshe ngeQlik Sense, evumela abasebenzi ukuthi bahlole amamethrikhi webhizinisi ngokushesha. Umsebenzi wokubekisa ngaphakathi kweQlik Sense uphinde wavumela abasebenzisi ukuthi babelane ngokutholakele kwabo ngokushesha. Isiko elisha le-analytics yedatha lalakha ngaphakathi kwenkampani nangamakhasimende kule ndawo.

Ngedatha, Kuhlala Kunendaba Ongayitshela

Umshuwalense unesabelo saso esifanele sokuxaka kepha amakhasimende afana nokulula. Amakhasimende athanda ukuzwa indaba ngokusebenza kwe-akhawunti yawo. Amagama afana nokuthi “subrogation,” “reinsurance,” “reserve reserve,” njll angadida. I-Qlik Sense ivumele i-RAS ukuthi idale amadeshogi anama-KPI amakhulu nohlu lwendaba, kwesinye isikhathi i-punchline ngisho, ukusiza amakhasimende aqonde Kanjani sithuthukisa ukuphepha kwabasebenzi babo futhi sibasize belaphe ngemuva kokulimala.

I-Qlik Sense yenze kwaba lula ukuthi i-RAS ikhombise amakhasimende lapho abasebenzi bawo beshelela khona futhi bezilimaza. Ngokuchofoza nje inkinobho, amakhasimende angabona lapho ukuqeqeshwa kubalulekile ekunciphiseni ukulimala. Idizayini ebonakalayo ebonakalayo ivumele amakhasimende ukuthi afinyelele esiphethweni ngisho nangaphambi kokuba sichaze indaba. Amakhasimende aqala ukuhlanganisa izici ezahlukahlukene zempilo nenhlalakahle yabasebenzi. Ama-dashboard ahlukahlukene aholele ku-"Aha!" izikhathi lapho abasebenzi namakhasimende beqala ukubona ukuthi ukuncipha kokulimala kuhambisana nezinhlelo zokuqeqesha nezokuphepha ezenziwa ngokuhamba kwesikhathi. Izindaba ezinjalo bezihlala zikhona, kepha bezifihliwe kumaspredishithi amakhulu amaningi. Njengoba omunye wabasebenzi abeka, "UQlik Sense ukhuluma nathi ngendlela esiqonda ngayo." Lowo muzwa ukhule kubantu abaningi ngaphakathi kweRAS kanye nesisekelo samakhasimende ayo.

Kwembulwa kokuthi “Kungani” Emuva Kwedatha

Lapho nje usuyizwile indaba ekhulunywa yidatha, ilukuluku liyangena. Lokhu ngokwemvelo kwaholela abasebenzi ekufuneni i- "Kungani."

Isibonelo, izindleko zezimangalo ezibikwe ngoMsombuluko zeNkampani-A ziphakeme kuneNkampani-B. Kungani kunjalo? Ngenkathi i-Qlik Sense idlala indima encane ekuchazeni u- "Kungani," ngokuqinisekile iyenza lula inqubo yokutholwa. Abasebenzi bakwazile ukusika imininingwane yedayisi ukuthola ukuhlangana. UQlik ubavumele ukuthi babone ngokushesha ukuthi iNkampani-A ibingenawo amashifu okukhiqiza ngezimpelasonto kodwa iNkampani-B ibinoshintsho lwangempelasonto. Kungani lokho kubalulekile? Abanye abalimele kusukela ngoLwesihlanu abelaswanga futhi babikwa ngoMsombuluko ngeNkampani-A. Lapho isikhathi eside isisebenzi esilimele silinde ukwelashwa, ayanda amathuba okuba yinkimbinkimbi yokuthuthuka okuholela ezindlekweni eziphakeme zokwelapha ubunzima obunjalo. Ngakolunye uhlangothi, inkampani-B, yafuna ukwelashwa futhi yabika ukulimala ngempelasonto okuvumela abahlinzeki bokunakekelwa kwezempilo ukuthi bakwazi ukwelapha ngokushesha. Izindleko zizonke zeNkampani-B zaziphansi. Amalungu abasebenzi athola lokhu kuhlangana kungakapheli imizuzu esebenzisa amandla eQlik Sense.

Isipiliyoni SeKhasimende Sihamba Ngezindiza

Abasebenzi abalimele baphendukela kubahlinzeki bezokunakekelwa kwezempilo nezinkampani zomshuwalense ukuze baqale inqubo yabo yokwelashwa. Kwa-RAS, siyaziqhenya ngokusiza abasebenzi abalimele ukuba basukume. Ngenkathi abasebenzi abalimele belulama, abaqashi babheke kubathwali bomshuwalense ukuthi banikeze umhlahlandlela ukuze bakwazi ukwenza izindlela zokuphepha, bahlole ukusebenza kokuphepha emsebenzini, futhi benze ngcono lapho kunesidingo khona ukuqinisekisa ukuthi abasebenzi benza kahle kakhulu. I-RAS iyakwazi ukwenza konke lokhu kanye nokunikeza abaqashi ama-analytics asekelayo ngemuva kwesiqondiso sethu. Lokhu kunikeza ukwethenjwa okusha ebudlelwaneni bethu namakhasimende ethu okuyinto ebaluleke kakhulu embonini yomshuwalense.

I-Qlik ithuthukise kakhulu ukuthi siluletha kanjani ulwazi kumakhasimende. Ngaphambi kweQlik, amahora okulungiselela aqale ukudala imibiko yokuphatha, ukufaka izicelo zokubuyekezwa kwezimangalo, nokuhlela imihlangano yokudingida leyo mibiko. Njengoba i-Qlik isendaweni, amakhasimende angavuka kuze kube semininingo yosuku ezandleni zawo futhi athole i- Ini futhi Kungani kwezicelo zabo. Ubuningi bamakhasimende ethu buwela kule ndlela yokuzenzela. Amakhasimende adinga amaphoyinti wokuthinta ngekota azuza ngokulinganayo ku-Qlik ngoba ukubonwa kwedatha yekota-ngaphezu kwekota kudinga nje ukuchofoza inkinobho kunokuhlanganisa nokuqhathanisa idatha kusuka kumashidi we-Excel kusuka ezingxenyeni ezimbili. Amakhasimende angabona ngokusobala igxathu elibalulekile emandleni okuhlaziya idatha ahlinzekwa yiQlik futhi ayakwazisa ukuqonda okucacile kwezizathu ezithinta izimangalo.

Amandla eQlik Sense akhanya lapho i-RAS ithola ikhasimende elisha elinezinkolelo eziqinile mayelana nokulahleka kwezimangalo. I-Qlik Sense ibavumela ukuthi baqinisekise noma balungise imibono yabo ngaphandle kokuzikhandla. Isibonelo, amakhasimende afuna usizo lwe-RAS ekuxazululeni ukulimala emuva kungenzeka angaboni ukuthi imbangela yokulimala emuva ishibilika / ikhubeka ezindleleni ezingalingani zomgwaqo. Ukugxila ekuvuseleleni kabusha komgwaqo kungasebenza kakhulu ekugcineni abasebenzi bephilile kunokukhulisa inani lezindlela zokwelapha zecala ngalinye lokulimala emuva. Imininingwane enjalo ebaluleke kakhulu iyindawo ejwayelekile ngokuhlaziywa ngeQlik Sense.

Ukucabanga Kwamasu Kuthuthukisa

I-Excel ibibambe iqhaza enkambisweni yethu yokucabanga ngamasu. Amasu esikhathi eside nesikhathi esifushane athuthukiswa ngokususelwa kumasethi wedatha ahlukahlukene asatshalaliswa kumaspredishithi amaningi. Kodwa-ke, ukwakha amasu kudinga isikhathi esibalulekile sokulungiselela idatha.

Njengoba iQlik Sense isendaweni, ukucabanga kwamasu kwaba lula. Ukuhlaziywa kwedatha yomlando, izitayela, nokubikezela ngaphakathi kwedeshibhodi efanayo kuvumele i-RAS ukuthi iguqule izimo ukubikezela imiphumela engaba khona yezinqumo zamasu. UQlik uphinde wasiza abaphathi beRAS ukuthi bahlale emzileni wabo namasu asekela izinqumo zamasu.

Hhayi Indawo Yethu Yokugcina, kodwa Isiqalo Sobungane Obuhle

I-RAS yenze ukweqa okuphawulekayo nemingcele ekuhlaziyweni kwedatha eminyakeni embalwa edlule yohambo lwethu futhi iQlik ibingumenzeli wezinguquko. Sibone ukuguquka kwamasiko nemininingwane yenhlangano ngenxa yeQlik. Abasebenzi be-IT babone ukwehla kwezicelo zemibiko enamakhasi amaningi kanye nokwanda kwamadeshibhodi enza isenzo. Abasebenzi be-RAS basebenzela amakhasimende ngempumelelo enkulu futhi ngokushesha okukhulu kunangaphambili. Izinqumo zamasu ezinamandla zixhaswe yizimo "uma-ke" ngaphakathi kweQlik.

Manje sisukaphi lapha? Yebo, amathuba awapheli.

Ukucabanga phambili, i-RAS ihlela ukusebenzisa i-Qlik Sense ukuhlaziya imiphumela yezibikezelo ze-analytics / AI zamanani entengo nokusiza ekulinganisweni kwamamodeli ngezikhathi ezithile ukuhlangabezana nezidingo zemboni. Amakhasimende nabathengisi bawo bemishwalense bangathola impendulo yesikhathi sangempela entengweni.

I-Qlik Sense izophinda isetshenziselwe ukutadisha imithelela yesikhathi eside ye-COVID-19. Lokhu kungasizwa ngokusebenzisa i- Izicelo zeCoronavirus ezivela ezinkampanini ezinjengeVantiq, ezisekela amabhizinisi azama ukunciphisa nokunciphisa i-COVID-19.

Esinye isibonelo ukuthi amakhasimende azohlomula ngokuzilungiselela kangcono izimo zezulu ikakhulukazi ezindaweni lapho izindawo ezishubile ziholela ekwandeni kwezimangalo.

Zonke lezi zinhlobo zezibalo nokuningi zingalethwa phambili ngokusebenzisa iQlik Sense. Lesi yisikhathi esimnandi ngempela sokuba semhlabeni wezibalo! Futhi ngicabanga ukuthi isicaphuno esivela kuRalph Waldo Emerson sifingqa kahle ulwazi lwethu ngedatha neQlik, “Akuyona indawo okuyiwa kuyo, wuhambo.”

I-Gitoqlok I-Qlik
I-ChatGPT Ye-Qlik
Ukusebenzisa i-GPT-n Ukuze Uthuthukise Inqubo Ye-Qlik Ethuthukisiwe

Ukusebenzisa i-GPT-n Ukuze Uthuthukise Inqubo Ye-Qlik Ethuthukisiwe

Njengoba kungenzeka uyazi, ithimba lami kanye nami silethe emphakathini wakwa-Qlik isandiso sesiphequluli esihlanganisa i-Qlik ne-Git ukuze ulondoloze izinguqulo zedeshibhodi kalula, senze izithonjana zamadeshibhodi ngaphandle kokushintshela kwamanye amawindi. Ngokwenza kanjalo, silondoloza onjiniyela be-Qlik...

Funda kabanzi

I-Qlik
Ukuhlanganiswa Okuqhubekayo Kwe-Qlik Sense
CI For Qlik Sense

CI For Qlik Sense

I-Agile Workflow ye-Qlik Sense Motio ubelokhu ehola ukwamukelwa kwe-Continuous Integration yokuthuthukiswa okushesha kwe-Analytics kanye neBusiness Intelligence iminyaka engaphezu kwe-15. I-Continuous Integration[1]iyindlela ebolekwe embonini yokuthuthukisa isofthiwe...

Funda kabanzi