ISQS 6339 Exercises

 

If not specified for a hard copy,

Please direct your electronic submissions of exercises to the Blackboard system

 

No:

Exercise Contents

Due

BigData-EX3

Install a copy of Hadoop onto a personal computer (individual assignment)

BigData-EX2

Teams will meet the instructor at least a week before the scheduled presentation for 1-2 hours. Every team member must talk to the instructor in the meeting and answer questions.

 

Each team MUST install Hadoop system for the project. Any technical questions can be referred to Rashid & Anagha (they were in the Hadoop Core Task Force (HCTF) in 2014).

 

Deliverables:

 

Before the presentation

1. Three questions/answers for classmates to review.

2. Reference materials

 

After presentation

3. Demonstration videos

4. Slides

5. Software resource information

A week before the presentation

BigData-EX1

1.     Based on the assignment of collaborative study in Hadoop architecture components, each team provides the following information in a report of 4-6 pages.

         A general description of the topic of the assignment, regarding the functions of the sub-system.

         The outline of each component in the sub-system.

         The outline of your presentation in the schedule.

         A cover page, and some references.

         In addition to what you learned from the presentations, you may add in your comments and market research outcomes to enrich the report.

2.     Each team only needs to submit one copy of the report.

 

Written Report each team

EG-EX4

SAS Enterprise Guide (4)

 

In-class exercises:

         Chapter 2 ANOVA

         Chapter 3 Regression

 

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX4a, <last name>

 

Take-home exercise:

a.     EGBS P2-85, Chapter 2, Exercise 3

b.    EGBS P3-117, Chapter 3, Exercise 5 and 6

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX4b, <last name>

Optional exercises

EG-EX3

SAS Enterprise Guide (3)

 

In-class exercises:

1.     P 5-9 to 5-14 Summarizing Data

2.     P 5-37 to 5-47 Creating a Tabular Summary Report

3.     P 5-53 to 5-59 Creating a Bar Chart

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX3a, <last name>

 

Take-home exercise:

P5-70 to 5-76, Chapter 5 Exercise 1, 3-5 (Skip the creating format part)

 

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX3b, <last name>

Take-home exercises

EG-EX2

SAS Enterprise Guide (2)

 

In-class exercises:

1.     P 4-17 to 4-23 Selecting Columns and Filtering Rows

2.     P 4-27 to 4-29 Creating a Column with an Expression

3.     P 4-37 to 4-43 Creating a New Column by Recoding Values

4.     P 4-51 to 4-56 Joining Tables

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX2a, <last name>

 

Take-home exercise:

P4-68 to 4-71, Chapter 4 Exercise 1-5

 

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX2b, <last name>

Take-home exercises

EG-EX1

SAS Enterprise Guide (1)

 

In-class exercises:

1.     P 2-29 to 2-36 Adding Data from a Fixed-Width Text File

2.     P 3-13 to 3-19 Creating a listing report

3.     P 3-26 to 3-30 Generating a One-Way Frequency Report

4.     P 3-35 to 3-37 Creating a Two-Way Frequency Report

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX1a, <last name>

 

Take-home exercise:

a.     p2-51, Chapter 2 Exercises

  1. p3-49 to 3-52, Chapter 3 Exercise 1, 2, 3, 4, and 5

Submit the screenshots of the results by email to ISQS6347@gmail.com, subject: ISQS 6339 EG EX1b, <last name>

Take-home exercises

EX7

Customizing a cube

 

         Project name: MMMCube2014_lastname

         Tasks

o    Deploying and processing the cube created

o    Define and debug calculations

o    Define KPIs

         Deliverable:

o    Screenshot of the successful deployment

o    Screenshot of the results from the cube: calculated measures, KPIs, and drill down/up results.

Demons

 

Due: 4/20

EX6

Creating an OLAP cube

 

         Project name: MMMCube2014_lastname

         Tasks

o    Add in new date items (year, quarter, and month) to two fact tables

o    Create time dimension using Manufacturing Fact table

o    Define calculated measures (Total Products, Percent Rejected)

o    Define hierarchies of attributes in dimension tables

o    Create a cube from the MaxMinManufacturing data mart with hierarchical date dimension

         Deliverable:

o    Screenshots: dimension hierarchies, dimensions, relationships of facts and dimensions, deployment result, format of measures, and browsing results.

Demons

 

Due 4/18

EX5

Populating Maximum Miniatures Manufacturing Fact Tables

 

Guidelines: http://zlin.ba.ttu.edu/BI/Exercise%205%20Instructions.htm

Demons

 

Due: 4/13

EX4

Populating Maximum Miniatures Manufacturing Dimension Tables

 

Guidelines: http://zlin.ba.ttu.edu/BI/Exercise%204%20Instructions.htm

Demons

 

Due 4/11

EX3

Creating a data mart with SSAS

 

         Learning Objectives

o    Learn an alternative way to create a data mart

o    How to deploy a data mart

         Tasks:

o    Create data mart ISQS6339MaxMinSalesDM<year>_yourname with BIDS from a cube template

o    Deploy the data mart

         Deliverable:

o    The printout of the screenshot of the cube structure and the success of the deployment

 

         Reference: pp119-130 in textbook DW.

q  You need to create a new database ISQS6339MaxMinSales2013_yourname. Then check the instructions in pdf files: MaxMinSalesDM (not complete) in \Docs of the shared network drive.

 

Measures in the fact table:

Measure Name

Measure group

Data type

Sales in Dollars

Sales Information

Currency

Sales in Units

Sales Information

Integer

Sales Tax

Sales Information

Currency

Shipping

Sales Information

Currency

 

Dimension tables:

Customer, Product, Promotion, SalesPerson (SCD), Store

For manually added columns, see file MaxMinSalesDM_more.pdf in \Docs in the shared network drive for the class.

 

Due: 4/6

EX2

Creating a data mart with SSMS

 

         Learning Objectives

o    How to design a dimensional model

o    How to create a data mart with SSMS

o    How to create a cube for a data mart.

 

         Tasks

o    Manually create the fact table and DimProduct table using SSMS (see the detailed information from file DW_MMM.PDF in the shared directory under \Docs)

o    Import remaining tables from oredb.lin.mmm.empty

o    Define the primary keys of tables and the relationships among them

o    Create a cube

 

         The primary key of the fact table is composed of three foreign keys plus one time dimension key: ProductCode, BatchNumber, MachineNumber, and DateOfManufacture. See DW_MMM in \Docs in the shared network drive for the class.

 

         Deliverable:

o    The printout of the screenshot of the cube structure

 

Due: 4/4

EX1

Walk through data warehousing process

 

         Learning Objectives

o    To gain a general impression how to use SQL Server 2008 to implement a data mart

         Tasks

o    Create your database with SSMS, named as ISQS6339_lastname

o    Import data from Commrex_2011.xls

o    Use SSMS to create a ERD diagram

o    Create a SSAS project using BIDS

o    Define data source, data source view, and cube

 

         Deliverable:

o    One-page printout of the screenshot of the cube diagram

 

Due: 3/30