Date/Time: October 24 (Tuesday), 3:30 pm – 4:30 pm
Location: Alter 240A (Breakout room)
In case you’d like some resources to learn Excel and as help for Assignment #4, here are some links for video tutorials on text manipulation (e.g., CONCATENATION), VLOOKUP, and Pivot Tables. You will need to log […]
I got quite some questions related to Part 4, Question (b) of Assignment #4, which asks you to create a pivot table first, and then use the excel AVERAGE function in a separate cell outside the pivot […]
I will be out of town on 10/23 (Monday). We will not meet in class. Instead, please review this slide deck: 9. Supplement – Basic Statistics on your own.For 10/25 (Wednesday), we will meet as usual.
Jing Gong wrote a new post, Download the latest version of Office (Windows or Mac), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 4 days, 17 hours ago
We will use Excel to create Pivot tables this week. Note that if you have an earlier Mac version, some of the options may not be available. If so, download the latest Mac version of Microsoft Office for free by […]
Here is the assignment: Assignment #4 – ETL and Pivot Tables in Excel
And here is the Excel workbook you’ll need to complete the assignment: ETL Workbook.xlsx
This assignment is due by Wednesday, 10/25 […]
Monday — Extract, Transform, Load (ETL) and some Excel basics
Please review the supplementary materials: Excel Basics, on your own
Wednesday — Dimensional Data Modeling: Ove […]
Jing Gong wrote a new post, Nathan’s Office Hour for Assignment 3 (Friday 3:00-4:00 pm), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 1 week, 2 days ago
Time: 3:00 pm – 4:00 pm on Friday (10/13)
Location: Alter 240B
Jing Gong wrote a new post, Group Project: Data Visualization and the QVC Analytics Challenge (due by 10/31 at 11:59 pm), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 1 week, 4 days ago
Here are the assignment instructions: Group Project – Data Visualization [f17].
The group project (for the course) is due October 31, at 11:59 pm.
You can work in teams of up to four people.
For each g […]
1. To start Assignment 3, you need to complete ICA #6 first. Want to check if you did ICA #6 correctly? Take a look at the solution key that I posted under Course Materials. If you had any mistake in your […]
Monday — Exam 1.
Wednesday — we will cover the slide deck on data visualization.
Friday — we will work on ICA #7 (Data Visualization), and start a new slide deck on Extract, Trans […]
Jing Gong wrote a new post, Office Hour on Monday 10/09 Moved to 11:00 am-12:00 pm, on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 2 weeks, 1 day ago
In case you need help before Exam 1, I will move my office hour on Monday (10/9) to 11:00 am -12:00 pm. If you have questions for Exam 1, feel free to stop by SP 201C.
Download here: Review for Exam 1
Jing Gong wrote a new post, Assignment #3: SQL Part 2 – Putting Information into a Database (Due Friday, 10/13/2017, 11:59 pm), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 2 weeks, 2 days ago
See instructions here: Assignment #3: SQL Part 2
It’s due on Friday, 10/13/2017, 11:59 pm. Please submit your assignment on Blackboard.
For this assignment, you will need to use MySQL Workbench to finish bu […]
Jing Gong wrote a new post, Additional Practice Problems (ERD, Schema, Advanced SQL), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 2 weeks, 5 days ago
Some students mentioned that they would like to practice on ERD/schema/SQL questions.
Here is an additional ERD and Schema exercise for practice: Additional ERD and Schema Exercise
Here are some additional […]
Monday — We will start a new topic on SQL Part 2 – Putting information into a database.
Wednesday — We will work on ICA #6 – SQL Part 2 (Putting information into a database).
A few students have experienced issues with using computers at Tech Center, when trying to use MySQL Workbench. It seems that they cannot connect to the database server with Tech Center computers because of […]
UPDATE: Due to a schedule change, Nathan will have to move his office hour to Wednesday morning. Below are the updated time and location.
Time: 8:00 am – 9:30 am on Wednesday (10/4)
Location: Alter 236B (Breakout room)
Here is the Exam 1 Study Guide.
Remember, the exam is on Monday, 10/9/2017 during class time. There will be an in-class review session on Friday, 10/6/2017.
Jing Gong wrote a new post, Assignment #2: SQL Part 1 – Getting Data out of the Database (Due Wednesday, 10/4/2017, 11:59 pm), on the site MIS2502: DATA ANALYTICS (FALL 2017, SECTION 002) 3 weeks, 5 days ago
Here are the instructions: Assignment #2 – SQL Part 1
Due date: Wednesday, 10/4/2017, 11:59 pm.
Complete and submit the answer sheet on page 4 as a word or PDF document through Blackboard. You will need to […]
- Load More