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) 12 hours, 44 minutes 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) 5 days, 15 hours 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) 6 days, 23 hours 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) 1 week, 4 days 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) 1 week, 4 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, 1 day 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, 1 day 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 […]
Monday — We will wrap up ICA #4 – SQL Pen and Paper Query Exercise and start the slide deck SQL 1: Advanced Queries.
Wednesday — We will work on ICA #5 – SQL Part 1 (using MySQL Wor […]
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 […]
There is a bonus assignment about creating schemas. It is optional. This is worth an additional 1% toward your final grade, if you choose to do it.
Here are the instructions: Bonus Assignment – Creating Sc […]
Below is the agenda for Week 4.
Monday — We will work on In-Class Activity (ICA) #3 – Converting ERDs to schemas. It is due by Wednesday (9/20).
Wednesday — We will […]
- Load More