Exploratory data analysis (EDA), data visualization, and visual analytics are essential for understanding and analyzing complex datasets. In this project, we explored these techniques and their applications in data analytics. The case discusses Tableau, a powerful data visualization tool, and Google BigQuery, a cloud-based data warehouse that…

In this article we discuss the use of RapidMiner, a data science software platform, in a Database Management Systems course. For further understanding of the database and the skill learned, students are given an assignment to complete, to not only use another software beside SQL Server Management Studio but also translate their findings in a more…

"Not only SQL" (NoSQL) databases have become widespread across organizations, enabling sophisticated, data-driven applications to be highly available, distributed, and cloud-based, such as e-commerce, social media, online multiplayer games, and video streaming. However, NoSQL is still sparsely found in MIS and analytics curricula. This…

Transparency is once again a central issue of debate across types of qualitative research. Work on how to conduct qualitative data analysis, on the other hand, walks us through the step-by-step process on how to code and understand the data we've collected. Although there are a few exceptions, less focus is on transparency regarding…

Beyond informing human resources (HR) policies and practices, information gleaned from predictive analytics, visualized via dashboards, can increase awareness and prompt employee and management actions based on identified variables often related to intent to leave and employee wellness. While considerable research, relevant measurements, and tools…

We have updated a version of the coordination geometry table of the d-block elements and their ions that Moore and co-workers presented in 1997. This table is constructed by searching and analyzing the data in the Cambridge Structural Database. In this updated version, we have also analyzed impact of ligands on the coordination geometry and…

OpenStax Kinetic is an innovative research infrastructure that aims to transform education and learning research in the digital age. With its access to large sample sizes, authentic learning environments, experimental control, scalability, security and privacy protection, Kinetic provides an unparalleled opportunity for researchers to study the…

Mass spectrometry is essential for large-scale protein identification in proteomics. By database searching of mass spectrometry data, it is possible to identify proteins without the need to interpret MS/MS spectra (de novo sequencing), which is time-consuming and not feasible as a systematic tool in proteomic analysis. Many authors have reported…

The SQL-Explore Learning Module detailed in this teaching tip provides an opportunity for students to apply database course knowledge beyond solving traditional pre-determined Structured Query Language (SQL) coding questions. In this unique constructivist activity using the apropos 5E Instructional Model, students explore tables to locate data…

This teaching case describes the functionality of a system employing IoT sensors to monitor part levels for a fictitious auto parts manufacturer. Data from the sensors are used to populate a centralized database and generate a dashboard for management. The system also generates tiered alerts to notify part runners and managers of pending part…

Secondary data analysis in educational research has been an established research method for many years. Yet, few publications outline the "how to" of undertaking the process. This paper presents an analysis framework suitable for undertaking secondary data analysis within the field of education. The framework is a modification and an…

The explosion in availability and variety of data requires learning experiences that reveal more of the data world faster and develop practical skills with digital technologies. Key high-level goals of the International Data Science in Schools Project (IDSSP) include having students continually immersed in the cycle of learning from data, and data…

Many small organizations sponsor events and activities that could benefit from the data management and reporting capabilities provided through a centralized database. However, many of those organizations do not have the budget to afford a commercial solution or an on-going subscription to a cloud-based solution for a small scope event with limited…

The "institutional databases audit" addresses common challenges of retention research by viewing existing databases and key surveys as resources for analyzing persistence rates. Such an audit helps verify whether student database elements have theoretically derived research referents. Positive results show that institutions can acquire…

Many introductory astronomy courses include concepts related to basic stellar properties. In general, these are concepts that originate from the human perception of starlight. This observational aspect is not easy to incorporate in the classroom. We explore if these concepts could be developed using the built-in data in a planetarium software.…