Iphutha elivamile losomabhizinisi abasafufusa ukuthi abanaki ngokwanele ukuqoqa nokuhlaziya idatha, ukuthuthukisa izinqubo zomsebenzi kanye nokuqapha izinkomba ezibalulekile. Lokhu kubangela ukwehla kokukhiqiza kanye nokumosha isikhathi nezinsiza ngendlela engafanele. Uma izinqubo zizimbi, kufanele ulungise amaphutha afanayo izikhathi eziningana. Njengoba isibalo samakhasimende sikhula, isevisi iyancipha, futhi ngaphandle kokuhlaziywa kwedatha akukho ukuqonda okucacile kwalokho okudingeka kuthuthukiswe. Ngenxa yalokho, izinqumo zithathwa ngokungalindelekile.
Ukuze libe nokuncintisana, ibhizinisi lesimanje, ngaphezu kwemikhiqizo namasevisi ekhwalithi, kufanele libe nezinqubo ezisobala futhi liqoqe idatha yokuhlaziya. Ngaphandle kwalokhu, kunzima ukuqonda isimo sangempela sezindaba ebhizinisini nokwenza izinqumo ezifanele. Ngakho-ke, kubalulekile ukuba ku-arsenal yakho amathuluzi adingekayo angagcini nje ngokufanele ukuwasebenzisa, kodwa futhi akuvumela ukuba wenze umsebenzi wakho ube lula futhi udale izinqubo ezisobala kakhulu ngangokunokwenzeka.
Namuhla kunenani elikhulu lamathuluzi nezixazululo. Kodwa osomabhizinisi abaningi abazisebenzisi ngenxa yokuthi ababoni ukubaluleka kwazo, noma abaqondi ukuthi zisetshenziswa kanjani, noma zibiza, noma ziyinkimbinkimbi, noma 100500 ngaphezulu. Kodwa labo abaye bakuthola, bathola noma bazenzele amathuluzi anjalo kakade banenzuzo esikhathini esimaphakathi.
Sekuyiminyaka engaphezu kwengu-10, bengidala imikhiqizo ye-IT nezisombululo ezisiza amabhizinisi akhulise inzuzo ngokuzenzakalela kanye nokuguqulwa kwedijithali kwezinqubo. Ngisize ekutholeni iziqalo eziningi futhi ngenza inqwaba yamathuluzi aku-inthanethi asetshenziswa amakhulu ezinkulungwane zabantu emhlabeni jikelele.
Nasi esinye sezibonelo ezinhle ekusebenzeni kwami ββββesibonisa izinzuzo zokuguqulwa kwedijithali. Enkampanini eyodwa encane yabameli baseMelika, mina nethimba lami sakha ithuluzi lokukhiqiza imibhalo yezomthetho, kwavumela abameli ukuthi bakhiqize amadokhumenti ngokushesha. Futhi kamuva, ngemva kokwandisa ukusebenza kwaleli thuluzi, sakha isevisi ye-intanethi futhi sashintsha ngokuphelele inkampani. Manje basebenzela amakhasimende hhayi edolobheni labo kuphela, kodwa ezweni lonke. Eminyakeni emithathu, imali yenkampani ikhule izikhathi eziningana.
Kulesi sihloko ngizokwabelana nawe ngolwazi lwangempela lokudala uhlelo olusobala lokuqapha izinkomba zebhizinisi ezibalulekile. Ngizozama ukugxilisa ukubaluleka kokusebenzisa izixazululo zedijithali, ngizobonisa ukuthi akunzima futhi akubizi njalo. Ngakho, asihambe!
Konke kwaqala kanjani
Uma ufuna ukuba nento ongakaze ube nayo, kuzomele wenze into ongakaze uyenze.
Coco Chanel
Umkami wayesekhathele ukuba sekhefini yokubeletha, futhi sanquma ukuvula ibhizinisi elincane - igumbi lokudlala lezingane. Njengoba nginebhizinisi lami, umkami unakekela igumbi legeyimu ngokuphelele, futhi ngisiza ngezinkinga zamasu kanye nentuthuko.
Imininingwane yokuvula ibhizinisi iyindaba ehluke ngokuphelele, kodwa esigabeni sokuqoqa idatha nokuhlaziya izimbangi, ngaphezu kokugqamisa izinkinga ezithile zaleli bhizinisi, sinake izinkinga zezinqubo zangaphakathi iningi labaqhudelana nazo elingazange libhekane nazo. .
Okwangimangazayo, ngekhulu lama-XNUMX cishe akekho owayegcina i-CRM nganoma iyiphi indlela; abaningi babegcina amarekhodi ebhaliwe, ezincwadini zokubhalela. Ngesikhathi esifanayo, abanikazi bakhala ngokuthi abasebenzi bayantshontsha, benza amaphutha lapho bebala futhi kufanele bachithe isikhathi esiningi bebala kabusha futhi behlola okubhalwe encwadini ye-accounting, idatha yokubhukelwa kanye ne-deposit iyalahleka, amakhasimende ahamba ngezizathu ezingaziwa. bona.
Ukuhlaziya idatha eqoqiwe, saqaphela ukuthi asifuni ukuphinda amaphutha abo futhi sidinga uhlelo olusobala oluzonciphisa lezi zingozi zibe ncane. Okokuqala, saqala ukufuna izixazululo esezakhiwe ngomumo, kodwa asikwazanga ukuzithola ezazanelisa ngokugcwele izidingo zethu. Futhi-ke nganquma ukwenza uhlelo lwami, nakuba lungalungile, kodwa lusebenza futhi lungabizi (cishe mahhala).
Lapho ngikhetha ithuluzi, ngacabangela le mibandela elandelayo: kufanele ibe engabizi, kufanele ibe nezimo futhi ifinyeleleke, futhi kufanele kube lula ukuyisebenzisa. Ngingabhala uhlelo oluphelele, olunamandla futhi olubizayo lwaleli bhizinisi, kodwa sasinesikhathi esincane nesabelomali esincane, futhi asizange siqonde ngokugcwele ukuthi iphrojekthi yethu izosebenza yini, futhi bekuyoba okungenangqondo ukuchitha izinsiza eziningi lolu hlelo. Ngakho-ke, ngesikhathi sokuhlola i-hypothesis, nganquma ukuqala nge-MVP (Minimum Viable Product - minimum viable product) futhi ngenze inguqulo esebenzayo ngesikhathi esifushane kakhulu ngokutshalwa kwezimali okuncane, futhi ngokuhamba kwesikhathi, ngiyiqede noma ngiyilungise kabusha.
Ngenxa yalokho, ukukhetha kwami ββkwawela ezinsizeni ze-Google (IDrayivu, AmaSpredishithi, Ikhalenda). Umthombo oyinhloko wokwaziswa okokufaka/okukhiphayo yi-Google AmaSpredishithi, njengoba umkami enolwazi lokusebenza ngamaspredishithi, angakwazi ukwenza izinguquko ngokwakhe uma kudingeka. Ngiphinde ngacabangela neqiniso lokuthi leli thuluzi lizosetshenziswa nayizisebenzi okungenzeka ukuthi azikho kahle kakhulu ekusebenziseni ikhompuyutha, futhi ukubafundisa ukufaka idatha etafuleni kuzoba lula kakhulu kunokubafundisa ukusebenza nabathile abakhethekile. uhlelo olufana no-1C.
Idatha efakwe ematafuleni ishintsha ngesikhathi sangempela, okungukuthi, nganoma yisiphi isikhathi lapho ungabona isimo sezindaba zenkampani, ukuphepha kwakhiwe, ungakwazi ukukhawulela ukufinyelela kubantu abathile.
Ukuthuthukiswa kwezakhiwo kanye nesakhiwo sedatha
Igumbi lokudlala lezingane lihlinzeka ngezinsizakalo ezimbalwa eziyisisekelo.
- Ukuvakasha okujwayelekile - lapho iklayenti lithenga isikhathi esichithwe egumbini lokudlala lezingane zalo.
- Ukuvakasha okugadiwe β lapho iklayenti lithenga isikhathi esisichithe egunjini lokudlala lezingane zalo futhi likhokha imali eyengeziwe ukuze ligadwe. Okungukuthi, iklayenti lingakwazi ukushiya ingane futhi liqhubeke nebhizinisi lakhe, futhi isisebenzi segumbi sizobuka futhi sidlale nengane ngesikhathi sokungabikho komzali.
- Vula usuku lokuzalwa β iklayenti liqasha itafula elihlukile lokudla nezivakashi zokuhlala futhi likhokhela ukuvakasha okuvamile kugumbi legeyimu, kuyilapho igumbi lisebenza njengokujwayelekile.
- Usuku lokuzalwa oluvaliwe - iklayenti liqashisa yonke indawo; ngesikhathi sokuqasha igumbi aliwamukeli amanye amakhasimende.
Kubalulekile ukuthi umnikazi azi ukuthi bangaki abantu abavakashele igumbi, babeneminyaka emingaki, singakanani isikhathi abasisebenzisile, yimalini abayitholayo, zingaki izindleko ebezikhona (imvamisa kwenzeka ukuthi umlawuli udinga ukuthenga okuthile noma ukukhokha. ngokuthile, isibonelo, ukulethwa noma amanzi), Zazingaki izinsuku zokuzalwa?
Njenganoma iyiphi iphrojekthi ye-IT, ngaqala ngokucabanga ngesakhiwo sesistimu yesikhathi esizayo kanye nokusebenza ngesakhiwo sedatha. Njengoba unkosikazi ephethe ibhizinisi, wazi konke okudingeka akubone, alawule futhi alawule, ngakho wenza njengekhasimende. Sisonke senze izingxoxo futhi sakha izimfuneko zesistimu, ngokusekelwe lapho ngacabanga ngokusebenza kwesistimu futhi ngaqala ukwakheka okulandelayo kwamafayela namafolda ku-Google Drayivu:
Umbhalo othi "Isifingqo" uqukethe ulwazi olujwayelekile ngenkampani: imali engenayo, izindleko, izibalo
Umbhalo Wezindleko uqukethe imininingwane yezindleko zenyanga zenkampani. Ukuze kube sobala kakhulu, kuhlukaniswe izigaba: izindleko zehhovisi, izintela, izindleko zabasebenzi, izindleko zokukhangisa, nezinye izindleko.
Izindleko zanyanga zonke
Ithebula elifingqiwe lezindleko zonyaka
Ifolda ye-Income inamafayela e-Google AmaSpredishithi angu-12, elilodwa ngenyanga ngayinye. Lawa yimibhalo esemqoka yokusebenza abasebenzi abayigcwalisa nsuku zonke. Ziqukethe ithebhu yedeshibhodi eyisibopho namathebhu osuku ngalunye lokusebenza. Ithebhu yedeshibhodi ibonisa lonke ulwazi oludingekayo lwenyanga yamanje ukuze uqonde izindaba ngokushesha, futhi ikuvumela ukuthi usethe amanani futhi wengeze amasevisi.
Ithebhu yedeshibhodi
Ithebhu yansuku zonke
Enqubweni yokuthuthukiswa kwebhizinisi, izidingo ezengeziwe zaqala ukuvela ngendlela yezaphulelo, ukubhalisa, izinsizakalo ezengeziwe, nemicimbi. Siphinde sasebenzisa konke lokhu ngokuhamba kwesikhathi, kodwa lesi sibonelo sibonisa inguqulo eyisisekelo yesistimu.
Ukudalwa kokusebenza
Ngemva kokuba ngithole izinkomba eziyinhloko, ngisebenze ukwakheka nokushintshana kwedatha phakathi kwezinhlangano, ngaqala ukuqaliswa. Into yokuqala engiyenzile kwakuwukudala idokhumenti ye-Google Sheet kufolda yami Yemali Engenayo. Ngidale amathebhu amabili kuyo: ideshibhodi kanye nosuku lokuqala lwenyanga, lapho ngengeze khona ithebula elilandelayo.
Ishidi lokusebenzela eliyinhloko
Leli yiphepha lokusebenza eliyinhloko uMphathi azosebenza ngalo. Udinga nje ukugcwalisa izinkambu ezidingekayo (zimakwe ngokubomvu), futhi uhlelo luzobala ngokuzenzakalelayo zonke izinkomba ezidingekayo.
Ukuze kuncishiswe amaphutha okokufaka nokwenza lula, inkambu ethi βUhlobo Lokuvakashaβ yasetshenziswa njengohlu lokuya phansi lwezinsizakalo ezinikeziwe, esingazihlela ekhasini ledeshibhodi. Ukwenza lokhu, sengeza ukuqinisekiswa kwedatha kulawa maseli futhi sibonise ububanzi okufanele sithathe kubo idatha.
Ukuze kuncishiswe iphutha lomuntu ekubaleni, ngengeze ukubala okuzenzakalelayo kwamahora iklayenti eliwachithe egumbini kanye nenani lemali okufanele liyikhokhe.
Ukwenza lokhu, Umlawuli kumelwe avele amake isikhathi sokufika seklayenti (ikholomu E) nesikhathi sokusuka (ikholomu F) ngefomethi ethi HH: MM. Ukuze ngibale isikhathi esiphelele iklayenti elisichitha egunjini legeyimu, ngisebenzisa le fomula:
=IF(ISBLANK($F8); ""; $F8-$E8)Ukuze sibale ngokuzenzakalelayo inani lemali yokusebenzisa amasevisi, bekufanele sisebenzise ifomula eyinkimbinkimbi, njengoba intengo yehora ingahluka kuye ngohlobo lwesevisi. Ngakho-ke, bekufanele ngibophe idatha kuthebula lezinsizakalo ekhasini ledeshibhodi ngisebenzisa umsebenzi we-QUERY:
=ROUNDDOWN(G4*24*IFERROR(QUERY(dashboard!$G$2:$H$5; "Select H where G = '"& $D4 & "'");0)Ngaphezu kwezenzo eziyinhloko, ngengeze imisebenzi eyengeziwe ukuze ngisuse amaphutha angafuneki e-IFERROR noma e-ISLANK, kanye nomsebenzi we-ROUNDDOWN - ukuze ngingakhathazeki ngezinto ezincane, ngifinyeze inani lokugcina phansi, ngibhekise kuklayenti.
Ngaphezu kwemali engenayo eyinhloko (isikhathi sokuqasha), ekamelweni lokudlala lezingane kukhona imali eyengeziwe eyengeziwe ngendlela yezinsizakalo noma ukuthengiswa kwamathoyizi, futhi abasebenzi benza izindleko ezincane, isibonelo, ukukhokhela amanzi okuphuza noma ukuthenga uswidi ukuze uthole izincomo, konke lokhu kumele futhi kubhekwe.
Ngakho-ke, ngengeze amanye amathebula amabili lapho sizoqopha khona le datha:
Ukwenza kube lula ukusebenza ngezimpawu, ngizifake umbala ngase ngengeza ukufometha okunemibandela kumaseli.
Amatafula amakhulu aselungile, manje udinga ukubeka izinkomba eziyinhloko etafuleni elihlukile ukuze ubone ngokucacile ukuthi uzuze malini ngosuku nokuthi ingakanani le mali kurejista yemali nokuthi yimalini ekhadini.
Ukuze ngihlanganise imali ngohlobo lwenkokhelo, ngiphinde ngasebenzisa umsebenzi we-QUERY:
=QUERY(I8:J;"SELECT sum(J) WHERE I='ΠΠ°Π»ΠΈΡΠΊΠ°'"Β» ΠΈ Β«=QUERY(I8:J;"SELECT sum(J) WHERE I='ΠΠ°ΡΡΠ°'")Ekupheleni kosuku lokusebenza, umlawuli udinga kuphela ukuhlola kabili imali engenayo futhi akudingekile ukubala kabusha mathupha. Asimphoqi umuntu ukuthi enze umsebenzi owengeziwe, futhi umnikazi angabheka futhi alawule isimo nganoma yisiphi isikhathi.
Wonke amathebula adingekayo aselungile, manje sizovele siphindaphinde ithebhu yosuku ngalunye, siyinombolo bese sithola okulandelayo.
Kuhle! Cishe yonke into isimi ngomumo, okusele wukukhombisa zonke izinkomba zenyanga kuthebhu yedeshibhodi.
Ukuze uthole isamba semali engenayo yenyanga, ungabhala ifomula elandelayo
='1'!D1+'2'!D1+'3'!D1+'4'!D1+'5'!D1+'6'!D1+'7'!D1+'8'!D1+'9'!D1+'10'!D1+'11'!D1+
'12'!D1+'13'!D1+'14'!D1+'15'!D1+'16'!D1+'17'!D1+'18'!D1+'19'!D1+'20'!D1+'21'!D1+
'22'!D1+'23'!D1+'24'!D1+'25'!D1+'26'!D1+'27'!D1+'28'!D1+'29'!D1+'30'!D1+'31'!D1lapho i-D1 iyiseli elinemali engenayo yansuku zonke, futhi '1', '2' nokunye kuyigama lethebhu. Ngendlela efanayo ngithola idatha yemali engenayo nezindleko ezengeziwe.
Ukuze kucace, nginqume ukubonisa inzuzo ephelele ngezigaba. Ukuze ngenze lokhu, kwakudingeka ngenze ukukhetha okuyinkimbinkimbi nokuhlanganisa kuwo wonke amathebhu, bese ngihlunga futhi ngisuse imigqa engenalutho nengadingekile.
Inzuzo ngesigaba
Ithuluzi lokubala eliyinhloko lemali engenayo selilungile, manje sizovele siphindaphinde ifayela lenyanga ngayinye yonyaka.
Ngemva kokudala ithuluzi lokubala kanye nokuqapha imali engenayo, ngaqala ukwakha ithebula lezindleko lapho sizocabangela zonke izindleko zanyanga zonke: indawo yokuhlala, inkokhelo, izintela, ukuthengwa kwezimpahla nezinye izindleko.
Kufolda yamanje yonyaka, ngidale idokhumenti ye-Google Sheet ngase ngengeza amathebhu ayi-13, ideshibhodi nezinyanga eziyishumi nambili kuyo.
Ithebhu yedeshibhodi
Ukuze kucace, kuthebhu yedeshibhodi ngifingqe lonke ulwazi oludingekayo ngezindleko zezimali zonyaka.
Futhi kuthebhu ngayinye yenyanga ngidale itafula lapho sizogcina khona umkhondo wazo zonke izindleko zemali zenkampani ngezigaba.
Ithebhu yenyanga
Kwaba lula kakhulu, manje ungabona futhi ulawule zonke izindleko zenkampani, futhi uma kunesidingo, bheka umlando futhi wenze izibalo.
Njengoba ulwazi lwemali engenayo nezindleko lutholakala kumafayela ahlukene futhi alulula kakhulu ukuqapha, nginqume ukudala ifayela elilodwa lapho ngihlanganise khona lonke ulwazi olufanele oludingekayo ukuze umnikazi alawule futhi aphathe inkampani. Ngiqambe leli fayela ngokuthi βIsifinyezoβ.
ithebula le-pivot
Kuleli fayela ngidale ithebula elithola idatha yanyanga zonke ematafuleni, kulokhu ngisebenzise umsebenzi ojwayelekile:
=IMPORTRANGE("url";"dashboard!$B$1")lapho ngidlulisela khona i-ID yedokhumenti njengengxabano yokuqala, kanye nobubanzi obungenisiwe njengepharamitha yesibili.
Ngabe sengihlanganisa ibhalansi yonyaka: ukuthi kutholwe malini, kusetshenziswe malini, yayiyini inzuzo, inzuzo. Ubone ngeso lengqondo idatha edingekayo.
Futhi ukuze kube lula, ukuze umnikazi webhizinisi abone yonke idatha endaweni eyodwa futhi angasebenzisi amafayela, ngihlanganise ikhono lokukhetha noma iyiphi inyanga yonyaka futhi ngibonise izinkomba ezibalulekile ngesikhathi sangempela.
Ukwenza lokhu, ngidale isixhumanisi phakathi kwenyanga ne-ID yedokhumenti
Ngabe sengidala uhlu lokudonsela phansi ngisebenzisa βIdatha -> Ukuqinisekiswa Kwedathaβ, ngacacisa ububanzi besixhumanisi futhi ngalungiselela ukungenisa ngesixhumanisi esinamandla sedokhumenti.
=IMPORTRANGE("'"& QUERY(O2:P13;"SELECT P WHERE O ='"& K7 &"'") &"'"; "dashboard!$A1:$B8")isiphetho
Njengoba ubona, ukuthuthukisa izinqubo ebhizinisini lakho akunzima njengoba kungase kubonakale, futhi awudingi ukuba namakhono amakhulu ukuze ukwenze. Yiqiniso, lolu hlelo lunokushiyeka okuningi, futhi njengoba ibhizinisi likhula ngeke likwazi ukulisebenzisa, kodwa ebhizinisini elincane noma ekuqaleni lapho kuhlolwa i-hypothesis, lesi yisixazululo esihle kakhulu.
Leli gumbi legeyimu belisebenzela lesi sixazululo unyaka wesithathu, futhi kulo nyaka kuphela, lapho sesivele siziqonda ngokucacile zonke izinqubo, siyalazi iklayenti lethu kanye nemakethe. Sinqume ukudala ithuluzi eligcwele lokuphatha ibhizinisi ku-inthanethi.
PS
Ukusebenzisa i-Google AmaSpredishithi ukuze ugade ibhizinisi lakho akulula kakhulu, ikakhulukazi kusuka kufoni yakho. Ngenza kanjalo , ebonisa zonke izinkomba zebhizinisi ezibalulekile ngesikhathi sangempela ngefomethi elula
Source: www.habr.com