GBA 6220 Data Management In Business Analytics (3 Credits)
Explore the various facets of how business data are organized, delving into relational database management systems, data warehouses and data marts, and distributed data environments such as NOSQL databases. Students survey the means of creating business data sources through data modeling techniques and review retrieving data working with standard data management languages such as SQL for the purpose of addressing issues such as data quality, data integration, and data management. Software used - MS Access, MS SQL etc.
- Be able to differentiate the types and sources of business data in modern world.
- Acquire an enterprise-wide view that integrate multiple types and sources of business data.
- Understand how business data is modelled using relational data model.
- Understand how business data is organized, stored, maintained and retrieved using an appropriate relational database management system.
- Understand how business data is managed, analyzed and derived for business intelligence.
- Acquire basic skills in installing, configuring and managing components in a relational database management system to develop business analytic solutions.