RIS622 – Advanced Databases Dr. Eduan Kotzé
Module Objective • Learn the fundamentals of Business Intelligence (BI) and how apply the knowledge of BI delivery channels (reports, cubes & dashboards) to deliver information from data warehouses. • Learn the basics of data mining and apply some of the data mining techniques on sample data.
Development Environment • Microsoft Business Intelligence Development Studio (BIDS) 2008: • Analysis Services (SSAS) • Data Mining (part of SSAS) • Visual Studio 2010 (with MDX) • SQL Server 2008 R2 • For further reading visit: http://en.wikipedia.org/wiki/Business_Intelligence_Development_Studio
Assessment • Class Tests (20%) • Practical Assignments (20%) • Practical Project (60%) • No written examination. • Build a Dashboard (VS 2010) for a customer which must include Grids, Reports, KPI’s etc. The data sources will consist of dimensional databases and cubes.
Prescribed Book (used in RIS625) Data Warehousing Fundamentals For IT Professionals 2nd Edition PaulrayPonniah Wiley Computer Publishing New Jersey 2010 ISBN: 978-0-470-46207-2