FIT5195 Business Intelligence and Data Warehousing

By Dr Rob Meredith

About this podcast   English    United States

Business Intelligence is a significant part of the IT industry but it is poorly understood by many. BI systems are fundamentally different to other IT systems in terms of users, their use of the system and the development processes required. This podcast is a recording of lectures and other material from Monash University's postgraduate unit on the topic covering both BI application design as well as data warehouse design.
April 18, 2018
This week we look at the most technically challenging part of developing the BI/DW architecture: the extract, transform and load process.  We also look at the related problem of data quality and why it is such a significant problem for data warehousing.
April 11, 2018
We finish looking at logical and physical design issues for data warehouses with a discussion of the design challenges for analysing customer data using Todman's hybrid approach.  We then look at several options for the technical architecture for BI/DW infrastructure.
April 5, 2018
This week we look at logical and physical dimensional modelling for the data warehouse.  We cover the basics of Star Schemas, as well as specific physical design techniques such as handling slowly changing dimensions, mini-dimensions and heteregeneous dimensions.
March 21, 2018
This week we move away from the BI interface to look at the underlying conceptual structures for analytical data used for decision support.  We look at multi-dimensional models as a way of creating a subject-oriented view of data that encourages exploration and analytics.  Our focus is on conceptual modelling - we'll look at logical and physical modelling next week.
March 14, 2018
We continue looking at interface design for BI applications, with a focus on the underlying theory of visual information processing and data visualisation design for both tables and graphical visualisations.
March 8, 2018
To the user, the interface is the system.  Often treated as an afterthough, the front end experience is critical to the overall effectiveness of a BI application in providing decision support and improving decision outcomes. In this lecture, we recap and finish off last week's material, then turn our attention to components of BI user interfaces, covering concepts like reports, data visualisations and dashboards.
March 1, 2018
FIT5195 Lecture 1
May 25, 2017
A brief discussion of the exam and revision of topics from throughout the semester.
May 25, 2017
Discussion of governance issues for business intelligence and data warehousing, looking at the Blue Cross Blue Shield case study.
May 23, 2017
A short summary of the key ideas covered in the unit, what to expect for the exam and how to prepare for it.

Podcasts like "FIT5195 Business Intelligence and Data Warehousing"   ·   View all

By Jay Owen
By Mikkel Toldam / Anchor
By Straight Against the Curve
By Podcast – The Aquascaping Podcast
By Designing North Studios
Disclaimer: The podcast and artwork embedded on this page are from Dr Rob Meredith, which is the property of its owner and not affiliated with or endorsed by Listen Notes, Inc.