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…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

"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…

Tracking and using data to inform decisions pays off for college success programs on multiple levels. Having data allows program staff to monitor the progress of individual students and tailor support to their particular needs. It enables staff to understand the effectiveness of program activities and make improvements as necessary. Most…

The purpose of this teaching case is to develop a hands-on exercise on graph processing using a hybrid system. The paper provides a background on graph databases and how graph processing is supported in a hybrid system, SAP HANA. It also details step-by-step instructions on how to create, modify, and process a graph database using SAP HANA. The…

Ahmedabad University has evolved a framework "ENABLE." Through ENABLE, concepts are taught from the context of real world. Industry projects are assigned to groups of students where they get engaged in real scenarios. Theoretical concepts are introduced as and when needed during the project implementation. Faculty serve as facilitators…

California's information about opportunities and outcomes in early learning and care, TK-12 schools, colleges, social services, and employment is currently disconnected. A longitudinal data system can be a powerful tool that allows California to identify bright spots, inequities, and roadblocks in our educational system, especially for students of…

The case provides a realistic scenario that can be used in a systems analysis and design, database development or graduate level management information systems course. The case focuses upon the development of an event management system for a small conference with participants and exhibitors. Multiple assignment options are provided allowing…

Planning for the sustainability of data system integration should be a fundamental part of the initial project plan. Taking a long-term view rather than a project-to-project approach improves the data culture and chances of success. The intent of this tip sheet is to identify key components, strategic timing, and planning considerations for…

Eleven states have worked with CIID, over the past three years, to integrate their IDEA data and to implement Generate, a software application that improves data quality and automates reporting through standardization. These eleven states have realized notable data quality improvements that will be shared in this brief to help states across the…

CIID has implemented Generate in 9 state education agencies (SEAs), and through this work SEAs have realized a variety of improvements to their special education data in terms of overall data quality, improvements to data governance structures, and ease of federal reporting. This brief is the second in a series looking at data quality. Here, we…

This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case…

While working in the Social and Emotional Support Services (SESS) for Montgomery County Public Schools in Maryland (MCPS), the author initiated a project to collect data on services to students with emotional needs. During the 2016-2017 school year, MCPS was the 17th largest school district in the country with nearly 160,000 students speaking 150…

High-quality data is essential when looking at student-level data, including data specifically focused on students with disabilities. For state education agencies (SEAs), it is critical to have a solid foundation for how data is collected and stored to achieve high-quality data. The process of integrating the Individuals with Disabilities…