{"id":31808,"date":"2023-12-13T12:10:51","date_gmt":"2023-12-13T11:10:51","guid":{"rendered":"https:\/\/www.888sp.com\/it\/blog\/congruita-della-manodopera-in-edilizia-cose-e-come-si-gestisce-copy\/"},"modified":"2024-07-05T09:05:53","modified_gmt":"2024-07-05T07:05:53","slug":"tutto-quello-che-devi-sapere-sulle-tabelle-pivot-e-i-vantaggi-di-averle-integrate-in-un-software-tecnico","status":"publish","type":"blog","link":"https:\/\/www.888sp.com\/it\/blog\/tutto-quello-che-devi-sapere-sulle-tabelle-pivot-e-i-vantaggi-di-averle-integrate-in-un-software-tecnico\/","title":{"rendered":"Tutto quello che devi sapere sulle Tabelle Pivot e i vantaggi di averle integrate in un software tecnico."},"content":{"rendered":"<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<p>La  <span style=\"color: #5E75D6;\">tabella Pivot<\/span> \u00e8 uno strumento di analisi dei dati che trasforma questi ultimi da \u201cgrezzi\u201d, una semplice tabella con righe e colonne, in \u201caggregati\u201d e \u201cdi sintesi\u201d; consente, pertanto, di  <span style=\"color: #5E75D6;\">presentare, calcolare, riassumere e analizzare rapidamente<\/span> gli stessi  <span style=\"color: #5E75D6;\">dati per creare un report personalizzato<\/span>.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"is-style-icon ghostkit-custom-LQpWj wp-block-list ghostkit-effects-reveal\">\n<li><strong><em>Si tratta, di fatto, di una tecnica che ti \u00e8 di grandissimo aiuto per ricavare e condividere nuova conoscenza dai dati.<\/em><\/strong><\/li>\n<\/ul>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>A seconda delle tue esigenze e preferenze,  <span style=\"color: #5E75D6;\">puoi utilizzare una tabella Pivot con un foglio elettronico, ad esempio Microsoft Excel<\/span>, oppure utilizzare altri strumenti online disponibili nel web;  <span style=\"color: #5E75D6;\">tuttavia, la soluzione migliore \u00e8 avere queste funzionalit\u00e0 integrate nel software applicativo in uso<\/span> e il perch\u00e9 \u00e8 presto detto!<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ol data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" style=\"background-color:#f9fbff\" class=\"is-style-icon ghostkit-custom-17BaD9 has-background wp-block-list ghostkit-effects-reveal\">\n<li>La <strong>soluzione Excel<\/strong> \u00e8 adatta per un  <span style=\"color: #5E75D6;\">uso desktop<\/span>; \u00e8 utile per chi desidera lavorare con dati locali e necessita di funzionalit\u00e0 avanzate tipiche di un foglio elettronico.  <span style=\"color: #5E75D6;\">I dati<\/span> possono essere caricati da diverse fonti (database), ma <span style=\"color: #5E75D6;\">sono sempre replicati in locale e non sono &#8220;in linea&#8221;<\/span>. Questa soluzione  <span style=\"color: #5E75D6;\">richiede<\/span>, tra l&#8217;altro, una  <span style=\"color: #5E75D6;\">licenza del prodotto<\/span> utilizzato (in questo caso Microsoft) e  <span style=\"color: #5E75D6;\">buone conoscenze<\/span> non solo dello stesso ma <span style=\"color: #5E75D6;\">anche sistemistiche<\/span>, per sfruttarne tutte le caratteristiche.<\/li>\n<li>Una <strong>tabella Pivot integrata nell&#8217;applicazione<\/strong>, invece, consente di  <span style=\"color: #5E75D6;\">analizzare e visualizzare i dati in modo interattivo e &#8220;al volo&#8221;<\/span>. Con questa modalit\u00e0 generalmente non sono disponibili tutte le funzionalit\u00e0 di un foglio elettronico, ma sussiste una <span style=\"color: #5E75D6;\">maggiore interattivit\u00e0 con i dati che la compongono e i processi che li popolano<\/span> ed \u00e8 possibile <span style=\"color: #5E75D6;\">navigare tra le informazioni fino all\u2019origine del dato!<\/span><\/li>\n<\/ol>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<h2 class=\"wp-block-heading ghostkit-custom-Z1fFrlh has-black-color has-text-color\" id=\"raccolta-e-analisi-delle-informazioni\" style=\"font-size:18px\">Tabelle Pivot: struttura e funzionalit\u00e0.<\/h2>\n<div style=\"height:24px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>La struttura di una qualsiasi tabella Pivot \u00e8 autoesplicativa e intuitiva; 3 sono le aree principali di cui si compone e con cui lavorare:  <span style=\"color: #5E75D6;\">righe, colonne e celle con valori aggregati<\/span>.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Per fare massima chiarezza sull&#8217;argomento, immagina ciascun campo dei tuoi dati come una  <span style=\"color: #5E75D6;\">dimensione<\/span> o una  <span style=\"color: #5E75D6;\">misura<\/span>, secondo le definizioni che seguono.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"is-style-icon ghostkit-custom-2atndj wp-block-list ghostkit-effects-reveal\">\n<li><strong>DIMENSIONI<\/strong>: contengono  <span style=\"color: #5E75D6;\">valori qualitativi<\/span> come nomi, descrizioni, date o dati geografici, ecc. Puoi utilizzare le dimensioni per classificare, segmentare e rilevare i dettagli nei dati. Nella tabella Pivot le dimensioni sono presentate come gerarchie e puoi inserirle in righe e\/o colonne.<\/li>\n<li><strong>MISURE<\/strong>: contengono  <span style=\"color: #5E75D6;\">valori numerici quantitativi<\/span>; possono essere aggregate e inserite nelle celle. \u00c8 possibile applicare loro funzioni di aggregazione come somma, media, massimo, minimo e molte altre.<\/li>\n<\/ul>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Ogni cella contiene un valore aggregato all\u2019intersezione di una riga e di una colonna che rappresenta dimensioni diverse.<br \/>I dati possono essere ordinati o filtrati in base a criteri specifici.<\/p>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<figure data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"wp-block-image size-large ghostkit-effects-reveal\"><a href=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"458\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1-1024x458.png\" alt=\"\" class=\"wp-image-32697\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1-1024x458.png 1024w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1-300x134.png 300w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1-768x344.png 768w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1-1536x687.png 1536w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/blog_pivot_tabella1.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<div style=\"height:46px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<h2 class=\"wp-block-heading ghostkit-custom-ZaksHV has-black-color has-text-color\" id=\"raccolta-e-analisi-delle-informazioni\" style=\"font-size:18px;font-style:normal;font-weight:600\">Le 4 funzioni delle Tabelle Pivot.<\/h2>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Riassumiamo le funzioni delle tabelle Pivot nei seguenti 4 punti:<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul class=\"is-style-icon ghostkit-custom-a3odR wp-block-list\">\n<li><strong> AGGREGAZIONE<\/strong><\/li>\n<\/ul>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul class=\"is-style-icon ghostkit-custom-1DWJ08 wp-block-list\">\n<li class=\"ghostkit-custom-ZcVi3j\"><strong>ORDINAMENTO<\/strong><\/li>\n<\/ul>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul class=\"is-style-icon ghostkit-custom-u0IfA wp-block-list\">\n<li><strong>FILTRAGGIO<\/strong><\/li>\n<\/ul>\n<div style=\"height:5px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul class=\"is-style-icon ghostkit-custom-ZIOm3P wp-block-list\">\n<li><strong>SLICING &amp; DICING<\/strong><\/li>\n<\/ul>\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><span style=\"color: #5e75d6;\"><strong>Aggregazione<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>L\u2019aggregazione \u00e8 la funzione pi\u00f9 importante di una tabella Pivot, che agisce sulle misure applicando una determinata regola; la pi\u00f9 comune \u00e8 la somma dei valori, ma \u00e8 anche possibile applicare la media, il minimo, il massimo, l\u2019incidenza %, ecc.<\/p>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<figure class=\"wp-block-video\"><video height=\"1214\" style=\"aspect-ratio: 2182 \/ 1214;\" width=\"2182\" controls src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/1.Aggregazione_r2-1.mp4\"><\/video><\/figure>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><span style=\"color: #5e75d6;\"><strong>Ordinamento<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>L\u2019ordinamento consente di disporre i dati sulla griglia in base alla tua logica aziendale, in modo che diventi pi\u00f9 facile comprenderne il significato. Ad esempio, le dimensioni possono essere ordinate in ordine alfabetico, i valori in crescente o decrescente.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><span style=\"color: #5e75d6;\"><strong>Filtraggio<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Secondo il principio <em>&#8220;less is more&#8221;<\/em>, \u00e8 molto utile poter definire un sottoinsieme di dati per concentrarsi solo sulle informazioni pi\u00f9 importanti. <br \/>Sono disponibili filtri basati sulle dimensioni e altri basati sui valori delle misure, ad esempio \u201ci 5 pi\u00f9 importanti\u201d.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"816\" height=\"852\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Filtraggio.png\" alt=\"\" class=\"wp-image-32343\" style=\"width:350px\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Filtraggio.png 816w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Filtraggio-287x300.png 287w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Filtraggio-768x802.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" \/><\/figure>\n<\/div>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div style=\"height:36px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><span style=\"color: #5E75D6;\"><strong>Slicing &amp; Dicing<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><em>Slicing e Dicing<\/em> sono due operazioni comuni per analizzare e visualizzare i dati in modo pi\u00f9 dettagliato, che consentono di suddividere la tabella Pivot in \u201cfette\u201d pi\u00f9 piccole per una visualizzazione e un\u2019analisi pi\u00f9 mirata dei dati. <br \/>La modifica pu\u00f2 essere fatta in modo dinamico utilizzando la funzione <em>drag&amp;drop<\/em>. Non c\u2019\u00e8 bisogno di chiedere allo specialista IT o alla <em>software house<\/em> di modificare o ristrutturare il tuo report, basta trascinare e rilasciare i campi necessari. <br \/>Questa funzionalit\u00e0 rende la tabella Pivot uno strumento completamente <em>self-service<\/em>.<\/p>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<figure class=\"wp-block-video\"><video height=\"608\" style=\"aspect-ratio: 1080 \/ 608;\" width=\"1080\" controls src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/2.SlicingDicing_r3.mp4\"><\/video><\/figure>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<h2 class=\"wp-block-heading ghostkit-custom-1EYhx8 has-black-color has-text-color\" id=\"raccolta-e-analisi-delle-informazioni\" style=\"font-size:18px;font-style:normal;font-weight:600\">Come creare un report da una tabella Pivot in 4 step.<\/h2>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Ora che hai un\u2019idea migliore di cosa sia la tabella Pivot, sporchiamoci le mani con la pratica. La cosa pi\u00f9 importante da fare \u00e8 porsi la domanda: &#8220;Cosa vogliamo ottenere con questo report?&#8221;<br \/> <span style=\"color: #5E75D6;\">Creiamo<\/span>, per esempio,  <span style=\"color: #5E75D6;\">un report aziendale per ottenere i ricavi suddivisi per tipologie di commessa e relativi responsabili<\/span>.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p class=\"has-text-color has-link-color wp-elements-4a1a206eba6f115f37ac0b9af7e63248\" style=\"color:#5e75d6\"> <span style=\"color: #5E75D6;\"><strong>Step 1<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Aggiungi i dati alla tabella selezionando i campi da inserire in righe e colonne. In questo caso abbiamo creato una gerarchia multi-livello per diversificare il nostro report con la  <span style=\"color: #5E75D6;\">dimensione &#8220;Famiglia&#8221;<\/span>, che classifica i ricavi in base alla tipologia dei clienti, la dimensione  <span style=\"color: #5E75D6;\">&#8220;Responsabile&#8221;<\/span> e la dimensione  <span style=\"color: #5E75D6;\">&#8220;Tipo&#8221;<\/span> che classificano le commesse per tipologia di fornitura.<\/p>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<figure class=\"wp-block-video\"><video height=\"1080\" style=\"aspect-ratio: 1920 \/ 1080;\" width=\"1920\" controls src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/3.Creazione-tabella_r3.mp4\"><\/video><\/figure>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<p class=\"has-text-color has-link-color wp-elements-a9af875377d541d6157096189bf604f8\" style=\"color:#5e75d6\"> <span style=\"color: #5E75D6;\"><strong>Step 2<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Scegli i valori che desideri misurare e applica loro l\u2019aggregazione (ad esempio la somma).<\/p>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" width=\"586\" height=\"406\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Valori.png\" alt=\"\" class=\"wp-image-32364\" style=\"width:350px\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Valori.png 586w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Valori-300x208.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/figure>\n<\/div>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<p class=\"has-text-color has-link-color wp-elements-c1bcac97dcd74104a019cdf445642233\" style=\"color:#5e75d6\"> <span style=\"color: #5E75D6;\"><strong>Step 3<\/strong><\/span><\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>\u00c8 ora di filtrare i dati! Adesso che la nostra tabella si \u00e8 riempita di dati significativi, filtrala aggiungendo la dimensione &#8220;Status&#8221; e visualizzando le sole commesse in corso.<\/p>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<figure class=\"wp-block-video\"><video height=\"1080\" style=\"aspect-ratio: 1920 \/ 1080;\" width=\"1920\" controls src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/4.Applicazione-Filtro-R2.mp4\"><\/video><\/figure>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p class=\"has-text-color has-link-color wp-elements-bcc3587ede28b0c4732c2d76f401f371\" style=\"color:#5e75d6\"> <span style=\"color: #5E75D6;\"><strong>Step 4<\/strong><\/span><\/p>\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Produci il report in PDF oppure in Excel per condividerlo con i tuoi colleghi.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<figure data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"wp-block-image size-large ghostkit-effects-reveal\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Step4-1024x596.png\" alt=\"\" class=\"wp-image-32706\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Step4-1024x596.png 1024w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Step4-300x175.png 300w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Step4-768x447.png 768w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Step4.png 1144w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<div style=\"height:46px\" aria-hidden=\"true\" class=\"wp-block-spacer is-style-icon\"><\/div>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-style-icon is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<h2 class=\"wp-block-heading ghostkit-custom-2mjXCJ has-black-color has-text-color\" id=\"raccolta-e-analisi-delle-informazioni\" style=\"font-size:18px;font-style:normal;font-weight:600\">Tutti i vantaggi di utilizzare le tabelle Pivot integrate in un applicativo software.<\/h2>\n<div style=\"height:32px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<ul data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"is-style-icon ghostkit-custom-145s54 wp-block-list ghostkit-effects-reveal\">\n<li>I sistemi ERP consentono di ottenere grandi moli di dati, ma per trasformarli in informazioni utili ai <i>controller<\/i> e al <i>management<\/i> sono necessari strumenti di analisi flessibili come le tabelle Pivot.<\/li>\n<\/ul>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Avere questi  <span style=\"color: #5E75D6;\">strumenti integrati nel sistema applicativo in uso<\/span> &#8211; anzich\u00e9 utilizzare soluzioni offline e fogli di calcolo tipo Excel &#8211; come ti abbiamo anticipato all\u2019inizio di questo articolo &#8211; d\u00e0 un  <span style=\"color: #5E75D6;\">grande vantaggio<\/span>:<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>I DATI SONO SEMPRE IN LINEA E AGGIORNATI; E&#8217; POSSIBILE NAVIGARE TRA LE INFORMAZIONI E ARRIVARE AL DOCUMENTO DI ORIGINE CHE LE HA GENERATE, MA SOPRATTUTTO NON SERVONO ALTRI PRODOTTI O LICENZE.<\/strong><\/p>\n<\/blockquote>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>Puoi trovare queste funzionalit\u00e0 sia nel nostro  <span style=\"color: #5E75D6;\">ERP Matrix<\/span>, per analizzare i dati aziendali e di commessa, che in  <span style=\"color: #5E75D6;\">Mastro 5K<\/span> per ottenere molte pi\u00f9 informazioni da Computi e Contabilit\u00e0 dei Lavori.<\/p>\n<div style=\"height:16px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p>E a proposito di Mastro 5K, vuoi vedere  <span style=\"color: #5E75D6;\">GRATIS<\/span> la registrazione del webinar  <span style=\"color: #5E75D6;\">&#8220;Il nuovo modulo Pivot per monitorare la stima economica delle opere&#8221;<\/span>, che si \u00e8 svolto il 16 novembre scorso? <br \/>Se hai almeno una licenza del programma e il contratto attivo, fai il login e <strong><a href=\"https:\/\/www.888sp.com\/it\/video\/2368-v.html\" title=\"\">guarda subito il video<\/a><\/strong>!<\/p>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<figure class=\"wp-block-image size-large is-style-default\"><a href=\"https:\/\/www.888sp.com\/it\/video\/2368-v.html\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Registrazione_Webinar--1024x576.webp\" alt=\"\" class=\"wp-image-32712\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Registrazione_Webinar--1024x576.webp 1024w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Registrazione_Webinar--300x169.webp 300w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Registrazione_Webinar--768x432.webp 768w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Blog_Pivot_Registrazione_Webinar-.webp 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption class=\"wp-element-caption\"><em>La visione di questo video \u00e8 riservata ai Clienti con contratto 888Service\/888Download<\/em>.<\/figcaption><\/figure>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<div class=\"wp-block-columns is-style-icon is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:80%\">\n<p>In pi\u00f9, puoi sempre contattarci e chiedere una  <span style=\"color: #5E75D6;\">demo personalizzata via Teams<\/span>, totalmente gratuita e non impegnativa: un\u2019opportunit\u00e0 per interagire con i nostri tecnici e valutare la migliore configurazione software, in funzione delle necessit\u00e0 nonch\u00e9 degli obiettivi attuali e futuri della tua organizzazione.<\/p>\n<\/div>\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:10%\"><\/div>\n<\/div>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<figure data-gkt-effects=\"{&quot;reveal&quot;:{&quot;x&quot;:0,&quot;y&quot;:0,&quot;opacity&quot;:0,&quot;scale&quot;:0.9,&quot;transition&quot;:{&quot;type&quot;:&quot;easing&quot;,&quot;duration&quot;:0.9,&quot;delay&quot;:0,&quot;easing&quot;:[0.5,0,0,1]}}}\" class=\"wp-block-image size-large ghostkit-effects-reveal\"><a href=\"https:\/\/www.888sp.com\/it\/richiesta-di-contatto\/\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"585\" src=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Post_Blog_Tabelle_Pivot_Contact_Us-1024x585.webp\" alt=\"\" class=\"wp-image-31812\" srcset=\"https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Post_Blog_Tabelle_Pivot_Contact_Us-1024x585.webp 1024w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Post_Blog_Tabelle_Pivot_Contact_Us-300x171.webp 300w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Post_Blog_Tabelle_Pivot_Contact_Us-768x439.webp 768w, https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Post_Blog_Tabelle_Pivot_Contact_Us.webp 1201w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<div class=\"wp-block-group\">\n<div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<style>\n.entry-content strong {\n\tcolor: #000000;\n}\n.entry-content ul,\n.entry-content ol {\n\tfont-size: 14px;\n\tcolor: #000;\n}\n.entry-content ul strong,\n.entry-content ol strong {\n\tcolor: inherit;\n}\n.wp-block-quote {\n\tmargin-left: -1rem;\n\tmargin-right: 0;\n\tborder-left-width: 4px;\n\tborder-color: #5e75d6;\n}\nol.violet-styled &gt; li {\n\tmargin-left: -28px;\n}\nol.violet-styled &gt; li:before {\n\tbackground-color: #5e75d6;\n\tborder-radius: 2px;\n\tfont-family: monospace;\n}\n.wp-block-table table {\n\tborder: 1px solid #5e75d6 !important;\n}\n.wp-block-table thead {\n\tborder-color: #5e75d6 !important;\n}\n.wp-block-table tr,\n.wp-block-table th,\n.wp-block-table td {\n\tvertical-align: top !important;\n\tpadding: 0.5em !important;\n\tborder: 1px solid #5e75d6 !important;\n}\n.wp-block-table tr {\n\tborder-bottom: 1px solid #5e75d6 !important;\n}\n<\/style>\n<\/div>\n<\/div>\n<div style=\"height:48px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Le tabelle Pivot sono strumenti per l\u2019analisi e la visualizzazione dei dati molto potenti; permettono, infatti, di riepilogare, filtrare, ordinare e presentare grandi quantit\u00e0 di dati in modo semplice e interattivo.  Ma cos\u2019\u00e8 esattamente una tabella Pivot? Come funziona? E perch\u00e9 dovresti usarla per il tuo reporting aziendale?<br \/>\nIn questo articolo risponderemo a tutte queste domande e ti spiegheremo le nozioni di base, la struttura e i vantaggi delle tabelle Pivot, oltre a fornirti esempi di utilizzo delle stesse per diversi scenari e scopi.  Al termine della lettura capirai chiaramente cosa sono le tabelle Pivot e come utilizzarle in modo efficace.<\/p>\n","protected":false},"featured_media":31811,"menu_order":0,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","ghostkit_customizer_options":"","ghostkit_custom_css":"","ghostkit_custom_js_head":"","ghostkit_custom_js_foot":"","ghostkit_typography":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-31808","blog","type-blog","status-publish","format-standard","has-post-thumbnail","hentry","blog_categories-computi-e-contabilita-lavori","blog_categories-gestione-progetti-e-commesse","blog_tag-mastro-5k","blog_tag-matrix"],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot.webp",2561,1340,false],"thumbnail":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-150x150.webp",150,150,true],"medium":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-300x157.webp",300,157,true],"medium_large":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-768x402.webp",600,314,true],"large":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-1024x536.webp",600,314,true],"1536x1536":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-1536x804.webp",1536,804,true],"2048x2048":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-2048x1072.webp",2048,1072,true],"post-thumbnail":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-50x50.webp",50,50,true],"blog-thumb":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-310x229.webp",310,229,true],"single-thumb":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-229x328.webp",229,328,true],"portfolio":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-112x72.webp",112,72,true],"portfolio-one-col":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-640x229.webp",640,229,true],"portfolio-two-col":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-310x229.webp",310,229,true],"portfolio-six-col":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-145x229.webp",145,229,true],"services":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-282x130.webp",282,130,true],"team":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-150x96.webp",150,96,true],"loop-thumb":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-346x236.webp",346,236,true],"masonry-thumb":["https:\/\/www.888sp.com\/it\/wp-content\/uploads\/2023\/11\/Cover_Post_Blog_Tabelle_Pivot-231x236.webp",231,236,true]},"uagb_author_info":{"display_name":"Mariella","author_link":"https:\/\/www.888sp.com\/it\/author\/"},"uagb_comment_info":0,"uagb_excerpt":"Le tabelle Pivot sono strumenti per l\u2019analisi e la visualizzazione dei dati molto potenti; permettono, infatti, di riepilogare, filtrare, ordinare e presentare grandi quantit\u00e0 di dati in modo semplice e interattivo. Ma cos\u2019\u00e8 esattamente una tabella Pivot? Come funziona? E perch\u00e9 dovresti usarla per il tuo reporting aziendale? In questo articolo risponderemo a tutte queste&hellip;","_links":{"self":[{"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/blog\/31808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/blog"}],"about":[{"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/types\/blog"}],"version-history":[{"count":3,"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/blog\/31808\/revisions"}],"predecessor-version":[{"id":32727,"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/blog\/31808\/revisions\/32727"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/media\/31811"}],"wp:attachment":[{"href":"https:\/\/www.888sp.com\/it\/wp-json\/wp\/v2\/media?parent=31808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}