?url_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Adc&rft.title=Sistema+de+BI+basado+en+datos+abiertos+para+el+an%C3%A1lisis+de+los+factores+demogr%C3%A1ficos+que+inciden+en+la+recogida+separada+de+residuos+en+el+municipio+de+Madrid&rft.creator=Ram%C3%ADrez+Ruiz%2C+David&rft.contributor=Alarc%C3%B3n+Cavero%2C+Pedro+Pablo&rft.subject=Computer+Science&rft.description=Una+de+las+tendencias+globales+que+contribuyen+al+crecimiento+insostenible+es+la+generaci%C3%B3n+de+ingentes+cantidades+de+residuos.+La+adecuada+gesti%C3%B3n+y+el+aprovechamiento+%C3%B3ptimo+de+los+residuos+urbanos+es+fundamental+para+el+desarrollo+sostenible+de+cualquier+ciudad+del+mundo.+Concretamente%2C+la+ciudad+de+Madrid+dispone+de+un+sistema+de+gesti%C3%B3n+de+residuos+de+los+m%C3%A1s+avanzados+y+completos+de+Europa.+El+principal+objetivo+de+este+proyecto+es+crear+una+soluci%C3%B3n+de+inteligencia+de+negocio+o+Business+Intelligence+que+aporte+conocimiento+detallado+sobre+los+factores+demogr%C3%A1ficos+y+de+recogida+de+residuos+que+permita+apoyar+la+toma+de+decisiones+en+la+gesti%C3%B3n+de+la+recogida+de+los+residuos+urbanos+en+la+ciudad+de+Madrid.+Para+ello%2C+se+ha+dise%C3%B1ado+e+implementado+un+sistema+de+an%C3%A1lisis+de+datos+basado+en+herramientas+de+software+libre+y+datos+abiertos+formado+por+cinco+capas%3A+Fuentes+de+datos%2C+Transformaci%C3%B3n%2C+Almacenamiento%2C+Explotaci%C3%B3n+y+Visualizaci%C3%B3n+de+datos.+La+primera+capa+comprende+el+proceso+de+b%C3%BAsqueda+e+investigaci%C3%B3n+de+datasets.+Mediante+este+proceso+se+seleccionaron+los+datasets+del+Portal+de+Datos+Abiertos+del+Ayuntamiento+de+Madrid+correspondientes+a+las+toneladas+de+residuos+recogidas%2C+divisiones+administrativas+a+nivel+distrito%2C+padr%C3%B3n+municipal+y+la+distribuci%C3%B3n+de+contenedores+de+residuos+y+puntos+limpios+de+la+ciudad+de+Madrid.+En+cuanto+a+la+transformaci%C3%B3n+de+los+datos+de+entrada%2C+se+han+creado+algoritmos+que+se+encargan+de+aplicar+los+procesos+ETL+(extract%2C+load+and+transform)+para+recopilar%2C+procesar+y+extraer+valor+de+las+distintas+fuentes+de+datos.+El+resultado+de+dichas+transformaciones+se+almacena+en+un+Data+Warehouse+cuyo+dise%C3%B1o+e+implementaci%C3%B3n+se+comprende+en+la+capa+de+Almacenamiento%2C+donde+se+modela+mediante+varios+diagramas+su+composici%C3%B3n+y+la+organizaci%C3%B3n+de+las+tablas+que+lo+forman.+A+lo+largo+de+la+capa+de+Explotaci%C3%B3n+de+datos%2C+se+realizan+consultas+para+crear+vistas+de+tablas+con+contenido+filtrado%2C+reordenado%2C+combinado+o+simplificado.+Adem%C3%A1s%2C+se+les+a%C3%B1aden+m%C3%A9tricas+o+indicadores+de+desempe%C3%B1o+(KPIs)+calculados+para+evaluar+ciertos+aspectos+relevantes+de+los+datos+con+los+que+extraer+informaci%C3%B3n+detallada.+Finalmente%2C+en+la+%C3%BAltima+capa+del+sistema%2C+se+ha+creado+un+Reporting+Dashboard%2C+una+interfaz+gr%C3%A1fica+de+visualizaci%C3%B3n+de+datos+que+permite+presentar+de+forma+interactiva%2C+clara+e+intuitiva+la+informaci%C3%B3n+y+los+KPIs+relevantes+del+an%C3%A1lisis+para+facilitar+su+interpretaci%C3%B3n+y+extraer+conclusiones.+Por+%C3%BAltimo%2C+el+desarrollo+de+este+proyecto+ha+sido+concebido+para+poner+en+pr%C3%A1ctica+todos+los+conocimientos+adquiridos+y+habilidades+aprendidas+durante+el+grado.+Adem%C3%A1s%2C+se+ha+querido+poner+en+valor+la+importancia+de+la+gesti%C3%B3n+de+residuos+en+una+de+las+ciudades+m%C3%A1s+pobladas+de+Europa%2C+para+proteger+as%C3%AD+el+medio+ambiente+y+la+salud+de+las+generaciones+presentes+y+futuras.+%0D%0AAbstract%3A%0D%0AOne+of+the+global+trends+that+contribute+to+unsustainable+growth+is+the+generation+of+huge+amounts+of+waste.+The+proper+management+and+optimal+use+of+urban+waste+is+essential+for+the+sustainable+development+of+any+city+in+the+world.+In+particular%2C+the+city+of+Madrid+has+one+of+the+most+advanced+and+complete+waste+management+systems+in+Europe.+The+main+objective+of+this+project+is+to+develop+a+Business+Intelligence+solution+that+provides+detailed+knowledge+on+demographic+and+waste+collection+factors+that+will+support+decision-making+in+the+management+of+urban+waste+collection+in+the+municipality+of+Madrid.+For+that+purpose%2C+a+data+analysis+system+has+been+designed+and+implemented+based+on+free+software+tools+and+open+data.+It+consists+of+five+layers+or+modules%3A+Data+Sources%2C+Transformation%2C+Storage%2C+Exploitation+and+Data+Visualization.+The+first+layer+comprises+the+dataset+searching+and+investigation+processes.+This+led+to+the+selection+of+the+datasets+from+the+Open+Data+Portal+of+the+Madrid+City+Council+corresponding+to+the+tons+of+urban+waste+collected+within+the+municipality%2C+its+administrative+divisions%2C+municipal+register+data+and+the+distribution+of+waste+collection+points+in+the+city.%0D%0ARegarding+the+transformation+of+input+data%2C+some+algorithms+have+been+created+to+apply+ETL+processes+(Extract%2C+Load+and+Transform)+to+collect%2C+process+and+extract+value+from+the+different+data+sources.+The+result+of+this+transformations+is+stored+in+a+Data+Warehouse+whose+design+and+implementation+are+comprised+in+the+Storage+layer%2C+where+its+composition+and+organization+of+the+tables+that+form+it+are+modelled+using+diagrams.%0D%0AThroughout+the+Data+Exploitation+layer%2C+there+were+made+queries+to+create+table+views+with+filtered%2C+rearranged%2C+combined+or+simplified+content.+In+addition%2C+metrics+or+KPIs+(Key+Performance+Indicators)+were+added+to+evaluate+certain+aspects+of+the+data+and+to+extract+detailed+information.+Finally%2C+in+the+last+module+of+the+system%2C+a+Reporting+Dashboard+has+been+created.+It+is+a+graphical+data+visualization+interface+that+allows+the+information+and+relevant+KPIs+to+be+presented+interactively%2C+clearly+and+intuitively+to+facilitate+their+interpretation+and+to+draw+conclusions.+In+conclusion%2C+the+development+of+this+project+has+been+conceived+to+put+into+practice+all+the+skills+and+knowledge+acquired+during+the+university+degree.+Moreover%2C+it+has+been+developed+to+emphasize+the+importance+of+waste+management+in+one+of+the+most+populated+cities+in+Europe%2C+in+order+to+protect+the+environment+and+the+health+of+present+and+future+generations.&rft.publisher=E.T.S.I+de+Sistemas+Inform%C3%83%C2%A1ticos+(UPM)&rft.rights=https%3A%2F%2Fcreativecommons.org%2Flicenses%2Fby-nc-nd%2F3.0%2Fes%2F&rft.date=2020&rft.type=info%3Aeu-repo%2Fsemantics%2FbachelorThesis&rft.type=Final+Project&rft.type=PeerReviewed&rft.format=application%2Fpdf&rft.language=spa&rft.format=application%2Fzip&rft.language=spa&rft.coverage=east%3D-3.7035825%3B+north%3D40.4167047%3B+name%3DMadrid%2C+Madrid%2C+Comunidad+de+Madrid%2C+Espa%C3%B1a&rft.rights=info%3Aeu-repo%2Fsemantics%2FrestrictedAccess&rft.identifier=https%3A%2F%2Foa.upm.es%2F64248%2F