MN50641: Databases & business intelligence
 Academic Year: | 2019/0 |
| Owning Department/School: | School of Management |
| Credits: | 6 [equivalent to 12 CATS credits] |
| Notional Study Hours: | 120 |
| Level: | Masters UG & PG (FHEQ level 7) |
| Period: |
|
| Assessment Summary:
| CW 50%, EX 50% |
| Assessment Detail: |
|
| Supplementary Assessment: |
|
| Requisites: | |
| Description:
| Aims: This unit introduces databases for the storage and retrieval of data as well as tabular and graphical methods of data presentation for deriving managerial insights. Learning Outcomes: At the end of this unit, students will be able to: * Design a database that will best fit the needs of a business in terms of both flexibility and efficiency. * Use optimised queries to process data and derive managerial insights. * Visualise processed data in multiple dimensions to maximise its business value. Skills: Intellectual skills: * Identify the underlying data model of a business process (T, F, A) Practical skills: * Present multi-dimensional data in tabular and graphical formats (T, F, A) * Use SQL and Business Intelligence software (T, F, A) Transferable skills: * Enhance perspective of data storage and retrieval (T, F) * Eliminate data duplication to achieve information consistency (T, F) Content: Topics covered include basic data types, relational databases, query design, object oriented databases, web databases, data warehousing, Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP), and slice-and-dice methods for data visualization. |
| Programme availability: |
MN50641 is a Designated Essential Unit on the following programmes:School of Management
|
Notes:
|