This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with…

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…

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…

Many traditional Information Systems (IS) programs are either redesigning current courses to incorporate business/data analytics or expanding curricular offerings to include business /data analytics; our IS program chose the former route to meet the demand (from employers) for business/data analytics. In that transition, a traditional systems…

Advanced Competition Simulations (ACS), a massive multiplayer online (MMO) strategy gaming company, has petabytes of customer data at their data center in Brentwood, Tennessee that could assist executives with decision making, but they currently do not have business intelligence software or a business intelligence and analytics (BIA) team. As is…

From their presence on social media sites to in-house application data files, the amount of data that companies, governments, individuals, and sensors generate is overwhelming. The growth of Big Data in both consumer and enterprise activities has caused educators to consider options for including Big Data in the Information Systems curriculum.…

No individual subject area in IS 2002 impacts more aspects of computing theory or professional preparation than data modeling. For more than four decades the bedrock of data modeling has been the relational data model. There are numerous extensions, variations and implementations of this theory but its core remains the central anchor in the…