SIG ED - IS in Education, IS Curriculum, Education and Teaching Cases

Loading...

Media is loading
 

Paper Type

ERF

Paper Number

1667

Description

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.

Comments

SIG ED

Download

Share

COinS
 
Aug 10th, 12:00 AM

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.

When commenting on articles, please be friendly, welcoming, respectful and abide by the AIS eLibrary Discussion Thread Code of Conduct posted here.