Please fill in the Min-Semester Course Feedback Form as I mentioned last week. The purpose of this form is to gather feedback on your course learning experience so far. Based on this I will improve this course, […]
Monday (10/15) Principles of Data Visualization
Wednesday (10/17) ICA #6.1: Data Visualization Principles
Friday (10/19) ICA #6.2: Creating Infograph […]
Deadline: Wednesday, 10/17/2018, at 11:59 pm.
The assignment instruction is posted on the Assignment Page of the Community site (link).
Complete and submit the assignment as an Excel document (the co […]
Monday (10/8) Exam 1
Wednesday (10/10) Dimensional Data Modeling Overview
Friday (10/12) ICA #5: Pivot Tables in Excel
Monday (10/1) Extract, Transform, Load (ETL) (Slides Link)
Wednesday (10/3) ICA #4 – ETL – Excel Basics (Instructions Link)
Friday (10/5) Revi […]
Check out the following for the group project.
Zhi (Aaron) Cheng wrote a new post, About Assignment #2 (Due 9/28/18 (Tomorrow) before Class by 3 pm), on the site MIS 2502 Data Analytics (Fall 2018) 2 weeks, 5 days ago
If you do have technical issues (constant error reports, no results grid, etc.), do the following,
Finish writing all queries and save them in a SQL or document (.docx, .txt, …) file before actually running […]
I will hold an additional office hour on Friday, 12:30 pm to 1:30 pm.
Note the location is Alter 604F (a breakout room).
Please drop by if you have any questions about SQL queries, or Assignment […]
Submission deadlines for ICA #2.2 and Assignment #2 are extended.
See the following NEW due dates and times:
ICA #2.2: Wednesday, 9/26/18, 6:50 pm.
Assignment #2: Friday, 9/28/18, 3:00 pm (before the class).
Monday (9/24) ICA #2.2 – Working with SQL, part 1 (Retrieving information from the database)
Wednesday (9/26) Creating and updating the database (SQL CREATE, DROP […]
SQL advanced queries are the most difficult ones in this course.
If you want to master SQL, you need to pay more attention, take more efforts, and do more practices.
I attached the SQL queries examples […]
Here are the instructions: Assignment #2 – SQL Part 1.
And here is the answer sheet: [Answer Sheet].
Due date: Wednesday, 9/26/2018, 11:59 pm.
Complete and submit the answer sheet as a Word […]
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 4.
Getting Data out of a Database
Notes: Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL powerpoint […]
As Assignment 1 is due next Monday, 9/17, here are some additional resources to get help:
1. I hold regular office hours on Mondays and Wednesdays between 3:50 and 4:50 pm, in Speakman 201F. If you have a quick […]
Zhi (Aaron) Cheng wrote a new post, Setting up MySQL Workbench Before Week 4 (the week of 9/17), on the site MIS 2502 Data Analytics (Fall 2018) 1 month ago
We’ll be using MySQL Workbench to create and execute SQL queries (to interact with databases). That will start around September 19, 2018.
(1) If you’re using your own computer (Windows or Mac), you’ll need to […]
Zhi (Aaron) Cheng wrote a new post, Assignment #1: ER Modeling [Due Monday, 9/17/18 at 11:59 pm], on the site MIS 2502 Data Analytics (Fall 2018) 1 month, 1 week ago
Here are the instructions for Assignment#1: ER Modeling.
Use ERDPlus to complete the assignment.
You must submit a single Microsoft Word or PDF document (if you send multiple files, you will not get cre […]
Below is the agenda for Week 3.
Relational Data Modelling and ERD
ICA #1.2: Creating an entity relationship diagram (ERD)
Notes: In ICA #1.2, we will use […]
- Load More