CyberText

Data Prep 1: Cuddly Stuffed Animals Single Stream

Price: $ 10.00

This case scenario involves sales of cuddly stuffed animals. It can be used for general business or accounting students. The case introduces students to essence of ETL software, extracting data from excel, transforming data and loading the results into excel. Students extract a sheet from an Excel workbook. They then transform the data; remove any blank rows, remove extra columns, change data types, rearrange the columns, check for data input errors, create new columns, change the position of columns, and export the modified file. Then the students load the file back into the Excel file and answer analytical questions related to their unique data. The case can be solved using Alteryx, Power BI or Tableau and a free mini tutorial and data set is available.

View chapter in pdf form

View chapter in ppt form

The book comes with a quizzing system, with each student being presented with a timed quiz comprising five questions selected at random from the database of quiz questions for the chapter. Instructors can assign these quizzes in advance of the topics to be covered in class, giving students an incentive to read the chapter in advance of the class. Students read the chapters and take the online quizzes prior to class.

Each chapter features hyperlinks to related information, taking advantage of the online nature of the book. Additionally, the chapters featuring Microsoft Access databases permit the databases to be downloaded by students for further exploration.

The following are some of the resources available for adopting instructors:

Solutions to end-of-chapter questions and problems
The ability to make selected solutions available to students
The ability to view all quiz questions for a chapter
The ability to generate quiz grade reports
Sample tests
Powerpoint files for each chapter

Videos Demo

Demos for this Book

Version 1 - Alteryx version (file extension .yxmd) Version 2 - Power BI version (file extension .pbix) Version 3 - Tableau Prep version (file extension .tflx)