@yang-yang
Active 13 years, 4 months ago-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 7 months ago
RAW= your mid-term raw score (full score is 100) Extra = your extra mid-term score (full score is 100). Your final mid-term score = RAW + 5 + (Extra – RAW)*(100-RAW)/150 Two rules are made to make sure it is fair to those students who didn’t take extra project: If your Extra is lower than your RAW, only […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 8 months ago
Click Final Exam Study Guide to download Schedule: May 10th 2011, Speakman Hall 114, 10:30 am – 11:30 am Format: (1) Conceptual Q&A, (2) Multiple choices, (3) Data Analytics Here is a practice exam (with answer key), which is similar in format: MIS2502003 Final exam practice MIS2502003 Practice Final – answer keys Please practice and grade it with answer […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 8 months ago
Some Collective Intelligence Thoughts Case Study Homework: Your team will analyze the “Decisions 2.0: The Power of Collective Intelligence” article and answer 5 questions below http://people.icoserver.com/users/eric/SMR_Collective_Decisions.pdf . Decision making can be divided into two tasks: the generation of potential solutions and the evaluation of potential solutions. Describe how each of those tasks can be negatively influenced by numerous human biases. Can the human biases […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 8 months ago
You need to finish this lab and answer the inside questions. A hard copy deliverable is required by April 21st (Thursday).
Solution: Regression-Lab-solutions
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 8 months ago
Regression is a basic and important modeling technique for analyzing the data variance and predicting the future event.
Click here to download the slides for: Regression Instruction
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 8 months ago
For Tuesday, we will do an exercise of data clustering and profile segmentation. Exercise: Exercise of Clustering and Segmentation Answer: Answer for Exercise of Clustering and Segmentation For Thursday, we will learn how to find the relationships between “Beer and Napies” Instruction: Association Rules or Market Basket Analysis Exercise: Exercise of Association Rules Answer: Answer for Exercise of Association Rules […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
SAS Enterprise Entrance: https://support.sas.com/ctx3/sodareg/index.html?execution=e2s1 Instruction of using SAS Enterprise Miner to do data sourcing and exploration: Accessing and Assaying Prepared Data Please note that this manual was for SAS Enterprise Miner 6.1, but we are using 6.2. There are two big differences: (1) we don’t have to create local folder in 6.2. So you can skip the […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
On Tuesday we will learn some basic theory of data mining, and learn how to create an account to use SAS data mining services.
Click here for introduction slides. Click Here to learn how to create SAS miner Account
Advanced textbook for using SAS miner:
http://proquest.safaribooksonline.com.libproxy.temple.edu/book/databases/sas/9781590478295
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
Here is a textbook which was used for teaching by MIS textbook. Although it was for ORACLE database, the content is the same for ERD and SQL parts. Check it out here: DBMS textbook
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
You need submit everything before Apr. 3 midnight 11:59 pm by Email, including your ERD, scenario description. Besides, you also need to create the database, tables and several records to your SQL workspace. Project Description It is an optional project for extra 10 points. 1. Create a detailed scenario from any of following topics: (1) Amazon product review system […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 9 months ago
Welcome back from spring break and I hope you have had a great time. For this week, we will start a new journey of business data analytics: OLAP and Data mining entry. For Tuesday, we will cover basic concepts of OLAP and do some practice in class. Related slides are here: Week-8-1 OLAP-Intro Week-8-2-PivotTable Data for case1: retail_sales_feb1 Data […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
Click HERE to download the slides for mid-term review.
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
Click Week-6-1-ERD-SQL-Exercise for slides.
SQL tutorial site: http://www.w3schools.com/sql/
Practice interface: http://class1.mis.temple.edu/dbclass.php
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
Intro to Join and Alias: Week-5-2-SQL-ALIAS-JOIN
Lab Practice:
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
Introduction to basic SQL
SELECT, INSERT, UPDATE, and DELETE
For the class presentation material and exercise questions, click HERE
Lab practice 1: MIS2502_Lab-Exercise-1-Deliverable-Intro-to-SQL.docx,
Lab practice 2: MIS2502_Lab-Exercise-2-Deliverable-Intro-to-SQL_Continued.docx -
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 10 months ago
Design a database which can be used to record all the transaction details of a retail firm such as Gap. Consider following players: Seller, Customer, Product. (Ignore suppliers here) Show your database design with ERD. Before draw it with Access 2007, please work together with your group members and draw it manually within 10 minutes. […]
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 11 months ago
-
Yang Yang wrote a new post on the site Business Intelligence and Data Analytics 13 years, 11 months ago
Good database design is important because even a good DBMS will perform poorly with a poorly designed database. The hierarchical model is based on a tree structure that is composed of a root segment, parent segments, and child segments. The hierarchical model depicts a set of one-to-many (l:M) relationships between a parent and its children. […]
- Load More
