Module Code: |
H7DWBI |
Long Title
|
Data Warehousing & Business Intelligence
|
Title
|
Data Warehousing & Business Intelligence
|
Module Level: |
LEVEL 8 |
EQF Level: |
6 |
EHEA Level: |
First Cycle |
Module Coordinator: |
Anu Sahni |
Departments: |
School of Computing
|
Specifications of the qualifications and experience required of staff |
Master’s degree in computing or cognate discipline. May have industry experience also.
|
Learning Outcomes |
On successful completion of this module the learner will be able to: |
# |
Learning Outcome Description |
LO1 |
Evaluate business requirements which inform the design of the decision support systems required. |
LO2 |
Design Implement Extract Transform and Load processes which support the integration of diverse data into a Data Warehouse environment |
LO3 |
Produce appropriate Business Intelligence reports and queries to a Data Warehouse to address domain requirements. |
LO4 |
Assess concerns regarding the scalability of Decision Support Systems and develop solutions which are suitable to the domain needs. |
Dependencies |
Module Recommendations
This is prior learning (or a practical skill) that is required before enrolment on this module. While the prior learning is expressed as named NCI module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
|
No recommendations listed |
Co-requisite Modules
|
No Co-requisite modules listed |
Entry requirements |
Learners should have attained the knowledge, skills and competence gained from stage 2 of the BSc (Hons) in Data Science
|
Module Content & Assessment
Indicative Content |
Data Warehouse Concepts Ethical
Introduction to module, discussion of concepts of data, data warehouses and Business Intelligence purposes. Ethics (Traditional Ethics, Core Ethical Values, Ethics in Computing, Noteworthy social and network forces)
|
Normalisation and denormalisation
Normal forms (UNF-5NF) distinction between unnormalised and denormalised, rationale for denormalisation
|
Dimensional modelling
Dimensional modelling concept, Fact tables, choice of dimensions: attributes and richness, star&snowflake schema
|
Granularity
Coarse vs fine grained data, design choices for dimensional modelling, practical impact
|
OLAP
ROLAP vs MOLAP vs HOLAP, Data Cubes vs star schema, implementation issues
|
ETL
Extract, Transform, Load: Data Cleansing, Data Quality, Organisational impact, prevention vs cure
|
Data Staging
Front room vs back room, transitive vs permanent staging
|
Data Modelling
Data mapping, dimensional and fact conformity, Data Loading (Bulk vs Refresh)
|
Business Intelligence Reporting
Data Visualisation refresh, Operational vs Informational reporting, Information density, Information access cost
|
Business Intelligence Implementation
Human-oriented design, user testing, expert vs novice users, domain vs technology expertise, communication with business decision makers
|
Scalability of implementation
Brewer's Theorem, Partitioning, Query complexity, Scalability, scalability break points, Optimisation
|
Enterprise Decision Support
Domain terminology, dimensional conformity, enterprise practices and support, Continuity vs development
|
Assessment Breakdown | % |
Coursework | 40.00% |
End of Module Assessment | 60.00% |
AssessmentsFull Time
Coursework |
Assessment Type: |
Continuous Assessment |
% of total: |
Non-Marked |
Assessment Date: |
n/a |
Outcome addressed: |
1,2,3,4 |
Non-Marked: |
Yes |
Assessment Description: Ongoing feedback on ongoing tutorial activities. Feedback on regular reflection. |
|
Assessment Type: |
Project |
% of total: |
40 |
Assessment Date: |
n/a |
Outcome addressed: |
1,2,3 |
Non-Marked: |
No |
Assessment Description: Long-form project which the student produces over the course of the entire semester. Student is required to access a set of large publicly accessible datasets and aggregate these data to form a cohesive data warehouse addressing specific domain questions addressed by the student. There are early milestones assessing outcomes such as data acquisition and interpretation, and later milestones including prototyping and user testing. |
|
Assessment Type: |
Easter Examination |
% of total: |
60 |
Assessment Date: |
n/a |
Outcome addressed: |
1,2,3,4 |
Non-Marked: |
No |
Assessment Description: Terminal assessment exam taken over 3 hours with 5 questions of which the student must answer four to address the students' understanding of the underlying theories and concepts |
|
No End of Module Assessment |
Reassessment Requirement |
Repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.
|
Reassessment Description The repeat strategy for this module is an examination. Learners will be afforded an opportunity to repeat the examination at specified times throughout the year and all learning outcomes will be assessed in the repeat exam.
|
NCIRL reserves the right to alter the nature and timings of assessment
Module Workload
Module Target Workload Hours 0 Hours |
Workload: Full Time |
Workload Type |
Workload Description |
Hours |
Frequency |
Average Weekly Learner Workload |
Lecture |
Classroom & Demonstrations (hours) |
24 |
Per Semester |
2.00 |
Tutorial |
Other hours (Practical/Tutorial) |
24 |
Per Semester |
2.00 |
Independent Learning |
Independent learning (hours) |
202 |
Per Semester |
16.83 |
Total Weekly Contact Hours |
4.00 |
Module Resources
Recommended Book Resources |
---|
-
Kimbal, R. & Ross, M.. (2013), The data warehouse lifecycle toolkit (3rd ed), Wiley Pub.
-
Inmon, W. H. & Linstedt, D.. (2014), Data Architecture: A Primer for the Data Scientist: Big Data, Data Warehouse and Data Vault, Indianapolis, IN, Wiley Pub.
-
Inmon, W. H.. (2005), Building the data warehouse, Wiley Indianapolis, Ind.
| Supplementary Book Resources |
---|
-
Howson, Cindi.. (2013), Successful Business Intelligence: Unlock the Value of BI & Big Data (2 ed), Mcgraw-Hill Osborne Media.
-
Provost, F. & Fawcett, T.. (2013), Data Science for Business: What you need to know about data mining and data-analytic thinking, O'Reilly Media.
-
Laberge, T.. (2011), The Data Warehouse Mentor, Practical Data Warehouse and Business Intelligence Insights, McGraw-Hill Osborne Media.
-
Ponniah, P. (2012), Data Warehousing Fundamentals for IT Professionals, Wiley.
-
McKnight W.. (2013), Information Management: Strategies for Gaining a Competitive Advantage with Data, Morgan Kaufmann.
-
Hultgren, H.. (2012), Modeling the Agile Data Warehouse with Data Vault Volume 1), Brighton Hamilton.
| This module does not have any article/paper resources |
---|
This module does not have any other resources |
---|
|