ISQS 3358 Exercises

 

Use the blackboard system to submit the exercises.

 

No:

Exercise Contents

Due

BD-EX3

Getting started with Tableau (II)

 

Using term project data to produce the charts for the term project report.

Due: 12/09

(Included in the term project report)

BD-EX2

Getting started with Tableau (I)

 

Using dataset Products, Orders, and Suppliers to walk through Tableau.

 

Due: 12/01

BD-EX1

Download and install Tableau community version

Web address : https://public.tableau.com/en-us/s/download

Explore features of Tableau using the cases in EG-EX1

1.     How to connect to a text file and modify the header

2.     How to access an Excel file

3.     How to open a SAS dataset

4.     How to analyze the data.

Here are the samples.

Due: 11/29

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

 

Submission: One page printout for the final results.

 

Take-home exercise:

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

 

Submission : Compile the screenshots in a Word file and upload it to the Blackboard. The file name should be “EG-EX3-lastname”

 11/26

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

 

Submission: One page printout for the final results.

 

Take-home exercise:

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

 

Submission : Compile the screenshots in a Word file and upload it to the Blackboard. The file name should be “EG-EX2-lastname”

11/15

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

 

Submission: One page printout for the final results.

 

Take-home exercise:

a.     p2-51, Chapter 2 Exercises

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

Compile the screenshots in a Word file and upload it to the Blackboard. The file name should be “EG-EX1-lastname”.

In-class exercises:

11/08

 

Take-home exercises:

11/10

 

 

 

Ex8 (ETL review)

10/27

Update Database: http://zlin.ba.ttu.edu/BI/Updating_database.htm

11/10

Optional

EX7

10/25

Customizing a cube

 

·         Project name: Based on the same project created for EX6

·         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.

 

11/03

EX6

10/18

Creating an OLAP cube

 

·         Project name: ISQS3358-EX6-2016fall-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.

 

10/27

EX5

10/13

Populating Maximum Miniatures Manufacturing Fact Tables

 

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

 

10/20

EX4

10/04

Populating Maximum Miniatures Manufacturing Dimension Tables

 

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

 

10/13

EX3

9/27

Creating a data mart with SSMS

 

·         Learning Objectives

o    How to design a dimensional model

o    How to create a data mart with SSMS.

 

·         Tasks

o    In SSMS, manually create the fact table and DimProduct table using SSMS (see the detailed information from file DW_MMM.PDF in the shared directory under ~\references)

o    Import remaining tables from lin.mmm.empty to your own database

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

o    Create a ERD diagram with SSMS

o    In BIDS, use analytic services to 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.pdf in ~\Downloaded data\Docs in the shared network drive for the class.

 

·         Deliverable:

o    The printout of the screenshot of the cube structure

 

10/04

EX2

9/20

Get familiar with a data mart with BIDS

 

·         Learning Objective

o    Getting familiar with the features of BIDS

o    Understand how a data mart works

 

·         Tasks

o    Explore the IMW data mart

·         Deliverable:

o    One-page printout of the screenshot of the cube drilling.

 

9/27

EX1

9/13

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 ISQS3358-2016Fall-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

 

9/20

EX0

Warming up with Citrix

 

·         Install Citrix (Citrix1, Citrix2). This is mandatory.

·         Install SQL Server 2012/2014 (video & Slides). This is optional.

·         Create and test Database WPC

q  \\Techshare\coba\d\isqs3358\isqs3348\Exercises\DBC-e07-WPC-Scripts

q   http://zlin.ba.ttu.edu/3358/WPCExercises.docx

 

Deliverable: None

 

 

9/06