Tehnologii Office in Marketing, Curs 4
32
CENTRALIZATORUL FAC Nume Client Adresa 101 Client1 Constanţa Str. A 456,853 Mon, 24 Nov 14 105 Client5 Arad Str. E 456,854 Fri, 7 Feb 14 101 Client1 Constanţa Str. A 456,856 Thu, 23 Jan 14 102 Client2 Bucureşti Str. B 456,858 Sun, 18 May 14 106 Client6 Timişoara Str. F 456,859 Mon, 25 Aug 14 105 Client5 Arad Str. E 456,855 Wed, 22 Oct 14 102 Client2 Bucureşti Str. B 456,861 Thu, 18 Sep 14 103 Client3 Braşov Str. C 456,852 Thu, 19 Feb 15 107 Client7 Buzău Str. C 456,857 Fri, 9 Jan 15 104 Client4 Cluj Str. D 456,860 Thu, 12 Mar 15 104 Client4 Cluj Str. D 456,862 Fri, 6 Mar 15 106 Client6 Timişoara Str. F 456,864 Thu, 8 Jan 15 105 Client5 Arad Str. E 456,865 Tue, 10 Feb 15 103 Client3 Braşov Str. C 456,866 Mon, 5 Jan 15 102 Client2 Bucureşti Str. B 456,867 Tue, 10 Mar 15 106 Client6 Timişoara Str. F 456,868 Wed, 4 Feb 15 105 Client5 Arad Str. E 456,869 Mon, 23 Mar 15 102 Client2 Bucureşti Str. B 456,870 Wed, 25 Mar 15 107 Client7 Buzău Str. G 456,871 Tue, 31 Mar 15 103 Client3 Braşov Str. C 456,863 Tue, 31 Mar 15 >0 0 Nume Client Adresa 101 Client1 Constanţa Str. A 456,853 Mon, 24 Nov 14 105 Client5 Arad Str. E 456,855 Wed, 22 Oct 14 103 Client3 Braşov Str. C 456,852 Thu, 19 Feb 15 104 Client4 Cluj Str. D 456,862 Fri, 6 Mar 15 106 Client6 Timişoara Str. F 456,864 Thu, 8 Jan 15 105 Client5 Arad Str. E 456,865 Tue, 10 Feb 15 103 Client3 Braşov Str. C 456,866 Mon, 5 Jan 15 102 Client2 Bucureşti Str. B 456,867 Tue, 10 Mar 15 105 Client5 Arad Str. E 456,869 Mon, 23 Mar 15 102 Client2 Bucureşti Str. B 456,870 Wed, 25 Mar 15 Cod Client Localitat e Client Număr factură Data facturii Să se afişeze toate detaliile privind facturile emise Nr zile graţie Ultimele 6 luni Cod Client Localitat e Client Număr factură Data facturii
-
Upload
bizarre-rocsu -
Category
Documents
-
view
253 -
download
1
description
office
Transcript of Tehnologii Office in Marketing, Curs 4
Interogare 1
CENTRALIZATORUL FACTURILOR EMISE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,854Fri, 7 Feb 140.0Fri, 7 Feb 1415,600 leiNU52,884 lei417 zile101Client1ConstanaStr. A456,856Thu, 23 Jan 1420 zileThu, 20 Feb 148,360 leiDA0.00.0102Client2BucuretiStr. B456,858Sun, 18 May 1410 zileFri, 30 May 1413,000 leiNU29,510 lei305 zile106Client6TimioaraStr. F456,859Mon, 25 Aug 1420 zileMon, 22 Sep 1438,060 leiNU42,627 lei190 zile105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU27,405 lei118 zile102Client2BucuretiStr. B456,861Thu, 18 Sep 1415 zileThu, 9 Oct 143,900 leiNU3,787 lei173 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0107Client7BuzuStr. C456,857Fri, 9 Jan 150.0Fri, 9 Jan 1587,056 leiNU30,034 lei81 zile104Client4ClujStr. D456,860Thu, 12 Mar 150.0Thu, 12 Mar 1519,500 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU754 lei78 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0106Client6TimioaraStr. F456,868Wed, 4 Feb 150.0Wed, 4 Feb 15Sat 14 Apr 51NU4,027 lei55 zile105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Tue, 31 Mar 156 zileWed, 8 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Tue, 31 Mar 1530 zileTue, 12 May 15Mon 4 Aug 53NU0.00.0
S se afieze toate detaliile privind facturile emise n ultimele 6 luni, pentru care clientul a beneficiat de un termen de graie.
Nr zile graieUltimele 6 luni>0TRUE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU26,423 lei115 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU719 lei75 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Tue, 31 Mar 156 zileWed, 8 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Wed, 1 Apr 1530 zileWed, 13 May 15Mon 4 Aug 53NU0.00.0
Interogare 2
CENTRALIZATORUL FACTURILOR EMISE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,854Fri, 7 Feb 140.0Fri, 7 Feb 1415,600 leiNU52,884 lei417 zile101Client1ConstanaStr. A456,856Thu, 23 Jan 1420 zileThu, 20 Feb 148,360 leiDA0.00.0102Client2BucuretiStr. B456,858Sun, 18 May 1410 zileFri, 30 May 1413,000 leiNU29,510 lei305 zile106Client6TimioaraStr. F456,859Mon, 25 Aug 1420 zileMon, 22 Sep 1438,060 leiNU42,627 lei190 zile105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU27,405 lei118 zile102Client2BucuretiStr. B456,861Thu, 18 Sep 1415 zileThu, 9 Oct 143,900 leiNU3,787 lei173 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0107Client7BuzuStr. C456,857Fri, 9 Jan 150.0Fri, 9 Jan 1587,056 leiNU30,034 lei81 zile104Client4ClujStr. D456,860Thu, 12 Mar 150.0Thu, 12 Mar 1519,500 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU754 lei78 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0106Client6TimioaraStr. F456,868Wed, 4 Feb 150.0Wed, 4 Feb 15Sat 14 Apr 51NU4,027 lei55 zile105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Fri, 27 Mar 156 zileMon, 6 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Tue, 31 Mar 1530 zileTue, 12 May 15Mon 4 Aug 53NU0.00.0
S se afieze lista clienilor (cod, nume, localitate i adres) din Bucureti i Braov care nu au platit facturile.Ficare client va fi afiat o singura dat n list.
Interogare 3
CENTRALIZATORUL FACTURILOR EMISE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,854Fri, 7 Feb 140.0Fri, 7 Feb 1415,600 leiNU52,884 lei417 zile101Client1ConstanaStr. A456,856Thu, 23 Jan 1420 zileThu, 20 Feb 148,360 leiDA0.00.0102Client2BucuretiStr. B456,858Sun, 18 May 1410 zileFri, 30 May 1413,000 leiNU29,510 lei305 zile106Client6TimioaraStr. F456,859Mon, 25 Aug 1420 zileMon, 22 Sep 1438,060 leiNU42,627 lei190 zile105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU27,405 lei118 zile102Client2BucuretiStr. B456,861Thu, 18 Sep 1415 zileThu, 9 Oct 143,900 leiNU3,787 lei173 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0107Client7BuzuStr. C456,857Fri, 9 Jan 150.0Fri, 9 Jan 1587,056 leiNU30,034 lei81 zile104Client4ClujStr. D456,860Thu, 12 Mar 150.0Thu, 12 Mar 1519,500 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU754 lei78 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0106Client6TimioaraStr. F456,868Wed, 4 Feb 150.0Wed, 4 Feb 15Sat 14 Apr 51NU4,027 lei55 zile105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Tue, 31 Mar 156 zileWed, 8 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Tue, 31 Mar 1530 zileTue, 12 May 15Mon 4 Aug 53NU0.00.0
S se afieze lista facturilor nepltite care devin scadente n luna curent.
Interogare 4
CENTRALIZATORUL FACTURILOR EMISE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,854Fri, 7 Feb 140.0Fri, 7 Feb 1415,600 leiNU52,884 lei417 zile101Client1ConstanaStr. A456,856Thu, 23 Jan 1420 zileThu, 20 Feb 148,360 leiDA0.00.0102Client2BucuretiStr. B456,858Sun, 18 May 1410 zileFri, 30 May 1413,000 leiNU29,510 lei305 zile106Client6TimioaraStr. F456,859Mon, 25 Aug 1420 zileMon, 22 Sep 1438,060 leiNU42,627 lei190 zile105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU27,405 lei118 zile102Client2BucuretiStr. B456,861Thu, 18 Sep 1415 zileThu, 9 Oct 143,900 leiNU3,787 lei173 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0107Client7BuzuStr. C456,857Fri, 9 Jan 150.0Fri, 9 Jan 1587,056 leiNU30,034 lei81 zile104Client4ClujStr. D456,860Thu, 12 Mar 150.0Thu, 12 Mar 1519,500 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU754 lei78 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0106Client6TimioaraStr. F456,868Wed, 4 Feb 150.0Wed, 4 Feb 15Sat 14 Apr 51NU4,027 lei55 zile105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Tue, 31 Mar 156 zileWed, 8 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Tue, 31 Mar 1530 zileTue, 12 May 15Mon 4 Aug 53NU0.00.0
S se afieze lista facturilor cu o valoare care depete media valoric a tuturor facturilor.
Interogare 5
CENTRALIZATORUL FACTURILOR EMISE
Cod ClientNume ClientLocalitate ClientAdresaNumr facturData facturiiNr zile graieData scadeneiValoare facturPltitMajorriNr. zile ntrziere101Client1ConstanaStr. A456,853Mon, 24 Nov 1420 zileMon, 22 Dec 1412,520 leiDA0.00.0105Client5AradStr. E456,854Fri, 7 Feb 140.0Fri, 7 Feb 1415,600 leiNU52,884 lei417 zile101Client1ConstanaStr. A456,856Thu, 23 Jan 1420 zileThu, 20 Feb 148,360 leiDA0.00.0102Client2BucuretiStr. B456,858Sun, 18 May 1410 zileFri, 30 May 1413,000 leiNU29,510 lei305 zile106Client6TimioaraStr. F456,859Mon, 25 Aug 1420 zileMon, 22 Sep 1438,060 leiNU42,627 lei190 zile105Client5AradStr. E456,855Wed, 22 Oct 1430 zileWed, 3 Dec 1446,766 leiNU27,405 lei118 zile102Client2BucuretiStr. B456,861Thu, 18 Sep 1415 zileThu, 9 Oct 143,900 leiNU3,787 lei173 zile103Client3BraovStr. C456,852Thu, 19 Feb 1515 zileThu, 12 Mar 1514,005 leiDA0.00.0107Client7BuzuStr. C456,857Fri, 9 Jan 150.0Fri, 9 Jan 1587,056 leiNU30,034 lei81 zile104Client4ClujStr. D456,860Thu, 12 Mar 150.0Thu, 12 Mar 1519,500 leiDA0.00.0104Client4ClujStr. D456,862Fri, 6 Mar 158 zileWed, 18 Mar 1512,505 leiDA0.00.0106Client6TimioaraStr. F456,864Thu, 8 Jan 153 zileTue, 13 Jan 158,706 leiDA0.00.0105Client5AradStr. E456,865Tue, 10 Feb 1517 zileThu, 5 Mar 1545,000 leiDA0.00.0103Client3BraovStr. C456,866Mon, 5 Jan 155 zileMon, 12 Jan 152,284 leiNU754 lei78 zile102Client2BucuretiStr. B456,867Tue, 10 Mar 157 zileThu, 19 Mar 15Mon 8 Nov 09DA0.00.0106Client6TimioaraStr. F456,868Wed, 4 Feb 150.0Wed, 4 Feb 15Sat 14 Apr 51NU4,027 lei55 zile105Client5AradStr. E456,869Mon, 23 Mar 159 zileFri, 3 Apr 15Fri 26 May 33NU0.00.0102Client2BucuretiStr. B456,870Wed, 25 Mar 1514 zileTue, 14 Apr 15Tue 18 Jun 40DA0.00.0107Client7BuzuStr. G456,871Tue, 31 Mar 156 zileWed, 8 Apr 15Tue 7 Oct 21NU0.00.0103Client3BraovStr. C456,863Tue, 31 Mar 1530 zileTue, 12 May 15Mon 4 Aug 53NU0.00.0
S se afieze lista facturilor emise n anul n care au fost emise cele mai multe facturi.
Tabel pivot 1TABELA PIVOT
Mirela Oancea: Tabela pivot este un instrument de sintetizare care
permite o analiz multidimensioal a elementelor dintr-o baz de date,
oferind faciliti avansate de permutare a informaiilor distribuite
pe linie i pe coloan n scopul obinerii unor situaii ct mai
semnificative pentru procesul de luare a deciziilor la nivelul unei
organizaii. Un avantaj important al tabelei pivot l constituie
elasticitatea pe care o ofer utilizatorului n momentul asocierii
cmpurilor bazei de date surs, fapt care permite regruparea i
prezentarea acestora ntr-un mod sintetic i ntr-o manier
interactiv.Tabela pivot permite crearea unui tablou de sintez n
care cmpurile unui tabel sau ale unei baze de date pot fi orientate
pe linie sau coloan, asupra datelor aplicndu-se funcii agregat de
nsumare, medie, minim, maxim etc.
Denumire societateTipul asigurariiNume si prenume asiguratLocalitatea asiguratuluiData asigurariiSuma asigurata (RON)Agent de asigurareASTRARCAVoicu D.Brasov22-October-20132500 Barbu I.ALFARCADinu R.Bucuresti6-August-20133000 Barbu I.UNITARCAPopa Al.Ploiesti16-July-201320000 Cristea M.Alliantz TiriacCASCOZecheru T.Constanta20-June-20134000 Barbu I.BCR AsigurariCASCORadu E.Constanta19-June-20134500 David P.ASTRACASCOAlexandru G.Ploiesti30-May-20135000 Oancea F.ALFAde bunuriIonescu R.Bucuresti1-March-201317000 Barbu I.UNITAde viataPanait I.Bucuresti15-February-20136000 Barbu I.Alliantz TiriacRCAGheorghe M.Brasov20-January-20136500 Cristea M.BCR Asiguraride viataStanciu C.Bucuresti3-January-20137000 Barbu I.ASTRACASCOEnescu F.Ploiesti15-December-20147500 David P.ALFAde bunuriSavu N.Constanta4-November-20148000 Oancea F.UNITAde bunuriNeagu B.Brasov4-November-201412000 Barbu I.Alliantz TiriacRCAFlorea L.Bucuresti1-September-20149000 Barbu I.BCR AsigurariCASCOManea S.Brasov13-July-20149500 Cristea M.ASTRAde viataPopescu S.Bucuresti16-April-201410000 Barbu I.ALFAde bunuriVoinea F.Brasov1-March-201410500 David P.UNITAde bunuriGanea I.Brasov7-February-201411000 Oancea F.Alliantz TiriacCASCOCalapod IBucuresti23-January-201411500 Barbu I.BCR Asiguraride bunuriTiganelea P.Brasov1-January-201412000 Barbu I.ASTRAde viataMihalache B.Campina16-March-201512500 Cristea M.ALFACASCORadulescu MBucuresti17-March-201513000 Barbu I.UNITAde viataRadulescu MBucuresti18-March-201513500 David P.Alliantz TiriacCASCOPurcareanu M.Ploiesti19-March-201514000 Oancea F.BCR Asiguraride bunuriTurcu V.Bucuresti16-March-201514500 Barbu I.ASTRARCAIonescu A.Bucuresti17-March-201515000 Barbu I.ALFARCAPopa V.Ploiesti18-March-201515500 Cristea M.UNITARCAAldea C.Constanta19-March-201516000 Barbu I.Alliantz TiriacCASCOHristea A.Brasov20-March-201516500 David P.BCR Asiguraride bunuriRadu G.Brasov21-March-201517000 Oancea F.Ex. 1: S se calculeze numrul de asigurri ncheiate pe tipuri de asigurri i ageni de asigurare, restricionnd afiarea datelor pe Localitate Asigurat.
FILTERS
Mirela Oancea: Genereaz un meniu derulant n partea superioar a
tabelei care permite selectarea elementelor ce vor restriciona
afiarea tabelei pivot, n raport de anumite rubrici ale bazei de
date.COLUMNS
Mirela Oancea: Aplic un format orizontal tabelei pivot, rezumnd
datele de la stnga la dreapta. n acest caz, elementele rubricii de
sintetizare vor fi plasate pe prima linie a tabelei
ROWS
Mirela Oancea: Aplic un format vertical tabelei pivot, rezumnd
datele de sus n jos, elementele rubricii de sintetizare fiind
afiate n prima coloan a tabelei pivot.S VALUES
Mirela Oancea: Permite definirea rubricilor asupra crora se vor
opera agregri i calcule sub form de totaluri, medii, numr de
elemente, minim, maxim etc., cu specificaia c funcia implicit setat
este cea de totalizare (funcia SUM). n plus, tabela pivot are
facilitatea de a permite operarea de calcule diferite asupra
acelorai elemente supuse sintetizrii.
Tabel pivot 2
Denumire societateTipul asigurariiNume si prenume asiguratLocalitatea asiguratuluiData asigurariiSuma asigurata (RON)Agent de asigurareASTRARCAVoicu D.Brasov22-October-20132500 Barbu I.ALFARCADinu R.Bucuresti6-August-20133000 Barbu I.UNITARCAPopa Al.Ploiesti16-July-201320000 Cristea M.Alliantz TiriacCASCOZecheru T.Constanta20-June-20134000 Barbu I.BCR AsigurariCASCORadu E.Constanta19-June-20134500 David P.ASTRACASCOAlexandru G.Ploiesti30-May-20135000 Oancea F.ALFAde bunuriIonescu R.Bucuresti1-March-201317000 Barbu I.UNITAde viataPanait I.Bucuresti15-February-20136000 Barbu I.Alliantz TiriacRCAGheorghe M.Brasov20-January-20136500 Cristea M.BCR Asiguraride viataStanciu C.Bucuresti3-January-20137000 Barbu I.ASTRACASCOEnescu F.Ploiesti15-December-20147500 David P.ALFAde bunuriSavu N.Constanta4-November-20148000 Oancea F.UNITAde bunuriNeagu B.Brasov4-November-201412000 Barbu I.Alliantz TiriacRCAFlorea L.Bucuresti1-September-20149000 Barbu I.BCR AsigurariCASCOManea S.Brasov13-July-20149500 Cristea M.ASTRAde viataPopescu S.Bucuresti16-April-201410000 Barbu I.ALFAde bunuriVoinea F.Brasov1-March-201410500 David P.UNITAde bunuriGanea I.Brasov7-February-201411000 Oancea F.Alliantz TiriacCASCOCalapod IBucuresti23-January-201411500 Barbu I.BCR Asiguraride bunuriTiganelea P.Brasov1-January-201412000 Barbu I.ASTRAde viataMihalache B.Campina16-March-201512500 Cristea M.ALFACASCORadulescu MBucuresti17-March-201513000 Barbu I.UNITAde viataRadulescu MBucuresti18-March-201513500 David P.Alliantz TiriacCASCOPurcareanu M.Ploiesti19-March-201514000 Oancea F.BCR Asiguraride bunuriTurcu V.Bucuresti16-March-201514500 Barbu I.ASTRARCAIonescu A.Bucuresti17-March-201515000 Barbu I.ALFARCAPopa V.Ploiesti18-March-201515500 Cristea M.UNITARCAAldea C.Constanta19-March-201516000 Barbu I.Alliantz TiriacCASCOHristea A.Brasov20-March-201516500 David P.BCR Asiguraride bunuriRadu G.Brasov21-March-201517000 Oancea F.Sintetizarea datelor prin regruparea acestora pe ani/ luni/ trimestre etc.Obs. Gruparea datelor nu este operaional direct n zona Filters.Ex. 2: S se afieze suma maxim asigurat, de fiecare agent la nivelul fiecrui an.Obs. Rezultatele vor fi restricionate interactiv n funcie de an.
Diagrama pivotDiagrama Pivot
Mirela Oancea: O alt modalitate de a obine i afia rapoarte de
sintez o reprezint construirea diagramelor pivot. Acest lucru este
realizat n Excel cu ajutorul comenzii Pivot Chart care poate fi din
tab-ul Insert grupul de opiuni Charts. Zona Ribbon va fi extins cu
o serie de comenzi de formatare i personalizare a diagramei pivot,
regrupate n taburile Analyze, Design i Format.Demersul aciunilor
este identic cu cel prezentat la tabela pivot, cu precizarea c, pe
lang raportul de sintez, se genereaz n mod automat i diagrama pivot
.
Denumire societateTipul asigurariiNume si prenume asiguratLocalitatea asiguratuluiData asigurariiSuma asigurata (RON)Agent de asigurareASTRARCAVoicu D.Brasov22-October-20132500 Barbu I.ALFARCADinu R.Bucuresti6-August-20133000 Barbu I.UNITARCAPopa Al.Ploiesti16-July-201320000 Cristea M.Alliantz TiriacCASCOZecheru T.Constanta20-June-20134000 Barbu I.BCR AsigurariCASCORadu E.Constanta19-June-20134500 David P.ASTRACASCOAlexandru G.Ploiesti30-May-20135000 Oancea F.ALFAde bunuriIonescu R.Bucuresti1-March-201317000 Barbu I.UNITAde viataPanait I.Bucuresti15-February-20136000 Barbu I.Alliantz TiriacRCAGheorghe M.Brasov20-January-20136500 Cristea M.BCR Asiguraride viataStanciu C.Bucuresti3-January-20137000 Barbu I.ASTRACASCOEnescu F.Ploiesti15-December-20147500 David P.ALFAde bunuriSavu N.Constanta4-November-20148000 Oancea F.UNITAde bunuriNeagu B.Brasov4-November-201412000 Barbu I.Alliantz TiriacRCAFlorea L.Bucuresti1-September-20149000 Barbu I.BCR AsigurariCASCOManea S.Brasov13-July-20149500 Cristea M.ASTRAde viataPopescu S.Bucuresti16-April-201410000 Barbu I.ALFAde bunuriVoinea F.Brasov1-March-201410500 David P.UNITAde bunuriGanea I.Brasov7-February-201411000 Oancea F.Alliantz TiriacCASCOCalapod IBucuresti23-January-201411500 Barbu I.BCR Asiguraride bunuriTiganelea P.Brasov1-January-201412000 Barbu I.ASTRAde viataMihalache B.Campina16-March-201512500 Cristea M.ALFACASCORadulescu MBucuresti17-March-201513000 Barbu I.UNITAde viataRadulescu MBucuresti18-March-201513500 David P.Alliantz TiriacCASCOPurcareanu M.Ploiesti19-March-201514000 Oancea F.BCR Asiguraride bunuriTurcu V.Bucuresti16-March-201514500 Barbu I.ASTRARCAIonescu A.Bucuresti17-March-201515000 Barbu I.ALFARCAPopa V.Ploiesti18-March-201515500 Cristea M.UNITARCAAldea C.Constanta19-March-201516000 Barbu I.Alliantz TiriacCASCOHristea A.Brasov20-March-201516500 David P.BCR Asiguraride bunuriRadu G.Brasov21-March-201517000 Oancea F.Ex. 3: S se reprezinte grafic volumul total al sumelor de asigurare ncheiate de ctre fiecare agent.
