1 / 8

RIS625 – Data Warehousing and Mining

RIS625 – Data Warehousing and Mining. Dr. Eduan Kotzé. Module Objective. Learn the fundamentals of data warehousing and dimensional modeling and how to apply the knowledge of database systems (3 rd year) in data warehouses.

valentine-newman
Download Presentation

RIS625 – Data Warehousing and Mining

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. RIS625 – Data Warehousing and Mining Dr. Eduan Kotzé

  2. Module Objective • Learn the fundamentals of data warehousing and dimensional modeling and how to apply the knowledge of database systems (3rd year) in data warehouses. • Learn the fundamentals of Extraction-Transformation-Loading (ETL) and apply the knowledge in SQL Server Data Tools. • Deliver a SQL*2012 Data Warehouse solution loaded with external data that will be provided.

  3. Development Environment • SQL Server 2012 • SQL Server Integration Services (SSIS) • SQL Server Data Tools (SSDT) • (SSDT is just a specialized use of the familiar Visual Studio 2010).

  4. Assessment • Written Examination (60%) • Data Warehouse Project (30%) • Class Tests (10%)

  5. Prescribed Book (For RIS622 as well) Data Warehousing Fundamentals For IT Professionals 2nd Edition PaulrayPonniah Wiley Computer Publishing New Jersey 2010 ISBN: 978-0-470-46207-2 Kalahari.net Take2.co.za Loot.co.za Van Schaik - R1045.00

  6. Supplementary Book Professional Microsoft SQL Server 2012 Integration Services Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock Wiley Indianapolis, IN 2012 ISBN: 978-1-118-10112-4

  7. RIS622 (Advanced Databases) • More practical application of DW/BI • Online Analytical Processing (OLAP) cubes in SSAS • Data mining in SSAS (Clustering, Neural Networks and Decision Trees) • No written examination. • Develop a BI tool in C#.

  8. Questions? Vrae?

More Related