Data Analysis and Visualization with Google Data Studio

As part of an Information Systems course a project was created to illustrate how Google Data Studio can play a role in improving the analysis and visualization of data. Often practitioners interact with data from already existing databases or datasets and need to make sense of them before analyzing, visualizing and gleaning insights from them. The dataset used in this case is retrieved from the w3schools learn SQL online course. A query is written to extract the data, and the data is imported to Google Sheets for visualization with Google Data studio. The process enables the identification of data anomalies, the analysis of trends, visualization of outliers and creation of additional data to gain further insights. This process reduces the time of analysis and provides students with insights on the life cycle of data analysis from business understanding, to data understanding and back to business understanding. Further, results that may be expected such as performance of employees, products or vendors is reviewed in more detail to gain further insights

Princípios de visualização de dados aplicados no software de gestão financeira Binfolio

Project Work presented as the partial requirement for obtaining a Master's degree in Information Management, specialization in Knowledge Management and Business IntelligenceA capacidade de análise e monotorização da informação é, atualmente, um dos focos principais das empresas. Propriedade da empresa portuguesa Novabase, o Binfolio é um software de Gestão Financeira utilizado por seguradoras, bancos, fundos de investimento e outras entidades gestores de património em Portugal para fazer a gestão das suas carteiras de investimento. Esta gestão implica a análise e monitorização de diversas métricas e indicadores sendo que a aplicação Binfolio é dotada de ferramentas para esse fim, estando povoado de um conjunto de interfaces gráficos e representações visuais. A partir da base teórica da temática de visualização de dados, este Trabalho de Projeto visa conferir a conformidade das representações visuais constantes no Binfolio com os princípios de visualização de dados. Adicionalmente, como aplicação prática dos conceitos retidos, foi construído um dashboard à luz dos princípios definidos que permitiu alargar o leque de ferramentas ao dispor na aplicação.The ability to analyze information is currently one of the companies' main focuses. Owned by technology company Novabase, Binfolio is a financial management software used by insurance companies, banks, investment funds and other entities managing wealth to manage their investment portfolios. That management implies the analysis and monitor of several crucial metrics and indicators and Binfolio application are endowed with tools for this purpose, being populated by a set of data visualization elements. Based on the theoretical basis of Data Visualization and Dashboards, this Project aims to verify the compliance of the data visualizations present in Binfolio with principles of data visualization defined a priori. In addition, a new data visualization was implemented in Binfolio, namely a dashboard, in the light of the defined principles that allowed to extend the range of tools available

Cognitive Foundations for Visual Analytics

In this report, we provide an overview of scientific/technical literature on information visualization and VA. Topics discussed include an update and overview of the extensive literature search conducted for this study, the nature and purpose of the field, major research thrusts, and scientific foundations. We review methodologies for evaluating and measuring the impact of VA technologies as well as taxonomies that have been proposed for various purposes to support the VA community. A cognitive science perspective underlies each of these discussions