1 / 23

ISCG 6425 Data Warehousing (DW) Week 1 Introduction to Data Warehousing

ISCG 6425 Data Warehousing (DW) Week 1 Introduction to Data Warehousing. Lecturer : Dr. Sira Yongchareon. Course’s introduction Introduction to Data Warehousing (DW) Tutorial/Lab exercises. Outline. Course’s introduction. About our classes 3 hours/week, every Tuesday

jorn
Télécharger la présentation

ISCG 6425 Data Warehousing (DW) Week 1 Introduction to Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ISCG 6425Data Warehousing(DW)Week 1Introduction to Data Warehousing Lecturer : Dr. Sira Yongchareon

  2. Course’s introduction Introduction to Data Warehousing (DW) Tutorial/Lab exercises Outline

  3. Course’s introduction • About our classes • 3 hours/week, every Tuesday • Lecture 8:30-10:15 • Lab 10:30-11:30 • Class schedule • Let’s see it on the Moodle

  4. Course’s introduction • What is expected from you • Attend alllectures/labs • Attendance and homework will be checked in labs  • Some contents notin lecture slides, you must turn up to know  • Download/print off lecture and lab materials BEFORE coming!! • Keep yourself updated on the about the course • All course’s materials (lecture slides, labs, supplementaries, quizzes, etc) are on the Moodle • Of course, pass the subject !!!

  5. Course’s introduction • About assessments • Mid-semester Test : 20% (Week 8) • 2 x Assignments : 40% (15% and 25%) • Final exam : 40% (after Week 13) • How to pass this subject • Obtain scores 50% from overall • AND obtain scores at least 40% from the final exam

  6. Course’s introduction • Learning resources • Lecture slides, tutorials, worksheets, lab exercises • And...

  7. Course’s introduction • Outside-a-class contact • Email mesyongchareon@unitec.ac.nz • Email code of conduct • In the subject line of your email,please write “[DW]” followed by “your topic/question/issue”. • For example, • To : syongchareon@unitec.ac.nz • Subject : [DW] Question about the next week’s test • WARNING!! Without following that your email may be directed to my Junk folder

  8. Any questions about the course?

  9. Introduction to Data Warehousing(DW) • What is a Data Warehouse? (Wikipedia) • DW is a database used for reporting and data analysis • DW is a central repository of data which is created by integrating data from one or more disparate sources • DW storescurrent as well as historical data that are used for creating reports to supportdecision makers in an organization  Business Intelligence

  10. Introduction to Data Warehousing(DW) • More detailed picture about DW …

  11. DW and Business Intelligence (BI)

  12. The flow of data in DW system

  13. From Data to Knowledge

  14. OLTP(On-Line Transaction Processing) Databases Database designed for day-to-day operations / transactions Queries contain SELECT, INSERT, UPDATE, DELETE Normalized schema (no duplicates, no inconsistency data) OLAP (On-Line Analytical Processing) Database Database designed for business analytics, summary reports, decision making Queries have SELECTonly(no INSERT, DELETE, UPDATE) De-normalized schema (lots of duplicates/redundancies) OLTP vs. OLAP Databases

  15. OLTP vs. OLAP Databases

  16. Our lab has MS-SQL Server 2008 R2 installed. If you want to download and install it on your computer. Google “unitecdreamspark” (Microsoft for academia) Register first then you can download any MS software ChooseSQL Enterprise 2014(latest version) Software used in this course

  17. Prerequisite knowledge • Database concepts, explain what are the followings.. • ERD, Relational Schema, and Normalization • SQL • DDL: Create, Drop, Alter • DML: Select, Insert, Update, Delete • PK, FK, Composite Key, Null value, Constraint • Union, Join (Inner and Outer), Having, Group by, Order by • Count, Sum, Avg, Min, Max • Sub-query • Please DO selfstudyif you don’t know any of them

  18. How much do you understand ERD? 1. How to read this ERD? 2. Convert this ERD to a Relational Schema (Database tables)

  19. How much do you understand ERD 2? 1. How to read this ERD? 2. Convert this ERD to a Relational Schema (Database tables)

  20. How much do you understand SQL? SELECT Name FROM Orders, Salesperson WHEREOrders.salesperson_id= Salesperson.ID GROUP BYsalesperson_id HAVING COUNT ( salesperson_id ) >1 Anything wrong??

  21. How good are you? • Next week will have “SQLQUIZ” !!! • Questions (Multiple-choices or T/F) • To test if you are READYfor this course • If you failed…. • Study MUCH harder !!! • Or…. consider to withdraw

  22. How good are you? • Quiz’s topics include: • ERD, RDBMS and Tables • Relations, Keys and Normalization • SQL commands • Study resources • http://www.w3schools.com/sql/ • http://www.tutorialspoint.com/sql/sql_tutorial.pdf • And more… PLEASE DO YOUR OWN GOOGLE!

  23. Any questions?

More Related