Below is the agenda for Week 6.
Tuesday — Exam 1
Thursday — Extract, Transform, Load (ETL); ICA #4: Excel Basics
Assignment #3 (SQL In) – I will […]
Jing Gong wrote a new post, February 23 – Giri Kumar Tayi to Present “Try-Before-You-Buy (TBYB): Online Retailing Strategy with Customer Self-Mending”, on the site MIS Distinguished Speaker Series 10 hours, 33 minutes ago
Try-Before-You-Buy (TBYB): Online Retailing Strategy with Customer Self-Mending
Giri Kumar Tayi
Professor of Management Science and Information Systems
School of Business, SUNY Albany
Friday, February […]
Time: Monday 02/19, 2:00 pm – 3:30 pm
Place: Alter 240D
This is the slide deck for Thursday’s review session: Review for Exam 1
Here is the Exam 1 Study Guide.
Here is the SQL Quick Reference 1 (a summary of all the queries we learned in Module 2 – SQL 1: Getting Information Out of a Database).
Note that advanced queries ( joins a […]
Jing Gong wrote a new post, Schedule changes for the following weeks (Assignment 2 deadline extended to Thursday 2/15 before class), on the site MIS2502 Data Analytics (Spring 2018) 1 week, 5 days ago
As you might have heard, the campus will be closed and classes will be canceled this Thursday (2/8). We will still have Exam 1 on Tuesday 2/20, but the rest of the class schedules will be adjusted […]
Jing Gong wrote a new post, Assignment #2: SQL Part 1 – Getting Data out of the Database (Deadline extended, Thursday, 2/15/2017, before class), on the site MIS2502 Data Analytics (Spring 2018) 2 weeks, 1 day ago
Here are the instructions: Assignment #2 – SQL Part 1. And here is the answer sheet: [Answer Sheet] (the same as page 4 of the assignment instruction).
[Updated] Due date: Thursday, 2/15/ […]
You might be interested to know how popular MySQL is in the real world. What companies are running MySQL? Well, the list is quite long (see a complete list of companies using MySQL here), but here are some […]
Below is the agenda for Week 4.
Tuesday — ICA #2.2 – SQL Out (using MySQL Workbench)
Please review 2.Supplement – MySQL and Workbench on your own.
And set up MySQL […]
Is That A Sugar High or High Sugar? Ask The Algorithm!
Associate Professor, Information Systems
Carey Business School, Johns Hopkins University
Friday, February 16, 2018
10:30 AM – n […]
There is a bonus credit assignment about creating schemas. It is optional. This is worth an additional 30% toward your Assignment #1 grade, if you choose to do it.
Here are the instructions: Bonus Credit […]
Below is the agenda for Week 3.
Tuesday — SQL 1 (Basic Queries); ICA #2.1 – Pen-and-paper SQL exercise
Please review 2.Supplement – MySQL and Workbench on your own. […]
We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around February 6, 2018.
(1) If you’re using your own computer (Windows or Mac), you’ll need to […]
Wikipedia: The Canary in the Coal Mine for Online Collaboration
Gerald C. Kane
Professor of Information Systems
Carroll School of Management, Boston College
Friday, February 2, 2018
10:30 AM – no […]
As Assignment 1 is due next Tuesday, 1/30, here are some additional resources to get help:
1. Our ITA Aaron Cheng will hold office hour on Monday 1/29, between noon and 1:00 pm, in Speakman 201F.
2. As […]
Examining the Impact of Ridehailing Services on Public Transit Use
Assistant Professor, Information & Decision Sciences
Carlson School of Management, University of Minnesota
Below is the agenda for Week 2.
Tuesday — More on ERDs (primary keys, relationships, cardinality); ICA #1.2 – Creating ERDs
Please watch the ERDPlus Tutorial video b […]
Jing Gong wrote a new post, Professional Achievement Point Requirement (MIS Majors Only), on the site MIS2502 Data Analytics (Spring 2018) 1 month ago
I have one quick update regarding professional achievement point which applies to MIS majors.
The MIS department has instituted a professional achievement point requirement for MIS majors. […]
Jing Gong wrote a new post, Assignment #1: ER Modeling (Due Tuesday, 1/30/2017 before class), on the site MIS2502 Data Analytics (Spring 2018) 1 month ago
Here are the instructions: Assignment #1 – ER Modeling
It is due Tuesday, 1/30/2017 before class.
You will need use ERDPlus to create your diagrams (which we will talk about soon). Do not hand draw grap […]
Jing Gong wrote a new post, Using ERDPlus to Creat Entity Relationship Diagrams (ERD), on the site MIS2502 Data Analytics (Spring 2018) 1 month ago
Starting from Thursday, January 18, we will learn how to create Entity Relationship diagrams (ERDs) to model databases.
To create ERDs, we will use ERDPlus, a free tool that is quite easy to […]
- Load More