{"id":55144,"date":"2020-01-13T00:00:00","date_gmt":"2020-01-12T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/tableau-v-roznitse-realno"},"modified":"2020-02-18T14:03:13","modified_gmt":"2020-02-18T11:03:13","slug":"tableau-v-roznitse-realno","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/tableau-v-roznitse-realno","title":{"rendered":"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><b>Koha e raportimit n\u00eb Excel \u00ebsht\u00eb duke u zhdukur me shpejt\u00ebsi \u2013 trendi p\u00ebr mjete t\u00eb p\u00ebrshtatshme p\u00ebr paraqitjen dhe analiz\u00ebn e informacionit \u00ebsht\u00eb i duksh\u00ebm n\u00eb t\u00eb gjitha fushat. Ne kemi diskutuar prej koh\u00ebsh brenda digjitalizimit t\u00eb nd\u00ebrtimit t\u00eb raportimeve dhe kemi zgjedhur sistemin e vizualizimit dhe analytik\u00ebs self-service Tableau. Aleksand\u00ebr Bezugly, drejtori i departamentit t\u00eb zgjidhjeve analitike dhe raportimeve t\u00eb Grupit \u00abM.Video-Eldorado\u00bb, tregoi p\u00ebr p\u00ebrvoj\u00ebn dhe rezultatet e nd\u00ebrtimit t\u00eb panelit t\u00eb informacioneve operative.<\/b><\/p>\n<p>T\u00eb them menj\u00ebher\u00eb, nuk \u00ebsht\u00eb realizuar gjith\u00e7ka q\u00eb ishte menduar, por p\u00ebrvoja ishte interesante, shpresoj se do t'ju ndihmoj\u00eb edhe juve. Dhe n\u00ebse dikush ka ide se si mund t\u00eb ishte b\u00ebr\u00eb m\u00eb mir\u00eb, do t\u00eb isha shum\u00eb mir\u00ebnjoh\u00ebs p\u00ebr k\u00ebshilla dhe ide.<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/81c41899e9b3acf1858a4faa627c121b.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nM\u00eb posht\u00eb ka p\u00ebr at\u00eb q\u00eb po hasnim dhe \u00e7far\u00eb m\u00ebsuam.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>Nga kemi filluar<\/h4>\n<p>\nN\u00eb \u00abM.Video-Eldorado\u00bb ekziston nj\u00eb model t\u00eb dh\u00ebnash shum\u00eb i punuar: informacion i strukturuar me thell\u00ebsin\u00eb e nevojshme t\u00eb ruajtjes dhe nj\u00eb num\u00ebr t\u00eb madh raportesh me forma t\u00eb fixuara (shih m\u00eb shum\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/mvideo\/blog\/462015\/\">k\u00ebt\u00eb artikull<\/a><\/noindex>). Prej tyre analist\u00ebt krijojn\u00eb ose tabela p\u00ebrmbledh\u00ebse ose d\u00ebrgesa t\u00eb formatuara n\u00eb Excel, ose prezantime t\u00eb bukura n\u00eb PowerPoint p\u00ebr p\u00ebrdoruesit e fundit.<\/p>\n<p>Disa vite m\u00eb par\u00eb, n\u00eb vend t\u00eb raporteve me forma t\u00eb fiksuara, filluam t\u00eb krijojm\u00eb raporte analitike n\u00eb SAP Analysis (nj\u00eb shtes\u00eb mbi Excel, n\u00eb thelb \u2013 nj\u00eb tabel\u00eb p\u00ebrmbledh\u00ebse mbi motorin OLAP). Por ky mjet nuk mundi t\u00eb p\u00ebrmbush\u00eb nevojat e t\u00eb gjith\u00eb p\u00ebrdoruesve, shumica vazhduan t\u00eb p\u00ebrdorin informacionin e p\u00ebrpunuar nga analist\u00ebt.<\/p>\n<p>P\u00ebrdoruesit tan\u00eb p\u00ebrfundimtar\u00eb ndahen n\u00eb tri kategori:<\/p>\n<p><b>Menaxhmenti i lart\u00eb<\/b>. K\u00ebrkon informacion n\u00eb nj\u00eb form\u00eb t\u00eb paraqitur mir\u00eb dhe n\u00eb m\u00ebnyr\u00eb t\u00eb dukshme.<\/p>\n<p><b>Menaxhmenti i mes\u00ebm<\/b>, p\u00ebrdorues t\u00eb avancuar. Jan\u00eb t\u00eb interesuar p\u00ebr hetimin e t\u00eb dh\u00ebnave dhe jan\u00eb t\u00eb aft\u00eb t\u00eb nd\u00ebrtojn\u00eb vet\u00eb raportet n\u00ebse kan\u00eb mjetet. Ata u b\u00ebn\u00eb p\u00ebrdoruesit ky\u00e7 t\u00eb raporteve analitike n\u00eb SAP Analysis.<\/p>\n<p><b>P\u00ebrdoruesit masiv\u00eb<\/b>. Nuk jan\u00eb t\u00eb interesuar p\u00ebr analizimin e t\u00eb dh\u00ebnave n\u00eb m\u00ebnyr\u00eb autonome, p\u00ebrdorin raportet me nj\u00eb shkall\u00eb t\u00eb kufizuar lirie, n\u00eb formatin e d\u00ebrgesave dhe tabelave p\u00ebrmbledh\u00ebse n\u00eb Excel.<\/p>\n<p>Ideja jon\u00eb ishte t\u00eb p\u00ebrmbushnim nevojat e t\u00eb gjith\u00eb p\u00ebrdoruesve dhe t\u2019u ofronim atyre nj\u00eb mjet t\u00eb p\u00ebrshtatsh\u00ebm. Vendos\u00ebm t\u00eb fillojm\u00eb me menaxhmentin e lart\u00eb. Ata kishin nevoj\u00eb p\u00ebr tabela t\u00eb p\u00ebrshtatshme p\u00ebr analizimin e rezultateve kryesore t\u00eb biznesit. Pra, filluam me Tableau dhe n\u00eb fillim zgjodh\u00ebm dy drejtimi: treguesit e shitjeve n\u00eb dyqan dhe online me nj\u00eb thell\u00ebsi dhe gjer\u00ebsi t\u00eb kufizuar analize, q\u00eb do t\u00eb mbulonin rreth 80% t\u00eb t\u00eb dh\u00ebnave t\u00eb k\u00ebrkuara nga menaxhmenti i lart\u00eb.<\/p>\n<p>P\u00ebr shkak se p\u00ebrdoruesit e panelit ishin menaxhmenti i lart\u00eb, u shfaq nj\u00eb KPI shtes\u00eb e produktit \u2013 shpejt\u00ebsia e p\u00ebrgjigjes. Askush nuk do t\u00eb pres\u00eb 20-30 sekonda derisa t\u00eb rinovohen t\u00eb dh\u00ebnat. Navigimi duheshin t\u00eb p\u00ebrfshij\u00eb 4-5 sekonda, por m\u00eb mir\u00eb t\u00eb funksiononte menj\u00ebher\u00eb. Dhe p\u00ebr fat t\u00eb keq, nuk arrit\u00ebm ta realizojm\u00eb k\u00ebt\u00eb.<\/p>\n<p>K\u00ebshtu dukej skica e panelit ton\u00eb kryesor:<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/a7a028feee6542dfbc1fd3c2feeaa3de.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nIdeja kryesore \u2013 t\u00eb bashkohen element\u00ebt kryesor\u00eb t\u00eb KPI-s\u00eb, t\u00eb cil\u00ebt p\u00ebrfundimisht u grumbulluan n\u00eb 19, majtas dhe t\u00eb paraqiten dinamikat dhe ndarjet sipas atribut\u00ebve kryesor\u00eb djathtas. Detyra duket e thjesht\u00eb, vizualizimi logjik dhe i qart\u00eb, p\u00ebrsa koh\u00eb nuk e thellohesh n\u00eb detaje.<\/p>\n<h2>Detaji 1. V\u00ebllimi i t\u00eb dh\u00ebnave<\/h2>\n<p>\nTabela kryesore p\u00ebr shitjet p\u00ebr vitin p\u00ebrmban rreth 300 milion rreshta. Duke qen\u00eb se \u00ebsht\u00eb e nevojshme t\u00eb reflektohet edhe dinamika e vitit t\u00eb kaluar dhe at\u00eb para vitit t\u00eb kaluar, v\u00ebllimi i t\u00eb dh\u00ebnave vet\u00ebm p\u00ebr shitjet faktike \u00ebsht\u00eb rreth 1 miliard rreshta. Dhe gjithashtu ndahen t\u00eb dh\u00ebnat p\u00ebr planet dhe bllokun e shitjeve online. Pra, pavar\u00ebsisht se p\u00ebrdorim nj\u00eb DB in-memory SAP HANA, shpejt\u00ebsia e k\u00ebrkes\u00ebs p\u00ebr t\u00eb p\u00ebrzgjedhur t\u00eb gjith\u00eb treguesit p\u00ebr nj\u00eb jav\u00eb nga magazinat aktuale arrinte rreth 15-20 sekonda. Zgjidhja e k\u00ebsaj problemi k\u00ebrkonte natyrsh\u00ebm materializimin e t\u00eb dh\u00ebnave. Por ka edhe pasojat n\u00eb k\u00ebt\u00eb drejtim, p\u00ebr t\u00eb cilat do t\u00eb flasim m\u00eb posht\u00eb.<\/p>\n<h2>Detaji 2. Treguesit jo-additv\u00eb<\/h2>\n<p>\nShum\u00eb KPI t\u00eb tona lidhen me numrin e faturave. Dhe ky tregues p\u00ebrfaq\u00ebson COUNT DISTINCT t\u00eb numrit t\u00eb rreshtave (titujve t\u00eb faturave) dhe tregon shuma t\u00eb ndryshme n\u00eb var\u00ebsi t\u00eb atributeve t\u00eb zgjedhura. P\u00ebr shembull, si duhet t\u00eb llogarit\u00ebsh k\u00ebt\u00eb tregues dhe derivat\u00ebt e tij:<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/0a6d676f0a5c2b779a5e7892b1f54929.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nP\u00ebr sakt\u00ebsin\u00eb e llogaritjeve mund t\u00eb:<\/p>\n<ul>\n<li>Kryejm\u00eb llogaritjen e treguesve t\u00eb till\u00eb n\u00eb koh\u00eb reale n\u00eb magazin\u00eb;\n<\/li>\n<li>Kryejm\u00eb llogaritjen n\u00eb gjith\u00eb v\u00ebllimin e t\u00eb dh\u00ebnave n\u00eb Tableau, dmth. me k\u00ebrkes\u00eb n\u00eb Tableau t\u00eb kthejm\u00eb t\u00eb gjith\u00eb t\u00eb dh\u00ebnat sipas filtrave t\u00eb zgjedhura n\u00eb granularitetin e pozicionit t\u00eb faturave;\n<\/li>\n<li>T\u00eb krijojm\u00eb nj\u00eb vitrin\u00eb t\u00eb materializuar, n\u00eb t\u00eb cil\u00ebn do t\u00eb llogariten t\u00eb gjith\u00eb treguesit n\u00eb t\u00eb gjitha variantet e zgjedhjes q\u00eb japin rezultate t\u00eb ndryshme jo-additv\u00eb.\n<\/li>\n<\/ul>\n<p>\n\u00cbsht\u00eb e qart\u00eb se n\u00eb shembullin UTE1 dhe UTE2 jan\u00eb atribute materiali q\u00eb p\u00ebrfaq\u00ebsojn\u00eb hierarkin\u00eb e produktit. Kjo nuk \u00ebsht\u00eb nj\u00eb gj\u00eb statike; p\u00ebrmes saj menaxhohet brenda kompanis\u00eb, sepse grupe t\u00eb ndryshme produktesh menaxhohen nga menaxher\u00eb t\u00eb ndrysh\u00ebm. Kemi pasur shum\u00eb rishikime globale t\u00eb k\u00ebsaj hierarkie, kur jan\u00eb ndryshuar t\u00eb gjitha nivelet, kur jan\u00eb rishikur lidhjet, si dhe ndryshime t\u00eb vazhdueshme t\u00eb pik\u00ebs, kur nj\u00eb grup kalon nga nj\u00eb nyj\u00eb n\u00eb nj\u00eb tjet\u00ebr. N\u00eb raportimin e zakonsh\u00ebm, t\u00eb gjitha k\u00ebto llogariten n\u00eb fluks nga atributet e materialeve; n\u00eb rastin e materializimit t\u00eb k\u00ebtyre t\u00eb dh\u00ebnave, \u00ebsht\u00eb e nevojshme t\u00eb zhvillohet nj\u00eb mekaniz\u00ebm p\u00ebr monitorimin e k\u00ebtyre ndryshimeve dhe mbingarkimin automatik t\u00eb t\u00eb dh\u00ebnave historike. Nj\u00eb detyr\u00eb mjaft jo triviale.<\/p>\n<h2>Detaji 3. Krahasimi i t\u00eb dh\u00ebnave <\/h2>\n<p>\nKy pik\u00eb \u00ebsht\u00eb e ngjashme me t\u00eb kaluar\u00ebn. Eshte thelbi q\u00eb n\u00eb kompani gjat\u00eb analiz\u00ebs \u00ebsht\u00eb e zakonshme t\u00eb formohen disa nivele krahasimi me periudh\u00ebn e kaluar:<\/p>\n<p><i>Krahasimi me periudh\u00ebn e kaluar (dit\u00eb p\u00ebr dit\u00eb, jav\u00eb p\u00ebr jav\u00eb, muaj p\u00ebr muaj)<\/i><\/p>\n<p>N\u00eb k\u00ebt\u00eb krahasim supozohet se, n\u00eb var\u00ebsi t\u00eb periudh\u00ebs t\u00eb zgjedhur nga p\u00ebrdoruesi (p.sh. java 33 e vitit), duhet t\u00eb tregojm\u00eb dinamik\u00ebn n\u00eb jav\u00ebn 32; n\u00ebse do t\u00eb zgjidhnim t\u00eb dh\u00ebnat p\u00ebr nj\u00eb muaj, p\u00ebr shembull maj, at\u00ebher\u00eb ky krahasim do t\u00eb tregonte dinamik\u00ebn n\u00eb prill.<\/p>\n<p><i>Krahasimi me vitin e kaluar<\/i><\/p>\n<p>K\u00ebtu nuance kryesore \u00ebsht\u00eb se n\u00eb krahasimin me dit\u00ebt dhe jav\u00ebt, ju merrni jo t\u00eb nj\u00ebjt\u00ebn dit\u00eb t\u00eb vitit t\u00eb kaluar; pra, nuk mund t\u00eb merrni thjesht vitin aktual minus nj\u00eb. Duhet t\u00eb shikoni dit\u00ebn e krahasueshme t\u00eb jav\u00ebs. Nd\u00ebrsa kur krahasoni muajt, p\u00ebrkundrazi, duhet t\u00eb merrni pik\u00ebrisht at\u00eb dit\u00eb t\u00eb kalendarit nga viti i kaluar. Po ashtu, ka nuanca me vitet e leaps. N\u00eb depozit\u00eb origjinale, t\u00eb gjitha informacionet jan\u00eb t\u00eb shp\u00ebrndara p\u00ebr dit\u00eb, nuk ka fusha t\u00eb ve\u00e7anta p\u00ebr jav\u00eb, muaj, vit. Prandaj, p\u00ebr t\u00eb marr\u00eb nj\u00eb prerje t\u00eb plot\u00eb analitike n\u00eb bord, \u00ebsht\u00eb e nevojshme t\u00eb llogaritni jo nj\u00eb periudh\u00eb, p\u00ebr shembull nj\u00eb jav\u00eb, por 4 jav\u00eb dhe pastaj t\u00eb krahasoni k\u00ebto t\u00eb dh\u00ebna, t\u00eb refletoni dinamik\u00ebn, devijimet. Prandaj, logjika e formimit t\u00eb krahasimit n\u00eb dinamik\u00eb mund t\u00eb realizohet ose n\u00eb Tableau, ose nga ana e ekranit. Po, dhe p\u00ebr k\u00ebto detaje ne sigurisht e dinim dhe mendonim q\u00eb n\u00eb faz\u00ebn e projektimit, por ndikimi i tyre n\u00eb performanc\u00ebn e p\u00ebrfundimtare t\u00eb panelit ishte e v\u00ebshtir\u00eb t\u00eb parashikohej.<\/p>\n<p>P\u00ebr pajisjen e panelit, ne ndiqnim nj\u00eb rrug\u00eb t\u00eb gjat\u00eb Agile. Detyra jon\u00eb ishte t\u00eb ofronim sa m\u00eb shpejt nj\u00eb mjet t\u00eb gatsh\u00ebm p\u00ebr testim me t\u00eb dh\u00ebna t\u00eb nevojshme. Prandaj, ne punonim n\u00eb sprint dhe bazohemi n\u00eb minimizimin e pun\u00ebve nga ana e depozit\u00ebs aktuale.<\/p>\n<h2>Pjesa 1. Besimi n\u00eb Tableau<\/h2>\n<p>\nP\u00ebr t\u00eb thjeshtuar mb\u00ebshtetje IT dhe p\u00ebr t\u00eb zbatuar shpejt ndryshimet, ne vendos\u00ebm t\u00eb b\u00ebnim logjik\u00ebn e llogaritjes s\u00eb treguesve jo aditivit dhe krahasimin e periudhave t\u00eb kaluara n\u00eb Tableau.<\/p>\n<h3>Hapi 1. T\u00eb gjith\u00eb n\u00eb Jet\u00eb, pa p\u00ebrmir\u00ebsime t\u00eb ekranit.<\/h3>\n<p>\nN\u00eb k\u00ebt\u00eb faz\u00eb, ne lidhem Tableau me ekranet aktuale dhe vendos\u00ebm t\u00eb shohim si do t\u00eb llogaritej numri i \u00e7ek\u00ebve p\u00ebr nj\u00eb vit.<\/p>\n<p><b>Rezultati:<\/b><\/p>\n<p>P\u00ebrgjigjja ishte d\u00ebshp\u00ebruese \u2013 20 minuta. Shk\u00ebmbimi i t\u00eb dh\u00ebnave p\u00ebrmes rrjetit, ngarkese e lart\u00eb n\u00eb Tableau. Ne kuptuam se logjika me treguesit jo aditivit duhet t\u00eb realizohej n\u00eb HANA. Kjo nuk na trembte shum\u00eb, sepse kishim pasur p\u00ebrvoj\u00eb t\u00eb ngjashme me BO dhe Analysis dhe ishim t\u00eb aft\u00eb t\u00eb nd\u00ebrtoshim ekrane t\u00eb shpejta n\u00eb HANA q\u00eb jepnin sakt\u00ebsisht treguesit e llogaritur jo aditivit. Tani mbeteshim ta p\u00ebrshtatim ato me Tableau.<\/p>\n<h3>Hapi 2. Jemi duke tuneuar ekranet, asnj\u00eb materializim, gjith\u00e7ka n\u00eb fluks.<\/h3>\n<p>\nNe b\u00ebm\u00eb nj\u00eb ekran t\u00eb ri t\u00eb ve\u00e7ant\u00eb, i cili nxirrte t\u00eb dh\u00ebnat e nevojshme p\u00ebr TABLEAU n\u00eb fluks. N\u00eb p\u00ebrgjith\u00ebsi, arrit\u00ebm nj\u00eb rezultat t\u00eb mir\u00eb; reduktuam koh\u00ebn e formimit t\u00eb t\u00eb gjith\u00eb treguesve p\u00ebr nj\u00eb jav\u00eb n\u00eb 9-10 sekonda. Dhe n\u00eb sinqerisht priteshim q\u00eb n\u00eb Tableau koha e p\u00ebrgjigjes s\u00eb panelit do t\u00eb ishte 20-30 sekonda n\u00eb hapjen e par\u00eb dhe m\u00eb pas fal\u00eb caches nga 10 deri n\u00eb 12, q\u00eb na do t\u00eb k\u00ebnaqte.<\/p>\n<p><b>Rezultati:<\/b><\/p>\n<p>Hapja e par\u00eb e panelit: 4-5 minuta<br \/>\n\u00c7do klik: 3-4 minuta<br \/>\nAskush nuk priste nj\u00eb shtes\u00eb t\u00eb till\u00eb n\u00eb funksionimin e ekranit.<\/p>\n<h2>Pjesa 2. Zhytesi n\u00eb Tableau<\/h2>\n<p><\/p>\n<h3>Hapi 1. Analiza e performanc\u00ebs s\u00eb Tableau dhe tuning i shpejt\u00eb<\/h3>\n<p>\nNe filluam t\u00eb analizojm\u00eb se ku shpenzon Tableau koh\u00ebn kryesore. Dhe p\u00ebr k\u00ebt\u00eb ka nj\u00eb instrument t\u00eb mir\u00eb, q\u00eb, sigurisht, \u00ebsht\u00eb nj\u00eb avantazh i Tableau. Problemi kryesor q\u00eb kemi identifikuar ishte SQL-t\u00eb shum\u00eb t\u00eb nd\u00ebrlikuara q\u00eb formonte Tableau. K\u00ebto ishin t\u00eb lidhura kryesisht me:<\/p>\n<p> \u2014 transponimin e t\u00eb dh\u00ebnave. T\u00eb mos kishte mjete p\u00ebr transponimin e dataset-eve n\u00eb Tableau, p\u00ebr nd\u00ebrtimin e pjes\u00ebs s\u00eb majt\u00eb t\u00eb panelit me nj\u00eb p\u00ebrfaq\u00ebsim t\u00eb detajuar t\u00eb t\u00eb gjith\u00eb KPI-ve, na duhej t\u00eb formonim nj\u00eb tabel\u00eb p\u00ebrmes case. Madh\u00ebsia e SQL-t\u00eb n\u00eb DB arriti 120,000 karaktere.<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/8fc4d99017ddd604bbabb5ea0a19b38d.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n \u2014 zgjedhjen e periudh\u00ebs s\u00eb koh\u00ebs. Nj\u00eb k\u00ebrkes\u00eb e till\u00eb n\u00eb nivelin e DB merrte m\u00eb shum\u00eb koh\u00eb p\u00ebr kompilim se p\u00ebr ekzekutim:<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/a9b9cc6ddd6b03c643935d070532728e.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPra, p\u00ebrpunimi i k\u00ebrkes\u00ebs 12 sekonda + 5 sekonda ekzekutimi.<\/p>\n<p>Ne vendos\u00ebm t\u00eb thjeshtojm\u00eb logjik\u00ebn e llogaritjeve n\u00eb Tableau dhe t\u00eb transferojm\u00eb nj\u00eb pjes\u00eb tjet\u00ebr t\u00eb llogaritjeve n\u00eb vitrin\u00eb dhe nivelin e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Kjo solli rezultate t\u00eb mira.<\/p>\n<p>Fillimisht b\u00ebm\u00eb transpozimin n\u00eb koh\u00eb reale, duke e b\u00ebr\u00eb at\u00eb p\u00ebrmes nj\u00eb full outer join n\u00eb faz\u00ebn p\u00ebrfundimtare t\u00eb llogaritjes s\u00eb VIEW, sipas nj\u00eb qasje si kjo, e p\u00ebrshkruar n\u00eb wiki. <noindex><a rel=\"nofollow\" href=\"http:\/\/en.wikipedia.org\/wiki\/Transpose\">Transpose \u2014 Wikipedia, enciklopedia falas<\/a><\/noindex> dhe <noindex><a rel=\"nofollow\" href=\"http:\/\/en.wikipedia.org\/wiki\/Elementary_matrix#Row-addition_transformations\">Matric\u00eb elementare \u2014 Wikipedia, enciklopedia falas<\/a><\/noindex>.<\/p>\n<p><img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/5259995831dc8ae379a34bfe84e52daa.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPra, krijuam nj\u00eb tabel\u00eb konfigurimi \u2013 nj\u00eb matric\u00eb transpozimi (21x21) dhe mor\u00ebm t\u00eb gjith\u00eb treguesit n\u00eb nj\u00eb ndarje rreshtash.<\/p>\n<p>Ishte:<br \/>\n<img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/9382ee65a1482cc137a52b5f80c39eeb.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nU b\u00eb:<br \/>\n<img decoding=\"async\" alt=\"Tableau n\u00eb shitje, a \u00ebsht\u00eb e v\u00ebrtet\u00eb?\" src=\"\/wp-content\/uploads\/2020\/01\/1d6653ec427ce0621b441943f589d860.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nTranspozimi n\u00eb vet\u00eb t\u00eb dh\u00ebnat nuk merr gati asnj\u00eb koh\u00eb. K\u00ebrkesa p\u00ebr t\u00eb gjith\u00eb treguesit p\u00ebr nj\u00eb jav\u00eb vazhdonte t\u00eb p\u00ebrfundonte ende rreth 10 sekonda. Por kemi humbur fleksibilitetin n\u00eb nd\u00ebrtimin e panelit t\u00eb kontrollit p\u00ebr nj\u00eb tregues t\u00eb caktuar, pra p\u00ebr pjes\u00ebn e djatht\u00eb t\u00eb panelit t\u00eb kontrollit ku paraqitet dinamika dhe ndarja e detajuar e nj\u00eb treguesi konkret, m\u00eb par\u00eb vitrina p\u00ebrfundonte p\u00ebr 1-3 sekonda, pasi k\u00ebrkesa shkonte p\u00ebr nj\u00eb tregues, nd\u00ebrsa tani baza e t\u00eb dh\u00ebnave gjithmon\u00eb p\u00ebrzgjidhte t\u00eb gjith\u00eb treguesit dhe filtroi rezultatin vet\u00ebm para se t\u00eb kthente rezultatin n\u00eb Tableau.<\/p>\n<p>Si rezultat, shpejt\u00ebsia e pun\u00ebs s\u00eb panelit t\u00eb kontrollit u zvog\u00eblua gati me 3 her\u00eb.<\/p>\n<p><b>Rezultati:<\/b><\/p>\n<ol>\n<li>5 sek \u2014 analizimi i panelit t\u00eb kontrollit, vizualizimeve<\/li>\n<li> 15-20 sek \u2014 p\u00ebrgatitja p\u00ebr kompilimin e k\u00ebrkesave me realizimin e parakalkulimeve n\u00eb Tableau<\/li>\n<li> 35-45 sek \u2014 kompilimi i k\u00ebrkesave SQL dhe ekzekutimi i tyre paralel-pjes\u00ebpas\u00eb n\u00eb Hana<\/li>\n<li> 5 sek \u2014 p\u00ebrpunimi i rezultateve, renditja, rinum\u00ebrimi i vizualizimeve n\u00eb Tableau<\/li>\n<li>Sigurisht, k\u00ebto rezultate nuk e k\u00ebnaqnin biznesin dhe ne vazhduam optimizimin.<\/li>\n<\/ol>\n<p><\/p>\n<h3>Faza 2. Minimalizimi i logjik\u00ebs n\u00eb Tableau, materializimi i plot\u00eb<\/h3>\n<p>\nNe e kuptonim se nd\u00ebrtimi i nj\u00eb paneli kontrolli me koh\u00eb p\u00ebrgjigjeje n\u00eb disa sekonda n\u00eb nj\u00eb vitrin\u00eb q\u00eb punon 10 sekonda \u00ebsht\u00eb e pamundur, dhe shqyrtuam mund\u00ebsit\u00eb e materializimit t\u00eb t\u00eb dh\u00ebnave n\u00eb an\u00ebn e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave posa\u00e7\u00ebrisht p\u00ebr panelin e k\u00ebrkuar. Por u p\u00ebrball\u00ebm me nj\u00eb problem t\u00eb p\u00ebrgjithsh\u00ebm, t\u00eb p\u00ebrshkruar m\u00eb sip\u00ebr \u2013 treguesit e paaditiv. Nuk arrit\u00ebm t\u00eb b\u00ebnim q\u00eb me ndryshimin e filtrave ose zgjerimeve Tableau t\u00eb kalonte fleksib\u00ebl midis vitrinave dhe niveleve t\u00eb ndryshme, t\u00eb parakalkuluara p\u00ebr hierarkit\u00eb e ndryshme t\u00eb produkteve (n\u00eb shembull, tre k\u00ebrkesa pa UTE, me UTE1 dhe UTE2 formojn\u00eb rezultate t\u00eb ndryshme). Prandaj, mor\u00ebm vendimin t\u00eb thjeshtojm\u00eb panelin, t\u00eb heqim hierarkin\u00eb e produkteve n\u00eb panelin e kontrollit dhe t\u00eb shohim se sa i shpejt\u00eb mund t\u00eb jet\u00eb n\u00eb versionin e thjeshtuar.<\/p>\n<p>Pra, n\u00eb k\u00ebt\u00eb faz\u00eb t\u00eb fundit, krijuam nj\u00eb depo t\u00eb ve\u00e7ant\u00eb, ku grumbulluam n\u00eb form\u00eb t\u00eb transpozuar t\u00eb gjith\u00eb KPI-t\u00eb. N\u00eb an\u00ebn e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, \u00e7do k\u00ebrkes\u00eb p\u00ebr nj\u00eb depo t\u00eb till\u00eb p\u00ebrfundon p\u00ebr 0,1 \u2013 0,3 sekonda. N\u00eb panelin e kontrollit mor\u00ebm rezultatet e m\u00ebposhtme:<\/p>\n<p>Hapja e par\u00eb: 8-10 sekonda<br \/>\n\u00c7do klik: 6-7 sekonda<\/p>\n<p>Koha q\u00eb harxhon Tableau \u00ebsht\u00eb:<\/p>\n<ol>\n<li>0,3 sek. \u2014 analizimi i panelit t\u00eb kontrollit dhe kompilimi i k\u00ebrkesave SQL\n<\/li>\n<li>1,5-3 sek. \u2014 ekzekutimi i k\u00ebrkesave SQL n\u00eb Hana p\u00ebr vizualizimet kryesore (mvijon paralelisht me p.1)\n<\/li>\n<li>1,5-2 sek. \u2014 renditja, rinum\u00ebrimi i vizualizimeve\n<\/li>\n<li>1,3 sek. \u2014 ekzekutimi i k\u00ebrkesave SQL shtes\u00eb p\u00ebr t\u00eb marr\u00eb vlerat p\u00ebrkat\u00ebse t\u00eb filtrave (Mark\u00eb, Divizion, Qytet, Dyqan), analizimi i rezultateve\n<\/li>\n<\/ol>\n<p><\/p>\n<h3>N\u00ebse p\u00ebrmbledhim shkurtimisht<\/h3>\n<p>\nNa p\u00eblqeu mjeti Tableau nga k\u00ebndv\u00ebshtrimi i vizualizimit. N\u00eb faz\u00ebn e projektimit shqyrtuam elemente t\u00eb ndryshme vizualizimi dhe i gjet\u00ebm t\u00eb gjitha n\u00eb bibliotekat, duke p\u00ebrfshir\u00eb segmentimet m\u00eb t\u00eb zakonshme dhe waterfall me m\u00eb shum\u00eb motor\u00eb.<\/p>\n<p>Duke zbatuar panele me treguesit kryesor\u00eb t\u00eb shitjeve, u p\u00ebrball\u00ebm me v\u00ebshtir\u00ebsi n\u00eb performanc\u00eb, t\u00eb cilat ende nuk arrit\u00ebm t'i kalojm\u00eb. Shqytzuam m\u00eb shum\u00eb se dy muaj dhe mor\u00ebm nj\u00eb panel funksionalisht t\u00eb pap\u00ebrfunduar, me shpejt\u00ebsin\u00eb e p\u00ebrgjigjes q\u00eb \u00ebsht\u00eb n\u00eb pragun e pranuesh\u00ebm. Dhe p\u00ebr vete b\u00ebm\u00eb p\u00ebrfundime:<\/p>\n<ol>\n<li>Tableau nuk mund t\u00eb punoj\u00eb me volume t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave. N\u00ebse n\u00eb modelin tuaj t\u00eb t\u00eb dh\u00ebnave keni m\u00eb shum\u00eb se 10 GB t\u00eb dh\u00ebna (af\u00ebrsisht 200 milion x 50 rreshta), at\u00ebher\u00eb dashboard-i ngadal\u00ebsohet seriozisht - nga 10 sekonda deri n\u00eb disa minuta p\u00ebr \u00e7do klik. Ne kemi eksperimentuar si me live-connect ashtu edhe me ekstrakt. Shpejt\u00ebsia e funksionimit \u00ebsht\u00eb e ngjashme.\n<\/li>\n<li>Kufizimi kur p\u00ebrdorni disa depo (datasete). Nuk ka mund\u00ebsi standarde p\u00ebr t\u00eb treguar lidhjen e dataset-eve. N\u00ebse p\u00ebrdoren zgjidhje alternative p\u00ebr lidhjen e dataset-eve, at\u00ebher\u00eb kjo do t\u00eb ndikoj\u00eb shum\u00eb n\u00eb performanc\u00eb. N\u00eb rastin ton\u00eb, shqyrtuam mund\u00ebsin\u00eb e materializimit t\u00eb t\u00eb dh\u00ebnave n\u00eb \u00e7do prerje t\u00eb nevojshme t\u00eb p\u00ebrfaq\u00ebsimeve dhe n\u00eb k\u00ebto dataset-e t\u00eb materializuara t\u00eb b\u00ebjm\u00eb kalimet me ruajtjen e filtrave t\u00eb zgjedhur m\u00eb par\u00eb \u2013 kjo doli e pamundur t\u00eb b\u00ebhej n\u00eb Tableau.\n<\/li>\n<li>N\u00eb Tableau, parametrat dinamik\u00eb nuk mund t\u00eb krijohen. Nuk mund t\u00eb mbushni nj\u00eb paramet\u00ebr, q\u00eb p\u00ebrdoret p\u00ebr filtrimin e dataset-it n\u00eb ekstrakt ose gjat\u00eb lidhjes live, me rezultatin e nj\u00eb seleksioni tjet\u00ebr nga dataset-i ose rezultatin e nj\u00eb tjet\u00ebr k\u00ebrkese SQL, vet\u00ebm me hyrje natyrale t\u00eb p\u00ebrdoruesit ose nj\u00eb konstant\u00eb.\n<\/li>\n<li>Kufizimet q\u00eb lidhen me nd\u00ebrtimin e dashboard-it me elemente OLAP|Tabela Pivot. <br \/>\nN\u00eb MSTR, SAP SAC, SAP Analysis, n\u00ebse i shtoni nj\u00eb dataset raportit, t\u00eb gjitha objektet n\u00eb t\u00eb jan\u00eb t\u00eb lidhura me nj\u00ebra-tjetr\u00ebn si t\u00eb dh\u00ebna nga default. N\u00eb Tableau, kjo nuk ndodh; lidhja duhet t\u00eb konfigurohet manualisht. Kjo, ndoshta, \u00ebsht\u00eb m\u00eb fleksibile, por p\u00ebr t\u00eb gjith\u00eb dashboard-et tan\u00eb \u00ebsht\u00eb nj\u00eb k\u00ebrkes\u00eb e domosdoshme p\u00ebr element\u00ebt \u2013 prandaj kjo solli shpenzime t\u00eb tjera t\u00eb pun\u00ebs. P\u00ebr m\u00eb tep\u00ebr, n\u00ebse b\u00ebni filtra t\u00eb lidhur, p\u00ebr shembull, q\u00eb kur filtroni rajonin lista e qyteteve t\u00eb kufizohet vet\u00ebm n\u00eb qytetet e atij rajoni, ju menj\u00ebher\u00eb hasni n\u00eb k\u00ebrkesa sekondare p\u00ebr BD ose Ekstrakt, \u00e7ka e ngadal\u00ebson duksh\u00ebm dashboard-in.<\/li>\n<li>Kufizimet n\u00eb funksione. As mbi ekstraktin, as aq m\u00eb shum\u00eb mbi dataset-in nga Live-connecta, nuk mund t\u00eb b\u00ebhen transformime masive. Kjo mund t\u00eb b\u00ebhet p\u00ebrmes Tableau Prep, por kjo sjell shpenzime t\u00eb tjera t\u00eb pun\u00ebs dhe nj\u00eb tjet\u00ebr mjet, t\u00eb cilin duhet ta m\u00ebsoni dhe mbani. P\u00ebr shembull, nuk mund t\u00eb transpononi t\u00eb dh\u00ebnat, t\u2019i bashkoni ato me vetveten. Kjo ndalon transformimet mbi kolona ose fusha t\u00eb ve\u00e7anta, t\u00eb cilat duhet t\u00eb zgjidhen p\u00ebrmes case ose if dhe kjo krijon shum\u00eb k\u00ebrkesa komplekse SQL, ku baza kalon m\u00eb shum\u00eb koh\u00eb duke kompiluar tekstin e k\u00ebrkes\u00ebs. K\u00ebto nd\u00ebrlikime t\u00eb mjetit duhej t'i zgjidhnim n\u00eb nivelin e vitrin\u00ebs, q\u00eb \u00e7on n\u00eb nd\u00ebrlikimin e magazin\u00ebs, ngarkesa shtes\u00eb dhe transformime.\n<\/li>\n<\/ol>\n<p>\nNe nuk i kemi v\u00ebn\u00eb nj\u00eb kryq Tableau. Por si nj\u00eb mjet q\u00eb mund t\u00eb krijoj\u00eb dashboard-e industriale dhe si nj\u00eb mjet me t\u00eb cilin mund t\u00eb z\u00ebvend\u00ebsohet dhe dixhitalizohet e gjith\u00eb sistemi i raportimit korporativ t\u00eb kompanis\u00eb, Tableau nuk e konsiderojm\u00eb.<\/p>\n<p>Aktualisht jemi duke zhvilluar nj\u00eb dashboard t\u00eb ngjash\u00ebm me nj\u00eb mjet tjet\u00ebr dhe paralelisht po p\u00ebrpiqemi t\u00eb rishohim arkitektur\u00ebn e dashboard-it n\u00eb Tableau, p\u00ebr ta thjeshtuar edhe m\u00eb shum\u00eb. N\u00ebse komuniteti do t\u00eb jet\u00eb i interesuar \u2013 do t\u2019ju informojm\u00eb p\u00ebr rezultatet.<\/p>\n<p>Gjithashtu, presim idet\u00eb ose k\u00ebshillat tuaja se si n\u00eb Tableau mund t\u00eb krijoni dashboard-e t\u00eb shpejta mbi volumet kaq t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, sepse ne kemi edhe nj\u00eb faqe ku t\u00eb dh\u00ebnat jan\u00eb shum\u00eb m\u00eb t\u00eb m\u00ebdha se n\u00eb shumic\u00eb.<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/mvideo\/blog\/483656\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0412\u0440\u0435\u043c\u044f \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0432 Excel \u0441\u0442\u0440\u0435\u043c\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0445\u043e\u0434\u0438\u0442 \u2014 \u0442\u0440\u0435\u043d\u0434 \u043d\u0430 \u0443\u0434\u043e\u0431\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432\u0438\u0434\u0435\u043d \u0432\u043e \u0432\u0441\u0435\u0445 \u0441\u0444\u0435\u0440\u0430\u0445. \u041c\u044b \u0434\u0430\u0432\u043d\u043e \u043e\u0431\u0441\u0443\u0436\u0434\u0430\u043b\u0438 \u0432\u043d\u0443\u0442\u0440\u0438 \u0446\u0438\u0444\u0440\u043e\u0432\u0438\u0437\u0430\u0446\u0438\u044e \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u044f \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0438 \u0432\u044b\u0431\u0440\u0430\u043b\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u0443 \u0432\u0438\u0437\u0443\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0438 self-service \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u043a\u0438 Tableau. \u0410\u043b\u0435\u043a\u0441\u0430\u043d\u0434\u0440 \u0411\u0435\u0437\u0443\u0433\u043b\u044b\u0439, \u0440\u0443\u043a\u043e\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c \u043e\u0442\u0434\u0435\u043b\u0430 \u0430\u043d\u0430\u043b\u0438\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0445 \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0438 \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0413\u0440\u0443\u043f\u043f\u044b \u00ab\u041c.\u0412\u0438\u0434\u0435\u043e-\u042d\u043b\u044c\u0434\u043e\u0440\u0430\u0434\u043e\u00bb, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u0430\u043b \u043e\u0431 \u043e\u043f\u044b\u0442\u0435 \u0438 \u0438\u0442\u043e\u0433\u0430\u0445 \u043f\u043e\u0441\u0442\u0440\u043e\u0435\u043d\u0438\u044f \u0431\u043e\u0435\u0432\u043e\u0433\u043e \u0434\u0430\u0448\u0431\u043e\u0440\u0434\u0430. \u0421\u043a\u0430\u0436\u0443 \u0441\u0440\u0430\u0437\u0443, \u043d\u0435 [&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-55144","post","type-post","status-publish","format-standard","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0412\u0440\u0435\u043c\u044f \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0432 Excel \u0441\u0442\u0440\u0435\u043c\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0445\u043e\u0434\u0438\u0442 \u2014 \u0442\u0440\u0435\u043d\u0434 \u043d\u0430 \u0443\u0434\u043e\u0431\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432\u0438\u0434\u0435\u043d \u0432\u043e \u0432\u0441\u0435\u0445 \u0441\u0444\u0435\u0440\u0430\u0445.\" \/>\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\/sq\/blog\/novosti-interneta\/tableau-v-roznitse-realno\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\udd47Tableau \u0432 \u0440\u043e\u0437\u043d\u0438\u0446\u0435, \u0440\u0435\u0430\u043b\u044c\u043d\u043e? | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0412\u0440\u0435\u043c\u044f \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0432 Excel \u0441\u0442\u0440\u0435\u043c\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0445\u043e\u0434\u0438\u0442 \u2014 \u0442\u0440\u0435\u043d\u0434 \u043d\u0430 \u0443\u0434\u043e\u0431\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432\u0438\u0434\u0435\u043d \u0432\u043e \u0432\u0441\u0435\u0445 \u0441\u0444\u0435\u0440\u0430\u0445.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/tableau-v-roznitse-realno\" \/>\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=\"2020-01-12T21:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-18T11:03:13+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\udd47A \u00ebsht\u00eb Tableau p\u00ebr shitjet me pakic\u00eb, n\u00eb t\u00eb v\u00ebrtet\u00eb? | ProHoster","description":"Koha e raportimit n\u00eb Excel po kalon shpejt \u2014 tendenca p\u00ebr mjete t\u00eb lehta dhe t\u00eb p\u00ebrshtatshme p\u00ebr paraqitjen dhe analizimin e informacionit \u00ebsht\u00eb evidente n\u00eb t\u00eb gjitha fushat.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/tableau-v-roznitse-realno","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\udd47Tableau \u0432 \u0440\u043e\u0437\u043d\u0438\u0446\u0435, \u0440\u0435\u0430\u043b\u044c\u043d\u043e? | ProHoster","og:description":"\u0412\u0440\u0435\u043c\u044f \u043e\u0442\u0447\u0451\u0442\u043d\u043e\u0441\u0442\u0438 \u0432 Excel \u0441\u0442\u0440\u0435\u043c\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0443\u0445\u043e\u0434\u0438\u0442 \u2014 \u0442\u0440\u0435\u043d\u0434 \u043d\u0430 \u0443\u0434\u043e\u0431\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u0438 \u0432\u0438\u0434\u0435\u043d \u0432\u043e \u0432\u0441\u0435\u0445 \u0441\u0444\u0435\u0440\u0430\u0445.","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/tableau-v-roznitse-realno","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":"2020-01-12T21:00:00+00:00","article:modified_time":"2020-02-18T11:03:13+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"55144","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 19:50:02","updated":"2022-10-05 23:10:07","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/55144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=55144"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/55144\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=55144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=55144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=55144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}