{"id":42152,"date":"2019-03-18T00:00:00","date_gmt":"2019-03-17T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau"},"modified":"2020-02-18T13:44:57","modified_gmt":"2020-02-18T10:44:57","slug":"analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau","title":{"rendered":"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<h2>Cine suntem \u0219i care au fost premisele proiectului?<\/h2>\n<p>\nBun\u0103 ziua, m\u0103 numesc Lazarev Vladimir, sunt directorul integratorului BI <noindex><a rel=\"nofollow\" href=\"http:\/\/analyticsgroup.ru\/?utm_source=habr&amp;utm_medium=article&amp;utm_campaign=xxx\">Analytics Group<\/a><\/noindex>. Cre\u0103m pentru afaceri rapoarte vizuale despre marketing, v\u00e2nz\u0103ri, finan\u021be, logistic\u0103 pe baza celor mai bune platforme analitice Qlik Sense, Power BI, Tableau.<\/p>\n<p>\u00cen platformele BI, componenta vizual\u0103 este foarte important\u0103. Dac\u0103 a\u021bi vizionat zeci de demo-uri de rapoarte de BI \u0219i nu v\u0103 place cum arat\u0103 o anumit\u0103 platform\u0103, cel mai probabil nu o ve\u021bi implementa, chiar dac\u0103 pre\u021bul \u0219i specifica\u021biile tehnice sunt acceptabile. Din aceast\u0103 cauz\u0103, apare necesitatea de a vedea acelea\u0219i date \u00een diferite platforme analitice, pentru a putea face compara\u021bii.<\/p>\n<p>\u0218i ar fi de dorit ca datele s\u0103 fie interesante\u2026 \ud83d\ude42<\/p>\n<h2>De unde a ap\u0103rut ideea de a face acest raport? <\/h2>\n<p>\nAcum c\u00e2\u021biva ani, \u0218coala Superioar\u0103 de Economie a publicat un articol despre formarea pre\u021burilor pentru serviciile furnizate de fete cu responsabilitate social\u0103 redus\u0103 \u00een Moscova. Acestea erau date agregate de analiza a 1.800 de chestionare. Ne-au p\u0103rut interesante datele care stau la baza concluziilor sociologilor de la HSE. \u0218i am decis s\u0103 lucr\u0103m pe acest subiect.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nIdei cheie:<\/p>\n<ul>\n<li>S\u0103 ar\u0103t\u0103m nu doar concluziile care sunt la suprafa\u021b\u0103, ci \u0219i datele pe baza c\u0103rora au fost construite;<\/li>\n<li>S\u0103 oferim posibilitatea celor interesa\u021bi s\u0103 analizeze singuri regularit\u0103\u021bile, s\u0103 formuleze o ipotez\u0103 \u0219i s\u0103 o verifice.<\/li>\n<li>Lucrul ar trebui s\u0103 includ\u0103 un e\u0219antion mare de chestionare pentru a cre\u0219te credibilitatea;<\/li>\n<li>S\u0103 ar\u0103t\u0103m nu doar \u201eoferta pie\u021bei\u201d, ci \u0219i cererea pe baza datelor statistice din motoarele de c\u0103utare;<\/li>\n<\/ul>\n<p><\/p>\n<h2>Surse de date:<\/h2>\n<p><\/p>\n<ul>\n<li>Baza de date SQL cu chestionare*, format\u0103 pe baza unui site care se afl\u0103 \u00een TOP 3 rezultatelor din motoarele de c\u0103utare Yandex \u0219i Google.<\/li>\n<li>Fi\u0219ier Excel cu termeni relevan\u021bi** din domeniul analizei.<\/li>\n<li>Fi\u0219ier Excel cu frecven\u021ba istoric\u0103 a c\u0103ut\u0103rilor \u00een motorul de c\u0103utare Yandex.<\/li>\n<li>Fi\u0219ier Excel cu frecven\u021ba c\u0103ut\u0103rilor \u00een motorul de c\u0103utare Google.<\/li>\n<\/ul>\n<p>\n* Pentru colectarea informa\u021biilor, a fost utilizat un parser. Parsingul datelor a fost efectuat o singur\u0103 dat\u0103.<br \/>\n** Instrumentul utilizat pentru selec\u021bia termenilor relevan\u021bi a fost <noindex><a rel=\"nofollow\" href=\"https:\/\/wordstat.yandex.ru\/\">wordstat.yandex.ru<\/a><\/noindex><\/p>\n<h2>Roluri de business &amp; USER-story<\/h2>\n<p>\n\u00cen proiectele obi\u0219nuite, \u00eentotdeauna clarific\u0103m cine va folosi analizele \u0219i la ce \u00eentreb\u0103ri (directe sau indirecte) persoana dore\u0219te s\u0103 g\u0103seasc\u0103 r\u0103spuns.<\/p>\n<p>Doar c\u0103 exist\u0103 o problem\u0103 - acest proiect nu are client. A\u0219adar, a trebuit s\u0103 invent\u0103m trei roluri \u0219i \u00eentreb\u0103rile lor.<\/p>\n<p>Astfel, rolurile noastre au rezultat urm\u0103toarele:<\/p>\n<ol>\n<li>Fata cu responsabilitate social\u0103 sc\u0103zut\u0103<\/li>\n<li>Administrator de site cu anun\u021buri<\/li>\n<li>Proprietar de propriet\u0103\u021bi pentru \u00eenchiriere<\/li>\n<\/ol>\n<p><\/p>\n<h3>Fata cu responsabilitate social\u0103 sc\u0103zut\u0103<\/h3>\n<p>\n\"Indie\" Elvira are 25 de ani. Arat\u0103 bine, b\u0103rba\u021bii cunoscu\u021bi \u00eei evalueaz\u0103 v\u00e2rsta \u00een jur de 19-20 de ani. Practic\u0103 sport, merge la solar, se hr\u0103ne\u0219te s\u0103n\u0103tos, \u00ee\u0219i face manichiura bine \u0219i toate cele. S-a obi\u0219nuit s\u0103 tr\u0103iasc\u0103 bine, f\u0103r\u0103 a renun\u021ba la nimic. Dar un astfel de stil de via\u021b\u0103 necesit\u0103 mul\u021bi bani. Consider\u0103 c\u0103 munca de birou nu este pentru ea. \u00cei place sexul \u0219i nu vede nimic ru\u0219inos \u00een aceast\u0103 activitate. Educa\u021bia economic\u0103 \u0219i g\u00e2ndirea analitic\u0103 au determinat-o s\u0103 abordeze procesul de stabilire a pre\u021burilor \u0219i a serviciilor oferite \u00eentr-un mod pragmatic. Elvira a decis s\u0103 analizeze datele folosind o platform\u0103 BI.<\/p>\n<p>Scop: s\u0103 identifice aspectele cheie pentru a fi competitiv\u0103 \u0219i a c\u00e2\u0219tiga mai mult.<\/p>\n<p>O intereseaz\u0103 urm\u0103toarele \u00eentreb\u0103ri:<\/p>\n<blockquote>\n<ul>\n<li>La ce pre\u021b \"colegii\" cu parametrii asem\u0103n\u0103tori (\u00een\u0103l\u021bime, greutate, bust, v\u00e2rst\u0103) \u00ee\u0219i v\u00e2nd ora \u00een zona \u00een care locuie\u0219te Elvira? Are sens s\u0103 g\u0103seasc\u0103 o variant\u0103 de apartament \u00eentr-un alt district din Moscova pentru acelea\u0219i bani, dar cu un bilet mediu mai mare sau cu mai pu\u021bin\u0103 competi\u021bie?<\/li>\n<li>Merit\u0103 s\u0103 \u00ee\u0219i creasc\u0103 sau s\u0103 \u00ee\u0219i scad\u0103 v\u00e2rsta \u00een anun\u021b?<\/li>\n<li>Exist\u0103 un sens economic \u00een a cre\u0219te m\u0103rimea 2 a bustului la 4 \u0219i c\u00e2t de repede se vor amortiza investi\u021biile \u00een opera\u021bie?<\/li>\n<\/ul>\n<\/blockquote>\n<h3>Proprietarul site-ului cu anun\u021buri<\/h3>\n<p>\n\u00cent\u00e2lni\u021bi-l pe Felix Albertovici - proprietarul site-ului cu anun\u021buri. Un b\u0103rbat puternic, fermec\u0103tor de 45 de ani, cu abilit\u0103\u021bi de comunicare excelente, cu o experien\u021b\u0103 bogat\u0103 anterioar\u0103 \u00een marketing \u0219i nu numai. A reu\u0219it s\u0103 umple site-ul cu numeroase anun\u021buri ale diferitelor fete, asigur\u00e2nd o bun\u0103 vizibilitate a acestui resource prin SEO. \u00cen prezent, \u00eencaseaz\u0103 bani din plasarea pl\u0103tit\u0103 a anun\u021burilor pe site.<\/p>\n<p>Scop: s\u0103 \u00een\u021beleag\u0103 solicit\u0103rile societ\u0103\u021bii, s\u0103 defineasc\u0103 direc\u021bii promi\u021b\u0103toare de lucru cu site-ul s\u0103u<\/p>\n<p>Adres\u00e2ndu-se unei agen\u021bii de analiz\u0103 de afaceri, sper\u0103 s\u0103 primeasc\u0103 urm\u0103toarele r\u0103spunsuri:<\/p>\n<blockquote>\n<ul>\n<li>Care este portretul tipic al unei \u201eindie\u201d?<\/li>\n<li>Ce c\u0103ut\u0103ri fac utilizatorii \u00een motoarele de c\u0103utare?<\/li>\n<\/ul>\n<\/blockquote>\n<h3>Cet antreprenor autoangajat care \u00eenchiriaz\u0103 un apartament<\/h3>\n<p>\nMitya este un aventurier modern, care abordeaz\u0103 lucrurile cu o mentalitate serioas\u0103. Este obi\u0219nuit s\u0103 se ghideze dup\u0103 statistici \u0219i fapte. Mitya are un apartament \u00een zona central\u0103 a Moscovei. El vrea s\u0103 g\u0103seasc\u0103 modalit\u0103\u021bi de a c\u00e2\u0219tiga mai mul\u021bi bani din activul s\u0103u.<\/p>\n<p>Obiectiv: a g\u0103si un model de utilizare mai eficient al apartamentului s\u0103u<\/p>\n<p>\u00centreb\u0103ri principale:<\/p>\n<blockquote>\n<ul>\n<li>Dac\u0103 \u00eenchiriez apartamentul unei fete cu comportament social sc\u0103zut nu pentru o sum\u0103 fix\u0103, ci pentru un % din venit, pot c\u00e2\u0219tiga mai mult \u00een acest fel?<\/li>\n<\/ul>\n<\/blockquote>\n<h2>Concluziile manageriale ale Elvirei<\/h2>\n<p>\nElvira a observat c\u0103 colegii cu parametrii similari de v\u00e2rst\u0103, m\u0103rimea bustului, \u00een\u0103l\u021bime \u0219i greutate ofer\u0103 pre\u021buri similare \u2013 4080 \u2013 4930 de ruble\/or\u0103. Cu excep\u021bia cartierelor \u201eVestic\u201d \u0219i \u201eCentral\u201d.<\/p>\n<p>Competi\u021bia este minim\u0103 \u00een \u201eRegiunea Moscova\u201d, cu doar 20 de anun\u021buri, iar pre\u021bul de \u00eenchiriere a locuin\u021belor este aproape dublu fa\u021b\u0103 de orice district administrativ din Moscova, men\u021bin\u00e2ndu-se acela\u0219i nivel de pre\u021b pe or\u0103.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/de32ce03ed22f0b9a118499b7b5e88ad.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u00cen plus, Elvira ar dori \u00een timp s\u0103 v\u00e2nd\u0103 servicii mai scumpe, a\u0219a c\u0103 a creat un duplicat al anun\u021bului men\u021bion\u00e2nd c\u0103 locuiesc \u00een cartierul Vestic \u0219i c\u0103 lucreaz\u0103 exclusiv la comenzi pentru noaptea. Dac\u0103 exist\u0103 suficiente oferte, se va muta \u00een acea zon\u0103.<\/p>\n<p>A indicat v\u00e2rsta sa real\u0103 \u2013 25 de ani. Dat fiind c\u0103 a observat c\u0103 pre\u021bul maxim pe noapte este men\u021bionat \u00een anun\u021buri pentru categoria de v\u00e2rst\u0103 de la 25 la 30 de ani. A fost setat un filtru pentru serviciul prioritar.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/9c953ac53f5b2740516ad5c0717ccadd.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nReferitor la oportunitatea de a-\u0219i m\u0103ri bustul de la m\u0103rimea 2 la 4, Elvira a calculat:<\/p>\n<ul>\n<li>Costul mediu al unei ore cre\u0219te cu 1.190 (7.060 \u2013 5.870 = 1.190).<\/li>\n<li>Opera\u021bia de m\u0103rire a bustului cost\u0103 300.000 de ruble.<\/li>\n<li>Astfel, investi\u021bia \u00een m\u0103rirea bustului va fi recuperat\u0103 \u00een 252 de ore de munc\u0103. Cu o \u00eenc\u0103rcare de 5 ore pe zi, aceasta \u00eenseamn\u0103 50 de zile lucr\u0103toare.<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/ff85a91f4bf118c465f0d23e0884ff43.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Concluziile manageriale ale lui Felix<\/h2>\n<p>\nFelix Albertovich a vrut mai \u00eent\u00e2i s\u0103 \u00een\u021beleag\u0103 portretul tipic al \u201eindie\u201d. A\u0219adar, a observat:<\/p>\n<ul>\n<li>V\u00e2rsta medie: 29,8 ani<\/li>\n<li>M\u0103rimea medie a bustului: 2,8<\/li>\n<li>\u00cen\u0103l\u021bimea medie: 168 cm<\/li>\n<li>Greutatea medie: 57 kg<\/li>\n<li>M\u0103rimea medie a \u00eembr\u0103c\u0103mintei: 44<\/li>\n<\/ul>\n<p>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/70b5fab5faff3dba31d11b1c3351a6a7.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nFelix Albertovich a decis apoi s\u0103 analizeze c\u0103ut\u0103rile din motoarele de c\u0103utare. Anterior, el a sistematizat deja cuvintele cheie \u00een grupuri, acum ne lipsea \u00een\u021belegerea ponderii fiec\u0103rui cuv\u00e2nt cheie, statisticile c\u0103ut\u0103rilor acestuia.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/7ee9e7eeaffe64542df07cf751461bdd.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u00cen raportul analitic, Felix a observat o cre\u0219tere constant\u0103 a num\u0103rului de cereri. \u00cen 2018, comparativ cu 2017, num\u0103rul cererilor a crescut cu 60% (de la 9,99 milioane la 16,59 milioane).<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/b54afdfa8caa9d4ede5c4b3ea6572eb3.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nA\u0219a cum era de a\u0219teptat, majoritatea cererilor sunt legate de loca\u021bie. Pe locul doi se afl\u0103 cererile generale, iar pe al treilea clasificarea pre\u021burilor. Aceasta l-a f\u0103cut pe Felix s\u0103 foloseasc\u0103 con\u021binut dinamic pe site, \u00een func\u021bie de ce c\u0103utare a f\u0103cut utilizatorul pentru a ajunge pe acesta.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/077c4c81f92c5523a51036bc9c7ce243.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDe asemenea, a observat o predominan\u021b\u0103 semnificativ\u0103 a acces\u0103rilor din cererile de pe telefoane mobile \u2014 aproape de trei ori. Din acest motiv, a cerut programatorului s\u0103 verifice afi\u0219area corect\u0103 pe mobil.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/4d79ba036561acc127bcaa4e2aa9c941.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nUn aspect interesant \u2014 grupuri separate de cereri cresc mai repede dec\u00e2t celelalte.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/79f2394f01ecfa28790ebf9b64477344.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDe exemplu, \u201eCategoria de pre\u021b\u201d \u2014 Subcategoria \u201eIeftin\u201d a crescut cu 74% (comparativ cu o cre\u0219tere medie de 60%). De asemenea, anumite cuvinte cheie \u201ecele mai ieftine *****\u201d au crescut cu 113%, iar \u201e**** uzbetchi\u201d au crescut cu 120%. Dar Felix le analizeaz\u0103 aceste date nu doar din perspectiva raportului procentual, ci \u0219i din cea cantitativ\u0103.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/e3b842a459caef59e08fc33c0d98a567.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Concluziile manageriale ale lui Mitya<\/h2>\n<p>\nMitya are un apartament \u00een CAO Moscova \u0219i vrea s\u0103-l \u00eenchirieze. \u201ePe pia\u021b\u0103\u201d un astfel de apartament se \u00eenchiriaz\u0103 cu 100-120 de mii de ruble. Dar el ar dori s\u0103 c\u00e2\u0219tige mai mult. De aceea a decis s\u0103 \u00eenchirieze apartamentul \u201eindie\u201d pentru un % din venit. Pentru ei \u2014 mai pu\u021bine riscuri de reac\u021bie nedorit\u0103 din partea proprietarului apartamentului, pentru el \u2014 mai mult venit din apartament.<\/p>\n<p>Mitya a formulat ipoteza c\u0103 fetele care \u00ee\u0219i v\u00e2nd ora la un pre\u021b mai mare \u00eei vor aduce un venit poten\u021bial mai mare. El are un apartament \u00een CAO, a\u0219a c\u0103 mai \u00eent\u00e2i a analizat care sunt bugetele la care, de obicei, fetele \u00ee\u0219i v\u00e2nd ora \u00een aceast\u0103 zon\u0103.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/af1c61df24ff17a4778bee50632427cb.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nMajoritatea anun\u021burilor (206 buc.) \u00ee\u0219i v\u00e2nd ora \u00een CAO cu pre\u021buri de la 10.000 ruble. Apoi a sortat anun\u021burile care nu sunt \u00een CAO, dar se v\u00e2nd pentru un pre\u021b similar. Aceasta este publicul pe care \u00eel va selec\u021biona pe site, cu scopul de a-i contacta \u0219i de a le propune un alt tip de \u00eenchiriere a apartamentului, dar \u00een CAO.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/1f664d8a9503bcdb00e960a08feb8f5b.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nDac\u0103 vinde \u00een medie 3 ore pe zi cu un pre\u021b mediu al acestui public, venitul total lunar ar fi: 11.203 * 3 ore * 30 zile = 1.008.270 ruble\/lun\u0103.<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/e048ea32b1d67c2c2a4bc29edd44a88e.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u00cen acest context, dac\u0103 el va primi 20%, \u00eenseamn\u0103 c\u0103 apartamentul va fi \u00eenchiriat pentru mai mult de 200.000 ruble\/lun\u0103.<\/p>\n<p>\u00cen calculele sale, Mitya nu a inclus veniturile din servicii adi\u021bionale:<\/p>\n<p><img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/4d0b9cfe790438ce09a2c782071b7907.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Concluzie<\/h2>\n<p>\n\u00cen concluzia acestui articol, a\u0219 dori s\u0103 subliniez c\u0103 domeniul analizei este destul de controversat. Cu siguran\u021b\u0103, aceast\u0103 tem\u0103 reprezint\u0103 o problem\u0103 a societ\u0103\u021bii. Am scris inten\u021bionat acest articol cu umor, iar \"Concluziile manageriale\" au fost construite cu o dozare de absurd pentru a facilita \u00een\u021belegerea informa\u021biei, dar sper\u0103m s\u0103 determine o reflec\u021bie asupra tendin\u021belor.<\/p>\n<p>\u00cen acest context, platforma analitic\u0103 permite, mai mult ca orice, s\u0103 vezi imaginea real\u0103, pur \u0219i simplu cifrele, dup\u0103 care trebuie s\u0103 urmeze ac\u021biuni umane corecte. <\/p>\n<p>Prin acest exemplu, am ar\u0103tat c\u0103 orice tem\u0103 sau afacere, indicatorii s\u0103i pot fi analiza\u021bi, construind ipoteze pe baza faptelor. Acest lucru este deosebit de relevant c\u00e2nd exist\u0103 multe date, c\u00e2nd acestea se afl\u0103 \u00een diferite surse \u0219i unificarea lor \u00eentr-o imagine unic\u0103 necesit\u00e2nd mult timp. Este relevant pentru marketing, v\u00e2nz\u0103ri, finan\u021be, logistic\u0103, contabilitate de stocuri. Dac\u0103 ave\u021bi nevoie, scrie\u021bi-ne, vom fi bucuro\u0219i s\u0103 discut\u0103m despre o solu\u021bie posibil\u0103. <\/p>\n<h2>Capturi de ecran din Microsoft Power BI<\/h2>\n<p>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/18889605765d7139061995c69367c932.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/cdf3dade9695f05a6e8415751b2736ff.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Capturi de ecran din Tableau<\/h2>\n<p>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/530c45be29430e4c4363409f333a0922.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/6e4a36158143907d5ad3accc212da2d6.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<\/p>\n<h2>Capturi de ecran din Qlik Sense<\/h2>\n<p>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/e289d6c9b8d79da76eb8942039cfa9f6.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<img decoding=\"async\" alt=\"Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat Power BI, Qlik Sense, Tableau)\" src=\"\/wp-content\/uploads\/2019\/03\/2e0f7d73c6b4567fc0d5da2911e6d789.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/443808\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u0442\u043e \u043c\u044b \u0442\u0430\u043a\u0438\u0435 \u0438 \u043a\u0430\u043a\u0438\u0435 \u0431\u044b\u043b\u0438 \u043f\u0440\u0435\u0434\u043f\u043e\u0441\u044b\u043b\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430? \u0414\u043e\u0431\u0440\u044b\u0439 \u0434\u0435\u043d\u044c, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u041b\u0430\u0437\u0430\u0440\u0435\u0432 \u0412\u043b\u0430\u0434\u0438\u043c\u0438\u0440, \u044f \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c BI-\u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0442\u043e\u0440\u0430 \u0410\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0441 \u0413\u0440\u0443\u043f\u043f. \u041c\u044b \u0434\u0435\u043b\u0430\u0435\u043c \u0434\u043b\u044f \u0431\u0438\u0437\u043d\u0435\u0441\u0430 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0435 \u043e\u0442\u0447\u0451\u0442\u044b \u043f\u043e \u043c\u0430\u0440\u043a\u0435\u0442\u0438\u043d\u0433\u0443, \u043f\u0440\u043e\u0434\u0430\u0436\u0430\u043c, \u0444\u0438\u043d\u0430\u043d\u0441\u0430\u043c, \u043b\u043e\u0433\u0438\u0441\u0442\u0438\u043a\u0435 \u043d\u0430 \u0431\u0430\u0437\u0435 \u0432\u0435\u0434\u0443\u0449\u0438\u0445 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c Qlik Sense, Power BI, Tableau. \u0412 BI \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430\u0445 \u043e\u0447\u0435\u043d\u044c \u0432\u0430\u0436\u043d\u0430 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u0430\u044f \u0441\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0430\u044f. \u0415\u0441\u043b\u0438 \u0432\u044b \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u0434\u0435\u0441\u044f\u0442\u043a\u0438 \u0434\u0435\u043c\u043e-\u043e\u0442\u0447\u0435\u0442\u043e\u0432 BI-\u0441\u0438\u0441\u0442\u0435\u043c \u0438 \u0432\u0430\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-42152","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u0442\u043e \u043c\u044b \u0442\u0430\u043a\u0438\u0435 \u0438 \u043a\u0430\u043a\u0438\u0435 \u0431\u044b\u043b\u0438 \u043f\u0440\u0435\u0434\u043f\u043e\u0441\u044b\u043b\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430? \u0414\u043e\u0431\u0440\u044b\u0439 \u0434\u0435\u043d\u044c, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u041b\u0430\u0437\u0430\u0440\u0435\u0432 \u0412\u043b\u0430\u0434\u0438\u043c\u0438\u0440, \u044f \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c BI-\u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0442\u043e\u0440\u0430\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/ro\/blog\/news\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0410\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0430 \u0434\u0435\u0432\u0443\u0448\u0435\u043a \u0441 \u043d\u0438\u0437\u043a\u043e\u0439 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0441\u0442\u044c\u044e (\u0417\u0430\u0440\u044f\u0436\u0435\u043d\u043e Power BI, Qlik Sense, Tableau) | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u0442\u043e \u043c\u044b \u0442\u0430\u043a\u0438\u0435 \u0438 \u043a\u0430\u043a\u0438\u0435 \u0431\u044b\u043b\u0438 \u043f\u0440\u0435\u0434\u043f\u043e\u0441\u044b\u043b\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430? \u0414\u043e\u0431\u0440\u044b\u0439 \u0434\u0435\u043d\u044c, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u041b\u0430\u0437\u0430\u0440\u0435\u0432 \u0412\u043b\u0430\u0434\u0438\u043c\u0438\u0440, \u044f \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c BI-\u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0442\u043e\u0440\u0430\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-03-17T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T10:44:57+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Analiza fetelor cu responsabilitate social\u0103 sc\u0103zut\u0103 (\u00cenc\u0103rcat \u00een Power BI, Qlik Sense, Tableau) | ProHoster","description":"Cine suntem \u0219i care au fost premisele proiectului? Bun\u0103 ziua, m\u0103 numesc Lazarev Vladimir, sunt conduc\u0103torul integratorului BI.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"ro_RO","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0410\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0430 \u0434\u0435\u0432\u0443\u0448\u0435\u043a \u0441 \u043d\u0438\u0437\u043a\u043e\u0439 \u0441\u043e\u0446\u0438\u0430\u043b\u044c\u043d\u043e\u0439 \u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0441\u0442\u044c\u044e (\u0417\u0430\u0440\u044f\u0436\u0435\u043d\u043e Power BI, Qlik Sense, Tableau) | ProHoster","og:description":"\u041a\u0442\u043e \u043c\u044b \u0442\u0430\u043a\u0438\u0435 \u0438 \u043a\u0430\u043a\u0438\u0435 \u0431\u044b\u043b\u0438 \u043f\u0440\u0435\u0434\u043f\u043e\u0441\u044b\u043b\u043a\u0438 \u043f\u0440\u043e\u0435\u043a\u0442\u0430? \u0414\u043e\u0431\u0440\u044b\u0439 \u0434\u0435\u043d\u044c, \u043c\u0435\u043d\u044f \u0437\u043e\u0432\u0443\u0442 \u041b\u0430\u0437\u0430\u0440\u0435\u0432 \u0412\u043b\u0430\u0434\u0438\u043c\u0438\u0440, \u044f \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c BI-\u0438\u043d\u0442\u0435\u0433\u0440\u0430\u0442\u043e\u0440\u0430","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/analitika-devushek-s-nizkoj-sotsialnoj-otvetstvennostyu-zaryazheno-power-bi-qlik-sense-tableau","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-03-17T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:57+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"42152","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 07:26:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:05:21","updated":"2026-01-22 07:26:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/42152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=42152"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/42152\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=42152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=42152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=42152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}