Jing Gong wrote a new post, Need Extra Credit? Or Professional Achievement Points? Read on…, on the site MIS2502: Data Analytics (Spring 2017) 5 months, 1 week ago
If you’re an MIS major you need Professional Achievement Points. And everybody likes extra credit.
So see instructions for this Bonus Assignment: MIS2502 Extra Credit and PAP Assignment
Do a write-up o […]
Here is the assignment instructions and an answer sheet to submit (in Word format).
Here is the data file you’ll need BankLoan.csv. (Right click to download the file. Make sure that the name doesn’t cha […]
Dear R experts,
While working on Assignment #6, you may experience errors. In order to at least run the script without error messages, you often have to “debug” to fix the errors.
Here is a list of […]
Update as of 4/4/2017 at 4:46 pm: I made a small change to the assignment instructions. Step 2 on Page 2 is slightly modified. (That is, you do not need to add a “#” sign before line 66 as said in the previous […]
What companies use R for data analysis? Check the list compiled by listendata.com. Here are some examples:
Facebook – For behavior analysis related to status updates and profile pictures.
Google – For […]
I got quite some questions related to Q4 and Q5 of Assignment #5, both of which ask you to create a pivot table first, and then use the excel AVERAGE function in a separate cell outside the pivot […]
If you plan to use your own laptop for in-class activities, please set up R and RStudio on your computer before Thursday’s class. The instructions are available here: Setting up R and RStudio
Here is the Exam 2 Study Guide.
Remember, there will be an in-class review session on March 28. The exam is March 30 during class time.
Here are the instructions: Assignment #5 – Pivot Tables
You will need this VandelaySales2013.xlsx file to complete the assignment.
It is due 3/23/2017, 11:59 pm.
Please submit a word or pdf file on Bl […]
Here is the assignment: Assignment #4 – ETL
And here is the Excel workbook you’ll need to complete the assignment: ETL Workbook.xlsx
This assignment is due by Thursday, March 9, 11:59 pm.
See instructions here: Assignment #3: SQL Part 2
For this assignment, you will need to use MySQL Workbench to finish building the contact management database for MarketCo that you started during ICA #6. […]
Jing Gong wrote a new post, Additional Practice Problems (ERD, Schema, Advanced SQL), on the site MIS2502: Data Analytics (Spring 2017) 7 months, 1 week 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 […]
Jing Gong wrote a new post, On Monetary Incentives, Online Product Reviews, and Sales, on the site Jing Gong 7 months, 2 weeks ago
On Monetary Incentives, Online Product Reviews, and Sales (with Shuting Wang and Paul Pavlou), International Conference on Information Systems (ICIS), Dublin, Ireland, December 2016.
Perils of Uncertainty? The Impact of Contextual Ambiguity on Search Advertising Keyword Performance (with Vibhanshu Abhishek and Beibei Li), International Conference on Information Systems (ICIS), Auckland, New […]
Jing Gong wrote a new post, Substitution or Promotion? The Impact of Price Discounts on Cross-Channel Sales of Digital Movies, on the site Jing Gong 7 months, 2 weeks ago
Gong, Jing, Michael D. Smith, and Rahul Telang. (2015). Substitution or Promotion? The Impact of Price Discounts on Cross-Channel Sales of Digital Movies. Journal of Retailing, 91(2), 343-357.
Here is the Exam 1 Study Guide.
Remember, there will be an in-class review session on February 16. The exam is February 21 during class time.
I just found an interesting research paper analyzing the effect of Super Bowl ads on movie box office sales: Super returns to Super Bowl ads? (by Seth Stephens-Davidowitz, Hal Varian and M […]
Here are the instructions: Assignment #2 – SQL Part 1
Due date: Tuesday, 2/14/2017, 11:59 pm.
Submit your solution as a word or PDF document through Blackboard. You will need to use MySQL Workbench to […]
I have corrected the dates for the exams in the updated syllabus [as of 1.26]. They were right in the tentative schedule (pages 6-7) but wrong in the “Exams” section (page 2). The correct dates are:
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 S […]
- Load More